2个具有相同ID的表

Question

Let's say I have 2 tables in the database, first table is userregistration and 2nd table is userdetails. In table userregistration, the primary key that I use is called id and it is auto increment.

So let's say I have insert one user and the id of the user is 1, and then I want to insert the details of the said user, how do I make sure the id is also the same as in the userregistration table?

Already read about last_insert_id, but I can't understand how to use it.

Answer 1

Here is an example:

$server_name = ""; //Your server name
$user_name = ""; //Database Username
$password = ""; //Database Password
$database_name = ""; //Database Name

// Create a connection
$connnection = new mysqli($server_name, $user_name, $password, $database_name);

//Insert into First Table
$sql = "INSERT INTO user_registration (firstname, lastname)
VALUES ('Firstname', 'Lastname')";

if ($connection->query($sql) == TRUE) {
    $last_inserted_id = $connection->insert_id;
    //Insert into Second Table
    $sql_two = "INSERT INTO user_registration (user_id, phone_no, address)
    VALUES ($last_inserted_id, 1234567, 'Address')";
    $connection->query($sql_two);
}

You must create a Foreign key reference in the second table. In this user_id is the Foreign Key.