Activity 11: MySQL Database Integration

This activity demonstrates a live connection between PHP and MySQL. The records below are being pulled from the alviar_students database table.

Add Student Record

Database Records

View Source

// Connect to the database
$conn = new mysqli("localhost", "username", "password", "database_name");

// Fetch all student records
$result = $conn->query("SELECT * FROM alviar_students ORDER BY id DESC");

// Loop through and display each record
while ($row = $result->fetch_assoc()) {
    echo $row["fullname"] . " — " . $row["course"];
}