on_duplicate_update 2

gistfile1.txt

INSERT INTO
 `product`
SET
  `id`=?
 ,`name`=?
 ,`created_at`=NOW()
ON DUPLICATE KEY UPDATE
 ,`name`=?
';
$stmt = mysqli_prepare($dbh, $sql);
foreach ($products as $p) {
 mysqli_stmt_bind_param($stmt, 'ss'.'ss',
    $p['id']
   ,$p['name']
   ,$p['name']
 );
 $success = mysqli_stmt_execute($stmt);
 $err = mysqli_error($dbh);
 if (!$success && strpos($err, 'Duplicate entry')) {
   echo "Error inserting product: ";
   echo $err;
   echo PHP_EOL;
 }
}