Question

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

Answer 1

/* 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
));

 

70+ SQL courses for beginners and professionals