Login / Create an account with an ID

Question

Whenever a user creates an account, I want their ID to increase by 1, so we have something like this:

User 1 >> ID
User 2 >> ID 1 more than previous.
User 3 >> ID 1 more than previous.
User 4 >> ID 1 more than previous.

So how can I make this in PHP and a MySQL database?

Marcx · Answer 1 · 2011-11-04T22:22:38.510

1

On database side create a table to save the users with a field id as integer

PRIMARY KEY, AUTOINCREMENT

and if you want you can also define it as UNSIGNED (this way the field can be only positive)

this way it will be done automatically when you insert a row into the database...

Example Query Insert:

INSERT INTO table (id,username,password) 
 values (,'UsernameSelected','PasswordSelected');

edited Nov 04 '11 at 22:22

answered Nov 04 '11 at 22:16

Marcx

6,806
5
46
69

best if you flag it as unsigned as well: `id int(11) unsigned NOT NULL auto_increment` – Mike Purcell Nov 04 '11 at 22:18
`ALTER TABLE table_name ADD COLUMN id int(11) unsigned NOT NULL auto_increment FIRST, ADD PRIMARY KEY (id)` – Mike Purcell Nov 04 '11 at 22:25

score 0 · Answer 2 · answered Nov 04 '11 at 22:16

0

Set the Id field as auto_increment. You can follow this tutorial to set it using phpmyadmin: tutorial

answered Nov 04 '11 at 22:16

Aurelio De Rosa

21,856
8
48
71

score 0 · Answer 3 · answered Nov 05 '11 at 04:06

Keep in mind what will happen if a user is deleted. If your goal is to always have user001 through user100 to be filled, I don't believe incrementing by 1 alone won't solve your issue. You'll have to do a check to see what "spots are open" between the lowest number and highest number. If there's one or more, those will have to be filled first and only when there are none, would you take the highest number and continue adding 1.

Just a thought.

Login / Create an account with an ID

3 Answers3