<?php
require __DIR__ . '/../vendor/autoload.php';

honwei189\Flayer\Config::load();
$app = new honwei189\Flayer;
$app->bind("honwei189\\FDO");

$dbh = $app->FDO()->connect(honwei189\Flayer\Config::get("database", "mysql"));

foreach ($app->FDO()->q('SELECT * from users') as $row) {
    print_r($row);
}

## Insert data
$insert = $app->FDO()->from("users");
$insert->name = "AAA";
$insert->email = "aaa@example";
$insert->gender = "M";
echo $insert->store(); // or you can use $insert->save();

## Altenative way to insert...

foreach($app->FDO()->_post as $k => $v) { // or $insert->_post
    $insert->$k = $v;
}

$insert->soft_update(false); // true = Dry run only
$insert->store();


## Update data
$update = $app->FDO()->from("users");
$update->name = "A.AA";
$update->update($insert->_id); // or you can use $update->save($this->_id);

# Delete data
$delete = $app->FDO()->from("users");
$delete->by_id($insert->_id)->delete(); // or you can use $delete->delete("id = ". $insert->_id);  or you can use $delete->where("id", $insert->_id)->delete();

## Retrieve data from DB
$users = $app->FDO()->from("users"); // Get data from table -- users
$users->debug(false); // false = disable debug mode.  stop printing SQL
print_r($users->where("userid='admin'")->get("id, userid, name"));

var_dump($app::FDO()->is_connected());
var_dump(honwei189\Flayer\Core::FDO()->is_connected());


var_dump($app->FDO()->is_connected());
foreach ($dbh->query('SELECT * from users') as $row) {
    print_r($row);
}

var_dump(honwei189\Flayer\Container::get("FDO")->is_connected());

$app->FDO()->fetch_mode(\PDO::FETCH_INTO);

$app->FDO()->set_table("users"); // Get data from table -- users
print_r($app->FDO()->where("userid='admin'")->get("id, userid, name"));
print_r($app->FDO()->users()->get("id, userid, name"));

class aaa
{
    public $id;
    public $m_name;
}

 
print_r($app->FDO()->users()->fetch_mode()->limit(20)->find());  // Get data from table -- users  with default fetch mode -- PDO::FETCH_LAZY

$list = $app->FDO()->history_logs(); // Get data from table -- history_logs
print_r($list->fetch_mode(\PDO::FETCH_INTO, new aaa)->limit(20)->order_by("id", "desc")->find("id, m_name"));
print_r($list->limit(20)->order_by("id", "desc")->cols("id, m_name")->find());
print_r($list->limit(20)->order_by("id", "desc")->cols(["id", "m_name"])->find());