<?php
require_once('session_backend_administrator.php');
header('Content-Type: text/html; charset=UTF-8');
date_default_timezone_set("Asia/Bangkok"); 
$datetime = date('d/m/Y H.i'); 
// echo $_POST['edt_data'];
// exit;
if($STT_login=="admin_login_true"){

    if( !isset($_POST['edt_id']) or !isset($_POST['edt_name']) ){
        echo "<SCRIPT type='text/javascript'>
                alert('กรุณากรอกข้อมูลให้ครบ');
                window.location.replace(document.referrer);
            </SCRIPT>";
        exit;
    }else{

        $data_id_dataother = $con_db_administrator->real_escape_string($_POST['edt_id']);
        $data_name_dataother = $con_db_administrator->real_escape_string($_POST['edt_name']);
        $data_page_dataother = $con_db_administrator->real_escape_string($_POST['edt_data']);
    
        $data_statusshow = $con_db_administrator->real_escape_string($_POST['statusshow']);

            $sql_check_data = " SELECT COUNT(*) FROM `data_dataother` WHERE `id_dataother` = '$data_id_dataother' AND `name_dataother`='$data_name_dataother' ";
            $qr_check_data = mysqli_query($con_db_administrator, $sql_check_data) or trigger_error("sql_check_data", E_USER_ERROR);
            $r_check_data = mysqli_fetch_row($qr_check_data);
            $rs_check_data = $r_check_data[0];   

            if($rs_check_data == 1){

                        /////// update DATA to SQL

                        $ud_data = " UPDATE `data_dataother` SET `page_dataother`='$data_page_dataother', `stt_dataother`='$data_statusshow', `lastupdate_dataother`='$datetime' 
                                    WHERE `id_dataother` = '$data_id_dataother' AND `name_dataother` = '$data_name_dataother' ";  
                        $action_ud_data = $con_db_administrator->query($ud_data);
                        if(!$action_ud_data){
                            echo "<SCRIPT type='text/javascript'>
                                    alert('เกิดข้อผิดพลาด! แก้ไขข้อมูลไม่สำเร็จ');
                                    window.location.replace(document.referrer);
                                </SCRIPT>";
                            exit;
                        }else{
                            echo "<SCRIPT type='text/javascript'>
                                    alert('แก้ไขข้อมูล [ $data_name_dataother ] สำเร็จ');
                                    window.location.replace(document.referrer);
                                </SCRIPT>";
                            exit;
                
                        }
            }else{
                echo "<SCRIPT type='text/javascript'>
                        alert('เกิดข้อผิดพลาด ไม่พบข้อมูลที่ต้องการแก้ไข');
                        window.location.replace(document.referrer);
                    </SCRIPT>";
                exit;

            }
    }

}else{
    echo "<SCRIPT type='text/javascript'>
        alert('กรุณาเข้าสู่ระบบ');
        window.location.replace('../../index');
    </SCRIPT>";
    exit;
}
mysqli_close($con_db_administrator);
?>