ctrlSimpleQuery.php

public function simpleQuery()
    {
        $pesan =  $this->input->post('kata');
        // $pesan = "DELETE FROM TESTING";
        if(!empty($pesan)){
            helper_log("query", $pesan);

            if ($this->filterKata($pesan)) {
                echo $hasil = "Maaf script yang anda masukkan salah/tidak dibolehkan";
            }else{
                $cari = $this->app_model->simpleQuery($pesan);
                $details = array_values($cari->result());


                $data = array('sample' => $details,
                );

                $this->load->view('table/simpleQuery', $data);

            }
        }else{
            echo "silahkan masukkan query anda.";
        }
    }

    public function filterKata($kata)
    {
        $filter = array("DELETE","DROP","TRUNCATE", "INSERT", "UPDATE");

        $hasil = 0;

        $jml_kata = count($filter);

        for ($i=0;$i<$jml_kata;$i++)

        {

        if (stristr($kata,$filter[$i]))

        { $hasil=1; }

        }

        return $hasil;


    }