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.

Week 11: Exercise 1

The registration page for user to register to join the website.

The users able to see other member who was joined the website after they have registered themselves.

Reflection:
1. We have to create three main item.

•  registration page - to let the user to record the data
•  view page - to let the use view the data.
• data base - a place to store all the data.

 2. Create connection
Create the connection so that there is a bridge for user to store the data from registration page
to data base.
User also able to view the data at view page from the data base.


3. Registration form
we have to create the form and the text field, so that user able to key the data.

Week 11: Using Active Server Pages in Dreamweaver

This was the form that i have created:

The result after key in the Data: