Section 6: Basic Database Interaction with PHP

Database interaction in PHP involves connecting to a MySQL database, configuring database connections, and performing basic CRUD (Create, Read, Update, Delete) operations. Let's explore these concepts with detailed coding examples.

Connecting to a MySQL Database

Configuring Database Connections

<?php

    // Database configuration

    $servername = "localhost";

    $username = "root";

    $password = "";

    $database = "example_db";

    // Create a connection

    $conn = new mysqli($servername, $username, $password, $database);

    // Check the connection

    if ($conn->connect_error) {

        die("Connection failed: " . $conn->connect_error);

    } else {

        echo "Connected to the database successfully";

    }

?>

Handling Database Queries

Executing SQL Queries

<?php

    // Sample SQL query (selecting data)

    $sql = "SELECT id, name, email FROM users";

    $result = $conn->query($sql);

    // Check if the query is successful

    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 "0 results";

    }

    // Close the database connection

    $conn->close();

?>

These examples provide a basic understanding of connecting to a MySQL database in PHP and executing SQL queries. Further exploration can involve updating, inserting, and deleting data from the database.