Question: Create a PHP web application that records student's names and grades. Requirements: Create a new table in your database called students. The table should include
Create a PHP web application that records student's names and grades.
Requirements:
- Create a new table in your database called students.
- The table should include 2 columns; student_name and student_grade (number from 0 - 100).
- Create 3 new php files called student_list.php, add_student.php and delete_student.php.
- In the student_list.php file code the HTML and PHP to list all of the students in your students table; including their student_name and student_grade (number grade) and letter grade (calculation below).
- Convert the number grade to a letter grade as follows.
- returns 'A' if grade is greater than or equaled to 90
- returns 'B' if grade is in the range of 80 through 89
- returns 'C' if grade is in the range of 70 through 79
- returns 'D' if grade is in the range of 60 through 69
- returns 'F' if grade is less 60
- In the student_list.php file, after the list of students, include a link to Add a Student. This link should display add_student.php file.
- In the add_student.php file create a form to input the student_name and student_grade (number grade) and a button to add the student (2 text boxes and 1 button).
- When the button in the add_student.php file is pressed, insert the new student_name and student_grade (number grade) into the students table. Then display the student_list.php file. The list of students in the student_list.php file should show the new student that was just added.
- In the student_list.php file, include a Delete button for each student in the list.
- When the Delete button is pressed, call the delete_student.php file and delete that student from the students table. Then display the student_list.php file. The list of students in the student_list.php file should not show the student that was just deleted.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
