Example of usage
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 | |
| return | array | |
/**
* fetchObject to instance
*/
public function testFetchObjectToInstance()
{
$result = $this->db->fetchObject("SELECT * FROM test LIMIT 1", array(), new \stdClass());
$this->assertInstanceOf('\\stdClass', $result);
}
