What is a Database?

Database is used to store information like your customer’s information – first name, last names, email address, address, and etc… Database is very useful on a dynamic website (type of website that needs frequent change of content like news, e-commerce, blog, and etc…), because you can easily retrieve, save, update, and delete data.

Database is composed of tables. A Table is composed of rows of data just like what you see in your excel file. (See Image below)

The text in blue at the top of each column is called “field name“, in excel it is called column title. Field names are very important because these serves as the labels of your data, you cannot either create a table without “field names“.

Sample Situation

Suppose, we will store basic information of our client:

  • First Name
  • Last Name
  • Middle Name
  • Email Address

The first thing that we need to do is to create a database name “user” and a table name “user” having a field names of first_name, middle_name, last_name, and email. Our database structure would be the same as the image below.

As you can see on the image above, our database consist of 1 table that has field names and data in it.

I’ll teach you on how to create a database and table, on my next topic.

This entry was posted in PHP Beginners Course, PHP Tutorial. Bookmark the permalink.

One Response to What is a Database?

  1. Nice information about “Database”. This information helped me so much and I think it will help to other people.

Comments are closed.