PHP Phalcon\Db\Adapter\Pdo\Mysql::fetchAll Beispiele

Beispiel #1

Datei: SearchCountryController.php Projekt: Just-a-fire/phalcon_test

 public function searchAction()
 {
     $connection = new Phalcon\Db\Adapter\Pdo\Mysql(array("host" => "localhost", "username" => "root", "password" => "", "dbname" => "test_phalcon"));
     $value = $this->request->getPost("value");
     $resultset = $connection->query("SELECT * FROM country WHERE name LIKE '%{$value}%'");
     $countries = $connection->fetchAll("SELECT * FROM country WHERE name LIKE '%{$value}%' LIMIT 5", Phalcon\Db::FETCH_ASSOC);
     foreach ($countries as $country) {
         echo $country['name'] . "!!!";
     }
 }