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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!