Ik haal data op uit een database en wil deze vervolgens inserten naar een andere table maar dit werkt niet.
<?php
require_once 'config.php';
$yacht = $_POST['yacht'];
$from_time = $_POST['from_time'];
$to_time = $_POST['to_time'];
$paymentPreference = $_POST['paymentPreference'];
$catering = $_POST['catering'];
$insurance = $_POST['insurance'];
$childLifejackets = $_POST['childLifejackets'];
$paddleboard = $_POST['paddleboard'];
$skipper = $_POST['skipper'];
$flot = $_POST['flot'];
$fishinggear = $_POST['fishinggear'];
$groceries = $_POST['groceries'];
$transfer = $_POST['transfer'];
$terms = $_POST['terms'];
$email = $_POST['email'];
$password = $_POST['password'];
$sql = "SELECT * FROM costumers WHERE email = '$email' LIMIT 1";
$result = $conn->query($sql);
if( $result->num_rows == 1) {
$row = $result->fetch_assoc();
if($password == $row['password']) {
$sql = "INSERT INTO `bookings`(`costumers_costumerID`, `Yachts_yachtID`, `paymentPreference`, `date_start`, `date_end`, `catering`, `skipper`, `flot`, `groceries`, `transfer`, `insurance`, `childLifejackets`, `fishinggear`, `paddlebloard`, `aggreedToTerms`)
VALUES ('". $row['customerID'] . "', '". $yacht . "', '". $paymentPreference . "', '". $from_time . "', '". $to_time . "', '". $catering . "', '". $skipper . "', '" . $flot . "', '" . $groceries . "', '" . $transfer . "', '" . $insurance . "', '" . $fishinggear . "', '" . $paddleboard . "', '" . $terms . "')";
if( $conn->query( $sql )) {
echo "Doet het";
} else {
echo "Doet het niet";
}
}
} else {
echo "Gebruiker niet gevonden";
}
?>
Error:
Warning: Undefined array key "customerID" in C:\xampp\htdocs\coral-yachts-delano-burhan\templates\RoyalCarsHtml\includes\booking_customers.php on line 30
Zouden jullie hier mij mee kunnen helpen?
