How to insert Multiple Query into different tables with foreign key? I have below code, would anyone help me to modified below code!
$query = "INSERT INTO student(fname, lname, phone, email,status) VALUES('".$_POST["fname"]."','".$_POST["lname"]."','".$_POST["phone"]."','".$_POST["email"]."','".$_POST["status"]."')";
$res = $db_handle->executeQuery($query);
if(!$res){
$message="Please try again!.";
} else {
header("Location:index.php");
}
}
my Tables: student, course, schedule
(id_schedule, id, id_courses, schedule_year, schedule_semester) "id" connect to student table. "id_courses" connect to the id_courses into the courses table!
My DB:
--
-- Table structure for table `courses`
--
--
-- Constraints for table `schedule`
--
ALTER TABLE `schedule`
ADD CONSTRAINT `schedule_ibfk_1` FOREIGN KEY (`id_courses`) REFERENCES `courses` (`id_courses`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `schedule_ibfk_2` FOREIGN KEY (`id`) REFERENCES `student` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;