$db = new YSPDO; // Change the values of $settings variable in class

$db = new YSPDO([
    'driver'    => 'mysql',
    'host'      => 'localhost',
    'port'      => 3306,
    'charset'   => 'utf8',
    'database'  => 'dbname',
    'user'      => 'root',
    'password'  => ''
]);

// PDO
$pdo = new PDO('DRIVER:host=HOST;dbname=DB_NAME', DB_USER, DB_PASSWORD);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// YSPDO
$db = new YSPDO([
    'driver'    => 'DRIVER',
    'host'      => 'HOST',
    'database'  => 'DB_NAME',
    'user'      => 'DB_USER',
    'password'  => 'DB_PASSWORD'
]);

// PDO
$stmt = $pdo->prepare('INSERT INTO `peoples` (`name`, `email`, `country`) VALUES (?, ?, ?)');
$stmt->bindValue(1, 'Gabriel Almeida', PDO::PARAM_STR);
$stmt->bindValue(2, '[email protected]', PDO::PARAM_STR);
$stmt->bindValue(3, 'Brazil', PDO::PARAM_STR);
$stmt->execute();
echo $stmt->lastInsertId();

// YSPDO
$stmt = $db->insert('peoples',[
  'name'    => 'Gabriel Almeida',
  'email'   => '[email protected]',
  'country' => 'Brazil'
]);
echo $stmt->lastInsertId();

// PDO
$stmt = $pdo->prepare('SELECT `name`,`email`,`address`,`company` FROM `peoples` WHERE id>=?');
$stmt->bindValue(1, 100, PDO::PARAM_INT);
$stmt->execute();

print_r( $stmt->fetchAll(PDO::FETCH_COLUMN) );

// YSPDO
$stmt = $db->select('peoples',['name','email','address','company'],[
  'id{>=}' => 100
]);

print_r( $stmt->fetchAll('COLUMN') );

// PDO
$stmt = $pdo->prepare('UPDATE `peoples` SET `phone`=?, `address`=? WHERE id=?');
$stmt->bindValue(1, '(00) 0000-0000', PDO::PARAM_STR);
$stmt->bindValue(2, '4129 Magna. Avenue', PDO::PARAM_STR);
$stmt->bindValue(3, 100, PDO::PARAM_INT);
$stmt->execute();

// YSPDO
$stmt = $db->update('peoples',[
  'phone' => '(00) 0000-0000',
  'address' => '4129 Magna. Avenue',
],[
  'id' => 100
]);

// PDO
$stmt = $pdo->prepare('DELETE FROM `peoples` WHERE id=?');
$stmt->bindValue(1, 100, PDO::PARAM_INT);
$stmt->execute();

// YSPDO
$stmt = $db->delete('peoples',[
  'id' => 100
]);

$db->select('peoples','all',[
    'email' => '[email protected]'
])->fetch();

$db->select('peoples')->fetchAll();

$db->select('peoples','all',[
    'email' => '[email protected]'
])->fetch('OBJ');

$db->select('peoples')->fetchAll('OBJ');

$db->select('peoples',['name','email','phone'])->fetchAll();

$db->select('peoples',[
    'DISTINCT' => 'name'
    // OR
    'DISTINCT' => ['name','phone','date']
])->fetchAll();

$db->select('peoples',[
    'AS' => [
        'name' => 'yourName',
        'date' => 'birthday',
        'email' => 'contact'
    ]
])->fetchAll();

$db->select('peoples','all',[
    'id{>=}' => 100
])->fetchAll();

$db->select('peoples','all',[
    'email' => '[email protected]'
])->rowCount();

$db->select('peoples','all',[
    'ORDER' => 'city'
// OR
    'ORDER' => 'name DESC'
// OR
    'ORDER' => ['name DESC','city ASC']
])->fetchAll();

$db->select('peoples','all',[
    'BETWEEN' => [
        'id' => [1,25]
        // OR
        'name' => ['a','b']
        // OR
        'date' => ['05/04/1980','05/04/1990']
    ]
])->fetchAll();

$db->select('peoples','all',[
    '!BETWEEN' => [
        'id' => [1,25]
        // OR
        'name' => ['a','b']
        // OR
        'date' => ['05/04/1980','05/04/1990']
    ]
])->fetchAll();

$db->select('peoples','all',[
    'LIKE' => [
        'name' => 'g%'
    ]
])->fetchAll();

$db->select('peoples','all',[
    '!LIKE' => [
        'name' => 'g%'
    ]
])->fetchAll();

$db->select('peoples','all',[
    'LIMIT' => 10
])->fetchAll()

$db->select('peoples','all',[
    'IN' => [
        'city' => ['Acoz','Pietraroja','Martelange','Relegem']
    ]
])->fetchAll();

$db->select('peoples','all',[
    '!IN' => [
        'city' => ['Acoz','Pietraroja','Martelange','Relegem']
    ]
])->fetchAll();

$db->select('peoples','all',[
    'IN' => [
        'date' => ['02/11/1985','11/27/1997','09/24/1969','01/15/1985','09/12/1986']
    ],
    'BETWEEN' => [
        'id' => [1,50]
    ],
    '!LIKE' => [
        'city' => 's%'
    ],
    'ORDER' => 'city ASC'
])->fetchAll();

$db->createDB('dbname');

$db->deleteDB('dbname');

$db->createTable('teste',[
    'id' => [
        'varchar',
        255,
        'AUTO_INCREMENT',
        '!NULL'
    ],
    'email' => [
        'varchar',
        100,
        '!NULL',
        'COMMENT' => 'Comment row'
    ],
    'PRIMARY KEY' => ['id']
],[
    'ENGINE' => 'MyISAM',
    'DEFAULT CHARSET' => 'utf8',
    'COLLATE' => 'utf8_bin',
    'STATS_PERSISTENT' => 0,
    'COMMENT' => 'comment'
]);

$db->insert('peoples',[
    'id' => 301,
    'name' => 'Gabriel',
    'phone' => '+0000000000',
    'date' => '00/00/0000',
    'email' => '[email protected]',
    'address' => 'Street teste address nº 1000 Av test',
    'city' => 'Araguaina',
    'country' => 'Brazil',
    'company' => 'No Company',
]);

$db->update('peoples',[
    'phone' => '+1111111111',
    'date' => '11/11/1111',
    'email' => '[email protected]',
    'address' => 'Street teste address nº 1000 Av test'
],[ 'id' => 301 ]);

$db->delete('peoples',[
    'id' => 301
]);

$db->deleteTable('peoples');

$db->truncate('peoples');

->getAvailableDrivers()
->commit()
->beginTransaction()
->rollBack()
->inTransaction()
->exec()
->quote()
->errorCode()
->errorInfo()
->query()
->rowCount()
->lastInsertId()
->prepare()
->bindColumn()
->bindParam()
->bindValue()
->closeCursor()
->columnCount()
->execute()
->fetch()
->fetchAll()
->fetchColumn()
->fetchObject()
->getAttribute()
->setAttribute()
->select()
->insert()
->update()
->delete()
->createDB()
->deleteDB()
->createTable()
->deleteTable()
->truncate()