How to get the auto-incremented ID for a row once you insert values using php? -

How to get the auto-incremented ID for a row once you insert values using php? -

i have mysql database , using httprequest connect android application. have php file insert values via httppost , table inserting have auto-incrementing id maintain each row unique.

what want able insert values via php , id of inserted row utilize insert query. ideas how via php?

here current code:

<?php /* * next code insert order request */ // array json response $response = array(); // check required fields if (isset($_post['table_id']) && isset($_post['menubook']) && isset($_post['order_status'])&& isset($_post['order_date'])&& isset($_post['order_receipt'])) { $tableid = $_post['table_id']; $menubook = $_post['menubook']; $order_status = $_post['order_status']; $order_date = $_post['order_date']; $order_receipt = $_post['order_receipt']; // inlude db connect class require_once __dir__ . '/dbconnect.php'; // connecting db $db = new db_connect(); // mysql inserting new row $result = mysql_query("insert orderdb(table_id,menubook,order_status,order_date,order_receipt) values('$table_id', '$menubook', '$order_status','$order_date','$order_receipt')"); // check if row inserted or not if ($result) { // inserted database $response["success"] = 1; $response["message"] = "order created."; // echoing json response echo json_encode($response); } else { // failed insert row $response["success"] = 0; $response["message"] = "oops! error occurred."; // echoing json response echo json_encode($response); } } else { // required field missing $response["success"] = 0; $response["message"] = "required field(s) missing"; // echoing json response echo json_encode($response); } ?>

just utilize mysql_insert_id shown below, though should convert mysqli or pdo, both have similar functions.

// mysql inserting new row $result = mysql_query("insert orderdb(table_id,menubook,order_status,order_date,order_receipt) values('$table_id', '$menubook', '$order_status','$order_date','$order_receipt')"); // check if row inserted or not if ($result) { $insert_id = mysql_insert_id($db); // inserted database $response["success"] = 1; $response["message"] = "order created."; // echoing json response echo json_encode($response); } else {

php insert information-retrieval