Select all
| public select_all ( string $query ) : array | ||
| $query | string | query to run |
| return | array | |
/**
* test multiple queries
*/
public function test_multiple_queries()
{
$this->adapter->execute_ddl("CREATE TABLE users ( name varchar(20) );");
$this->adapter->multi_query("\n INSERT INTO users (name)\n VALUES ('Bill');\n INSERT INTO users (name)\n VALUES ('John')\n ");
$users = $this->adapter->select_all('SELECT * FROM users');
$expected = array(array('name' => 'Bill'), array('name' => 'John'));
$this->assertEquals($expected, $users);
}
/**
* Select all query
*
* @param string $sql the query to run
*
* @return array
*/
public function select_all($sql)
{
return $this->_adapter->select_all($sql);
}
