Implementing PHP into webpages

The assignment is to implement PHP into a couple of webpages. I only really need about 60% of the stuff on the list done. and for the base html page, you can use whatever works, i just need something to hand to the markers so that i can have some time to work on the actual site. been busy with work so i completely forgot about the assignment.

Get Help With a similar task to - Implementing PHP into webpages

Login to view and/or buy answers.. or post an answer
Additional Instructions:

UNIVERSITY OF REGINA Department of Computer Science CS 215 – Web & Database Programming Winter 2021 Assignment #5: In-Class Q&A System – Server-Side Programming Due: Wednesday June 9, 2021 by 11:55 PM This is the fourth in the series of assignments for building an in-class Q&A system. In the first assignment, you built an interface mock-up of the site. In the second assignment, you implemented the client-side programming. In the third assignment, you designed and built the database. For this assignment, you will use PHP to implement the server-side programming. The last assignment will focus on performing AJAX-based updates of the website. Because the assignments build upon each other, you may wish to made modifications to your previous assignment submission before starting this assignment. Now that you have designed and constructed the database, the next step is to use PHP to access the database, save user-specified content, and dynamically construct specific elements of the web pages. You are not permitted to use third-party libraries that simplify or abstract the PHP coding. This assignment is divided into two different components: A. PHP Database Entry & File Upload There are a number of pages that result in the database being updated with new information. These pages are listed below, with an explanation of what is to be done for each. 1. Sign-up Page • validate the form data to ensure that the required fields are present and that they do not contain illegal data; if there is a problem, return to the sign-up form with a generic error message • if the data is good, add it to the database and return the user to the Login Page so they can login • for the user avatar image/graphic upload, move the uploaded file to an appropriate location within the web application file structure, and save its location (URL) in the database • see http://www.php.net/manual/en/features.file-upload.post- method.php for more information on managing file uploads 2. Post Question Page • only allow access to this page if the user has successfully logged in • validate the form data to ensure that all of the required elements are present and in the proper format CS 215 (Spring 2021): Assignment #5 2 • if the data is good, add it to the database and return the user to the Question List Page 3. Up-Vote • the ability to update the up-vote information should only be possible when the user is logged in • when a logged-in user clicks on the up-vote icon for a question, the system should save this information in the database and the reload the page • if a user up-votes a question, they should be able to undo their selection, which should delete the previous up-vote record 4. Mark as Answered • the ability to update the question to mark it as answered should only be available to the user who posted the question (the “answered” button should not be shown to anyone else) • when this user clicks on the “answered” button for a question, the system should save this information in the database and the reload the page • if the question has been answered, it should be displayed in a different visual format so that this is obvious B. PHP Database Query There are a number of pages that result in the database being queried. These pages are listed below, with an explanation of what is to be done for each. 1. Login Page • query the database with the login credentials to verify that the user exists and provided the correct password • if the information is correct, save the necessary information to know who this user is within a session variable, and redirect to the Question List Page 2. Question List Page • query the database for the 10 most up-voted/recent questions • List the questions with the most up-voted first, and then the most recent if there is a tie in the up-votes • each post should include the email address and avatar image/graphic for the user who posted the question, the date/time the question was posted, the content of the question, and the count for the up-votes • for each question, display small versions of the avatar image/graphic for each user who has up-voted the question • hint: this last feature can be done by issuing a new query for each question produced by the first query CS 215 (Spring 2021): Assignment #5 3 3. User Detail Page • this page is accessed by clicking on the avatar image/graphic of a question author within the Question List Page • query the database to retrieve only the questions posted by this individual user • order and display these questions in the same manner as for the Question List Page above (showing all, instead of limiting it to 10) Since the pages you have built for the previous assignments will each be modified, you should ensure that they are still HTML5 compliant (following the syntax rules of XTHML), use CSS, and that there is a proper separation of the specification of the content from the specification of the presentation rules, the specification of the JavaScript code, and the specification of the PHP processing code. Grading Scheme This assignment will be graded out of 10 marks, based on the following criteria: 1 mark: Sign-up Page: process form and save data 1 mark: Post Question Page: creation of new question 1 mark: Question List Page: up-vote and remove up-vote 1 mark: Question List Page: mark as answered 1 mark: Login Page: login and saving the state in a session variable 2 marks: Question List Page: dynamically generate the question list 1 mark: Question List Page: up-vote avatar graphics 1 mark: Question List Page: show answered questions differently than active ones 1 mark: User Detail Page: dynamically generate the question list Submissions All of the files for this assignment should be posted to your personal website on Hercules (a separate directory for this assignment, with a link on your home page), as well as uploaded to UR Courses (a single zip file). A simple submission log file should be provided that includes your name, student number, class number, the URL of where you have posted the files on Hercules, and a listing of the files you have submitted along with a short explanation of the purpose of each file. Failure to provide these support documents will result in delays in the grading of your assignment and possibly a deduction in your grade. Late submissions (up to 12 hours) will not be accepted with an automatic 20% grade deduction (-2 marks) for any submission that is more than one hour late. If there are exceptional circumstances that kept you from submitting your assignment on-time, CS 215 (Spring 2021): Assignment #5 4 you should consult with your instructor as soon as you are able to do so. See the syllabus for more details on the late policy for this class.

