This web-based application uses SQL database combined with PHP to let users browse a collection of books that are available in the bookstore. A user can search the bookstore by book name, author name, ISBN, genre, etc..
unzip MOVAMP (movamp.zip) on your local drive, you will find the following:
You will see two screens, one for the Apache HTTP server and one for the SQL server (as follows). Click on “Allow Access” for both.
- Open a web browser such as Chrome
- Type the URL: http://localhost/phpmyadmin to open the PHPMYADMIN application:
- Use the following credentials and then click on GO
- Username: root
- Password: (empty)
- Create a new database named bookstore (choose utf8_unicode_ci)
- Go to the tab Import and choose a file that contains the database DDL and click on the button (Go) (Sql/DDL.sql).
- Go to the tab Import and choose a file that contains the database data and click on the button (Go) ( Sql/Data.sql).
- go to movamp\mnt\var\www folder. Check the bookstore folder. It should have all php files (generated by the phpGenerator application).
- Open the file phpgen_settings.php
- Go to the line 21 and configure a database parameters as follows:
function GetGlobalConnectionOptions()
{
return
array(
'server' => 'localhost',
'port' => '3306',
'username' => 'root',
'database' => 'bookstore',
'client_encoding' => 'utf8'
);
}
Now after installation of the database and the web application on the server, the next step is running the application on the web browser with the URL : http://localhost/bookstore
To access to the application login with the username and password. We have 3 roles:
- Admin: (uid: admin; pwd:admin)
- Owner: (uid: ownwe; pwd:owner)
- User: (uid: user1; pwd:user1)
The following Login dialog is shown: (enter your credentials as listed above)
The following Registration dialog is shown when you click on "Register Here" (on the above dialog for new accounts):
If you would like recover the password you must click on the link below the login form.
If you log in with the owner user id and password, you will be able to manage the bookstore, books, users, accounts, etc.
Some actions can be performed on list of items as adding a new record, refresh the list, export the list, print a report, or deleting the selected items you must go to the top right position on the list.
The following screenshots show some examples.
The figure below shows an extract of the books list.
The following screenshot shows how to perform a filter on some specific data (Title of a book).
The following shows the results after applying the filter.
The following screenshot shows how to perform the search on a certain criteria.
The following screenshot shows the results after searching for a specific name of publisher.