Question: Problem 3 (35 points) Write a PHP script that collects the data from the form of Problem 2, above, and stores the information into a

 Problem 3 (35 points) Write a PHP script that collects the
data from the form of Problem 2, above, and stores the information

Problem 3 (35 points) Write a PHP script that collects the data from the form of Problem 2, above, and stores the information into a MySQL database. Your code should also examine the discipline, course code, and title submitted to verify that they are valid. Valid disciplines are four characters long. A valid course title is any non empty string, while a valid course code is a string of length 4 consisting only of integers. After each new and valid course is submitted, print the contents of the database to a table that is formatted as in Problem 1-a. The database for this problem should be named CourseMgmtDB. Use the database username "comp2190SA" with the password "2018Sem1". The CourseMgmtDB should contain a table called Courses. The fields of the table are as follows: Field Discipline Code Title Level Credits AuthorlD Semester ID Data t String String String Integer Integer Integer Integer Integer, autonumber Discipline Code Course Title COMP Level Semester Credits Author ID 2201 Discrete Mathematics for Computing 2 2211 Analysis of Algorithms 2120 Introduction to Digital Logic 2340 Computer Organisation 2 2 COMP COMP COMP2190 Net Centric COMP COMP2171 Object Technology INFO COMP 2135 Systems Programming COMP2010Probability & Statistics for Computing Camputing 2141 Software Engineering 2180 Web Design & Programming T 2

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!