PHP MySQL Introduction 🚀

Welcome to PHP MySQL tutorial! In this comprehensive guide, we'll learn how to work with databases using PHP and MySQL, a powerful combination for web development.

By the end of this lesson, you'll be able to create, read, update, and delete data from a MySQL database using PHP. Let's dive in!

What is MySQL? 📝

MySQL is an open-source relational database management system (RDBMS) that is widely used for web applications. It's known for its speed, reliability, and ease of use.

What is PHP? 📝

PHP (Hypertext Preprocessor) is a popular open-source scripting language for web development. It's used to create dynamic and interactive websites and applications.

Why PHP and MySQL? 💡

PHP and MySQL are a great combination for web development because they complement each other. PHP is used to interact with the MySQL database, while MySQL is used to store and manage data.

Getting Started 🎯

To get started, make sure you have the following installed on your computer:

PHP (version 7.4 or higher)
MySQL Server (version 8.0 or higher)

You can download both from the Official PHP Website and Official MySQL Website.

Connecting to a MySQL Database 🔗

To connect to a MySQL database using PHP, we'll use the mysqli extension. Here's a simple example of how to create a connection:

php

<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully!";
?>

📝 Note: Replace your_username, your_password, and your_database with your actual MySQL credentials and database name.

Creating a Database and Table 📝

Let's create a simple table called users:

sql

CREATE DATABASE my_database;
USE my_database;

CREATE TABLE users (
    id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL
);

Inserting Data 📝

Now, let's insert some data into our users table using PHP:

php

// Insert data
$sql = "INSERT INTO users (name, email, password) VALUES ('John Doe', 'john@example.com', 'password123')";

if ($conn->query($sql) === TRUE) {
    echo "New user created successfully!";
} else {
    echo "Error: " . $conn->error;
}

Retrieving Data 📝

To retrieve data from the users table, we'll use PHP to execute a SELECT query:

php

// Retrieve data
$sql = "SELECT * FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"] . " - Name: " . $row["name"] . " - Email: " . $row["email"] . "<br>";
    }
} else {
    echo "No users found.";
}

Updating Data 📝

To update data in the users table, we'll use PHP to execute an UPDATE query:

php

// Update data
$sql = "UPDATE users SET email='john_updated@example.com' WHERE id=1";

if ($conn->query($sql) === TRUE) {
    echo "User updated successfully!";
} else {
    echo "Error: " . $conn->error;
}

Deleting Data 📝

To delete data from the users table, we'll use PHP to execute a DELETE query:

php

// Delete data
$sql = "DELETE FROM users WHERE id=1";

if ($conn->query($sql) === TRUE) {
    echo "User deleted successfully!";
} else {
    echo "Error: " . $conn->error;
}

That's it for this lesson! In the next lessons, we'll dive deeper into working with PHP and MySQL, including more advanced topics like prepared statements, transactions, and more. Happy coding! 🥳💻🚀