You can simply get the last insert record id by using php insert_id statement.<\/p>\n
Example Code:<\/strong><\/p>\n [php]<?php \/\/ Create connection $sql = "INSERT INTO MyGuests (firstname, lastname, email) if ($conn->query($sql) === TRUE) { $conn->close(); Code Explanation:<\/strong><\/p>\n In the above code, we have just added one additional statement to get last inserted id.<\/p>\n In the if statement, once we confirm the connection, is true, on the next line we are asking php to check the last You can simply get the last insert record id by using php insert_id statement. Example Code: [php]<?php $servername = "localhost"; $username = "username"; $password =<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-377","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts\/377","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/comments?post=377"}],"version-history":[{"count":1,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts\/377\/revisions"}],"predecessor-version":[{"id":378,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts\/377\/revisions\/378"}],"wp:attachment":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/media?parent=377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/categories?post=377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/tags?post=377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n$servername = "localhost";
\n$username = "username";
\n$password = "password";
\n$dbname = "myDB";<\/p>\n
\n$conn = new mysqli($servername, $username, $password, $dbname);
\n\/\/ Check connection
\nif ($conn->connect_error) {
\n die("Connection failed: " . $conn->connect_error);
\n} <\/p>\n
\nVALUES (‘John’, ‘Doe’, ‘john@example.com’)";<\/p>\n
\n $last_id = $conn->insert_id;
\n echo "New record created successfully. Last inserted ID is: " . $last_id;
\n} else {
\n echo "Error: " . $sql . "<br>" . $conn->error;
\n}<\/p>\n
\n?>[\/php]<\/p>\nif ($conn->query($sql) === TRUE) {
\n $last_id = $conn->insert_id;
\n echo \"New record created successfully. Last inserted ID is: \" . $last_id;
\n}<\/code><\/p>\ninsert_id<\/code>. The php script will check the statement and return the value in the echo statement.<\/p>\n","protected":false},"excerpt":{"rendered":"