Send the data to a database

A database is a place where you can send and store data for future use. This information can be sorted or searched through and cross referenced. There are many examples of databases in use and you use them everyday. A prime example is the library database that allows you to search for a book based on a keyword, author's first or last name, etc.

We will be using a database software called MySQL.

The first thing to do is create the database. This has already been done for you. The second thing is to access the database and set it up:

1. Connect to http://mo-hi.org/phpmyadmin. You will be prompted for a login and password.

2. Login using your regular login and use coyote for the password.

3. Select your database from the dropdown menu on the left hand side of the screen. Ignore any other databases that may appear there. For this exerices I am using add's database as the example.

 

 

 

 

 

 

 

 

 

 

A MySQL database is made up of tables. A single database can hold many different tables. These tables can interact with one another.

4. Click on the word Databases. A new window will appear.

5. Click on the name of your database. You'll now be asked to create a new table.

6. Name the table 'info'. It should have the same number of fields as your form has. In the case of this exercise it will be four.

 

 

 

 

 

 

 

7. Click on Go. You will come to a page where you can name your fields:

8. Enter the Field names in the field category. These must match exactly what you named your form fields in your HTML document.

9. Change the length/Values to 25 on each. Leave the rest as it is.

 

 

 

 

 

 

 

 

 

10 Click on Save. Your database is now set up and ready to use. CONTINUE