function handleDELETE() { $conn = Connection::startConnection(); $id = file_get_contents("php://input"); $book = new Book(); $book->deleteBook($conn, $id); Connection::stopConnecion($conn); header('Content-type: application/json'); }
function testDeleteBook() { $title = "BRING ON THE PAIN"; $id = 1; $test_book = new Book($title, $id); $test_book->save(); $title2 = "Oh Yeah"; $id2 = 2; $test_book2 = new Book($title2, $id2); $test_book2->save(); $test_book->deleteBook(); $this->assertEquals([$test_book2], Book::getAll()); }
<?php class Book { public function deleteBook() { $tid = $_GET['tid']; $link = mysql_connect('localhost', 'root', '') or die('No se pudo conectar al servidor: ' . mysql_error()); mysql_select_db('books') or die('No se pudo seleccionar la base de datos'); mysql_query("SET NAMES 'utf8'"); $query = "DELETE FROM `books` WHERE `books`.`id` = {$tid}"; $result = mysql_query($query) or die('Consulta fallida: ' . mysql_error()); if ($result) { echo "Eliminado."; unlink("archivo" . $tid . ".html"); } mysql_close($link); } } $book = new Book(); $book->deleteBook(); echo "<br><br>"; echo "<a href='index.php'>Back</a>";