Example #1
0
$page = 1;
//Default page
$limit = 25;
//Records per page
$start = 0;
//starts displaying records from 0
if (isset($_GET['page']) && $_GET['page'] != '') {
    $page = $_GET['page'];
}
$start = ($page - 1) * $limit;
if ($_GET['limite']) {
    $limit = $_GET['limite'];
}
$users = getusers_list_temp($_REQUEST['sort'], $start, $limit);
//$rows= '4273';
$rows = count(CustomersCount());
$last_element = $_GET['page'];
if ($_GET['delete_id']) {
    $delete_id = $_GET['delete_id'];
    $sql = "UPDATE sohorepro_company\r\r\n\t\t\tSET     status = '0',\r\r\n                        archive = '1' \r\r\n                        WHERE comp_id= '" . $delete_id . "' ";
    $sql_result = mysql_query($sql);
    if ($sql_result) {
        $result = "success_del";
    } else {
        $result = "failure_del";
    }
}
if ($_GET['delete_product_id']) {
    $delete_id = $_GET['delete_product_id'];
    $sql = "DELETE FROM sohorepro_special_pricing WHERE sp_id = " . $delete_id . " ";
    $sql_result = mysql_query($sql);
Example #2
0
//Records per page
$start = 0;
//starts displaying records from 0
if (isset($_GET['page']) && $_GET['page'] != '') {
    $page = $_GET['page'];
}
$start = ($page - 1) * $limit;
if ($_GET['limite']) {
    $limit = $_GET['limite'];
}
$users = getusers_list_temp($_REQUEST['sort'], $start, $limit);
$filter_by_customer = $_GET["cus_type_fil"];
$admin_added = $_GET["admin_added"] != '' ? $_GET["admin_added"] : '';
$filtered_customer = FilterByCustomer($filter_by_customer, $admin_added, $start, $limit);
//$rows= '4273';
$rows = $filter_by_customer != '' ? count(FilterByCustomerCount($filter_by_customer)) : count(CustomersCount());
$last_element = $_GET['page'];
if ($_GET['delete_id']) {
    $delete_id = $_GET['delete_id'];
    /* $sql = "UPDATE sohorepro_company
       SET     status = '0',
       archive = '1'
       WHERE comp_id= '" . $delete_id . "' "; */
    $sql_user = "******" . $delete_id . "'";
    mysql_query($sql_user);
    $sql = "DELETE FROM sohorepro_company WHERE comp_id = " . $delete_id . " ";
    $sql_result = mysql_query($sql);
    if ($sql_result) {
        $result = "success_del";
    } else {
        $result = "failure_del";