UNIVERSITY OF REGINA Department of Computer Science CS 215 – Web & Database Programming Winter 2021 Assignment #5: In-Class Q&A System – Server-Side Programming Due: Wednesday June 9, 2021 by 11:55 PM This is the fourth in the series of assignments for building an in-class Q&A system. In the first assignment, you built an interface mock-up of the site. In the second assignment, you implemented the client-side programming. In the third assignment, you designed and built the database. For this assignment, you will use PHP to implement the server-side programming. The last assignment will focus on performing AJAX-based updates of the website. Because the assignments build upon each other, you may wish to made modifications to your previous assignment submission before starting this assignment. Now that you have designed and constructed the database, the next step is to use PHP to access the database, save user-specified content, and dynamically construct specific elements of the web pages. You are not permitted to use third-party libraries that simplify or abstract the PHP coding. This assignment is divided into two different components: A. PHP Database Entry & File Upload There are a number of pages that result in the database being updated with new information. These pages are listed below, with an explanation of what is to be done for each. 1. Sign-up Page • validate the form data to ensure that the required fields are present and that they do not contain illegal data; if there is a problem, return to the sign-up form with a generic error message • if the data is good, add it to the database and return the user to the Login Page so they can login • for the user avatar image/graphic upload, move the uploaded file to an appropriate location within the web application file structure, and save its location (URL) in the database • see http://www.php.net/manual/en/features.file-upload.post- method.php for more information on managing file uploads 2. Post Question Page • only allow access to this page if the user has successfully logged in • validate the form data to ensure that all of the required elements are present and in the proper format CS 215 (Spring 2021): Assignment #5 2 • if the data is good, add it to the database and return the user to the Question List Page 3. Up-Vote • the ability to update the up-vote information should only be possible when the user is logged in • when a logged-in user clicks on the up-vote icon for a question, the system should save this information in the database and the reload the page • if a user up-votes a question, they should be able to undo their selection, which should delete the previous up-vote record 4. Mark as Answered • the ability to update the question to mark it as answered should only be available to the user who posted the question (the “answered” button should not be shown to anyone else) • when this user clicks on the “answered” button for a question, the system should save this information in the database and the reload the page • if the question has been answered, it should be displayed in a different visual format so that this is obvious B. PHP Database Query There are a number of pages that result in the database being queried. These pages are listed below, with an explanation of what is to be done for each. 1. Login Page • query the database with the login credentials to verify that the user exists and provided the correct password • if the information is correct, save the necessary information to know who this user is within a session variable, and redirect to the Question List Page 2. Question List Page • query the database for the 10 most up-voted/recent questions • List the questions with the most up-voted first, and then the most recent if there is a tie in the up-votes • each post should include the email address and avatar image/graphic for the user who posted the question, the date/time the question was posted, the content of the question, and the count for the up-votes • for each question, display small versions of the avatar image/graphic for each user who has up-voted the question • hint: this last feature can be done by issuing a new query for each question produced by the first query CS 215 (Spring 2021): Assignment #5 3 3. User Detail Page • this page is accessed by clicking on the avatar image/graphic of a question author within the Question List Page • query the database to retrieve only the questions posted by this individual user • order and display these questions in the same manner as for the Question List Page above (showing all, instead of limiting it to 10) Since the pages you have built for the previous assignments will each be modified, you should ensure that they are still HTML5 compliant (following the syntax rules of XTHML), use CSS, and that there is a proper separation of the specification of the content from the specification of the presentation rules, the specification of the JavaScript code, and the specification of the PHP processing code. Grading Scheme This assignment will be graded out of 10 marks, based on the following criteria: 1 mark: Sign-up Page: process form and save data 1 mark: Post Question Page: creation of new question 1 mark: Question List Page: up-vote and remove up-vote 1 mark: Question List Page: mark as answered 1 mark: Login Page: login and saving the state in a session variable 2 marks: Question List Page: dynamically generate the question list 1 mark: Question List Page: up-vote avatar graphics 1 mark: Question List Page: show answered questions differently than active ones 1 mark: User Detail Page: dynamically generate the question list Submissions All of the files for this assignment should be posted to your personal website on Hercules (a separate directory for this assignment, with a link on your home page), as well as uploaded to UR Courses (a single zip file). A simple submission log file should be provided that includes your name, student number, class number, the URL of where you have posted the files on Hercules, and a listing of the files you have submitted along with a short explanation of the purpose of each file. Failure to provide these support documents will result in delays in the grading of your assignment and possibly a deduction in your grade. Late submissions (up to 12 hours) will not be accepted with an automatic 20% grade deduction (-2 marks) for any submission that is more than one hour late. If there are exceptional circumstances that kept you from submitting your assignment on-time, CS 215 (Spring 2021): Assignment #5 4 you should consult with your instructor as soon as you are able to do so. See the syllabus for more details on the late policy for this class.

Related Questions

Similar orders to Implementing PHP into webpages
43
Views
0
Answers
PG2 – LAB 2: BLACKJACK OBJECTS
CONTENTS Overview........................................................................................................................................................................2 Part A - Classes......................................................
24
Views
0
Answers
Excel Project with Documentation
In a new sheet, create one-variable data tables for these food items. For each previously selected food item, create a two-variable data table that calculates the amounts of calories based on various portion sizes and the number of portions. I have att...
52
Views
0
Answers
Computer Vision - (Machine Learning, Artificial Intelligence field) assignment in python
Video processing, image processing, object detection, object tracking, background removel. It needs to be in PYTHON. Objective The goal of this project is to develop an automatic system for video analysis of footages for the game of curling. The system...
19
Views
0
Answers
Writing and understanding simple java program code
I need help writing a java program with an Eclipse IDE. Once written I need to identify, objects, lists, algorithms, set of instructions, anything that explains how the code is written, what it does, and how an end user will use it...