PHP DBUtils::setNextId Examples

Example #1

File: DBFunctions.php Project: bsormagec/tavlamania-php

 public static function getNextId($field)
 {
     if (!empty($field)) {
         $field = DBUtils::mysql_escape($field);
         $SQL = "SELECT * FROM " . TBL_KEYGENERATOR . " WHERE  PK_COLUMN = '" . $field . "'";
         $query = mysql_query($SQL) or die(mysql_error());
         $result = mysql_fetch_array($query);
         if (empty($result)) {
             return DBUtils::setNextId($field);
         } else {
             $val = $result['VALUE_COLUMN'] + 1;
             $SQL = "UPDATE  " . TBL_KEYGENERATOR . " SET  VALUE_COLUMN={$val} WHERE PK_COLUMN = '" . $field . "'";
             mysql_query($SQL) or die(mysql_error());
             return $val;
         }
     } else {
         return -1;
     }
 }