public function edit($step) { $obj = new Answer(); if (!$_POST) { $data = $this->_get_test(); $topics = $data['topics']; $topic_id = $topics[$step - 1]['id']; $condition = array('user_id' => $this->_user->id, 'topic_id' => $topic_id); $obj->where($condition)->get(); $json = array_merge($obj->to_array(), $this->_get_test()); $json['aChoose'] = $json['aChoose'] ? explode(',', $json['aChoose']) : array(); echo json_encode($this->_filter($json)); } else { if (isset($_POST['model']) and $model = $_POST['model']) { $data = json_decode($model); $get = $this->_save($data); if (isset($get['error'])) { json_encode($get); } else { $get['aChoose'] = explode(',', $get['aChoose']); echo json_encode($this->_filter($get)); } } else { if (isset($_POST['_method']) and $_POST['_method'] === 'DELETE') { $obj->delete(); } } } }
public static function delete($id) { $db = Connection::getInstance(); // delete answer require_once ROOT . DS . 'application' . DS . 'model' . DS . 'class.answer.php'; Answer::delete($id); // delete thread $sql = "DELETE FROM sse_thread WHERE thread_id = :id"; $statement = $db->prepare($sql); $statement->execute(array(':id' => $id)); }
<?php require_once "/etc/apache2/capstone-mysql/encrypted-config.php"; require_once "answer.php"; $pdo = connectToEncryptedMySQL("/etc/apache2/data-design/jfindley2.ini"); $answer = new Answer(null, 1, 2, "The answer", null); $answer->insert($pdo); $answer->setAnswerText("A better answer"); $answer->update($pdo); $answer->delete($pdo);
function test_delete() { //Arrange $test_field = "Joe FindById"; $test_quest_id = 1; $test_answer = new Answer($test_field, $test_quest_id); $test_answer->save(); $test_field2 = "Red FindById"; $test_quest_id2 = 2; $test_answer2 = new Answer($test_field2, $test_quest_id2); $test_answer2->save(); //Act $test_answer->delete(); $result = Answer::getAll(); //Assert $this->assertEquals($test_answer2, $result[0]); }