How can the code be modified to correctly insert the 'id' value from the 'customer' table into the 'userid' column of the 'Bedarf' table?

To correctly insert the 'id' value from the 'customer' table into the 'userid' column of the 'Bedarf' table, you need to first retrieve the 'id' value from the 'customer' table based on some condition (e.g., email), and then use that value in the INSERT query for the 'Bedarf' table. 

// Retrieve the 'id' value from the 'customer' table based on some condition (e.g., email)
$email = 'example@example.com';
$query = "SELECT id FROM customer WHERE email = '$email'";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);
$userId = $row['id'];

// Insert the retrieved 'id' value into the 'userid' column of the 'Bedarf' table
$query = "INSERT INTO Bedarf (userid, bedarf) VALUES ('$userId', 'Some value')";
mysqli_query($conn, $query);

Keywords

PHP SQL database INSERT query foreign key

Related Questions