Build a Website with database and php

• Develop a website to provide information about short courses at a College. Must be made to run on my xampp server with mysql, php, etc. *Write an SQL script to set up a table course in a database college, with fields for a unique id, code, name, subject, instructor, weeks and description. o code is a typical course code such a LIT101 o name is the name of the course e.g. English Literature in the 18th Century o subject is the genera subject area e.g. Literature o instructor is the name of the instructor o weeks is how long the course runs for e.g. 8 weeks. o description is a paragraph or so describing the course content • Also setup a user table in the SQL script (same database) with id, username and password (encrypted with SHA), and add a user (in the script) called admin and password abc123. Do not include any other fields in this table. *• Each webpage must be 1000px wide, centered in the browser window, using a wrapper div to contain all content. *It must have a banner across the top 100px high with College title. *Each page has a horizontal navigation below the top, 30px high, with links to Home, , Courses, Subjects, Instructors, Add, Register and Login. • Home is the home page ([login to view URL]). This page needs to have some content to fill up some space. Lorem ipsum will do. • Register ([login to view URL]) needs a form to register new users, with a processing script. • Login ([login to view URL]) has the login form. Use session management. Once logged in the admin user can access the Add page (described below). • Add ([login to view URL]) is a form to add a new course. Only the admin user, logged in, can access this page. Include form elements for all fields (code, name, subject, instructor, weeks and description) except the id, which is generated by the database. *Also write a script to add the data from the add form to the database. • Courses ([login to view URL]) lists all courses created in the Add form ([login to view URL]) in an HTML table with column headings across the top. Don’t display the id or the description. The name is a hyperlink to a page [login to view URL], which displays all the data for the selected course. Use the id in the query string, not the course name. • Subjects ([login to view URL]) lists each unique subject from the database as a hyperlink to a page [login to view URL], which uses a query string to display only the courses that belong to that subject. • Instructors ([login to view URL]) lists each instructor from the database as a hyperlink to a page [login to view URL], which uses a query string to display only the courses taught by that instructor. • Use separate files for common content and an external stylesheet