<?php
    require('../db.php');
    require('session.php');

    $response = array();

    $pertanyaan = $_POST['pertanyaan'];
    $kategori = $_POST['kategori'];
    $id_pengelola = $_SESSION['id_pengelola'];


    $sql = "SELECT pertanyaan FROM kuesioner WHERE pertanyaan = '$pertanyaan' AND kategori='$kategori'";
    $query = mysql_query($sql);
    if(mysql_num_rows($query) == 0){

        if(empty($pertanyaan)){
            $response['status'] = FALSE;
            $response['message'] = "Pertanyaan kosong";
        }
        elseif(empty($kategori)){
            $response['status'] = FALSE;
            $response['message'] = "Kategori kosong";
        }
        else{
            $sql_insert = "INSERT INTO kuesioner (`id_pengelola`,`pertanyaan`,`kategori`,`tgl_buat`,`tgl_perbarui`) VALUES('$id_pengelola','$pertanyaan','$kategori',NOW(),NOW())";

            $query_insert = mysql_query($sql_insert);
            if(mysql_affected_rows() > 0){
                $response['status'] = TRUE;
                $response['message'] = "Data kuesioner berhasil disimpan";
            }
            else{
                $response['status'] = FALSE;
                $response['message'] = "Data kuesioner gagal direkam";
            }
        }


    }
    else{
        $response['status'] = FALSE;
        $response['message'] = "Kuesioner telah direkam sebelumnya";

    }

    echo(json_encode($response));

?>