Hi all,
I want some help regarding my banking project. I have a customer registration form in my project.After successfully completion of the form users have to click on the "Open Account" button.Thereafter a customer id(Auto increment value) should be generated.It was stored in the database where other form details are also being stored. How can i call to this one by one customer id's??
Heshan,
generating customer id's from the database
Moderator: General Moderators
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
Re: generating customer id's from the database
Are you asking how to get the ID of the new customer? After inserting the data, either make use of MySQL's last insert ID (accessible via PHP's mysql_insert_id() function) or, if each user is unique in some way other than their ID, use their unique data to select their row from the database.
Re: generating customer id's from the database
@ superdezign,
yeah, i want something that to be happened. Since i am new to php i cannot handle codings properly.Can you please send me the exact coding of this. I mean how the mysql_insert_id() function works?
Heshan,
yeah, i want something that to be happened. Since i am new to php i cannot handle codings properly.Can you please send me the exact coding of this. I mean how the mysql_insert_id() function works?
Heshan,
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
Re: generating customer id's from the database
Well, that was the initial purpose of providing a link...heshan wrote:Can you please send me the exact coding of this. I mean how the mysql_insert_id() function works?
If you want your work done for you, you've come to the wrong place. We work for money.
Re: generating customer id's from the database
It's ok. i will try...... 