This repo contains the code for out MusicSTORE e-commerce website:
User can register an account, before login user need to verify his/her account. User will receive an OTP code sent by PHPMailer.
How to use this source code: requirement:
- install wamp here is the link to install wamp (64-bit) https://www.wampserver.com/en/#wampserver-64-bits-php-5-6-25-php-7
First step:
- download this repo
- create a folder name as DBMS-Project -> extract to your wamp64 folder -> www -> on folder DBMS-Project
- go to phpmyadmin -> create database 'dbmsproject'
- copy all the query command from SQL.sql -> paste it under the database 'dbmsproject' sql.
- modify the account and password under the file functions.php to your email id and password
- modify the admin email which you want to set, in the login.php file (make sure that the email and password for admin is present in the database)
- NOTE: inorder to send email through php mailer, you have to first enable Less secure app access for your email -> to do that go to your gmail -> click on Manage your Google account -> Click on security -> scroll down till you find Less secure app access -> turn it on
- now you are ready to run your RDBMS E-commerce project!
- Happy Coding
If you get an error saying "Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. in C:\wamp64\www\DBMS\private\connection.php on line 14"
-> then go to connection.php -> under define('DB_HOST', "localhost:3308"); remove ':3308' and try
More details refer to this youtube video with clear explanation https://youtu.be/-1SJPDL-9o8
