PHP Zend\Db\Sql\Where::literal Exemples

Exemple #1

Fichier : ExerciseSqlController.php Projet : trongle/zend-2

 public function index10Action()
 {
     $subObj = new Select("building");
     $subObj->columns(array("cost"))->where(new Pre\Expression("city = ?", array("can tho")));
     $stringSql = $this->createSqlString($subObj);
     $selectObj = new Select("building");
     $where = new \Zend\Db\Sql\Where();
     $where->literal(sprintf("cost > ANY (%s)", $stringSql))->notEqualTo("city", "can tho");
     $selectObj->columns(array("id", "name", "address", "cost"))->where($where);
     $this->showResult($selectObj);
     return false;
 }