PHP Query_Select::give_sql_and_values Beispiele

Beispiel #1

Datei: QuerySelect.php Projekt: reddragon010/RG-ServerPanel

 function testCount(){
     $sqlobj = new Query_Select($this->table,$this->fields);
     $testString = "SELECT count(*) as c FROM {$this->table} WHERE testTable.testid = :testid";
     $testValues = array(':testid' => '12');
     
     $sql->where(array('testid' => '12'))->count();
     list($sql, $values) = $sqlobj->give_sql_and_values();
     
     $this->assertEquals($testString, (string) $sql);
     $this->assertEquals($testValues,  $values);
 }