Nrthugu

This is my ajax code which fetches all data from data and display in the table, but when I input an alphabet in search-box, it again fetches complete data inside the table

<script>

    $(document).ready(function(){



     load_data();



     function load_data(query)

     {

      var xhttp = new XMLHttpRequest(); 

     xhttp.open("GET", "<?php echo base_url() ?>Appconfig/get_masteradmin_data?query="+query,true);

     xhttp.onload= function()

    {

      if (xhttp.status >=200 && xhttp.status <400)

      {

        var data= JSON.parse(xhttp.responseText);

        var html = '';

            var i;

            for(i=0; i<data.length; i++){



                        html +='<tr>'+

                                    '<td>'+data[i].full_name+'</td>'+

                                    '<td>'+data[i].username+'</td>'+

                                    '<td>'+data[i].designation+'</td>'+

                                    '<td>'+data[i].department+'</td>'+

                                    '<td>'+data[i].official_mobile_no+'</td>'+

                                    '<td>'+data[i].official_email_id+'</td>'+

                                    '<td>'+data[i].select_user_type+'</td>'+

                                    '<td>'+data[i].permission+'</td>'+

                                '</tr>';

                    }

            showdata.insertAdjacentHTML('beforeend',html);  

      }

      else

      {

      console.log("Try again after some time");

      }



      };

      xhttp.send();

     }





     $('#search').keyup(function(){

      var search = $(this).val();

      //console.log(search);

      if(search != '')

      {

       load_data(search);

      }

      else

      {

       load_data();

      }

     });

    });

</script>

This is my model for fetching data from my mongodb collection.

public function get_masteradmin_data($query)

    {

        $mongo = new MongoDBDriverManager('mongodb://localhost:27017');

        $query= '';

        //$filter = ['full_name' => 'www'];

        $regex = new MongoDBBSONRegex ($query);

        $filter = ['full_name'=>$regex,];

        $options =[

                    'projection' => [

                                    '_id' => 0,

                                    'full_name' => 1,

                                    'username' => 1,

                                    'designation'=> 1,

                                    'department'=> 1,

                                    'official_mobile_no'=> 1,

                                    'official_email_id'=> 1,

                                    'select_user_type'=> 1,

                                    'permission'=> 1,

                                    ],

                    'sort' => [

                                '_id' => -1

                            ],



        ];



            $query = new MongoDBDriverQuery($filter, $options);

            //$readPreference = new MongoDBDriverReadPreference(MongoDBDriverReadPreference::RP_PRIMARY);

            $result = $mongo->executeQuery('justrack_db.master_admin', $query); 





           $res = array();

            foreach($result as $r)

                { 

                    $res = $r;

                }

            return json_encode($res,true);

            //return $res;

    }

This is my controller for displaying data. I am not sure, but I think there is some issue in my controller, as I tried to echo $query but it shows nothing. I am not able to understand how to fix this.

public function get_masteradmin_data()

        {

            $query = '';

            $this->load->model('AppconfigModel');

            $this->master_admin();

            if($this->input->post('query'))

              {

               $query = $this->input->post('query');

              }

            $result= $this->AppconfigModel->get_masteradmin_data($query);

            echo ($result);



        }