<?php

// composer require aura/sqlquery
require_once __DIR__ . '/vendor/autoload.php';

$host = '127.0.0.1';
$dbname = 'querybuilder';
$username = 'root';
$password = '';
$charset = 'utf8';
$collate = 'utf8_unicode_ci';

$pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=$charset", $username, $password, array(
		PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
		PDO::ATTR_PERSISTENT => false,
		PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
		PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES $charset COLLATE $collate"
	));

use Aura\SqlQuery\QueryFactory;

$queryFactory = new QueryFactory('mysql');

$select = $queryFactory->newSelect();
$insert = $queryFactory->newInsert();
$update = $queryFactory->newUpdate();
$delete = $queryFactory->newDelete();

// INSERT
$insert->into('users')
->cols([
	'username' => 'name-' . date('Y-m-d H:i:s'),
]);

$sth = $pdo->prepare($insert->getStatement());
$sth->execute($insert->getBindValues());
$name = $insert->getLastInsertIdName('id');
$id = $pdo->lastInsertId($name);
echo "ID: " . $id . "<br>";


// SELECT
$select->cols(['*'])->from('users')->where('id > ?', 10)->orderBy(['id DESC'])->limit(10);

echo $select->__toString();

// prepare the statement
$sth = $pdo->prepare($select->getStatement());

// bind the values and execute
$sth->execute($select->getBindValues());

// get the results back as an associative array
$result = $sth->fetchAll();

var_dump($result);