Fetch object to stdClass
$stdClass = $db->fetchObject('SELECT * FROM some_table WHERE id = ?', [$id]);
Fetch object to new Some object
$someClass = $db->fetchObject('SELECT * FROM some_table WHERE id = ?', [$id], 'Some');
Fetch object to exists instance of Some object
$someClass = $db->fetchObject('SELECT * FROM some_table WHERE id = ?', [$id], $someClass);
| public fetchObject ( string $sql, array $params = [], mixed $object = 'stdClass' ) : 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 | |
| 리턴 | array | |
public function fetchObject($sql, $params = [], $object = 'stdClass')
{
$stmt = $this->prepare($sql, $params);
if (is_string($object)) {
// some class name
$result = $stmt->fetchObject($object);
} else {
// some instance
$stmt->setFetchMode(\PDO::FETCH_INTO, $object);
$result = $stmt->fetch(\PDO::FETCH_INTO);
}
$stmt->closeCursor();
$this->ok();
return $result;
} /**
* fetchObject to instance
*/
public function testFetchObjectToInstance()
{
$result = $this->db->fetchObject("SELECT * FROM test LIMIT 1", array(), new \stdClass());
$this->assertInstanceOf('\\stdClass', $result);
}
