$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' => '[email protected]') |
public function fetchRow($sql, $params = [])
{
$stmt = $this->prepare($sql, $params);
$result = $stmt->fetch(\PDO::FETCH_ASSOC);
$this->ok();
return $result;
} /**
* fetchRow
*/
public function testFetchRow()
{
$result = $this->db->fetchRow("SELECT * FROM test LIMIT 1");
$this->assertEquals(4, sizeof($result));
}
