HW08: Laravel Database and Validation due Tue 19 Mar 13:20

Allowed and Disallowed Resources

• The JavaScript Command Sheets handed out in Web 1 (and also available here: https://josephus.hsutx.edu/classes/all/javascriptcommandsheets/.
• Examples and sample code found here: https://josephus.hsutx.edu/classes/w2/source/.
• The VSCode editor with appropriate syntax highlighting and formatting plugins. You may not use any plugins that generate code, however.
• Video instructions provided in Canvas as part of this course. You MAY NOT USE any other video resources.
• The course notes that accompany the video instructions which can be found here: https://docs.google.com/presentation/d/113px2eo6b2rltW0cKty7782GpEFIYA4WyFlhE6ye5G4/edit?pli=1#slide=id.p
• The official JavaScript Documentation found here: https://developer.mozilla.org/en-US/docs/Web/JavaScript.
• The official PHP Documentation found here: https://www.php.net/docs.php
• The official jQuery Documentation found here: https://api.jquery.com/
• Any handouts provided by the instructor as part of this course.
• Your own course notes
• Your instructor
• Discussions about the assignment with other students as long as you never look at the code produced by another student and you never receive instructions about solving the homework. That is, discussions need to be about concepts and understanding the technologies and not about how to solve the particular problem posed in this assignment.

You may NOT use/access:

• Resources not expressly listed above, including, but not limited to, the following ...
• Source code not provided as part of this assignment. (Obviously, this includes, but is not limited to, source code written by other students whether current or in the past).
• Code-generating tools (of which ChatGPT is one example).
• Any web sites not directly linked to from the homework assignment.

Failure to abide by these guidelines will result in a zero for the assignment and the incident will be reported to the university provost as a violation of the university academic integrity policy. A second incident of academic dishonesty (whether from this course or another computer science course) will result in an F in the course.

Details

1. Establish a model that maps to your books table.

2. Modify the index route/view to pull book info and display it to the screen as you did in in HW #5.

3. Implement the addbook form to trim, do validation, repopulate when validation fails, and safely save valid, entered values to the database. Your code should mitigate both CSRF and SQL injection attacks. The form should redirect to the home page after a success entry.

4. Implement the bookdetail route/view to display a book's detailed information when the book title is clicked on the home page. This view should also provide buttons to modify and delete the book. If a book id is not provided as a query string parameter to the bookdetail page (or is invalid) then redirect to the error page with the book_not_found code.

Summary

• Styling should be done in an external CSS document.
• Each page has a Menu with Home, Add Book, and Login with working links (except for Login)
• The home page should display title and price of books with the title being a clickable link to the detail page
• The add book form should validate with the same rules as required in previous assignment and should safely save valid, entered data to the database. It should redirect to the home page upon successful entry.
• The bookdetail page should display all available book information and should provide working Change and Delete buttons. The change button should populate the form and allow modification of the data. The delete button should remove the specified book from the database.