How to get last id after insert a value in php

Question

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);

http://bobby-tables.com also please learn about SQL injection and how to prevent them. Your code is not safe at all and your database could be hacked within a few seconds. — Twinfriends, Jun 21 '17 at 09:08

score 0 · Accepted Answer · answered Jun 21 '17 at 09:03

0

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

answered Jun 21 '17 at 09:03

B. Desai

16,414
5
26
47

Im getting 0 when i tried to echo the $last_inserted_id – Leorah Sumarong Jun 21 '17 at 09:21
Then verify in database value is inserted or not – B. Desai Jun 21 '17 at 09:22
i found it now.. i forgot that the $var_name is a string.. – Leorah Sumarong Jun 21 '17 at 09:28

How to get last id after insert a value in php

1 Answers1