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));