Example of usage
$db->fetchRow("SELECT name, email FROM users WHERE id = ". $db->quote($id));
$db->fetchRow("SELECT name, email FROM users WHERE id = ?", [$id]);
$db->fetchRow("SELECT name, email FROM users WHERE id = :id", [':id'=>$id]);
| public fetchRow ( string $sql, array $params = [] ) : 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') |
| return | array | array ('name' => 'John', 'email' => 'john@smith.com') |
/**
* fetchRow
*/
public function testFetchRow()
{
$result = $this->db->fetchRow("SELECT * FROM test LIMIT 1");
$this->assertEquals(4, sizeof($result));
}
