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,361 questions

11,615 answers

573 users

How to use SQL INSERT INTO and UPDATE ON DUPLICATE KEY (to avoid duplicate error) in MySQL with PDO in PHP

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


24 views
asked Sep 13, 2016 by avibootz
edited Nov 2, 2016 by avibootz

1 Answer

0 votes
/* Note: ws_name - Unique - Yes */

$inserted = $con->prepare("INSERT INTO websites(ws_name, ws_registered, ws_active)
VALUES(:ws_name, :ws_registered, :ws_active) ON DUPLICATE KEY UPDATE ws_name = ws_name;");

$inserted->execute(array(
    "ws_name" => $row_ws['ws_name'],
    "ws_registered" => 0,
    "ws_active" => 1
));

 




answered Sep 13, 2016 by avibootz
edited Sep 14, 2016 by avibootz
...