fetchObjects() public method

Returns an array of objects containing the result set
public fetchObjects ( string $sql, array $params = [], mixed $object = null ) : array
$sql string SQL query with placeholders "SELECT * FROM users WHERE name = :name AND pass = :pass"
$params array params for query placeholders (optional) array (':name' => 'John', ':pass' => '123456')
$object mixed Class name or instance
return array
Db Class Documentation
Example #1
0
 /**
  * fetchObjects to declared class
  */
 public function testFetchObjectsToDeclaredClass()
 {
     $result = $this->db->fetchObjects("SELECT * FROM test LIMIT 10", array(), 'stdClass');
     $this->assertEquals(10, sizeof($result));
     $this->assertInstanceOf('\\stdClass', current($result));
 }