PHP function to Create unique Order Number or Sequence number

PHP function to Create unique Order Number



There may be some situations in which a unique order number or sequence number required to identify a transaction. Instead of depending on the Auto increment fields of the table , programmers may use some sequence number generating functions.



Let's go to the MySQL side

Create a Config table like this:

CREATE TABLE `tbl_AppConfig` ( RecId INTEGER PRIMARY KEY AUTO_INCREMENT, OrderNo INTEGER );

Insert a record into the table:

INSERT INTO `tbl_AppConfig` SET `OrderNo`=1000 ;

Now the table will be like this

RecId	OrderNo
1	1000

Now your config table is ready

Now let's move to the PHP side, create a function like this

PHP 5 Version

<?php

function get_unique_number(){
$LastInsertedId=0;
$get_unique_number_qry=" UPDATE `tbl_AppConfig` SET `OrderNo` = LAST_INSERT_ID( `OrderNo` ) + 1 WHERE Id = 1 ";

//ConnectToYourDatabase
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

if ($result = mysqli_query($link, $get_unique_number_qry)) {
$LastInsertedId = mysqli_insert_id($link)
mysqli_free_result($result);
}


//disconnect dbase
mysqli_close($link);
if($LastInsertedId > 0)
return($LastInsertedId);
}

?>

PHP 4 Version

<?php

function get_unique_number(){
$LastInsertedId=0;
$get_unique_number_qry=" UPDATE `tbl_AppConfig` SET `OrderNo` = LAST_INSERT_ID( `OrderNo` ) + 1 WHERE Id = 1 ";

//ConnectToYourDatabase
$connection=mysql_connect("localhost", "my_user", "my_password", "world");
mysql_select_db("My_Database",$connection)

if ($result = mysql_query($link, $get_unique_number_qry)) {
$LastInsertedId = mysql_insert_id()
}


//disconnect dbase
mysql_close();
if($LastInsertedId > 0)
return($LastInsertedId);
}

?>

On the PHP page , where you want to generate the unique sequence number, there call the function like this

$seq_no = get_unique_number();

You may prepend strings to this if needed

ex: EX1000,EX1001,EX1002....


Query " UPDATE tbl_AppConfig SET OrderNo = LAST_INSERT_ID( OrderNo ) + 1 WHERE RecId = 1 " , returns last inserted value of "OrderNo" field and update the field value with a One increment.

Try this and put your comments :)

TAGS: PHP code for Order number generation, How to create unique sequential numbers using php , Unique order number generation using PHP