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 make static data row in table for 10 rows. I have 3 data foreach (item01, item02, item03) like this. <table> <?php foreach($data as $row): ?> <tr> <td><?php echo $row->item_no; ?></td> </tr> <?php endforeach; </table> I want to…
I need to hide/show action columns based on permissions if action column is null I want to hide action column, if action has data I want to show that data passes on backend side. // my backend code php $data…
I'm still learning codeigniter, and i'm trying to create a detail page, so when i click on the detail button on a certain item, it will redirect the user to the detail page of that item. But when i click…
I store details about books in table called books. One of the columns is called "book_active" and holds values "Y" or "N". I want my checkbox named "book_active" to be checked if value in mentioned column equals "Y" and unchecked…
Two parts to this question, I currently have a php script which grabs new info from themoviedb, however it times out so I'm trying to limit it in order to chunk it. I have this below snippet. $Posts = $this->db->from('posts')->where('type','serie')->all();…
Visual studio code show syntax error in Codeigniter 3 how to fix them... How to i remove these under line in visual studio code
I am using CI version 3.1.13 and PHP 7.4.33 to develop my webapp. I am using CyberSource payment gateway for online payments, but when user is getting redirected back from CyberSource to the webapp then the session is getting lost.…
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); `
I have modelled and am now testing a Database for a PHP (CodeIgniter 4) web application. I made a function in my (products) Model that retrieves data from the DB and called that function in the controller. getBasicInfo(int $id): array…