Bluz\Db\Db::fetchPairs PHP Method

fetchPairs() public method

Returns a key-value array
public fetchPairs ( string $sql, array $params = [] ) : array
$sql string SQL query with placeholders "SELECT id, username FROM users WHERE ip = :ip"
$params array params for query placeholders (optional) array (':ip' => '127.0.0.1')
return array
    public function fetchPairs($sql, $params = [])
    {
        $stmt = $this->prepare($sql, $params);
        $result = $stmt->fetchAll(\PDO::FETCH_KEY_PAIR);
        $this->ok();
        return $result;
    }

Usage Example

Esempio n. 1
0
 /**
  * fetchPairs
  */
 public function testFetchPairs()
 {
     $result = $this->db->fetchPairs("SELECT email, name FROM test LIMIT 10");
     $this->assertEquals(10, sizeof($result));
 }