Question
Table student with the attributes student_Id, Fname, Lnameme, Date of Birth, Address, and GPA is included in the registration database. 1. Create the above table
Table student with the attributes student_Id, Fname, Lnameme, Date of Birth, Address, and GPA is included in the registration database.
1. Create the above table using the SQL command.
2. Insert 6 records into the student table using SQL command.
3. Write a PHP code to connect to the database called registration, that contains the student table.
4. Write a PHP code to retrieve all students with GPA between (2.5 and 4.0 ) from the student's table and display them as a list that contains: student_Id, Fname, Lname, Address, and GPA on the screen.
5. Write a PHP code to delete students with GPA between 1 and 1.99.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started