CodeIgniter Forums
codeigniter 3 where clause does not work properly - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Model-View-Controller (https://forum.codeigniter.com/forumdisplay.php?fid=10)
+--- Thread: codeigniter 3 where clause does not work properly (/showthread.php?tid=87100)

codeigniter 3 where clause does not work properly - abdirahim - 03-14-2023

Hey @all
I am using CodeIgniter version 3, I face an error of querying a table that have large amount of data while I passed it where condition but my model escaped where and changed it to where variable is null after I dumped into last_query
here is my code 
view code
Code:
<?php echo form_open('Access/show'); ?>
                        <div class="form-group">
                            <div class="my-3">
                                <label class="form-label" for="startdate">Dooro Taariikh:</label>
                                <input type="date" class="form-control" value="" name="whichday" id="whichday" required="required">
                            </div>
                        </div>
                        <div class="form-group">
                            <div class="my-3">
                                <label class="form-label" for="MobileNo">MobileNo:</label>
                                <input type="number" name="phone" placeholder="25263XXXXXXX" id="MobileNo" class="form-control" required="required">
                            </div>
                        </div>
                                                   
                        <div class="form-group my-3">
                            <input type="submit" class="au-btn au-btn--block au-btn--green form-control rounded" value="submit" name="showChannel">
                        </div>
                 
            <?php echo form_close(); ?>


my controller code
    public function show(){
        if ($this->session->userdata('isUserLoggedIn')) {
            $this->load->view('incl/header');
            $this->load->view('incl/sidebar');
            $this->load->view('incl/navbar');
            $this->load->view('dash/access/view');
            $this->load->view('incl/datatable');
         
        } else {
            $this->load->view('incl/header');
            $this->load->view('login');
            $this->load->view('incl/script');
        }
    }


    public function getAccess(){


        $phone = $this->input->post('phone');
        $data = $this->AccessChannel->showAccess($phone);
        echo json_encode($data); 

    }

my model code

  public function showAccess($phone)
    {
        $this->db->select('createdat, SenderMobile,ReceiverMobile,transferid,Currency,ChannelName,shortCodeDailed');
        $this->db->from('loggingprofile2');


        $this->db->where('SenderMobile =',$phone);
        $query = $this->db->get();
        var_dump($this->db->last_query());
        // die();
        return $query->result();

I expect that where condition runs first as it in sql query but where condition returns NULL string(164) "SELECT createdat, SenderMobile, ReceiverMobile, transferid, Currency, ChannelName, shortCodeDailed FROM loggingprofile2 WHERE senderMobile IS NULL" Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 10489856 bytes)