login, redirect to an error page with the flowing content: "You don't have permission to access this
function!"
3.2 (1.0 point) List All Rice Products
If the login is successful with an Admin role or Staff role, list all Rice Products (includes rice_id,
rice_name, price, created_at, supplier_name obtained by joining with suppliers table)
3.3 (0.5 point) Delete Rice Product
If the login is successful with an Admin role, delete the selected rice product and then update the product
list.
3.4 (1.5 points) Add New Rice Product
If the login is successful with an Admin role, add a new rice with the following requirements
All fields are required (Not null and Not Blank)
The value of price should be greater than or equal to $50 (price >= $50)
•
The value for rice_name is between 3 and 100 characters (3≤ length ≤ 100)
•
The created_at field should be automatically set to current datetime
3.5 (1.0 point) Update Existing Rice Product
If the login is successful with an Admin role, provide functionality to update an existing rice product. For
the update function, apply the same validation requirements as the Add function.
Note: You can use a different page or utilize the current table for this update function (update by rice_id).
Zoom
- FUO
+ 100%
Good luck!
3
Close
