Week 5

As salam..this week class..i come to class with heavy heart..for not able to achieved my ASP objectives..but then..live must go on...

This week class , start with revision from previous class..about the checklist ...and discussion about all the problem arise from last week class..

 checklist

This segment really help all of us, because we shared the problem that have been arise as a team with advice from Prof Zaidatun..this session help the spirit up..:).

                                                         
Troubleshoot session




__________________________________________________________

This  2nd session  we learn about PHP (PreProcessor Hypertext)

From theory part - i do remember that PHP - using SQL as the database, apache as the testing server  and using open source (Linux) as the platform.

1stly , we need to install Xampp - Xampp act as a cross platform for installing apache using Windows environment.It is free to download..

xampp installation

For PHP- The important folder is htdocs..and we can check it under c: xampp directory..

interface of xampp

For PHP we need to set the password for database security..please remember  the username is root. For the password better we use something that is easy for us to remember .
One thing about Xampp - Xampp can help us save our password in text file.




Now  start the developing dynamic webpage.. the same procedure as the checklist .. we have to create the database..An advice from Prof Zaidatun- use lowercase for all the field when creating the database.

interface for create dbase

 For SQL database, if we don't close the database file, no error will occur. This is very different from Access, an error will occur if we don't close the file. In my opinion, creating database using SQL is much more convenience and easy.

For creating testing server..this part is most critical part..if we wrongly give path we will never make a connection - gonna  stuck here..so we must be alert n know the correct path.During this stage also,need to create new folder with the site name .
(Note: Change the security property for this folder -"Everyone" with full access.

Next- need to configure the database connection .

For the next stage- creating form with php extension.. this stage is for the designing  of the layout form.The page will act as virtual communication  interaction . This is the most important part when developing dynamic pages. We need to think about the logic flow of the pages  along with user-friendly instructions for the user.

For the interaction, the use of form and text field for the input from user, along with suitable fields.Once we have created form for user , we need to create one more form for the admin to view.
During this process, the summary is as below :

Example : Register form - use insert record function
                View form - use recordset and repeat region
(Note: Refer to previous handouts - same process as in ASP & PHP for this stage)

One thing to highlight using PHP- we can assign user authentication - to control user access .

user authentication

Last but not least - test the pages  using the browser :)..to make sure all the link path correctly assign.

Reflection / Summary  for this week :

• PHP is more easy to configure and easy to understand. 
• I am happy because now i have the  knowledge to create pages using ASP and PHP.