I have built a site with codeigniter 3. I want to prevent run all php files directly. imagine that I have a file named test.php in my root. When the user goes to a site.com/test.php , it is not possible…
SELECT * FROM tbl_booking WHERE '2023-10-27 13:00:00' between startDate and endDate I need to write the query in code igniter how it can be done
at the moment I'm using these functions for my queries: public function Surat_300() { $query = $this->db->query(" SELECT * FROM `ts_300` WHERE `status_surat` = '1' "); return $query->num_rows(); } public function Surat_336_a() { $query = $this->db->query(" SELECT * FROM `ts_336_a`…
Code in the view, this is being copied straight from the docs and is not working. // app -> Cells -> DropdownCell.php namespace AppCells; use CodeIgniterViewCellsCell; class DropdownCell extends Cell { protected $surveys; public function courses($params): string { $this->surveys =…
I'm using CodeIgniter v4.4.1. I'm trying to insert Customers into my MySQL database. My Customer table has only two columns for now (for testing): idcustomer (primary key, not null, auto increment), and name (varchar(45)). That's working fine. My Customer model…
I have a table that has flight data in mysql. Im writing a php code that will group and display the data in groups using codeigniter 3 journey_id air_id FlightDuration out_or_in flightduration2 1 1 20hr 5min outbound 1205 2 1…
I'm trying to display the value that is stored in the variable $('#view-property .imo_desc_site').html(${property.imo_desc_site}); In my textarea, but I'm not getting it. What could I be doing wrong? <div class="col-md-12" style="margin-bottom: 0px !important"> <div class="form-group"> <label for="imo_desc_site" style="margin-bottom: 10px;">DESCRIÇÃO DO…
I have input with date type and checkbox for job history. Every working period that is still running will select checkbox input. How to display the checkbox value to the input form and save it to the database? Form Input…
I have seen this code in CodeIgniter docs. <?php $fields = [ 'id' => [ 'type' => 'INT', 'constraint' => 5, 'unsigned' => true, 'auto_increment' => true, ], 'title' => [ 'type' => 'VARCHAR', 'constraint' => '100', 'unique' => true,…
I have a simple question related to input post method. There are two input fields as follows : $this->input->post('billed_date') $this->input->post('branch_id') Then I want to combine this two input post methods using logical "OR" argument. I used the following code :…