Here is my mysql table (chatizin) Id Sender Receiver 1 11 6 2 11 96 3 6 96 4 6 11 And Here is my php codes by using codeigniter 3 $UserId=11; $Receiver=6; $this->db->where(["Sender" => $UserId,"Receiver"=>$Receiver]); $this->db->or_where(["Sender" => $Receiver,"Receiver"=>$UserId]); $this->db->order_by("Id…
I am facing using in accessing files in Codeigniter. I will explain using examples. Suppose I have an Xampp folder in c drive and my project is running fine and I am trying to access D drive folder and that…
Note: It was working on single view page, but once I pass it to User Dashboard it will be showing error. I was trying to pass user data from database to form table but it was showing error Here's my…
I have a table that have many records and others are duplicated. I want to print all the records out but I don't want the duplicated to echo more than once. I have a tried to add break when a…
im beginer in program i try get data from other model in CI3 can help me for fix this error? the error Message: Undefined variable: data Filename: sale/sale_form.php Line Number: 274 My view: <?php foreach ($data as $i => $data)…
I want to create export file date-range report using ci. views.php <div class="form-group row"> <label for="attn_date" class="col-sm-4 col-form-label">From</label> <div class="col-sm-8"> <input type="date" class="form-control" id="attn_from" name="attn_from"> <?= form_error('attn_from'); ?> </div> </div> <div class="form-group row"> <label for="attn_date" class="col-sm-4 col-form-label">To</label> <div class="col-sm-8"> <input…
An uncaught Exception was encountered Type: Error Message: Call to a member function num_rows() on bool Filename: C:xampphtdocssikan_v2applicationviewstransactionsalecart_data.php Line Number: 2 Backtrace: File: C:xampphtdocssikan_v2applicationviewstransactionsalesale_form.php Line: 134 Function: view File: C:xampphtdocssikan_v2applicationlibrariesTemplate.php Line: 14 Function: view File: C:xampphtdocssikan_v2applicationcontrollersSale.php Line: 26 Function: load…
I'm sorting some users by id (oldest to newest). This is my accounts table: Accounts id name 1 James 2 Kirk 3 Roberto 4 Lars However, I need to improve this ordering by relating a second messages table. Accounts_Messages id…
Between Condition is not working on server side $this->db->group_start(); $this->db->where('("'.$start_date.'" BETWEEN start_date AND end_date)', NULL, FALSE); $this->db->or_where('("'.$end_date.'" BETWEEN start_date AND end_date)', NULL, FALSE); $this->db->group_end(); This Between Condition is working on local but not on server side
I want to access my database models from database.php file. ` //$ci =& get_instance(); $this->CI->session->userdata('user_id'); $this->CI->load->model('users/user_model'); $current_user = $this->CI->user_model->find($this->CI->auth->user_id()); echo $current_user->organisation; $this->CI->load->model('organisation/organisation_model'); $org = $this->CI->organisation_model->find($current_user->organisation); `