This project was bootstrapped with Create React App.
Below you will find some information on how to perform common tasks.
You can find the most recent version of this guide here.
- Available Scripts
- [Schema create](#Create required table)
- [Node Service](#Runing Node service)
After creation, your project should look like this:
my-app/
README.md
node_modules/
package.json
public/
index.html
favicon.ico
src/
App.css
App.js
App.test.js
index.css
index.js
logo.svg
For the project to build, these files must exist with exact filenames:
public/index.html
is the page template;src/index.js
is the JavaScript entry point.
In the project directory, you can run:
Runs the app in the development mode.
Open http://localhost:3000 to view it in the browser.
Mysql database is required. Database login username and password is root.
create database name as test
CREATE TABLE tbl_member
(
id
int(11) NOT NULL AUTO_INCREMENT,
fname
varchar(255) NOT NULL,
lname
varchar(255) NOT NULL,
email
varchar(255) NOT NULL,
mobile
bigint(11) NOT NULL,
address
varchar(255) NOT NULL,
password
varchar(255) NOT NULL,
is_admin
tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE tbl_hotel
(
h_id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(255) NOT NULL,
total_room
int(11) NOT NULL,
photo_url
varchar(255) NOT NULL,
address
varchar(255) NOT NULL,
PRIMARY KEY(h_id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Insert data into tbl_hotel from database.
so member details will be displayed for admin users.
Got to server folder and run node server
node index.js