public function delete($id = NULL) { if (is_null($id)) { Utility::message('No id available !!'); return Utility::redirect('index.php'); } $connect = mysql_connect("localhost", "root", "root"); $link = mysql_select_db("BITM"); $query = "DELETE FROM `radio` WHERE `id` = " . $id; $result = mysql_query($query); if ($result) { Utility::message("Delete is successful"); } else { Utility::message("Delete is failed."); } Utility::redirect('index.php'); }
public function delete($id = null) { if (is_null($id)) { Utility::message('No id available !!'); return Utility::redirect('index.php'); } $conn = mysql_connect("localhost", "root", "root") or die("Not connected"); $link = mysql_select_db("BITM") or die("Not connected table"); $query = "DELETE FROM `BITM`.`atomicProject` WHERE `atomicProject`.`id` = " . $id; $result = mysql_query($query); if ($result) { Utility::message("Delete is successful"); } else { Utility::message("Delete is failed."); } Utility::redirect('index.php'); }
public function recoverMultiple($ids = array()) { if (is_array($ids) && count($ids) > 0) { $_ids = implode(',', $ids); $query = "UPDATE `phone_data` SET `deleted_at` = NULL WHERE `id` IN({$_ids}) "; $result = mysql_query($query); if ($result) { Utility::message("Trash is successful"); } else { Utility::message("Trash is failed."); } Utility::redirect('index.php'); } else { Utility::message('No id available !!'); return Utility::redirect('index.php'); } }
use App\BITM\SEIP107348\Utility\Utility; $view = new Birthday(); $date = $view->update($_GET['id']); $id = $date['id']; if (isset($_POST['submit'])) { $date = $_POST['date']; $conn = mysql_connect("localhost", "root", "root") or die("not connected"); $lnk = mysql_select_db("BITM") or die("cannot select db table"); $query = "UPDATE `Date` SET `birthday`='" . $date . "' WHERE id='{$id}'"; $result = mysql_query($query); if ($result) { Utility::message("Update is successful"); } else { Utility::message("Update is failed."); } Utility::redirect('index.php'); } ?> <!DOCTYPE> <html> <head> <title>Birthday</title> <link href="../../../Asset/css/font-awesome.min.css" rel="stylesheet" type="text/css"/> <link href="../../../Asset/css/bootstrap.min.css" rel="stylesheet" type="text/css"/> <link href="../../../Asset/css/main.css" rel="stylesheet" type="text/css"/> <style> .add_book_form{ padding: 15px 170px;