abbe98/simple-pdo

A simpe PDO class for MariaDB and MySQL

Simple PDO

Secure and simple library for PHP's PDO class., _(*1)

Installation

Install the composer package., _(*2)

composer require abbe98/simple-pdo

In define your database connection/user details using constants:, _(*3)

const HOST = '' // the IP of the database
const DBNAME = '' // the database name to be used
const USERNAME = '' // the username to be used with the database
const PASSWORD = '' // the password to be used with the username

Usage Examples

Create new SimplePDO instance and open a connection:, _(*4)

$database = SimplePDO::getInstance();`

If there is already a open connection that one will be used automatically., _(*5)

Query database and return a single row:, _(*6)

$database = SimplePDO::getInstance();
$database->query("SELECT `column` FROM `table` WHERE `columnValue` = :id");
$database->bind(':id', 123);
$result = $database->single();

Query database and return multiply rows:, _(*7)

$database = SimplePDO::getInstance();
$database->query("SELECT * FROM `table`");
$result = $database->resultSet();

Insert new row in database:, _(*8)

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

Update existing row:, _(*9)

$database = SimplePDO::getInstance();
$database->query("UPDATE `users` SET `name` = :name WHERE `id` = :id");
$database->bind(':name', $newName);
$database->bind(':id', $id);
$database->execute();