'''
$containts = $_POST['containts'] ;
$driver_name = $_POST['driver_name'];
$car_model = $_POST['car_model'];
$car_number = $_POST['car_number'];
$day1 = strtotime($_POST["start_date"]);
$day1 = date('Y-m-d', $day1); //now you can save in DB
$servername = "localhost";
$username = "cockbuster";
$password = "56789Alls";
$db = "test";
$conn = mysqli_connect($servername, $username, $password, $db);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
$stm = $conn->prepare("insert into busses(car_model,car_number) values(?,?)");
$stm->bind_param("ss",$car_model,$car_number);
$stm->execute();
$bus_id = $stm->insert_id;
$driver = $conn->prepare("insert into driver(driver_name) values(?)");
$driver->bind_param("s",$driver_name);
$driver->execute();
$driver_id = $driver->insert_id;
$course = $conn->prepare("insert into course(containts,course_date,buss_id,driver_id)
values(?,?,?,?)");
$course->bind_param("siii",$containts,$day1,$bus_id,$driver_id);
$course->execute();
$stm->close();
$course->close();
$driver->close();
$conn->close();
'''
I can't get data into course table and I'm getting data into busses and driver.
My course table contains course_id, start_date, buss_id and driver_id columns; all my id rows are autoincremented.
