Week 12 : PHP and MySQL

Doing the same thing but this time is using PHP and MySQL instead of ASP and Microsoft Access.

Step 1 : Set up the site as firstphp

Step 2 : Set up the database by using My SQL, create the datebase with the name firstphp.
             There are four field that i was using together with the type of variable.

Step 3 : Set up the connection , select the database firstphp. Test the connection.

Step 4 : Set up the registration form for php.
             By insert the form, and text field and button.
             Make sure the text field must be rename it as name, username, password and remarks.
             Save it as php.

Step 5 : Insert the record to the form it mean that write the data to the form.

          

Step 6 : Make sure each text field insert into the correct field.

This this the view of the page when explore it through firefox.

Step7 : Set up the view.php type the interface like this

Step 8 : we using recordset to view the record have been insert.

Step 9 :Select by highlight the area that we want to repeat then click on repeat region in server behavior.

          Remember to select all record.

 Step 10 : Explore in the mozila we able to view the record that we key in.