User Model";
$user = new User();
var_dump($user);
echo "
Find By Id
";
$user = (new User())->findById($testId);
var_dump($user->data(), [$user->first_name, $user->full_name]);
/**
* FIND EXAMPLE
*/
echo "Find
";
//$result = $user->find()->fetch(true);
//$result = $user->find()->group("genre")->fetch(true);
//$result = $user->find()->limit(4)->fetch(true);
//$result = $user->find()->limit(2)->offset(2)->fetch(true);
//$result = $user->find()->limit(4)->offset(2)->order("id DESC")->fetch(true);
//$result = $user->find()->limit(2)->offset(2)->order("RAND()")->fetch(true);
$result = $user->find()->limit(1)->fetch(true);
$totalUsers = $user->find()->count();
echo "{$totalUsers} cadastros!
";
if ($result) {
foreach ($result as $user) {
var_dump($user->data());
}
} else {
echo "Not Users
";
}
echo "Find IN
";
$result = $user->find()->in("id", [1, 2, 3])->fetch(true);
if ($result) {
foreach ($result as $user) {
var_dump($user->data());
}
} else {
echo "Not Users
";
}
echo "Secure Params
";
$params = http_build_query(["name" => "UpInside"]);
$company = (new Company())->find("name = :name", $params);
var_dump($company->fetch()->data());
echo "Join
";
$addresses = new Address();
$address = $addresses->findById($testId);
$address->getUser();
var_dump($address->data());
echo "Table Columns
";
var_dump($user->columns()); //object
var_dump($user->columns(PDO::FETCH_COLUMN));