The assignment requirements;
- The user must be able to register and login
- The registration information must be stored in a MySQL database
- Users must fill in the name and student number fields when registering and then create a username and password
- An 8-character password must be created and confirmed as the correct password
- The user should be able to view used textbooks that have been loaded onto the application.
Librarian User (seller) Functionality:
The college’s librarians will load the details of used books that students want to sell. For the user to start selling textbooks, the college librarians need to confirm the following details for the users (sellers):
- Verify that the seller is a student at the institution before the options to sell/upload the textbook are available to the buyer (from the MySQL database)
- Remove books from the database that have been sold
- Approve students, giving them the functionality to sell books
- Communicate with all users regarding books that are being sold
- Make sure that books are delivered to the buyers
- Liaise between the buyer and the selle
How to run the application
- Create a database called bookstore (with all lowercase)
- Add your information suchs as PORT and DATABASE USER in the DBConn.php file (located in the config folder)
- run the createTable.php script which will create tblUser and tblBook tables and add dummy data
Config folder containes all the configration of the application like:
- BDConn.php = which creates the connection between the web application and the database
- createTable.php = which deletes tblUser and tblBook tables and the re-adds them in the database
- userData = which contains dummy data for the users createTable
- booksData = whcih contains dummy data for the books table
To create admin user:
- register like how students register by going to the login.php url
- use the password "admin321"
To approve students:
- Only admins can approve users
- if you are an admin an "Office link" will show on the navigation which will show all the unapproved students
- click on approve will make it possible for them to add books
How to add books:
- on the navigation section there is a "sell" option which is for selling books
- You must be approved first by the admin
Application Structure:
config folder - conatins configration for the application
server_login - conatins server code for authetication, logout, approving students, adding books and images folder: