Exemplos de Bluz\Db Db::fetchPairs em PHP

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

Exemplo n.º 1

Arquivo: DbTest.php Projeto: dezvell/mm.local

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