function get_nav_category($id = null)
{
$return = array();
$query = 'select `category_id`,`category_name` from category where `categoryarea_id` = ' . $id . ' AND `category_status` = "open" order by `category_priority` asc ;';
$query = query_despace($query);
$result = mysql_query($query);
//有'項目'才填充資料 - 讓左側的category項目填滿不用limit
if (mysql_num_rows($result) > 0) {
$nav_category = array();
while ($row = mysql_fetch_array($result)) {
$nav_category['id'] = $row['category_id'];
$nav_category['name'] = $row['category_name'];
$return[] = $nav_category;
}
}
return $return;
}
<?php
if (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
$value = !empty($_POST['value']) ? $_POST['value'] : null;
if ($value == null) {
json_encode_return(0, '未輸入內容');
}
$value = stripslashes(htmlspecialchars($value));
$new_id = 3;
$query = 'UPDATE `about` SET `value` = \'' . $value . '\' , `modify_name` = "' . $_SESSION['admin']['name'] . '" ,`modify_time` = NOW() WHERE `about`.`id` = "' . $new_id . '" LIMIT 1 ; ';
$query = query_despace($query);
$result = mysql_query($query);
!$result ? json_encode_return(0, '修改失敗，請確認您輸入的資料是否有誤', URL_ADMIN2_ROOT . 'about') : json_encode_return(1, '修改成功', URL_ADMIN2_ROOT . 'about');
}
header('Content-type: text/html; charset=utf-8');
header('Location: http://' . $_SERVER['SERVER_NAME']);
<!DOCTYPE html>
<html>
<?php
include '../head.php';
?>
<body class="hold-transition skin-blue sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
<?php
include '../header.php';
?>
<?php
include '../navbar.php';
?>
<?php
$query = query_despace('select * from `contact` where status != "delete" order by `inserttime` desc;');
$result = mysql_query($query);
$data = array();
$a_contact_open = array();
$a_contact_archive = array();
while ($row = mysql_fetch_assoc($result)) {
$data[] = $row;
}
foreach ($data as $k => $v) {
$v['read'] = $data[$k]['read'] == 'read' ? '<span class="label label-success">Read</span>' : '<span class="label label-warning">Unread</span>';
if ($v['status'] == 'open') {
$a_contact_open[] = $v;
} else {
$a_contact_archive[] = $v;
}
}
function get_product_id(array $category_id)
{
$query = 'select `product_id` from product where `product_status` != "delete" and product_category_id IN (' . implode(',', $category_id) . ') ;';
$query = query_despace($query);
$result = mysql_query($query);
$product_id_list = array();
while ($row = mysql_fetch_assoc($result)) {
$product_id_list[] = $row['product_id'];
}
return !empty($product_id_list) ? $product_id_list : null;
}
<!DOCTYPE html>
<html>
<?php
include '../head.php';
?>
<body class="hold-transition skin-blue sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
<?php
include '../header.php';
?>
<?php
include '../navbar.php';
?>
<?php
$query = query_despace('select * from `admin`;');
$result = mysql_query($query);
if (!$result) {
redirect_php(URL_ADMIN2_ROOT);
}
$a_admin = array();
while ($row = mysql_fetch_assoc($result)) {
$a_admin[] = $row;
}
?>
<div class="content-wrapper">
<section class="content-header">
<div class="box-body"><h2>管理員設定</h2></div>
<h1>
<small><p class="text-light-blue">(若不需修改密碼請將該欄位留空)</p></small>
</h1>
function del_product_meta(array $product_id_list)
{
$query = 'DELETE FROM product_meta WHERE product_id IN (' . implode(',', $product_id_list) . ') ;';
$query = query_despace($query);
return mysql_query($query);
}
$num = 20;
$start_page = ($page - 1) * $num;
//只取有`category`的area且ID不重複
$query = 'select DISTINCT `categoryarea`.`categoryarea_id` AS id , `categoryarea`.`categoryarea_name` AS name, `categoryarea`.`categoryarea_description` AS description ,`categoryarea`.`categoryarea_cover` AS cover
from category inner join `categoryarea` on `categoryarea`.`categoryarea_id` = `category`.`categoryarea_id`
where `categoryarea_status` = "open" and `category`.`category_id` != "" and `category`.`category_status` = "open"
order by `categoryarea_priority`
asc limit ' . $start_page . ',' . $num . ';';
$query = query_despace($query);
$result = mysql_query($query);
$n_query = $query = 'select DISTINCT `categoryarea`.`categoryarea_id` AS id , `categoryarea`.`categoryarea_name` AS name, `categoryarea`.`categoryarea_description` AS description ,`categoryarea`.`categoryarea_cover` AS cover
from category inner join `categoryarea` on `categoryarea`.`categoryarea_id` = `category`.`categoryarea_id`
where `categoryarea_status` = "open" and `category`.`category_id` != "" and `category`.`category_status` = "open"
order by `categoryarea_priority`
asc ;';
$n_query = query_despace($n_query);
$n_result = mysql_query($n_query);
$num_rows = mysql_num_rows($n_result);
if (!$result) {
echo 'Error!';
exit;
}
$categoryarea = array();
$n = 1;
while ($row = mysql_fetch_array($result)) {
$categoryarea[$n]['categoryarea_id'] = $row['id'];
$categoryarea[$n]['categoryarea_name'] = $row['name'];
$categoryarea[$n]['categoryarea_description'] = $row['description'];
$categoryarea[$n]['categoryarea_cover'] = $row['cover'];
$n++;
}
<!DOCTYPE html>
<html>
<?php
include '../head.php';
?>
<body class="hold-transition skin-blue sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
<?php
include '../header.php';
?>
<?php
include '../navbar.php';
?>
<?php
$query = query_despace('select * from `categoryarea` where `categoryarea_status` != "delete" order by `categoryarea_insert_time` desc;');
$result = mysql_query($query);
$data = array();
while ($row = mysql_fetch_assoc($result)) {
$data[] = $row;
}
foreach ($data as $k => $v) {
$data[$k]['categoryarea_status'] = $data[$k]['categoryarea_status'] == 'open' ? '<span class="label label-success">Open</span>' : '<span class="label label-warning">Close</span>';
}
?>
<div class="content-wrapper">
<section class="content-header">
<div class="box-body"><h2>產品類別管理</h2></div>
<h1>
<small><p class="text-light-blue"></p></small>
</h1>
<?php
if (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
$data = !empty($_POST['data']) ? $_POST['data'] : null;
if ($data == null) {
json_encode_return(0, '未輸入內容');
}
$data = json_decode($data, true);
/**
* v0[0] => admin_account, v0[1] => admin_password , v0[2] => admin_name , v0[3] => admin_email , v0[4] => id
*/
foreach ($data as $k0 => $v0) {
$query = 'update `admin` set `admin_account` = "' . $v0[0] . '",';
if (!empty($v0[1]) && $v0[1] != '') {
$query .= '`admin_password` = "' . $v0[1] . '",';
}
$query .= '`admin_name` = "' . $v0[2] . '", `admin_email` = "' . $v0[3] . '" where `id` = "' . $v0[4] . '" ;';
$result = mysql_query(query_despace($query));
if (!$result) {
json_encode_return(0, '修改失敗. [Error id:' . $v0[4] . ']', URL_ADMIN2_ROOT . 'system/admin.php');
}
}
json_encode_return(1, '修改成功', URL_ADMIN2_ROOT . 'system/admin.php');
}
header('Content-type: text/html; charset=utf-8');
header('Location: http://' . $_SERVER['SERVER_NAME']);
<!DOCTYPE html>
<html>
<?php
include '../head.php';
?>
<body class="hold-transition skin-blue sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
<?php
include '../header.php';
?>
<?php
include '../navbar.php';
?>
<?php
$query = query_despace('select * from `system`;');
$result = mysql_query($query);
if (!$result) {
redirect_php(URL_ADMIN2_ROOT);
}
$row = mysql_fetch_assoc($result);
$flat_check = null;
$birman_check = null;
$classic_check = null;
$single_check = null;
$horizontal_check = null;
switch ($row['social_skin']) {
case 'flat':
$flat_check = 'checked="true"';
break;
case 'birman':
<!DOCTYPE html>
<html>
<?php
include '../head.php';
?>
<body class="hold-transition skin-blue sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
<?php
include '../header.php';
?>
<?php
include '../navbar.php';
?>
<?php
$query = query_despace('select `product`.* , `category`.`category_name` from `product` left JOIN `category` on product.product_category_id = category.category_id where `product`.`product_status` != "delete" order by `product_modify_time` desc');
$result = mysql_query($query);
$data = array();
while ($row = mysql_fetch_assoc($result)) {
$data[] = $row;
}
foreach ($data as $k => $v) {
$data[$k]['product_status'] = $data[$k]['product_status'] == 'open' ? '<span class="label label-success">Open</span>' : '<span class="label label-warning">Close</span>';
}
?>
<div class="content-wrapper">
<section class="content-header">
<div class="box-body"><h2>產品管理</h2></div>
<h1>
<small><p class="text-light-blue"></p></small>
</h1>
<!DOCTYPE html>
<html>
<?php
include '../head.php';
?>
<body class="hold-transition skin-blue sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
<?php
include '../header.php';
?>
<?php
include '../navbar.php';
?>
<?php
$query = query_despace('select * from `sociallink`;');
$result = mysql_query($query);
if (!$result) {
redirect_php(URL_ADMIN2_ROOT);
}
$a_sociallink = array();
while ($row = mysql_fetch_assoc($result)) {
$a_sociallink[] = $row;
}
foreach ($a_sociallink as $k => $v) {
$a_sociallink[$k]['status'] = $a_sociallink[$k]['status'] == 'open' ? 'On' : 'Off';
}
$a_icon = ['fa-google', 'fa-facebook', 'fa-flickr', 'fa-twitter', 'fa-google', 'fa-instagram', 'fa-linkedin', 'fa-pinterest', 'fa-tumblr'];
?>
<div class="content-wrapper">
<section class="content-header">
<!DOCTYPE html>
<html>
<?php
include '../head.php';
?>
<body class="hold-transition skin-blue sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
<?php
include '../header.php';
?>
<?php
include '../navbar.php';
?>
<?php
$query = query_despace('select * from about where id = 3');
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
$data = $row;
}
?>
<div class="content-wrapper">
<section class="content-header">
<div class="box-body"><h2>關於品利興</h2></div>
<h1>
<small><p class="text-light-blue">(建議上傳圖片格式: PNG / JPEG / JPG)</p></small>
</h1>
<ol class="breadcrumb">
<li><a href="<?php
echo URL_ADMIN2_ROOT;
/**
* 0108 透過product_id取得前台產品的連結網址
*/
function get_product_url($id = null)
{
$return = null;
if ($id != null) {
$query = query_despace('select * from `product` where `product_id` = ' . $id . ' ;');
$result = mysql_query($query);
$product = mysql_fetch_assoc($result);
if (empty($product)) {
return $return;
}
$query = query_despace('select * from `category` where `category_status` = "open" and `category_id` = ' . $product['product_category_id'] . ' ;');
$result = mysql_query($query);
$category = mysql_fetch_assoc($result);
if (empty($category)) {
return $return;
}
$query = query_despace('select * from `categoryarea` where `categoryarea_status` = "open" and `categoryarea_id` = ' . $category['categoryarea_id'] . ' ;');
$result = mysql_query($query);
$categoryarea = mysql_fetch_assoc($result);
if (empty($categoryarea)) {
return $return;
}
$param = 'goods=' . base64_encode($categoryarea['categoryarea_id']) . '&category=' . base64_encode($category['category_id']) . '&items=' . base64_encode($product['product_id']);
$return = '<a target="_blank" href="' . URL_ROOT . 'product?' . $param . '">' . $product['product_name'] . '</a>';
}
return $return;
}
<?php
if (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
$contact_id = !empty($_POST['contact_id']) ? $_POST['contact_id'] : null;
$act = !empty($_POST['act']) ? $_POST['act'] : null;
if ($contact_id == null || $act == null) {
json_encode_return(0, '[Error] 資料錯誤請重新操作');
}
switch ($act) {
case 'archive':
$query = query_despace('UPDATE `contact` SET `status` = "archive" where `id` = "' . $contact_id . '" limit 1');
$result = mysql_query($query);
!$result ? json_encode_return(0, '修改失敗，請確認您輸入的資料是否有誤', URL_ADMIN2_ROOT . 'contact/content.php?contact_id=' . $contact_id) : json_encode_return(1, '修改成功', URL_ADMIN2_ROOT . 'contact/content.php?contact_id=' . $contact_id);
break;
case 'delete':
$query = query_despace('UPDATE `contact` SET `status` = "delete" where `id` = "' . $contact_id . '" limit 1');
$result = mysql_query($query);
!$result ? json_encode_return(0, '刪除資料失敗，請確認您輸入的資料是否有誤', URL_ADMIN2_ROOT . 'contact') : json_encode_return(1, '刪除資料成功', URL_ADMIN2_ROOT . 'contact');
break;
}
}
header('Content-type: text/html; charset=utf-8');
header('Location: http://' . $_SERVER['SERVER_NAME']);
<?php
if (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
$inquiry_id = !empty($_POST['inquiry_id']) ? $_POST['inquiry_id'] : null;
$act = !empty($_POST['act']) ? $_POST['act'] : null;
if ($inquiry_id == null || $act == null) {
json_encode_return(0, '[Error] 資料錯誤請重新操作');
}
switch ($act) {
case 'archive':
$query = query_despace('UPDATE `inquiry` SET `status` = "archive" where `id` = "' . $inquiry_id . '" limit 1');
$result = mysql_query($query);
!$result ? json_encode_return(0, '修改失敗，請確認您輸入的資料是否有誤', URL_ADMIN2_ROOT . 'inquiry/content.php?inquiry_id=' . $inquiry_id) : json_encode_return(1, '修改成功', URL_ADMIN2_ROOT . 'inquiry/content.php?inquiry_id=' . $inquiry_id);
break;
case 'delete':
$query = query_despace('UPDATE `inquiry` SET `status` = "delete" where `id` = "' . $inquiry_id . '" limit 1');
$result = mysql_query($query);
!$result ? json_encode_return(0, '刪除資料失敗，請確認您輸入的資料是否有誤', URL_ADMIN2_ROOT . 'inquiry') : json_encode_return(1, '刪除資料成功', URL_ADMIN2_ROOT . 'inquiry');
break;
}
}
header('Content-type: text/html; charset=utf-8');
header('Location: http://' . $_SERVER['SERVER_NAME']);
