Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. I check, compile and run every program. Contact me at: aviboots(AT)netvision.net.il
Hostgator 1 Penny

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


Distribute your Resume to 500+ Job Boards & Recruiters


6,846 questions

9,748 answers

573 users

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

Anker Quick Charge 3.0 63W 5-Port USB Wall Charger, PowerPort Speed 5 for Galaxy S7/S6/Edge/Plus, Note 5/4 and PowerIQ for iPhone X / 8 / 7 / 6s / Plus, iPad Pro/Air 2/mini, LG, Nexus, HTC


21 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
...