/**
* 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
