Secure PHP PDO MySQL Database Connection

Category Web
Type PHP
Platform Cross-platform
Language PHP
Price Free
Copy 7 186
Comments 0

Secure PHP PDO MySQL Database Connection

Copy this PHP snippet on Clayi Code — one click, no account required. Free web snippets with highlighted syntax and one-click copy — save time on repetitive front-end work.

What it does and when to use

Copy-paste code for front-end or web workflows — markup, styles, scripts, or server-side patterns. Reach for it when you need a layout, UI component, DOM logic, form handling, or styling pattern without starting from scratch.

How to copy from Clayi Code

Copy from the code block and paste into your editor, component file, or browser DevTools.

Before you deploy

You may need small tweaks for your framework and hosting setup. Client-side code runs in the browser; server-side snippets need a matching runtime. Preview in a local file or dev server and check console errors before shipping.

Web reference

Category: Web. Language: PHP. Platform: Cross-platform. Format: PHP.

Popularity

Votes: 661
Comments: 0

Secure PHP PDO MySQL Database Connection

<?php
$host    = 'localhost';
$db      = 'your_database_name';
$user    = 'database_user';
$pass    = 'secure_password';
$charset = 'utf8mb4';

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$options = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];

try {
     $pdo = new PDO($dsn, $user, $pass, $options);
     // Connection successful
} catch (PDOException $e) {
     throw new PDOException($e->getMessage(), (int)$e->getCode());
}
?>

Free snippet — copy & paste!

Copy this snippet for free on Clayi Code. One click — no account required.