Home   Best Sellers   Blogging   Coding & Design   Technology   SEO   Travel & living   Career   Videos   Tips   Calculators     
Home  »     »     »     »  PHP function to Create unique Order Number or Sequence number

PHP function to Create unique Order Number or Sequence number

Thursday, October 23, 2014

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



How to link to this page?
If you wish to link to this page from your website, simply Copy and paste the above HTML code to your web page. It will appear on your page as:
PHP function to Create unique Order Number or Sequence number.




Share this!




comments powered by Disqus

This Weeks 7 Popular Posts


Subscribe to Recent Posts by Email
Stay connected to CROZOOM with regular Email notices of new Techie articles and IT Jobs. Updates will be delivered to your Inbox as soon as they are posted online.

Enter Your Email Address:  

Delivered by FeedBurner   RSS Feed

Search this Blog   



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 »