Make some PHP pages for project. I am not going to specify the number of pages, but the following features and functionality should be present
Have an INSERT query. There should be some type of validation on at least two different type of fields (or two different patterns/filters).
Have a DELETE query.
Have an UPDATE query.
Have a SELECT query that populates an element of a form. (For example, you have a one-to-many relationship as well as
a many-to-many relationship, and the options for the foreign key(s) in an INSERT or UPDATE might come from a drop-down
select).
Have at least five SELECT queries.
At least one must be displayed in a datatable.
At least one must be displayed in a PDF table.
At least one must be displayed as JSON.
At least one must be a JOIN.
At least one must be parametrized -- have a WHERE clause with data
provided by the user.
Due: Apr. 25
Monday:
Test 3 on April 27 & 29. Material: the Week of March 14 up to and including the Week of April 11
http://csc-srv1.lasalle.edu/blum/Logon.phpNorthwindLogon.zip Allows an employee user to "log on"
using the Northwind Employee last name and extension as credentials (e.g. Davolio 5467). Establishes a session variable
with the EmployeeID and moves to a second page. (If a user attempts to access the second page
without logging on, he/she is sent back to the logon page.) On the second page the employee
sees a drop-down list of orders he/she is involved with. If the user selects an order
from the drop-down list, some details of that order are displayed.
LAB Make a version of pages like those above, but instead of employees, you can have
Northwind suppliers log on using the ContactName and PostalCode as credentials. Establish a session
variable with the SupplierID and move to a second page. (If a user attempts to access the second
page without logging on, send him/her back to the logon page.) On the second page display a
drop-down list with the names of the products supplied by that supplier. If the user
selects a product from the list, display a few more fields from that product's record.