This interface consists of Login - Create an account - Edit account - Delete account - Edit Reviews - Delete Reviews. This is built using PHP, HTML and Materilize CSS that are connected to local databases created on Oracle 11g Express Edition. Xampp was used to host the PHP scripts.
When I worked on this project, it was done on a Windows 10 OS, 64 bit. You may need to go for the more latest versions for the links given below. Here are some links and tutorials that I used to help me download and connect:
- Oracle Instant Client - https://www.oracle.com/in/database/technologies/instant-client/winx64-64-downloads.html
- PECL Package - https://pecl.php.net/package/oci8/3.0.1/windows
- Youtbe Video with in-depth steps on how to connect - https://youtu.be/_CNM6ie-PwQ
- A guide on how you use PHP and Oracle Database - https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/oow10/php_db/php_db.htm
The commands to retrive data from the the tables are different from mysql. You can refer to the OCI 8 Manual for these commands: https://www.php.net/manual/en/book.oci8.php
Here's the ERD for the entire interface.
Tables used are: country, login, customer_details, category, product, review. In the programs they have been named as cia_country, cia_login, cia_cd, cia_category, cia_product, cia_review,
Page were registered customers can log in to the page to access their account and start shoping. Their accounts will store data like their previous purchases and so on.
If the user doesn't have an account, they can create an account by entering the details required.
Retrives the data related to the registered customer. Also has the option to delete their account permanently from the shop's databases.
Customers can update or delete their previous stationery product reviews. There is a separate update or delete review pages for these two functions.
The "pages" folder has all the php webpages where db_connect is an important file to check if the database is connected successfully to the php Admin. Replace with your username and password and if required, even the name of the localhost. The "templates" folder is required for the header, footer and navigation bar.