doongdoong/admin_create_cont_action.php at master · fatihohn/doongdoong · 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
122
123
124
125
126
127
128
129
130
131
<?php

include 'bbdd_db_conn.php';


$author = $_POST['author'];
$author = mysqli_real_escape_string($conn, $author);

$username = $_POST['username'];
$username = mysqli_real_escape_string($conn, $username);

$category = $_POST['category'];
$category = mysqli_real_escape_string($conn, $category);

$sess = $_POST['sess'];
$sess = mysqli_real_escape_string($conn, $sess);

$zin = $_POST['zin'];
$zin = mysqli_real_escape_string($conn, $zin);

$title = $_POST['title'];
$title = mysqli_real_escape_string($conn, $title);

$content = $_POST['ir1'];
$content = mysqli_real_escape_string($conn, $content);

$display = $_POST['display'];
$display = mysqli_real_escape_string($conn, $display);

$memo = $_POST['memo'];
$memo = mysqli_real_escape_string($conn, $memo);


// $id = "id";
$sqlNo = "SELECT `no` FROM contents ORDER BY id DESC LIMIT 1";
// $stmt = mysqli_stmt_init($conn);
// if (!mysqli_stmt_prepare($stmt, $sqlNo)) {
//         echo "sqlNo error";
//     } else {
//             // mysqli_stmt_bind_param($stmt, , );
//             mysqli_stmt_execute($stmt);
//             $resultNo = mysqli_stmt_get_result($stmt);
//             if($resultNo->num_rows > 0) {
//                     $rowNo = mysqli_fetch_assoc($resultNo);
//                     $no = $rowNo['no'];
//                     $no = intval(intval($no) + 1);
//                 } else {
//                         $no = "1";
//                     }
//                     // mysqli_stmt_close();
//                 }

                // $sqlNo = "SELECT `no` FROM contents ORDER BY id DESC LIMIT 1";
                $resultNo = $conn->query($sqlNo) or die($conn->error);
                if($resultNo->num_rows > 0) {
                    $rowNo = mysqli_fetch_assoc($resultNo);
                    $no = $rowNo['no'];
                    $no = intval(intval($no) + 1);
                } else {
                    $no = "1";
                }


                $sql = "
                INSERT INTO contents
                        (no, author, username, category, sess, zin, title, content, display, memo, created)
                    VALUES(
                            '{$no}',
                            '{$author}',
                            '{$username}',
                            '{$category}',
                            '{$sess}',
                            '{$zin}',
                            '{$title}',
                            '{$content}',
                            '{$display}',
                            '{$memo}',
                            NOW()
                            )";

                            $result = mysqli_query($conn, $sql);
                            if($result === false){
                                echo '저장실패. 관리자에게 문의해주세요';
                                error_log(mysqli_error($conn));
                            }
                            else{
                                echo("<script>alert('게시물이 생성되었습니다.');location.href='admin_contList.php';</script>");
                            }


        //             // $created = mysqli_real_escape_string($conn, NOW());
        //             $sql = "
        //             INSERT INTO `contents`
        //                     (`no`, `author`, `username`, `category`, `sess`, `zin`, `title`, `content`, `display`, `memo`, `created`)
        //                 VALUES(
        //                         ?,
        //                         ?,
        //                         ?,
        //                         ?,
        //                         ?,
        //                         ?,
        //                         ?,
        //                         ?,
        //                         ?,
        //                         ?,
        //                         NOW()
        //                 );";

        // $stmt = mysqli_stmt_init($conn);
        // if (!mysqli_stmt_prepare($stmt, $sql)) {
        //         echo "sql error";
        // } else {
        //         mysqli_stmt_bind_param($stmt, "isssssssss", $no, $author, $username, $category, $sess, $zin, $title, $content, $display, $memo);
        //         // mysqli_stmt_execute($stmt);
        //         // $result = mysqli_stmt_get_result($stmt);
        //         if(!mysqli_stmt_execute($stmt)){
        //         // if($result === false){
        //             echo '저장실패. 관리자에게 문의해주세요';
        //             error_log(mysqli_error($conn));
        //         }
        //         else{
        //             echo("<script>alert('게시물이 생성되었습니다.');location.href='admin_contList.php';</script>");
        //         }
        //         // mysqli_stmt_close();
        //     }


?>