The web application uses a 4-table relational database stored on a server that records a number of suppliers of various items required by several projects and the orders for items as follows. The structure of each table is given by: < TABLE_NAME >(< PRIMARY_KEY >, OTHER FIELDS ........)
SUPPLIERS (SNAME, MOBILE, POSTCODE)
ITEMS(INAME, NUMBER_IN_PACKAGE, DESCRIPTION)
ORDERS(SNAME, INAME, PNAME, QUANTITY)
Each order refers to a single supplier requesting supply of a single item for a single project. No nulls are permitted. The ORDERS table has a primary key that combines the primary keys of the other 3 tables.
When the database is set up it should be populated with data that you have chosen. Display this data as part of your documentation. Each table should have from 3 to 6 records initially.
Before implementing the database, use PHP and CSS to create a form that enables a user to make an order to a supplier for an item required for a specified project. You should use drop down boxes containing the initial data for user-friendly selection of supplier, item and project.
Test the form by posting the values of the entries in the order form to a separate php file that will display the order details.
Use MySQL commands from the command line to create a database on the server with the structure specified and populated with the initial data.
Test the database by writing a query on the command line that displays all initial orders.
Write PHP code that will enable users to create an account giving them access to the database with permission to query the database and add new orders. Account usernames will generally be email addresses. However include username ‘tutor’ with password ‘guest’ as one of the accounts. User passwords should be encrypted with an MD5() hash function.
Write PHP code that connects the database with the application. Enable the user to interrogate the database in a variety of ways, using a column of 5 buttons, 1 per query, with an appropriate description attached. Queries should demonstrate at least the ability to select records, select fields, display in sorted form and count.
Allow recognised users to submit a valid form that creates an additional record being written to the ORDERS table.
On the topic of “Advantages of server-side scripting” identify four (4), relevant, independent resources. Use these resources to discuss the topic in about 500 words. Take care to cite appropriately.
Include in a Word document: