Any idea how to convert query below into Codeigniter? select agency from agency where agency not in (SELECT agency FROM trip where trip_type = 'local trip' group by trip_type, agency having count(agency)=(select count(*) from role)); Tried but failed. Please help
in autoload.php public $helpers = [ 'general' ]; helper is loaded and helper file defined 2 functions <?php function datetimeformat($date) { return date("Y-m-d H:i:s", strtotime($date)); } function randomnumber() { return "111"; } and in controller i called the helper but…
I am having the following dynamically loaded values to be saved to DB Here, what i need to save to the db is that if there are wo tickets form Adult, there should be two entries in the DB and…
I have a table in the database that I named department, and another that I named doctor. I plan to display the number of doctors for each department. But when I try to display them, I always get the result…
I'd like to get a user-defined constants file out of the native ConfigConstants.php from CI4 I would like to write a class like : public class UserConstants{ const YEAR = 2024; const MAX = 9999; const FOO = "myfoo"; }…
help me... I want to create a laundry program and i use codeigniter 3. when I programmed on the user side, I experienced the problem of data not inserted to database. even though the database name, table name, and column…
i am learning codeigniter 4, i am trying to get the login page block once my user is logged but i am getting the error too many redirection and i dont know how to fix it my login controller: public…
I am trying to add some validation for the description field to check if the user has entered any scripting/js/jQuery/SQL query code rather than a genuine product description. // Check for disallowed patterns (JavaScript, jQuery, and SQL) $disallowedPatterns = array(…
I'm getting this error: Attempt to read property"id" on array File name: controler/patient.php Line 352 I had just modified by putting the entire code for further clarification This is the code: $username = $this->input->post('name'); if (empty($id)) { // Adding New…
I am having difficulty getting the blood type description to be displayed in my patients table due to receiving the blood type foreign key in Codeigniter 4. The error happen in <td><?php echo $p['bt']['description']; ?></td> showing ErrorException Undefined array key…