library php-database

itlessons/php-database

PHP Database

PHP Database

Very simple database toolkit for PHP, providing simple pdo wrapper connection and query builder. It currently supports MySQL. Сreated for the study. But you can use it in real projects. Сode taken from Laravel Database Layer and simplified., _(*1)

Usage

First, create a new manager instance., _(*2)

use Database\Manager;

$manager = new Manager;

$manager->addConnection([
    'dsn' => 'mysql:dbname=testdb;host=127.0.0.1',
    'username' => 'root',
    'password' => null,
    'options' => [] // pdo driver options 
]);

Once the Manager instance has been registered. You may use it like so:, _(*3)

Using Connection, _(*4)

$conn = $manager->getConnection();
$data = $conn->queryAll('select * from users where id in (?,?,?)', 1, 2, 3);
// $data -> [['id' => 1, 'name' => 'joe'], ...]

$conn->exec('insert into users (id, name) values (?, ?)', 1, 'joe'));

$conn->execBatch(file_get_contents('file_with_queries.txt'));

Using The Query Builder, _(*5)

$data = $manager
            ->query('users')
            ->select('*')
            ->whereIn('id', [1,2,3])
            ->execute();

// $data -> [['id' => 1, 'name' => 'joe'], ...]


$data = $manager
            ->query('users')
            ->update(['votes' => 2])
            ->where('id', 1)
            ->toSql();
// $data -> ['update `user` set `votes` = ? where `id` = ?',[2,1]]

$data = $manager
          ->query('users')
          ->insert([
              ['email' => 'john@example.com', 'votes' => 0],
              ['email' => 'john1@example.com', 'votes' => 1]
          ])->execute();

More about query builder see in QueryBuilderTest, _(*6)

Installation

The recommended way to install php-database is through Composer. Just create a composer.json file and run the php composer.phar install command to install it:, _(*7)

{
    "require": {
        "itlessons/php-database": "*"
    }
}

Alternatively, you can download the php-database.zip file and extract it., _(*8)

Resources

You can run the unit tests with the following command:, _(*9)

$ cd path/to/php-database/
$ composer.phar install
$ phpunit

Links

• MySQL библиотека на сайте с помощью PHP