$show = ''; $i = 0; while ($row = $this->result->fetchArray()) { $show .= '<li><span class="number">' . $row[0] . '</span><span class="date">' . $row[1] . '</span></li>'; $i++; } echo '<ol start="0" id="history"><li class="close">X</li>', $show, '<li class="opacity"><span class="plus">-</span><span class="minus">+</span></li></ol>'; } public function going($id) { $this->result = $this->query('SELECT ID, STATE, TIMESTAMP FROM HISTORY WHERE ID = ' . $id . ';'); echo $this->result->fetchArray()[1]; } public function insert($ul) { $this->exec('INSERT INTO HISTORY (STATE) VALUES (\'' . SQLite3::escapeString($ul) . '\');'); $this->result = $this->query('SELECT ID, STATE, TIMESTAMP FROM HISTORY WHERE ID = (SELECT max(ID)FROM HISTORY);'); echo $this->result->fetchArray()[1]; } } $insertul = new Crud(); if (isset($_POST['history'])) { $insertul->history(); } if (isset($_POST['insert'])) { $insertul->insert($_POST['insert']); } if (isset($_POST['id'])) { $num = intval($_POST['id']); $insertul->going($num); }
echo "error:" . $sql . "<br>" . $conn->error; } } public function update() { $sql = " Update faqs SET answer ='woh' WHERE id=1"; if ($this->conn->query($sql) === TRUE) { echo "Record updated successfully"; } else { echo "Error updating record: " . $conn->error; } } public function __destruct() { $this->conn->close(); } } $crud = new Crud(); switch ($_GET['action']) { case "read": $crud->read(); break; case "update": $crud->update(); break; case "delete": break; case "insert": $crud->insert(); break; }