artemmelnik/devstart-db

Class Database (PDO)

1. Install, _(*1)

   composer require artemmelnik/devstart-db
   

2. Use, _(*2)

Select

```php <?php, <sub>(*3)</sub>

require_once DIR . '/vendor/autoload.php';, <sub>(*4)</sub>

use DevStart\Database;, <sub>(*5)</sub>

$db = new Database([ 'host' => 'localhost', 'dbname' => 'devstart_db', 'user' => 'root', 'password' => 'root', 'charset' => 'utf8' ]);, <sub>(*6)</sub>

$query = $db->query('SELECT * FROM posts ORDER BY id DESC');, <sub>(*7)</sub>

$db->closeConnection();, <sub>(*8)</sub>

  ###Insert

 ```php
    <?php

    $insert = $db->query("INSERT INTO posts (title, content) VALUES (:title, :content)", [
        'title' => 'Hello World',
        'content' => 'Wrire content'
    ]);