The last three weeks of creating my PHP [Hypertext Preprocessor] driven website has been a challenge for me, and I am glad it is all over now. My task was to create a log in form and a database driven statistics page. I decided to create a stock management site for a company called Dynasty. This will allow only their workers to log on to the site and update the stock management page.
To test to see if the website fufills Dynasty’s requirements I have used a local testing server called XAMMP. This will allow me to check to see if the site that I have created allows users to log in and update the stock management sheet.
With the login page I have decided to put the members onto the MySQL database myself, this will only allow Dynasty to change the users that can log on to the website. I have created a username and password for myself to test to see if the log in page works. Once I entered the correct username and password it then sent me to the stock management sheet, but when I entered a wrong username and password it would tell me to enter a correct username and password.
Onto the stock management page where I have created a form which allows me to enter data. This will then be processed through a MySQL database and then be shown in a dynamic table using PHP. A delete function has also been created to allow data that has been entered to be deleted at any time.
To test it out I entered information into the form and pressed the update button. Once I pressed the update button a row apperaed on my dynamic table below. This had all the information I had entered into the form and also a delete button. I then pressed the delete button which sent me to a page where it showed the message “Data has been deleted”. Then it had a link which sent me back to the stock sheet. The dynamic table had deleted the row of information I had put into the form.
Overall the testing went through smoothly and I have correctly used PHP to create a log in form and a database driven statistics page. I am proud of achieving one of my objectives and to be able to use PHP which I never thought I would be able to do at the start of this year.
Word Count: 412
