The book_store from sudipsub

This code is used for admin and User Interface which was built for uploading book name , author name , tittle , image and store in database.Whole code is written in php.Moreover, manupulation of data can be done

This data is use by ecommerce website which was build and can be found in repositories

sql to create database

=======================================

create a bs database then run sql query

=======================================

Create Book table

CREATE TABLE book ( book_id VARCHAR(100) PRIMARY KEY , title VARCHAR(50) NOT NULL, author VARCHAR(50) NOT NULL, price VARCHAR(30) NOT NULL, image VARCHAR(100), category VARCHAR(50), description VARCHAR(10000) NOT NULL )

CREATE TABLE book_details_more( book_id VARCHAR(100) PRIMARY KEY,author VARCHAR(50) NOT NULL, first_co_author VARCHAR(500),publisher VARCHAR(500),stock int(255))

Create user-delivery section where admin will see how many have ordered

CREATE TABLE user_deliver ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, full_name VARCHAR(30) NOT NULL, book_name VARCHAR(500) NOT NULL, street1 VARCHAR(30) NOT NULL, street2 VARCHAR(50), city VARCHAR(50), zip VARCHAR(50), toal_cost_pass VARCHAR(50), stripeToken VARCHAR(50), stripeEmail VARCHAR(50), hash_token_for_client_for_ship VARCHAR(50), time TIMESTAMP DEFAULT CURRENT_TIMESTAMP )

=============================================

create a players database then run sql query

=============================================

Create admin section

CREATE TABLE mail_change( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,user_id VARCHAR(100),new_email VARCHAR(50) NOT NULL, token VARCHAR(500))

CREATE TABLE admin ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, user VARCHAR(30) NOT NULL, password VARCHAR(100) NOT NULL )

Then add admin user and password as per client demand manually

The username and password is admin & admin respectively (Hashed in md5 )

INSERT INTO admin (user,password) VALUES ('admin', '21232f297a57a5a743894a0e4a801fc3');

Set the email address for localserver

Before singup signup some checking valid email or not with verified Token

Create a Database first_database_for_check

Run this sql query

CREATE TABLE check_after_signup ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(30) NOT NULL, email VARCHAR(30) NOT NULL, password VARCHAR(100) NOT NULL, hash VARCHAR(50), type VARCHAR(50), Nickname VARCHAR(50), time TIMESTAMP DEFAULT CURRENT_TIMESTAMP )

Then u ready to go

For Password reset

User forgot password --> reset the password

sql to create password_reset databse

CREATE TABLE password_reset_temp ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,email VARCHAR(30) NOT NULL, expDate VARCHAR(30) NOT NULL)

sql to create database first create a players database then run sql query

CREATE TABLE users ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,username VARCHAR(30) NOT NULL, email VARCHAR(30) NOT NULL, password VARCHAR(100) NOT NULL, nickname VARCHAR(50), password_hash VARCHAR(100), bio VARCHAR(50) )

Run the .bat file in schedule task in every 5 minute so the token get expired