Menu
Community /Pin to ProfileBookmark
@NogDogSep 24.2008 — #Sounds to me like you should be using an auto-increment integer field as the primary key field of that table. This will automatically take care of assigning a unique, sequential number for each insert. If you then need to display it in the "EMPnnnn" format, that can be done either in the select query or in your PHP output code via the applicable formatting functions, e.g.:
...or...
@NogDogSep 25.2008 — #In MySQL you can specify the display length of an integer field (the value in parentheses after the type when you define the column) and add the ZEROFILL argument which will left pad it with zeros (see http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html ), but I generally prefer to directly control any such padding with with PHP's sprintf()/printf() functions.
Preventing Duplicate Records
Hi,
I am using PHP/MySQL to build an application.
My application is a multi-user application where in more then 1 people will be entering data.
There is an employee table in my database [I]tbl_employee[I]serial_no[I]tbl_employee
[B]Now Problem
If there are 5 people doing the addition of employee simultaneously then all of those 5 people will be adding the next employee code as EMP0051.
[B]Question:
How can we prevent from inserting duplicate employee nos. under such scenario?
Plz Help ?
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogSep 24.2008 — #Sounds to me like you should be using an auto-increment integer field as the primary key field of that table. This will automatically take care of assigning a unique, sequential number for each insert. If you then need to display it in the "EMPnnnn" format, that can be done either in the select query or in your PHP output code via the applicable formatting functions, e.g.:<i>
</i>SELECT CONCAT('EMP', LPAD(serial_no, 4, '0')) AS emp_no . . .
...or...
[code=php]
printf("Employee Nbr.: EMP%04d", $row['serial_no']);
[/code]0
@NogDogSep 25.2008 — #In MySQL you can specify the display length of an integer field (the value in parentheses after the type when you define the column) and add the ZEROFILL argument which will left pad it with zeros (see