Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
function AutoIncrement($dbh) {
/*Begin a transaction, turning off autocommit */
$dbh->beginTransaction();
$stmt = $dbh->prepare("SELECT ai_dt FROM ".$this->Table." WHERE num_dt=:num_dt FOR UPDATE");
$stmt->execute(array('num_dt' => $this->ID));
$AutoIncrement = $stmt->fetchColumn();
$stmt = $dbh->prepare("UPDATE ".$this->Table." SET ai_dt=ai_dt+1 WHERE num_dt=:num_dt");
$stmt->execute(array('num_dt' => $this->ID));
/*Commit the changes*/
$dbh->commit();
return $AutoIncrement;
}