Exemplos de voku\db DB::secure em PHP

Exemplo n.º 1

Arquivo: SimpleDbTest.php Projeto: jensaronsson/simple-mysqli

 public function testExecSQL()
 {
     // execSQL - false
     $sql = "INSERT INTO " . $this->tableName . "\n      SET\n        page_template_lall = '" . $this->db->escape('tpl_test_new7') . "',\n        page_type = " . $this->db->secure('öäü') . "\n    ";
     $return = $this->db->execSQL($sql);
     self::assertEquals(false, $return);
     // execSQL - true
     $sql = "INSERT INTO " . $this->tableName . "\n      SET\n        page_template = '" . $this->db->escape('tpl_test_new7') . "',\n        page_type = " . $this->db->secure('öäü') . "\n    ";
     $return = $this->db->execSQL($sql);
     self::assertEquals(true, is_int($return));
     self::assertEquals(true, $return > 0);
 }