Week 6 Assignment

Attached Files:

Assignment Week 6 SQL statement.txt (1.119 KB)

Purpose: Practice Database connection from client Web Page using PHP Coding. (Chapter 9 Coding.)

Instruction:

1. Create a Web application Books that provides the following functions with their corresponding pages:

a. Login: Only valid users are allowed to access the Web applications. it perform credential checking by validating the email and the password against a database table at the server side.

b. Show Books: It provides a Tab of Show Books. When it is clicked, a list available books will be listed with the fields of ISBN, Title, Author and Year on a new page

c. Delete Book: It provide a Tab of Delete Book. When it is clicked, a page with a textbox will display to allow a user to enter a ISBN number for deletion.

d. Update Book Page: It provide a Tab of Update Book. When it is clicked, a page with text boxes of ISBN number, author, title and year will display to allow a user to enter new values for author, title and year. The ISBN number is required field and the rest of three fields should be entered at least one for updating.

2. A sample sql statements for creating Books database and database operations such as select, update and delete are attached.

Thing to submitted:

1. php and/or html files.

2. Screen shots showing successful operations of login, show book, update and delete operations.

3. All the files aabove should be zipped in a single file including all the css and folders if there is any.

Assignment Week 6 SQL statement.txt mysql -u root -p > >create user 'don'@'localhost' identified by 'wei'; >create database library; >grant all on library.* to 'eric@'localhost'; >exit mysql -u eric -p wei >user library; >show tables; (No tables) >CREATE TABLE Books ( Book_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, ISBN varchar(35) NOT NULL, Author varchar(50) NOT NULL, Title varchar(255) NOT NULL, Year int NOT NULL default 2000, PRIMARY KEY (Book_id) ); >desc Books; (show the structure of the Books table) >INSERT INTO Books VALUES(NULL, '978-0321833891', 'Luke Welling', 'PHP and MySQL Web Development', 2016); INSERT INTO Books VALUES(NULL, '978-1118987247', 'Brad Williams', 'Professional WordPress: Design and Development', 2015); INSERT INTO Books VALUES(NULL, '978-1782175919', 'Paul Wellens', 'Practical Web Development', 2015); > >SELECT * FROM Books; (Three books are listed.) > >UPDATE Books SET ISBN='978-0321833891' WHERE book_id= 1; >DELETE from Books WHERE book_id=1; >INSERT INTO Books VALUES(1, '978-0321833891', 'Luke Welling', 'PHP and MySQL Web Development', 2016);