admin_modify_cont_action.php

<?php

include 'bbdd_db_conn.php';



$q = intval($_POST['id']); 
$author = $_POST['author'];
$author = mysqli_real_escape_string($conn, $author);
// $author = mysql_real_escape_string($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);




        $sql = 
                "UPDATE contents SET 
                `author`='$author', 
                `username`='$username', 
                `category`='$category', 
                `sess`='$sess', 
                `zin`='$zin', 
                `title`='$title', 
                `content`='$content', 
                `display`='$display', 
                `memo`='$memo'
                WHERE `id`='$q'";
//         $sql = 
//                 "UPDATE contents SET 
//                 `author` = ?, 
//                 `username` = ?, 
//                 `category` = ?, 
//                 `sess` = ?, 
//                 `zin` = ?, 
//                 `title` = ?, 
//                 `content` = ?, 
//                 `display` = ?, 
//                 `memo` = ?
//                 WHERE `id` = ?";

// $stmt = mysqli_stmt_init($conn);
//         if (!mysqli_stmt_prepare($stmt, $sql)) {
//                 echo "sql error";
//         } else {
//                 mysqli_stmt_bind_param($stmt, "sssssssssi", $author, $username, $category, $sess, $zin, $title, $content, $display, $memo, $q);
//                 // 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();
//             }


$result = mysqli_query($conn, $sql);
// $result = $conn->query($sql);


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




?>