Timilsina Prakash's Blog
"Better to live one year as a tiger than 100 year as a sheep"

Next Auto Increment Number in MySQL using PHP

While doing live project, we face many obstacles with mysql queries or my be with PHP codes. We may have the concept how to do that, but, we are just not able to write the absolute code for what we want. I wanted the script from which we can know next auto increment number using php and mysql. I had the logic how to do that, but, i was searching for the simplest method to do this. To make you more clear what i wanted is:
Suppose there is a database table `test`
id (int) (auto increment)
name (varchar) (20)
So, the value may be:
1Aakriti
2Prakash
3John
4Walton

Now, to get the next auto increment number, we can simply use this code:
<?php
         $q=mysql_query("SELECT * FROM `test`");
         $next_auto_num=mysql_num_rows($q)+1;
         echo "Next Auto increment number is :".$next_auto_num;
?>
But this is not gonna work,
For example, what if the third row with name John is removed? Then, the next auto increment number is shown as : 4. Which actually is 5. Because, the total result are 3 therefore the increment is shown as 4. But, 5 gonna be the next auto increment number. If you understood what I mean, this code gonna work for this problem:
<?php
        $q = mysql_query("SHOW TABLE STATUS LIKE 'test'");
        $row = mysql_fetch_assoc($q);
        $next_increment = $row['Auto_increment'];
        echo "next increment number: [$next_increment]";?>
 This gonna work for this problem. Please comment if you have something more innovative idea.

7 Responses to “Next Auto Increment Number in MySQL using PHP”

Anonymous said...

November 14, 2013

kjlk


Syafiq Mustafa said...
December 03, 2014

Prakash, may I ask you a question. How can I make the auto increment number be like "001" instead of "1"?


mao qiuyun said...
October 30, 2015

michael kors bags
nike air force 1
swarovski outlet
iphone cases
cheap oakley sunglasses
polo ralph lauren
moncler coats
true religion outlet
prada handbags
cheap nba jerseys
uggs outlet
mbt shoes
hermes outlet
michael kors online
the north face outlet
toms shoes
asics
timberland boots
ugg sale
ghd hair straighteners
cheap nfl jerseys
oakley outlet
pandora jewelry
true religion jeans
thomas sabo uk
ugg boots
louis vuitton outlet
chanel handbags
kobe bryant shoes
ugg boots
1031maoqiuyun


Xiaoxiao Zhao said...
November 04, 2015

isabel marant sneaker
nike online
nike free run
market 365
nike free
sunglasses on sale
nike shop
michael kors outlet
925 jewelry
burberry outlet
louis vuitton
ralph lauren stocker
oakley sunglasses
af outlet
chritian louboutin
nikr air jordan
jimmy choo
air jordan retro
christian louboutin shoes
louis vuitton bags
abercrombie and fitch
louis vuitton outlet sale
popular sunglasses
fendi outlet
paul smith uk
ugg australia
michael kors
hermes bags
free nike
kate spade australia


John said...
January 14, 2016

ugg boots outlet
christian louboutin
giuseppe zanotti
louis vuitton
celine handbags
hollister kids
ugg sale
hollister kids
canada goose outlet
cheap air jordans
louis vuitton purses
michael kors outlet clearance
ugg outlet
uggs for men
concords 11
ugg clearance outlet
canada goose
abercrombie and fitch
michael kors outlet online
oakley outlet
coach factory outlet
canada goose outlet
tory burch outlet online
oakley outlet
air force 1
louis vuitton handbags
kevin durant shoes 2015
polo ralph lauren
louis vuitton bags
true religion outlet
north face
coach outlet store online
kids uggs on sale
2016115yuanyuan


Yuanyuan Lin said...
May 04, 2016

5.04lllllyuanpuma outlet
air jordan 4
air jordan 11
tommy hilfiger
air jordan 13
supra shoes
hollister canada
ysl outlet
mizuno running shoes
nike mercurial
vans shoes
nike outlet store
cheap nike shoes
nike outlet
nike free 5
nike outlet store
air max 2014
air max 90
chicago blackhawks
nike air max uk


Yuanyuan Lin said...
May 08, 2016

5.09llllllyuancoach outlet
swarovski crystal
michael kors outlet store
discount michael kors handbags
michael kors wholesale
michael kors clearance
michael kors sale
michael kors outlet clearance
michael kors online
michael kors handbags
michael kors handbags clearance
ray ban sunglasses
coach outlet
coach outlet online
coach outlet
coach outlet
fitflops sale clearance
fitflops outlet
celine outlet
swarovski crystal


Post a Comment

Please drop a comment on the above post :)

Search This Blog

Loading...

Followers

Email Subscription

Enter your email address: