如何在php中插入一个值后获取最后一个id [duplicate]

Question

This question already has an answer here:

• How do I get the last inserted ID of a MySQL table in PHP? 22 answers

How to get the last id inserted in my database

here is my code:

    $id = $_POST['c_id'];
    $var_id = $_POST['var_id'];
    $var_name = $_POST['variable_name'];
    $saveVar = "INSERT INTO ".$table_sub_var." 
    VALUES(NULL,".$var_id.",".$var_name.")";
    mysqli_query($connect,$saveVar);

</div>

Answer 1

You can use mysqli_insert_id() method:

$id = $_POST['c_id'];
    $var_id = $_POST['var_id'];
    $var_name = $_POST['variable_name'];
    $saveVar = "INSERT INTO ".$table_sub_var." 
    VALUES(NULL,".$var_id.",".$var_name.")";
    mysqli_query($connect,$saveVar);

    $last_inserted_id = mysqli_insert_id($connect); // return last inserted ID