Exemplos de voku\db DB::qry em PHP

Exemplo n.º 1

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

 public function testQry()
 {
     $result = $this->db->qry("UPDATE " . $this->db->escape($this->tableName) . "\n      SET\n        page_template = 'tpl_test'\n      WHERE page_id = ?\n    ", 1);
     self::assertEquals(1, $result);
     $result = $this->db->qry("SELECT * FROM " . $this->db->escape($this->tableName) . "\n      WHERE page_id = 1\n    ");
     self::assertEquals('tpl_test', $result[0]['page_template']);
     $result = $this->db->qry("SELECT * FROM " . $this->db->escape($this->tableName) . "\n      WHERE page_id_lall = 1\n    ");
     self::assertEquals(false, $result);
 }