| 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 |
| 리턴 | array | |
public function fetchObjects($sql, $params = [], $object = null)
{
$stmt = $this->prepare($sql, $params);
if (is_string($object)) {
// fetch to some class by name
$result = $stmt->fetchAll(\PDO::FETCH_CLASS, $object);
} else {
// fetch to StdClass
$result = $stmt->fetchAll(\PDO::FETCH_OBJ);
}
$stmt->closeCursor();
$this->ok();
return $result;
} /**
* 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));
}
