|
| |
mysql_insert_id() to get the number created after insert command from auto increment field |
On many occasions we want to generate a unique ID from the operation we do on a database. For example take the case of generating a trouble ticket number in case of a help desk. Here a ticket number is generated while the record is inserted to the table. This ticket number is nothing but the value of an auto incremented numeric field, which is unique also. Now in this case once the record is created we have to display or process (sending mail etc) the trouble ticket number (auto incremented unique ID) to the system. Here we will use mysql_insert_id() function to get the id generated after the insert command. We have to just echo or print the mysql_insert_id() to show the trouble ticket number. Here is an example of this. We will start with an insert command.
$query=mysql_query(“insert into help_desk(userid,type,domain,detail) values('$userid','$type','$domain','$detail')”);
/* Note that here auto increment field is not shown as it automatically add the next incremented value with every insert command
*/
echo "Your trouble ticket number is = " mysql_insert_id();
This way we can display the generated ID of auto increment field of recent insert command.
| |
|
|
|
