Skip to main content

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

RecIdOrderNo
11000

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

Popular posts from this blog

How to apply for a new ration card and what are the documents required?

List of documents required for new ration card application in Kerala and how to apply


Application for a new ration card should be addressed to Taluk Supply Officer (TSO) / City Rationing Officer (CRO) of applicant's residing area.

Primary document required are Residence certificate, Income certificate and incase the applicant's name is in another ration card then he/she should submit the reduction certificate ontained from previous TSO / CRO as proof for removing his/her name from old Ration card.

You can get the new application from your currently residing Taluk Supply Office.

Payback Points - How to redeem - How to merge multiple payback accounts - Block Payback card - Payback customer care

Joomla and Forum Integration - Integrating Forums to Joomla

Joomla is one of the most popular CMS opensource packages. It is very easier to develop website's using Joomla. You just need to download Joomla package from Joomla's Official website www.joomla.org  and install it on your domain and later adding customizations to templates and feature and Your website is ready :). Now a days most websites provides a forum section for it users for discussing various article topics, gathering opinions etc.



Following are some best know forum opensource packages which can be integrated with Joomla and create a new forum experience for users


Urgent Openings for PHP trainees, Andriod / IOS developers and PHP developers in Kochi Trivandrum Calicut and Bangalore. Please Send Your updated resumes to recruit.vo@gmail.com   Read more »
Member
Search This Blog