PHP UpdateQuery::parameters Exemples

Exemple #1

Fichier : UpdateQueryTest.php Projet : NinjaKC/MySQL-Query-Builder

 public function testOrderBy()
 {
     $q = new UpdateQuery(array('test'));
     $q->setValues(array('qwe' => 'qweqwe'));
     $q->setLimit(10);
     $q->setOrderBy(array(new Field('date')));
     $this->assertEquals('UPDATE `test` AS `t0` SET `t0`.`qwe` = :p1 ORDER BY `t0`.`date` ASC LIMIT 10', $q->sql());
     $params = $q->parameters();
     $this->assertEquals('qweqwe', $params[':p1']);
 }