PHP with MySQL

PHP and MySQL are widely used together to create dynamic, database-driven web applications such as login systems, registration forms, e-commerce websites, etc.

What is MySQL?

MySQL is an open-source relational database management system (RDBMS) used to store and manage data in tables.

Features of MySQL

• Open source and free
• Fast and reliable
• Uses SQL (Structured Query Language)
• Works well with PHP
• Supports large databases

Exam Definition: MySQL is a relational database that stores data in the form of tables using SQL.

---

Integration of PHP with MySQL

PHP communicates with MySQL using MySQLi or PDO extensions.

Steps for PHP–MySQL Integration

1. Create database
2. Create table
3. Connect PHP with MySQL
4. Perform database operations (CRUD)

Database Connection (MySQLi)

$conn = mysqli_connect("localhost", "root", "", "testdb");

if(!$conn){
   die("Connection Failed");
}

Exam Tip: mysqli_connect() is used to connect PHP with MySQL.

---

MySQL Functions in PHP

PHP provides built-in functions to work with MySQL databases.

Common MySQLi Functions

Example: Fetch Data

$result = mysqli_query($conn, "SELECT * FROM users");

while($row = mysqli_fetch_assoc($result)){
   echo $row['name'];
}