A simpe PDO class for MariaDB and MySQL

2.0.0 2014-12-23 14:54 UTC


Secure and simple!


Include pdo.php or install the composer package.

In in your config file define your database connection/user details in the following way:

define('HOST', ''); // the IP of the database
define('DBNAME', ''); // the database name to be used
define('USERNAME', ''); // the username to be used with the database
define('PASSWORD', ''); // the password to be used with the username


Create new SimplePDO instance or use the existing one:

$database = SimplePDO::getInstance();

Query database and return a single row:

function get_user_from_id($userid) {
    $database = SimplePDO::getInstance();
    $database->query("SELECT `name` FROM `users` WHERE `id` = :userid");
    $database->bind(':userid', $userid);
    return $database->single();

Query database and return multiply rows:

function get_all_users() {
    $database = SimplePDO::getInstance();
    $database->query("SELECT * FROM `users`");
    return $database->resultSet();

Insert new row in database:

function new_user($name, $email) {
    $database = SimplePDO::getInstance();
    $database->query("INSERT INTO `users` (name, email) VALUES (:name, :email)");
    $database->bind(':name', $name);
    $database->bind(':name', $email);

Update existing row:

function update_user_name($new_name, $id) {
    $database = SimplePDO::getInstance();
    $database->query("UPDATE `users` SET `name` = :name WHERE `id` = :id");
    $database->bind(':name', $new_name);
    $database->bind(':id', $id);

Licensed under MIT