next »

[TechnicalTalk]

 TechnicalTalk » Programming and Web Development » Database Programming Discussions » My SQL
 Featch ID number from Datsbase

[amber.long83]

amber.long83  

 Featch ID number from Datsbase

Hello Everyone!

I have made one registration system that can send an email with registered data to the administrator and to the user.

now my problem is that how can i know the ID number of the new user registred in my database, that have auto increase function, and display it in the email that the system will send? 

$checkid = mysql_query("SELECT id FROM form1 WHERE id='$id'");

$message2 = "Your ID: $id"

any one can please help me to solve this problem

Thanks in advance.

[Admin]

Admin  

 Re: Featch ID number from Datsbase

Before inserting a new record in the database, fetch the last ID OR maximum ID from the database. Now after inserting the record, you can easily increase the already fetched MAX ID by 1.

This will be the new ID of newly added record in the database.

Hope this helps you.

[amber.long83]

amber.long83  

 Re: Featch ID number from Datsbase

yeah, this is realy help me, thanks

[webhosting.am]

webhosting.am  

 Re: Featch ID number from Datsbase

Try to find a professional in that field

[svr2112]

svr2112  

 Re: Featch ID number from Datsbase

first . .  we will assume that you have the following:

1.  a textbox called MyTextBox
2.  a database called MyDB with one table called PersonalData.
3.  PersonalData has two columns, one is called ID and the other is called MyName.
4.  To connect to a database, you needs a username YASSER and password 123456
5.  your database is hosted on your computer! (localhost)
6.  in your C#, you imported namespaces: System. Data , System. Data. SqlClient.

Are we ok till now?

Ok, now for the coding ! (this is not the 100% correct way to do it in C# 3. 5, but this is just a starter)

1.  you must create a connection object:

SqlConnection con = new SqlConnection();

2.  you give that connection the connection string it needs to connect to your database:

con. ConnectionString = "Data Source=localhost;Initial Catalog=MyDB;Persist Security Info=True;User ID=YASSER;Password=123456";


3.  define a string variable that will hold the SQL statement that you will use with your database:

string sql = "select * from PersonalData";

4.  create a Database Adapter that will connect you to the database, you will pass your connection and sql statement to it:

SqlDataAdapter adp = new SqlDataAdapter(sql, con);

5.  creat a dataset that will hold your tables:

DataSet ds = new DataSet();


_________

 Insurance | Accident Insurance

[Admin]

Admin  

 Re: Featch ID number from Datsbase

@svr2112: Thank you for posting the code. But the code is in C# and the this thread is talking about PHP and mySQL.

There fore the code is not very helpful in this section and you have just posted about how to generate dataset object but did not gave any hint about how to use it.

[johnpitter]

johnpitter  

 Re: Featch ID number from Datsbase

For Fetching ID number form database you have to write one query as given below.

string sql = "select (Field Name) from (Table Name)";