Skip to content

Instantly share code, notes, and snippets.

@kublaios

kublaios/pdo_duplicate_key_update.php

Created July 12, 2014 09:54
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save kublaios/007ee6b7b7936c6cd80a to your computer and use it in GitHub Desktop.
Save kublaios/007ee6b7b7936c6cd80a to your computer and use it in GitHub Desktop.
Download ZIP
PDO ON DUPLICATE KEY UPDATE for multiple insert rows
Raw
pdo_duplicate_key_update.php
function test() {
$sql = "INSERT INTO `table` (`id`, `name`) VALUES (?,?),(?,?) ON DUPLICATE KEY UPDATE `name` = VALUES(`name`) ";
$values = array(1, "test", 2, "so so");
$stmt = $this->db->prepare($sql);
$stmt->execute($values);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment