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') |