pyataks/sinlgularpdo

PDO based classes to singular connections

1.0.4 2016-08-30 08:54 UTC

BSD

• Sergiy Pyatak

README

Wrapper for the PDO Class. Easy SQl query.

For each user is created only one connection for each database.

Install

composer require pyataks/sinlgularpdo

Documentation

###Create connection

$db = DBConnect::connect('mysql:dbname=db_name;host=localhost','root','');

###Create new query

$query = new DBQuery($db);

####Examples of queries

$selectAll = $query->queryAll('SELECT * FROM users');

$selectColumn = $query->queryColumn('SELECT email FROM users');

$data = [
    'email' => '[e-mail]',
    'password' => password_hash('q1234')
];
$rowCount = $query->execute("INSERT INTO `users` (`email`, `password`) VALUES (:email, :password)", $data);