Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
GreenGeeks Web Hosting - Faster, Scalable & Eco-Friendly

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


7,804 questions

10,890 answers

573 users

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

OneTravel.com | Grab our Special Flight Deal!


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