Auto increment in phpmyadmin

I have an existing database using PHP, MySQL and phpMyAdmin.

When users become a member on my website, I need the system to create a unique membership number for them using a five digit number. for e.g 83773. I guess it is like generating a random password except I only want numbers for my members. This ID number has to be unique to each member.

Would it be possible for me to set the primary key to auto_increment in my user table and set it to start at 10000 and then auto increment every time a member registers?

Also, is there a maximum number that the primary key ID number would go up to?

Is this a reliable and safe way to use the primary key ID number as a membership number?

Related Posts:

  1. How to log in to phpMyAdmin with WAMP, what is the username and password?
  2. mysqli_real_connect(): (HY000/2002): No such file or directory
  3. phpMyAdmin: secret passphrase?
  4. Forbidden :You don’t have permission to access /phpmyadmin on this server
  5. mysqli_real_connect(): (HY000/2002): No such file or directory
  6. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  7. “Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP
  8. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  9. MySQL Daemon Failed to Start – centos 6
  10. Visual list of all installed fonts with respective pangram phrase?
  11. count() parameter must be an array or an object that implements countable in laravel
  12. Fatal error: Call to undefined function mysql_connect()
  13. Mysql query- How to use contains?
  14. what does PHP die() return
  15. Invalid column count in CSV input on line 1 Error
  16. how to replace quotation marks with \”
  17. mcrypt is deprecated, what is the alternative?
  18. How to echo or print an array in PHP?
  19. Resize image in PHP
  20. How to replace “if” statement with a ternary operator ( ? : )?
  21. why use 0xffff over 65535
  22. Email Not Sending from Byethost Hosting
  23. .rar, .zip files MIME Type
  24. PDO bindParam() with prepared statement isn’t working
  25. HTML Element Array, name=”something[]” or name=”something”?
  26. Why use $_SERVER[‘PHP_SELF’] instead of “”
  27. Setting up a PHP interpreter in PhpStorm
  28. PHP: $_SERVER variables: $_SERVER[‘HTTP_HOST’] vs $_SERVER[‘SERVER_NAME’]
  29. Illegal string offset Warning PHP
  30. Fatal error: Call to undefined function mysqli_connect()
  31. Could not open input file: artisan
  32. Why php tag is not working in html file?
  33. What’s the use of ob_start() in php?
  34. PHP: variables in strings without concatenation
  35. What is the difference between the ‘www’ folder and ‘htdocs’ folder?
  36. Notice: Trying to get property of non-object error
  37. undefined offset PHP error
  38. PHP mail not working for some reason
  39. Get Root Directory Path of a PHP project
  40. Returning JSON from PHP to JavaScript?
  41. How to create cron job using PHP?
  42. Imploding an associative array in PHP
  43. curl POST format for CURLOPT_POSTFIELDS
  44. Can’t use method return value in write context
  45. PHP get domain name
  46. How to solve “Fatal error: Class ‘MySQLi’ not found”?
  47. Running a Python script from PHP
  48. Object of class DateTime could not be converted to string
  49. HTTP Error 411, The request must be chunked or have a content length
  50. mysqli::query(): Couldn’t fetch mysqli
  51. Fatal error: Call to undefined function sqlsrv_connect()
  52. NotFoundHttpException in RouteCollection.php line 161: in laravel 5
  53. Easy way to password-protect php page
  54. Html encode in PHP
  55. file_put_contents: Failed to open stream, no such file or directory
  56. PHP json_decode() returns NULL with valid JSON?
  57. Why do I have to run “composer dump-autoload” command to make migrations work in laravel?
  58. PHP $_POST not working?
  59. PHP cURL HTTP PUT
  60. Convert timestamp to readable date/time PHP
  61. PHP sessions that have already been started
  62. Contact Form 7 – Custom Validation
  63. How to output JavaScript with PHP
  64. WRONGTYPE Operation against a key holding the wrong kind of value php
  65. What is the advantage of using try {} catch {} versus if {} else {}
  66. Check if URL has certain string with PHP
  67. Subtracting days, months or years from date using php
  68. Laravel – Model Class not found
  69. Fatal error: Call to a member function fetch_assoc() on a non-object
  70. What is unexpected T_VARIABLE in PHP?
  71. How to close Browser Tab After Submitting a Form?
  72. Strict Standards: Only variables should be assigned by reference PHP 5.4
  73. mysqlworkbench giving version error on exporting database
  74. Steam Market API?
  75. PHP array delete by value (not key)
  76. PHP mail: Multiple recipients?
  77. Having a problem getting mysqli_query to execute
  78. PHP Multiple Checkbox Array
  79. Session variables not working php
  80. PHP Warning: PHP Startup: Unable to load dynamic library
  81. Do I need a !DOCTYPE declaration in a php file with html?
  82. How get value from URL
  83. Get JSON object from URL
  84. How can I parse a JSON file with PHP? [duplicate]
  85. Object of class stdClass could not be converted to string
  86. How to get URL of current page in PHP
  87. How to push both value and key into PHP array
  88. WordPress visual composer not loading
  89. Find the last element of an array while using a foreach loop in PHP
  90. Popup window in PHP?
  91. How can you use php in a javascript function
  92. How to bypass (deprecated) reCAPTCHA V1?
  93. Adding days to $Date in PHP
  94. Way to send multiple values for column to MySQL?
  95. Unable to insert two value in two different columns (WordPress database)
  96. why not selecting multiple rows of same standard_id using SQL query from database?
  97. submit form data to wordpress existing database table using my plugin
  98. 403 Forbidden Localhost Wamp Apache Php
  99. Changing WordPress author name in database
  100. Importing data from excel sheet on webpage rather than from within phpMyAdmin

Leave a Comment