how to use php admin on xxamp

SQL session 7

/*CREATE DATABASE ablestate;

CREATE TABLE student( 
 id INT AUTO_INCREMENT NOT NULL, 
 first_name VARCHAR(11)NOT NULL, 
 last_name VARCHAR(11), 
 dob date, 
 gender VARCHAR(2) DEFAULT 'M', 
 PRIMARY KEY (id)
 );
 
 SHOW TABLES;
 DROP TABLE student;
 DROP DATABASE students
 */
 /* lesson started from me*/
 CREATE TABLE students ( 
  id INT AUTO_INCREMENT NOT NULL, 
  first_name VARCHAR(11) NOT NULL, 
  last_name VARCHAR(11), 
  dob DATE, 
  gender VARCHAR(6) DEFAULT 'Female', 
  CHECK( gender IN('Female', 'Male')),
  PRIMARY KEY (id) 
  );
  
  CREATE TABLE results (
  id int NOT NULL AUTO_INCREMENT, 
  subject VARCHAR(100) NOT NULL, 
  marks INT(3), student_id INT(20),
  PRIMARY KEY(id), 
  CONSTRAINT FK_Student_id 
  FOREIGN KEY (student_id) REFERENCES students(id)
  ON DELETE CASCADE );
  
  SELECT * FROM `results`
  SELECT * FROM `students`
  SELECT * FROM `results`
  INSERT INTO students(
    first_name,
    last_name, 
    dob, gender) 
    VALUES (
    'David','Anyuru', '1999-06-07', 'Male'),
    ('Joanita', 'Nakityo', '2000-11-11', 'Female'),
    ('Abudi','Mutamba', '1998-10-26', 'Male')
  SELECT * FROM `students`
  INSERT INTO results (
    subject, 
    marks, 
    student_id) 
    VALUES 
    ('Maths',89, 1), 
    ('SST', 95, 2),
    ('Science', 96, 3)
  SELECT * FROM `results`
  SELECT * FROM `students`
  DELETE FROM students WHERE id = 1
  DELETE FROM students WHERE id = 2
  Expand Requery Edit Explain Profiling Bookmark Database Queried time
  SELECT * FROM `students`

Things to follow
  /* Check constrainSLt in a table*/
CREATE TABLE students (
 	id INT AUTO_INCREMENT NOT NULL,
    first_name VARCHAR(11) NOT NULL,
    last_name VARCHAR(11),
    dob DATE,
    gender VARCHAR(6) DEFAULT 'Female',
    CHECK( gender IN('Female', 'Male')),
    PRIMARY KEY (id)
);
/* in php admin will show errors but run the code*/
#1452 - Cannot add or update a child row: a foreign key constraint fails (`ablestate`.`results`, CONSTRAINT `FK_Student_id` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE)
/* You cannot add data in the a child table
tab of structure