PHP database interaction

connect.php

<?php
// Connect to the database
$dsn = "mysql:host=localhost;dbname=mydatabase";
$username = "root";
$password = "password";

try {
    $db = new PDO($dsn, $username, $password);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

// Execute a query
$sql = "SELECT * FROM users";
$stmt = $db->query($sql);

// Fetch results
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    echo $row["name"] . "<br>";
}
?>