Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
Liquid Web Managed Dedicated Server: RAID 1 SSD with 16GB of RAM minimum! 24/7 On-Site Heroic Support! Industry-Leading SLA!

BlueHost Web Hosting

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

getflywheel wordpress hosting


Liquid Web Cloud VPS Hosting

8,505 questions

11,788 answers

573 users

How to get last Insert id when using on duplicate key update with PDO MySQL SQL and PHP

1 Answer

0 votes
$query = "INSERT INTO $table ($field) 
                      VALUES(:$field) ON DUPLICATE KEY UPDATE $field = $field, 
                      id = LAST_INSERT_ID(id);";
$data = array($field => $value);

$inserting = conn->prepare($query);
$inserting->execute($data);

$id = conn->lastInsertId();

 




answered Jun 12 by avibootz
...