Question: Php programming A University Try to complete the tasks below. 1 1 Create a MYSQL Database named 'db' Create a MYSQL User named dbuser with
Php programming

A University Try to complete the tasks below. 1 1 Create a MYSQL Database named 'db' Create a MYSQL User named dbuser with a password dbpass' Grant Insert, Delete, Update and select privileges for 'dbuser' on Create a MYSQL Table on database 'db' and name it as 'students' with the following field and field properties Field Name Field Type Field Size Additional information Student No Varchar 6 Primary key Name Varchar 20 Surname Varchar 25 birthdate date Using Mysqli Commands (not the pdo) : A University wants to record their students with the following properties in order to give chance to the teachers to make a search: Students should be recorded with the following fields. : Student No, Name, Surname, birthdate. and a mysql You must create 3 forms ( 1 html for menu and 2 php) table (which has the above fields). 1. Menu as html which will have link to other files. 2. A Form to add a new student into db table. 3. A form to search a student. Search could be made via using any of the following three criterias: i. Based on Student no ii. Based on Name iii. Based on surname iv. Based on birthyear (a bit sal knowledge required)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
