Practical C Programming

How to do it…

1. Initialize a MYSQL object:

mysql_init(NULL);

2. Establish a connection to the MySQL server running at the specified host. Also, establish a connection to the ecommerce database:

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

3. Enter the email address of the user whose details you want to search for:

printf("Enter email address to search: ");scanf("%s", emailaddress);

4. Create an SQL SELECT statement that searches the row in the users table that matches the email address that was entered by the user:

strcpy(sqlquery,"SELECT * FROM users where email_address like \'");strcat(sqlquery,emailaddress);strcat(sqlquery,"\'");

5. Execute the SQL SELECT statement. Terminate the program if the SQL query does not ...