Auto Increment ID’s of 4 digit

by

Make id as varchar and use php to make id like this

<?php
for($i=0;$i<10+27;$i++){
  $number = base_convert($i,10,10+26);//here 26 is for a-z
  $number = str_pad($number, 4, '0', STR_PAD_LEFT);
  echo " ".$number;
}
?>

Live demo : https://eval.in/854013

I hope you can get last inserted id and then increment id by 1 as in loop above to insert new record.

output of above php code is :

0000 0001 0002 0003 0004 0005 0006 0007 0008 0009 000a 000b 000c 000d
000e 000f 000g 000h 000i 000j 000k 000l 000m 000n 000o 000p 000q 000r
000s 000t 000u 000v 000w 000x 000y 000z 0010

More Related Contents:

  1. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  2. Calculating distance between zip codes in PHP
  3. Algorithm for generating a random number
  4. recursive function to get all the child categories
  5. Why shouldn’t I use mysql_* functions in PHP?
  6. Invoking a PHP script from a MySQL trigger
  7. Fatal error: Uncaught Error: Call to undefined function mysql_connect()
  8. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client [duplicate]
  9. Best way to avoid duplicate entry into mysql database
  10. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result [duplicate]
  11. PDO binding values for MySQL IN statement [duplicate]
  12. PDO mysql: How to know if insert was successful
  13. Trying to get property of non-object in [duplicate]
  14. PHP & MySQL Pagination
  15. convert php date to mysql format
  16. how to access the command line for xampp on windows
  17. How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent?
  18. PHP, MySQL and Time Zones
  19. How do I loop through a MySQL query via PDO in PHP?
  20. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  21. Password_Hash not working on my PHP login
  22. Select last 20 order by ascending – PHP/MySQL
  23. Formatting an SQL timestamp with PHP
  24. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  25. Finding free blocks of time in mysql and php?
  26. How do you make good use of multicore CPUs in your PHP/MySQL applications? [closed]
  27. Update query PHP MySQL [duplicate]
  28. Do I have to use mysql_real_escape_string if I bind parameters?
  29. How to get a list of databases?
  30. How to sort MYSQL fulltext search results by relevancy

Leave a Comment