MySQL Auto-incremented ID number sent to User as registration number

Question

The question is in bold. Everything else is for context.

User submits form data, which is inserted into a MySQL db. The MySQL db generates an auto-incremented "id".
"id" is then (auto) pulled out of the db and is emailed to User via a "Success" email.

Possible? How? Thanks, Leo Jerome

Did you try something? I think that's a very straight question and you can find many articles on the web explaining how to read the last inserted ID from the DB — Abhay, Jun 27 '11 at 17:42

score 0 · Answer 1 · edited May 23 '17 at 11:55

0

Its definatly possible. Depends what language your most familiar with but here is one way

edited May 23 '17 at 11:55

Community

answered Jun 27 '11 at 16:59

Tom Squires

score 0 · Answer 2 · answered Jun 27 '11 at 16:59

0

Assuming you're using php, use mysql_insert_id() to get the id of the last inserted record. It returns an int.

answered Jun 27 '11 at 16:59

kinakuta

score 0 · Answer 3 · answered Jun 27 '11 at 17:01

0

In PHP you are able to receive the last id inserted by using mysql_insert_id() (see here) and further mail()

answered Jun 27 '11 at 17:01

Jaques le Fraque

3 Answers3