Introduction to Databases, MySQL & phpMyAdmin

Introduction

When building dynamic websites, we need a way to store, manage, and retrieve data.
This is where databases come into play.

In this lesson, we’ll understand:

• What a database is
• What MySQL is
• What phpMyAdmin is
• How PHP works with databases

What Is a Database?

A database is an organized collection of data stored electronically.

Instead of saving data in files, databases allow you to:

• Store large amounts of data
• Search data quickly
• Update and delete data easily
• Keep data structured and secure

Examples of data stored in databases:

• User accounts
• Blog posts
• Comments
• Products
• Orders

What Is MySQL?

MySQL is a popular relational database management system (RDBMS).

It:

• Stores data in tables
• Uses SQL (Structured Query Language)
• Is fast, reliable, and open-source
• Works perfectly with PHP

Most PHP applications, including WordPress, use MySQL.

Understanding Tables, Rows, and Columns

In MySQL:

• Tables store data
• Columns define data fields
• Rows store actual records

Example:

id	name	email
1	John	john@email.com

This structure makes data easy to manage.

What Is phpMyAdmin?

phpMyAdmin is a web-based tool to manage MySQL databases visually.

Using phpMyAdmin, you can:

• Create databases and tables
• Insert, edit, and delete records
• Run SQL queries
• Import and export databases

It removes the need to use the command line.

Why phpMyAdmin Is Important for Beginners

phpMyAdmin helps beginners:

• Understand database structure visually
• Avoid SQL mistakes early
• Manage databases easily on shared hosting
• Learn faster without confusion

Most hosting providers (including InfinityFree) provide phpMyAdmin access.

How PHP, MySQL & phpMyAdmin Work Together

• phpMyAdmin → Used to manage databases manually
• MySQL → Stores the data
• PHP → Communicates with MySQL to insert, fetch, update, or delete data

This combination can powers

• login systems
• comment system
• contact forms
• blog systems
• dashboards
• admin panels
• e-commerce orders
• profile managing

Flow:

User → PHP Script → MySQL Database → PHP → User

phpMyAdmin is mainly for administration, while PHP handles data dynamically.

Creating a Database Using phpMyAdmin (Step-by-Step)

Basic steps you can explain (and add screenshots on your site):

1. Open phpMyAdmin from your hosting control panel or local server
2. Click “Databases”
3. Enter a database name
4. Click “Create”
5. Create tables with columns
6. Insert sample records

Simple SQL Example (Just to Understand)

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100),
  email VARCHAR(100)
);

This is just for example. We’ll learn about it in detail in later tutorials.

Real-World Example

When a user submits a form:

1. PHP receives the form data
2. PHP inserts data into MySQL
3. Data is stored in a database table
4. PHP fetches data when needed
5. phpMyAdmin helps manage it visually

Why This Is Important for PHP Developers

• Most dynamic websites use databases
• PHP + MySQL is a powerful combination
• Required for backend and WordPress development
• Essential for real-world projects

Common Beginner Mistakes

• ❌ Forgetting database password
• ❌ Not creating tables
• ❌ Confusing database with table
• ❌ Editing production database without backup
• ❌ Using phpMyAdmin directly on live site without care

Mini Task for Students

1. Open phpMyAdmin
2. Create a database named test_db
3. Create a table named users
4. Add 2 records manually
5. View the data in Browse tab

Summary

• A database stores structured data
• MySQL is a popular database system
• phpMyAdmin is a visual database management tool
• PHP interacts with MySQL to build dynamic websites

In the next tutorial, we’ll learn about Creating Database & Tables using phpMyAdmin.