Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.
Solved
Find the last ID inserted into a DB
Posted on 2013-12-02
I have the following query:
At: $workorder_id = mysql_insert_id();
I'm trying to grab the last auto incremented id number inserted into the DB, so I can use it in another query. What am I doing wrong here?
$new_order = $pdo->prepare("INSERT INTO workorders (date_booked, shippers_full_name) VALUES (:start_date, :shippers_full_name)");
//start a record counter so we can track how many records are updated
if(isset($_POST['new_workorder'])) {
try {
$new_order->execute();
$workorder_id = mysql_insert_id();
} catch(PDOException $e) {
echo 'ERROR: ' . $e->getMessage();
}
} else {
$workorder_id = $_POST['workorder_id'];
}
At: $workorder_id = mysql_insert_id();
I'm trying to grab the last auto incremented id number inserted into the DB, so I can use it in another query. What am I doing wrong here?
2 Comments
Active today
You're mixing your database extensions. You're using PDO to execute the query, but you're trying to use the raw MySQL extension to get the insert ID. Use PDO to get the last insert ID:
http://php.net/manual/en/pdo.lastinsertid.php
http://php.net/manual/en/pdo.lastinsertid.php
This article will show you how to do these things, mapping the familiar but obsolete MySQL extension to the modern MySQLi and PDO. It also includes an example of using MySQLi with prepared statements. Make a search for "Use an Iterator to Escape the Data and Load the Table" and you will find the way to the last INSERT id.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/A_11177-PHP-MySQL-Deprecated-as-of-PHP-5-5-0.html
You may also find this reference helpful.
http://www.iconoun.com/mysql_mysqli_pdo_function_map.php
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/A_11177-PHP-MySQL-Deprecated-as-of-PHP-5-5-0.html
You may also find this reference helpful.
http://www.iconoun.com/mysql_mysqli_pdo_function_map.php
Featured Post
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Custom Android App Development is the need of an hour for several businesses. If you go through the right firm for Android Application Development, it can make a huge difference to the ways in which customers interact with your business.
I recently worked on a Wordpress site that utilized the popular ContactForm7 (https://contactform7.com/) plug-in that only sends an email and does not save data. The client wanted the data saved to a custom CRM database. This is my solution.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
Learn how to create flexible layouts using relative units in CSS. New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses
Course of the Month8 days, 4 hours left to enroll
585 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.