Practical C Programming

How to do it…

1. Initialize a MYSQL object:

conn = mysql_init(NULL);

2. Establish a connection to the MySQL server running at the localhost. Also, connect to the database that you want to work on:

mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)

3. Enter the information of the new row that you want to insert into the users table in the ecommerce database, which will be for the new user's email address, password, and address of delivery:

printf("Enter email address: ");scanf("%s", emailaddress);printf("Enter password: ");scanf("%s", upassword);printf("Enter address of delivery: ");getchar();gets(deliveryaddress);

4. Prepare an SQL INSERT statement comprising this information; that is, the email address, password, and address ...