photos/admin_classify.php at master · g618/photos · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
<?php
require 'loginheader.php';
require_once '_header.php';
$page_title = '分類管理';
$op         = '';

// die(var_dump($_SESSION));/*檢查有沒有session*/

$op = isset($_REQUEST['op']) ? filter_var($_REQUEST['op']) : '';
$sn = isset($_REQUEST['sn']) ? (int) $_REQUEST['sn'] : 0;

/***************** ↓ 流程控制區 ↓ ********************/
switch ($op) {

    case 'insert':
        $sn = data_insert();
        header("location: index.php");
        exit;

    case 'modify':
        data_modify($sn);
        header("location: index.php");
        exit;

    case 'delete':
        data_delete($sn);
        header("location: index.php");
        exit;

    default:
        if ($sn) {
            $op = 'classify_modify';
            show_classify($sn);
        } /*else {
        $op = 'home';
        }*/
        break;
}

require_once '_footer.php';

/******************* ↓ 函式區 ↓ **********************/

//新增資料
function data_insert()
{
    global $db;
    $title       = $db->real_escape_string($_POST['title']);
    $description = $db->real_escape_string($_POST['description']);
    $username    = $db->real_escape_string($_POST['username']);
    $sort        = $db->real_escape_string($_POST['sort']);

    $sql = "INSERT INTO `classify` (`title`, `description`, `sort`) VALUES ('{$title}', '{$description}', '{$sort}')";
    $db->query($sql) or die($db->error);
    $sn = $db->insert_id;

    upload_pic($sn);

    return $sn;
}

//修改資料
function data_modify($sn)
{
    global $db;
    $title       = $db->real_escape_string($_REQUEST['title']);
    $sort        = $db->real_escape_string($_REQUEST['sort']);
    $description = $db->real_escape_string($_REQUEST['description']);

    $sql = "UPDATE `classify` SET `title`='{$title}', `description`='{$description}', `sort`= '{$sort}' WHERE `sn`='{$sn}'";
    $db->query($sql) or die($db->error);

    upload_pic($sn);

    return $sn;
}

function data_delete($sn)
{
    global $db;

    $sql = "DELETE FROM `classify` WHERE sn='{$sn}' and '{$_SESSION['username']}'='admin'";
    $db->query($sql) or die($db->error);

    if (file_exists("uploads/classify_{$sn}.jpg")) {
        unlink("uploads/classify_{$sn}.jpg");
    }
}
//讀出一則分類資料
function show_classify($sn)
{
    global $db, $smarty;

    $sql             = "SELECT * FROM `classify` WHERE `sn`='$sn'";
    $result          = $db->query($sql) or die($db->error);
    $data            = $result->fetch_assoc();
    $data['summary'] = mb_substr(strip_tags($data['description']), 0, 30);
    $smarty->assign('classify', $data);
}

//上傳分類照片
function upload_pic($sn)
{
    if (file_exists("uploads/classify_{$sn}.jpg")) {
        unlink("uploads/classify_{$sn}.jpg");
    }

    if (isset($_FILES)) {
        require_once 'class.upload.php';
        $foo = new Upload($_FILES['uploadpic']);
        if ($foo->uploaded) {
            // save uploaded image with a new name
            $foo->file_new_name_body = 'classify_' . $sn;
            $foo->image_resize       = true;
            $foo->image_convert      = jpg;
            $foo->image_y            = 1080;
            $foo->image_ratio_x      = true;
            $foo->Process('uploads/');
        }
    }
}