Bluz\Db\Db::fetchOne PHP Method

fetchOne() public method

Example of usage $db->fetchOne("SELECT COUNT(*) FROM users");
public fetchOne ( string $sql, array $params = [] ) : string
$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 string
    public function fetchOne($sql, $params = [])
    {
        $stmt = $this->prepare($sql, $params);
        $result = $stmt->fetch(\PDO::FETCH_COLUMN);
        $this->ok();
        return $result;
    }

Usage Example

Ejemplo n.º 1
0
 /**
  * fetchOne
  */
 public function testFetchOne()
 {
     $result = $this->db->fetchOne("SELECT COUNT(*) FROM test");
     $this->assertEquals(42, $result);
 }