<?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'); 

if($STT_login=="admin_login_true"){


    if(!isset($_POST['txt_id']) or !isset($_POST['txt_question']) or !isset($_POST['txt_answer']) ){
        echo "<SCRIPT type='text/javascript'>
                alert('กรุณากรอกข้อมูลให้ครบ');
                window.location.replace(document.referrer);
            </SCRIPT>";
        exit;
    }else{
        $data_idfaq = $con_db_administrator->real_escape_string($_POST['txt_id']);
        $data_questionfaq = trim($con_db_administrator->real_escape_string($_POST['txt_question']));
        $data_answerfaq = trim($con_db_administrator->real_escape_string($_POST['txt_answer']));
        $data_sttfaq = $con_db_administrator->real_escape_string($_POST['statusshow']);
        $lastupdate_faq = $datetime;
        

            /////// เช็คข้อมูล id ซ้ำ
            $sql_check_id = " SELECT COUNT(*) FROM `data_faq` WHERE `id_faq`='$data_idfaq' ";
            $qr_check_id = mysqli_query($con_db_administrator, $sql_check_id) or trigger_error("sql_check_id", E_USER_ERROR);
            $rs_check_id = mysqli_fetch_row($qr_check_id);
            $check_id = $rs_check_id[0]; 

            if($check_id >= 1){
                echo "<SCRIPT type='text/javascript'>
                        alert('ลำดับแสดงผล [ $data_idfaq ] ซ้ำ');
                        window.location.replace(document.referrer);
                    </SCRIPT>";
                exit;
            }else{

                    /////// insert DATA to SQL

                    $insert_faq = " INSERT INTO `data_faq`(`question_faq`, `answer_faq`, `stt_faq`, `lastupdate_faq`)
                                        SELECT '$data_questionfaq', '$data_answerfaq', '$data_sttfaq', '$lastupdate_faq'
                                        FROM DUAL WHERE NOT EXISTS (SELECT `question_faq` FROM `data_faq` WHERE `question_faq`= '$data_questionfaq' LIMIT 1) ";      
                    $action_faq = $con_db_administrator->query($insert_faq);
                    if(!$action_faq){
                        echo "<SCRIPT type='text/javascript'>
                                alert('เพิ่มข้อมูลไม่สำเร็จ กรุณาลองใหม่อีกครั้ง');
                                window.location.replace('../FaqMain');
                            </SCRIPT>";
                        exit;
                    }else{
                        echo "<SCRIPT type='text/javascript'>
                                alert('เพิ่มข้อมูลใหม่ สำเร็จ');
                                window.location.replace('../FaqMain');
                            </SCRIPT>";
                        exit;
                    }

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