pull-icon
logo-mobile

PDO Prepared Statements

Home/Forums/PDO Prepared Statements

EmmaS

today at 04:58

Create PDO Prepared Statements

<?php
declare(strict_types=1);

// --- Database connection settings ---
$dsn  = 'mysql:host=localhost;dbname=db_name;charset=utf8mb4';
$user = 'db_user';
$pass = 'db_password';

try {
    $pdo = new PDO($dsn, $user, $pass, [
        PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        PDO::ATTR_EMULATE_PREPARES   => false,
    ]);
} catch (PDOException $e) {
    http_response_code(500);
    exit("Database connection failed.");
}


// --- Prepared insert statement ---
$insert = $pdo->prepare("
    INSERT INTO people (username, gender, country)
    VALUES (:username, :gender, :country)
");


// --- Cleaner insert helper function ---
function addPerson(PDOStatement $stmt, string $username, string $gender, string $country): void {
    $stmt->execute([
        ':username' => $username,
        ':gender'   => $gender,
        ':country'  => $country,
    ]);
}


// --- Insert sample people ---
addPerson($insert, "Sarah",    "f", "Canada");
addPerson($insert, "Steve", "m", "India");

echo "People successfully inserted.";

?>

Leave a Comment

You must be logged in to post a reply.


BellOnline provides fast, reliable UK hosting designed for modern radio and web projects. Optimised servers, strong security, and excellent uptime ensure your station runs smoothly.
MixStream delivers broadcast-grade radio streaming with outstanding stability, crystal-clear audio, and powerful performance even during peak listener hours. Perfect for hobby stations and professional broadcasters alike.


Your secure download link has been emailed to:

Goto BellOnline Now!