Database connection

Need Help
3

A very simplified example in model:

    public function getPets()  // params would be used in real app
    {
        $dbh = ConnectionManager::get('default');
        $sql = "SELECT * FROM dc_pets Where `adopted` = :adpt";
        $sth = $dbh->prepare($sql);
        $params = ['adpt' => 0];
        $sth->execute($params);
        return $sth->fetchAll(\PDO::FETCH_OBJ);
    }

Of course if for real I’d pass in an offset and a rows per page to paginate