arturobp3/product_catalogue

Final project made for my Advanced Databases university subject. To that end, I've used the next technologies: HTML, CSS, JavaScript, JQuery, AJAX, PHP, MySQL, MongoDB and XML

Product Catalogue

The purpose of this project was to use different types of databases in a real software example that people may use everyday. Therefore, I made a web-app similar to Amazon where you can: login and register, purchase products and leave comments below them, check what you have ordered and, among other things, use a search engine which shows suggestions of products while you are typing on it.

Steps to use the application:

Download XAMPP

Download MongoDB Server

Download Robo 3T - MongoDB GUI (Optional)

You have to make sure that both ports (in MongoDB and Robo 3T) are the 27017 one

Install the MongoDB driver for PHP

Your MongoDB version must match that of PHP. You should also pay attention to architecture and Thread Safe. To that end, use the info.php file which I provided in this repository. Then, copy the 'php_mongodb.dll' file and paste it into the path xampp/php/ext. Now, edit 'php.ini', which is located in 'xampp/php', and add the next statement:

extension=php_mongodb.dll

Execute mongod.exe

Now, execute mongo.exe. Here, execute the following commands:

use Product_Catalogue

This command will create our new database

db.createCollection("InfoProducto")

and this one will create the necessary collection for comments.

Open the system console (CMD):

Find the 'bin' folder in the MongoDB Server path and type the next command:

mongoimport -h localhost:27017 --db Product_Catalogue --collection InfoProducto --file C:\xampp\htdocs\Product_Catalogue\backend\MongoDB\MongoDB_database.json

The xampp folder is supposed to be located at C:\

This command will import the necessary documents into our database.

Open the XAMPP control panel and start Apache and MySQL

Import in phpMyAdmin the SQL files provided in this repository

Try my aplication typing in the browser the next URL

localhost/Product_Catalogue/frontend/index.php