BIT245 Build Dynamic Webpage :
For solution: +610482078788
Please read “BIT245 Build Dynamic Webpage Assignment 1 – Overview” and the “Assignment 1 – Part 1” documents before reading this document.
Create web page that allows Members to display all payments they have made. The web site will ask for the member’s phone number and their password to login and will then show them all payments that they have made.
- The page(s) you create here should be built from same template that you used in Part 1.
- The login page should be named either index.html or index.php and the navigation bar link to it should be named “Home”
- The navigation bar should also contain a link to Part 1’s sponsors.html page.
- Create a database on your webhost. The name of the database must include your name e.g. epizy_04503430034_Maria
- Write MySQL code in a tool like Notepad++ that builds the following. Note that you will need to submit the code that creates your tables and that you wouldn’t receive marks for creating your tables using the phpMyAdmin GUI.
- A “member” table
- The table fields should be member_id, phone_number, and password
- The member_id field should be an auto_increment number.
- The member_id field should serve as the primary key
- The phone_number field should be a number between 0 and 9,999,999,999
- The password field should be stored encrypted
- Use Not Null as appropriate
- A “payment” table.
- The columns should be payment_id, member_id, date, amount
- The payment_id field should be an auto_increment number.
- The payment _id field should serve as the primary key
- The amount field should hold a number between 0 and 9,999.
- The member_id field should be a number and serve as the foreign key link to the “member” table.
- Insert at least 3 records into the “member” table and 10 records into “payment” table.
- The first record (that is where the member_id is “1”) must have a phone number of “1” and a password of “1”. This is for testing purposes – both for you and your teacher.
- A “member” table
- Create that table on your web host by copy-pasting your MySQL code into your Webhost’s phpMyAdmin “SQL” tab and pressing “Go”.
- Your index.html (or index.php) page should:
- Display a login page. The HTML form should ask the member for their phone number and password.
- Uses HTML to block form submission if either box is left empty.
- Uses HTML to prevent entry of more than 10 characters for the phone number
- Create PHP page named process.php that reads the submitted form’s details and:
- Connects with your database using connection string that contains your name e.g.
$con_maria = @mysqli_connect(…
- Where a member login is successful, displays all payments for that member, including the description and date.
- Where the login is unsuccessful, displays an error message and offers a button that will take the member back to the login form.
- Create a sitemap.xml file of your site and upload it to your site.
- Make your site and your sitemap file known to Google using a Google Search Console account.
- Advanced implementations:
- Display the total payments below member payment lists.
- Combine your index.html and process.php page into a single file named index.php. Tips to make this work:
- The form “action” will need to be set to “index.php” (itself).
- If statements should check if the submit button has been pressed and then
- Display the form when the client has not pressed the submit button.
- Check the form contents where the submit button has been pressed and display
- An error message and the form again when the login is unsuccessful. The form input boxes should contain the attempted phone number or password where are match for them exists in the database, or be empty when no match was found.
- The payments, as described above, where the login is successful.
- Take steps to block SQL injection.
- Edit the MS Word document you began in Part 1 as follows:
- Place the URL of your php and/or html files immediately above the “Part 1” heading you created in Part 1
- At the end of your document (below all your Part 1 content), create the heading “Part 2” and make it a Microsoft Word “Heading 1” style.
- Below the “Part 2” heading, create headings for each of these 9 requirements and make each one an MS Word “Heading 2” style:
- Your MySQL code as plain text
- A screenshot of your web host showing the names of the database in your site
- Screenshots from your host’s phpMyAdmin tool showing all records in your database.
- Screenshots from your Webhost’s public directory showing all files that you created for this assignment. Use multiple screenshots if necessary.
- All PHP code.
- All CSS code that you wrote (Don’t include libraries like Bootstrap or CSS that comes with a template)
- The contents of your sitemap file, pasted as plain text (not a screenshot)
- A screenshot of your Google Search Console account showing that you have “added” your site (property) to your account and have let Google know that you have created your sitemap.xml file.
Please help your teacher out by formatting your MS Word document in these ways:
- Making all URLs clickable hyperlinks
- Insert an MS Word “Table of Contents” above your “Part 1” heading
- Don’t include a cover page. The top of the first page of your document should have your URLs and login details.
For solution: +610482078788