Storing information in MySQL database

In this recipe, we will learn how to insert a new row into the users table. Recall that at the beginning of this chapter, we created a database called ecommerce, and in that database, we created a table called users with the following columns:

email_address varchar(30)
password varchar(30) 
address_of_delivery text  

We will be inserting rows into this users table now.

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...