Skip to content

GarroDev/FIRETRONICS

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Welcome to FIRETRONICS E-Commerce!

What motivated us to do this project?

Help people, develop new skill, and explore our creativity, are some things that motivated us to create this project.

What is this project about?

This is a technology E-commerce web application. This web application was created with JavaScript, HTML, Bootstrap and JavaScript, storing products, customers information, and purchase records in SQL Server datatabase (RDBMS).

Why use this project?

This is a good base to create your own E-commerce project about wathever you want, it's awesome, enjoy it! :shipit:

What we learned?

New ways to create projects, and use different softwares to achieve a great goal.

How can you start using this project?

Order Detail
1 Download Visual Sudio Code.
2 Download Node.js.
3 Download SQL Server (We recommend SQL Server developer edition.).
4 Dowload GitHub FIRETRONICS FILES!
5 Use FIRETRONICS.sql from "Database" file to create the SQL Server database :feelsgood:
6 Installation, configuration and deployment of XAMPP applications.
7 Installation, configuration and deployment of MySQL database engine

Warning

¡BE CAREFUL! Developer edition it's only for DEV, QA, STG enviorments, no PRD.

Start using step by step configuring SQL Server enviortment.

Start in step 3.

Once you install de SQL Server instance let's configure it.

1. Enable TCP/IP protocols for MSSQLServer

image

2. Restart the SQL Server instance.

image

3. Install SQL Server Management Studio.

SSMS

4. Create the database.

image

Execute: CREATE DATABASE ECommerce_ENU_V1;

image

5. Create the database schema. (It's the FIRETRONICS.sql)

image

6. Create login with sysadmin privileges to connect FIRETRONICS web with SQL Server database.

image

image

image

7. Configurate the sql server connection from Server.js.

Use the login that u created before to configurate the conntection string:

image

8. Execute the next commands in the visual studio terminal.

Like this:

image

  • npm install express
  • npm install body-parser
  • npm install mssql
  • npm install bcrypt

Configurations for the correct functioning of the products section

1. Configure Xampp

1. Application installation

Since the project has a section developed in PHP, it is necessary to run the Apache web server services on a specific port, so for this development XAMPP was implemented.

|Download XAMPP .|

image

2. Route configuration

Once XAMPP is installed in its default configuration, we proceed to run and configure the application in its Apache server section:

image

Select the "Apache (httpd.conf)" option from the drop-down list

image

Find the “'Main' Server Configuration” section and then go to the “#DocumentRoot” sector to add the following path:

#DocumentRoot "C:/xampp/htdocs"
#<Directory "C:/xampp/htdocs">
Document root "C:/FIRETRONICS/HTML"
<Directory "C:/FIRETRONICS/HTML">

Example image

image

3. Preparation of work spaces

You need to save and close the file, and then add the main project folder called “FIRETRONICS” to the root of the C: drive.

image

4. Run server

Finally, run the Apache service and verify that it is running on the default ports 80, 443:

image

image

Configure MySQL

1. Install application

Using a secondary database engine, it was implemented for mysql for proper integration of PHP functions and queries. Therefore MySQL must be installed with its basic configuration, version 8.0.4 being recommended.

|Download MySQL .|

image

2. Configure the database

And then configure the root user with the connection details and make a test connection.

Usuario: root
Password: qwe1234
Servidor: localhost
Basededatos: carritodb

image

Useful resoruces

Who work in this project?

  • Cristian Garro Sabogal.
  • Juan Pablo Jimenez Rodriguez.
  • Mateo Londoño Echeverri.
  • David Vallejo Grisales.