dsgggez/comshop

comshop 💻

ComShop Website

Why Create ComShop 🎈

ComShop It is a website that was created as part of the course Database Systems for Information Technology.

Our project consists of

• comshop.com: Frontend application.
• comshop API: Backend application API with MySQL Workbench.

Technology stack. ✨ ✨ ✨

ComShop

• ✅ HTML for creating frontend application.
• ✅ JavaScript for building our frontend HTML application
• ✅ Bootstrap for styling our application.

ComShop Database.

• MySQL Workbench for our database.

Our main language of development is PHP

Prequistics. 🔑

Check the required 📌 📌 📌

First, check the required

• Bitnami Applications for PHP or other application server. You can check by typing

  http://localhost:8080
  

  into the your browser.

You can download Bitnami here

Running the application. 💡 💡 💡

You go to your browser and paste url http://localhost:8080/name your project folder will see the web application runs at http://localhost:8080/name your project folder

Database setup (ComShop API) 🗂️

Reminder: this topic needs to be done only once.

At ComSop, we use MySQL Workbench to store user data and credentials, this section will teach you how to set up the database locally. But first of all

• You should have MySQL Workbench installed in your machine.
• You should know your master password of phpmyadmin superuser. (They will ask for it during the installation).

If top 2 requirements surpassed. You're ready to develop ComShop's database. These are steps to get the database running.

if you want to develop more database use My SQL Workbench for easy to add more table or etc.

WARNING: You should follow the instructions exactly or you'll end up with a broken database that's super hard to work with and fix.

• Go your browser

  Login php my admin on your browser

  Next

  CREATE DATABASE "comshop" select utf8 unicode ci and then click Create ;

  This means you've successfully created a database.

• import simple database

  Click import on your database and select file.sql on floder db

  and click go You should see a message saying

  Import has been successfully finished.

  This means you've import successfully to the database.

comshop's Issues

Unknown Column in Field List

Calling the CID variable from the session

Cannot add or update a child row: a foreign key constraint fails