In this is project, we built a full-stack interactive online marketplace for cars that supports checkout and admin functions for over 2000 cars. This app uses react for its frontend and express/node.js as its backend which interacts with our MySQL database.
- Download the project directory. Ensure node and yarn are installed.
- In MySQL, run the script DBAdump.sql in the sql folder to create the database
- Open 2 node-enabled command prompts and cd to the project directory in both
yarn install is not necessary in steps 4-5 if the directories already have a 'node modules' folder
- install server dependencies: in one command prompt, cd server && yarn install
- install frontend dependencies: in the other prompt, cd client && yarn install
- Run 'yarn start' in both the server & client terminals
- localhost:3000 automatically opens in browser
- Users can buy product. review past orders and can add mutiple cars to the cart and choose the store of choice.
- Users can search products & rerank products based on price
- Passwords are now stored as hashes in the database. Remember your password, as the database values can't be returned to plaintext once entered! Upon login, the password entered in the front-end is hashed and compared to the database value from the server.
- During customer registration, phone numbers and emails now are checked for the correct format. Phones: 10 digits with no delimiters, or '+' and up to 12 digit (for international numbers) email: requires a nonempty string, then the '@' symbol, and another non-empty string.
- Designed an online marketplace for luxury cars, built the Frontend and UI (User Interface) components for the website with detail pages for each car, a checkout page, and an order detail page using ReactJS, HTML, and CSS.
- Led the team developing and enhancing various backend features such as password encryption using NodeJS and MySQL.