Upsert generator, (pdo style)

upsert.php

  <?php
  //This snippet is released to the public domain of course
  
  
   /**
    * Upsert one column value
    */
   function upsert($pkcolname, $pk, $table, $column, $val) {
      $sql_upsert_templ = 'INSERT INTO `{TABLE}` (`{PKCOLUMN}`, `{COLUMN}`) VALUES (:pk, :value)
                           ON DUPLICATE KEY UPDATE `{COLUMN}` = :value_dup';
      $params = array(':pk'=>$pk, ':value'=>$val, ':value_dup'=>$val);
      $sql = $sql_upsert_templ;
      $sql = preg_replace('/\\{TABLE\\}/', $table, $sql);
      $sql = preg_replace('/\\{COLUMN\\}/', $column, $sql);
      $sql = preg_replace('/\\{PKCOLUMN\\}/', $pkcolname, $sql);
      return array($sql, $params);
   }
  ?>