Creating Web Application Part 1

Steps to create the web application Backend

Step 1: Database Creation and Connection

At first we need to create a database which has schema of how the data is stored internally, for that I have used MySQL as Database Language. Here is the MySQL code which creates all the table and necessary relations among the table.

Step 2: Connecting to backend

Now having got the SQL file it need to be executed at PHPMyadmin site where the table will be created.First Select or create new database and then go to SQL option in the site and execute the SQL code you will get a new database created called db_admin which contains all tables dont panic if you get warnings or error just make sure that tables are created in that database.

Below figure shows how to do

Open XAMPP control panel and start apache server and MySQL server.

Enter URL localhost:8081/phpmyadmin in your browser (Check the port number in my case it is 8081 it might be 8080 in your system it is shown in XAMPP control panel)

Above image shows the database tables this is how it should be after executing db_admin in SQL section.