( Luckye | 2018. 08. 28., k – 15:58 )

A PHP kód:

<?php
function Get_Next_ID()
{
$prefix = "X";
$servername = "localhost";
$username = "dbuser";
$password = "dbjelszo";
$dbname = "adatbazisnev";

$ret = "";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if ($conn)
{
$sql = "INSERT INTO orders () VALUES ()";
$stmt = mysqli_prepare($conn, $sql);
mysqli_execute($stmt);

$sql = "SELECT LAST_INSERT_ID() as ID";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0)
{
$row = mysqli_fetch_assoc($result);
$ret = $row["ID"];
}

mysqli_close($conn);
}

$ret = "000000".$ret;
$ret = substr($ret, strlen($ret)-5, 5);

return $prefix.$ret;
}

?>