Bluz\Db\Db::fetchObject
Returns an object containing first row from the result set
Example of usage <code> // 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); </code>
Signature
public function fetchObject(string
$sql,
[array
$params = ,
[string
$object = 'stdClass']] )
Parameters
$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
— string
Returns
- array