Example #1
0
    }
    function getServiceCategoryDetail($category_alias)
    {
        $sql = "SELECT category_id FROM `tbl_service_category` WHERE `category_alias` = '{$category_alias}'";
        $result = $this->fetchData('single', $sql);
        return $result;
    }
    function getServiceCategories()
    {
        $sql = "SELECT * FROM `tbl_service_category` ORDER BY `category_order`";
        $result = $this->fetchData('multiple', $sql);
        return $result;
    }
}
/* --- CONSTRUCT CLASS --- */
$_global = new HeaderGlobal();
/*
# ----------------------------------------------------------------------
# DEFINED VARIABLE
# ----------------------------------------------------------------------
*/
/* --- ACTION PAGE --- */
if (isset($_REQUEST['act']) && $_REQUEST['act'] != '' && $_REQUEST['act'] != 'empty') {
    $_temp_act = $_REQUEST['act'];
} else {
    $_temp_act = 'empty';
}
/* --- USER LOGIN --- */
if (isset($_SESSION['account'])) {
    $_global_user_temp = $_SESSION['account']['login_id'];
} else {
Example #2
0
    }
    function update_log($order_id, $description, $note, $created_date)
    {
        $sql = "INSERT INTO `tbl_order_log` (order_id, `description`, `note`, `created_date`) VALUES(?, ?, ?, ?)";
        $stmt = $this->conn->prepare($sql);
        if ($stmt === false) {
            trigger_error('Database error: ' . $sql . ' Error: ' . $this->conn->errno . ' ' . $this->conn->error, E_USER_ERROR);
        } else {
            $stmt->bind_param("isss", $order_id, $description, $note, $created_date);
            $stmt->execute();
        }
        $stmt->close();
    }
}
/* --- CONSTRUCT CLASS --- */
$_global = new HeaderGlobal();
/*
# ----------------------------------------------------------------------
# DEFINED VARIABLE
# ----------------------------------------------------------------------
*/
/* --- ACTION PAGE --- */
if (isset($_REQUEST['act']) && $_REQUEST['act'] != '' && $_REQUEST['act'] != 'empty') {
    $_temp_act = $_REQUEST['act'];
} else {
    $_temp_act = 'empty';
}
/* --- USER LOGIN --- */
if (isset($_SESSION['account'])) {
    $_global_user_temp = $_SESSION['account']['login_id'];
} else {