How to connect with database using php (Part 2)

 

For that we need a database

As we know that we have to create database in localhost/phpmyadmin section

Ok so lets start

Open a nee tab in your browser and type localhost/phpmyadmin 

Click on Database

Give any name you want in our case lets give it test_project

Press create. And boom your database is created successfully.

Now we need some tables in the database

Tables in database

Why we need this table. 

Well database is collection of data. We organised this data in various table. 

For example: just think about Facebook

Assume that in Facebook we have many data like our username password, photo, our post etc.

How to organize  data

 To organize this data we have to create table. 

Example:

For usename ,password, address phone no 

We create a new table and named it User_login

Similarly for photo, post, comment we create a new table user_profile

So in this example we have two tables user_ login & user_profile under this table we organised this data in different coulmn

Create table in database

Select your database in our case our database name is test_project under this database there is a option call create table. Before pressing create table button we have to give the table name. 

Type user_login and press create.

after clicking this we need to enter our column. As we decided that in user_login table we have username, password, address, phone no.

So we have to create this field. And also every field has its data type. 

For username,password and address data type will be varchar . And for phone_no data type will be int also give the size. And press save

Thats it your table has been created

Similarly create the user_profile  table