public function indexAction() { $adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter'); $sql = "SELECT *\n FROM watchdog\n LIMIT 0,5\n "; $statement = $adapter->createStatement($sql); $result = $statement->execute(); $p1 = new \Helloworld\Model\Person('Nadir Fouka', '47,Rue de la paix - Grenoble', '78500€', 'PHP Developer'); $p2 = new \Helloworld\Model\Person('Pierre Anderson', '347,Rue de la paix - Paris', '56600€', 'Java Developer'); $p3 = new \Helloworld\Model\Person('Maximus Miridus', '47,albert verdun - Lyon', '69500€', 'FullStack Developer'); $collection_person = array('p1' => $p1, 'p2' => $p2, 'p3' => $p3); $views = new ViewModel(array('text' => 'First Application With Zend Framework 2 ', 'par1' => 'parameters 2', 'p1' => $p1->getPerson(), 'all' => $collection_person, 'res' => $result)); return $views; }
public function rssAction() { $adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter'); $sql = "SELECT *\n FROM watchdog\n LIMIT 0,5\n "; $statement = $adapter->createStatement($sql); $result = $statement->execute(); /* $adapter = new \Zend\Db\Adapter\Adapter( array( 'driver' => 'Pdo', 'dsn' => 'mysql:dbname=drupal;hostname=localhost', 'username' => 'root', 'password' => 'lonelyness', 'driver_options' => array( \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\'' ), )) ; $isconnected = $adapter->getDriver()->getConnection() ; $value = $isconnected->execute("SELECT * FROM cachetags LIMIT 0 , 30") ; foreach ($value as $value){ print $value['tag']."<br/>" ; } * */ $p1 = new \Helloworld\Model\Person('Nadir Fouka', '47,Rue de la paix - Grenoble', '78500€', 'PHP Developer'); $p2 = new \Helloworld\Model\Person('Pierre Anderson', '347,Rue de la paix - Paris', '56600€', 'Java Developer'); $p3 = new \Helloworld\Model\Person('Maximus Miridus', '47,albert verdun - Lyon', '69500€', 'FullStack Developer'); $collection_person = array('p1' => $p1, 'p2' => $p2, 'p3' => $p3); $views = new ViewModel(array('text' => 'First Application With Zend Framework 2 ', 'par1' => 'parameters 2', 'p1' => $p1->getPerson(), 'all' => $collection_person, 'res' => $result)); return $views; }