PHP Free

PDO Bootstrap (db.php pattern)

A stronger db bootstrap for bespoke PHP apps. Uses static reuse, utf8mb4, disabled emulated prepares, clear exception handling and small helper structure that fits shared hosting as well as more advanced setups.

1 min read 44 lines Intermediate Updated: March 2026

Use case

Database bootstrapping

Best for

Tools, admin panels, dashboards, booking systems

Drop-in level

Drop in and edit credentials

Stack / dependencies

PHP 8+ PDO MySQL 8+ / MariaDB

Compatibility

Shared hosting Traditional PHP apps API endpoints

Usage notes

Save this as /config/db.php. Then call db() anywhere you need a connection.

Why this exists

A weak database bootstrap becomes technical debt fast. This pattern gives you a clean, central connection point with safer PDO defaults from day one.

Integration steps

1 Save the file into your config directory.
2 Replace the host, database name, username and password values.
3 Require the file before any query logic.
4 Call db() to obtain the PDO instance.
5 Keep all database access through this file so future changes remain centralised.

Code snippet

Full version with formatting intact. Use “Copy stripped version” when you want a leaner base.

<?php
declare(strict_types=1);

/**
 * /config/db.php
 * Central PDO bootstrap for 1-Byte style PHP apps
 */

function db(): PDO
{
    static $pdo = null;

    if ($pdo instanceof PDO) {
        return $pdo;
    }

    $host    = 'localhost';
    $dbname  = 'your_database';
    $user    = 'your_username';
    $pass    = 'your_password';
    $charset = 'utf8mb4';

    $dsn = sprintf(
        'mysql:host=%s;dbname=%s;charset=%s',
        $host,
        $dbname,
        $charset
    );

    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,
            PDO::ATTR_STRINGIFY_FETCHES  => false,
        ]);
    } catch (PDOException $e) {
        error_log('[DB] Connection failed: ' . $e->getMessage());
        http_response_code(500);
        exit('Database connection error.');
    }

    return $pdo;
}

Implementation notes

The static variable prevents repeat connections during a single request lifecycle.

Disabling emulated prepares gives you more predictable bound parameter behaviour.

Returning PDO::FETCH_ASSOC by default keeps templates and APIs simpler.

Security notes

Do not expose raw PDOException messages to end users.
Keep credentials outside the public web root when possible.
Use prepared statements everywhere downstream.

Performance notes

A single reused PDO instance per request is typically more efficient than creating multiple new connections across includes and templates.

Related snippets

View all

PHP Free

Secure PHP Contact Form Handler

A more real-world contact form endpoint for bespoke PHP builds. Includes request method enforcement, CSRF validation, anti-bot checks, sane input validation, response helpers and a clean place to wire PHPMailer or your preferred provider.

PHP Free

PHP Login Rate Limiter (Session Based)

A slightly more production-shaped login limiter that blocks repeated attempts over a lock window, returns consistent responses and gives you a cleaner place to evolve later into database or IP-backed rate limiting.

PHP + SQL Free

MySQL Pagination Query Pattern

A production-friendlier listing pattern for admin pages and frontend archives. Handles total count, page clamping, LIMIT/OFFSET binding and page metadata cleanly.

← Back to all snippets

Stack / dependencies

Compatibility

Usage notes

Why this exists

Integration steps

Code snippet

Implementation notes

Security notes

Performance notes

Tags

Related snippets

Secure PHP Contact Form Handler

PHP Login Rate Limiter (Session Based)

MySQL Pagination Query Pattern

Cookie preferences