making a DIY database

We will practice making a database, which we will need for another flash cs3 scripting miracle.

For this we need a browser, like Firefox, with a FTP plugin, FireFTP.

Then we need a host, like www.byethost.com/free-hosting

if we have an account, we go to the admin panel:

http://panel.byethost.com/

and we log in with our new account name and password.

Then we go to: php admin, and create a database.
We go to the MYSQL page and we can start making a table.

After making a table with fields, we start filling the fields and practice a bit inserting, deleting and searches.

Then we look at the MYSQL code and we copy this code and save it for later on.

The next step is looking a PHP pages.
With these pages we call the database and get the records.

First of all we will produce some "HTML" pages with the PHP pages, to get used to the coding.
The we will insert the MYSQL code into th PHP and look at the results.

My PHP examples can be found here:
http://www.contrechoc.com/crosslab/php-examples.zip

(The password has to be replaced.)

PHP references can be found everywhere:
http://www.w3schools.com/php/default.asp

also on this page PHP Database (on the left), this gives MYSQL code
http://www.w3schools.com/php/php_mysql_intro.asp