/** * Xóa bản ghi có khóa chính là $id */ function categories_delete($id) { $id = intval($id); //xóa sản phẩm require_once 'backend/models/products.php'; $options = array('select' => 'id', 'where' => 'category_id=' . $id); $products = get_all('products', $options); foreach ($products as $product) { products_delete($product['id']); } //xóa danh mục $sql = "DELETE FROM categories WHERE id={$id}"; mysql_query($sql) or die(mysql_error()); }
<?php //load model require_once 'backend/models/model.php'; require_once 'backend/models/products.php'; $pid = intval($_GET['pid']); $status = 'none'; $status = products_delete($pid, $status); $url = 'location:admin.php?controller=product'; $url .= $status != 'none' ? '&statusdelete=' . $status : ''; header($url);
<?php //load model require_once 'backend/models/products.php'; if (isset($_POST['search'])) { header('location:admin.php?controller=product&search=' . $_POST['search']); } if (isset($_POST['pid'])) { foreach ($_POST['pid'] as $pid) { $pid = intval($pid); products_delete($pid); } } if (isset($_GET['page'])) { $page = intval($_GET['page']); } else { $page = 1; } $page = $page > 0 ? $page : 1; $limit = 10; $offset = ($page - 1) * $limit; $options = array('limit' => $limit, 'offset' => $offset, 'order_by' => 'id DESC'); $url = 'admin.php?controller=product'; if (isset($_GET['search'])) { $search = escape($_GET['search']); $options['where'] = "name LIKE '%{$search}%'"; $url = 'admin.php?controller=product&search=' . $_GET['search']; } $total_rows = get_total('products', $options); $total = ceil($total_rows / $limit); //data