how to run query in codeignitor hook

Question

I want to create hook that check my project is in maintenance mode or not
Every thing work fine
But db call is not work

I try

hooks.php

$hook['pre_controller'][] = array(
'class'    => 'maintenance',
'function' => 'maintenance_check',
'filename' => 'maintenance.php',
'filepath' => 'hooks'
);

maintenance.php

public function maintenance_check(){
   $this->load->database();
   $result = $this->db->query('SELECT * FROM maintenance');

   if($result[0]->mode === TRUE){
     echo 'maintenance';
   }
}

error => Undefined property: Maintenance::$load

TimBrownlaw · Answer 1 · 2020-03-15T03:01:46.100

Your issue is that $this->load does not exist in your class

One answer is to use 'post_controller_constructor'. This allows you to extend the CI_Controller and get access to all the goodies.

$hook['post_controller_constructor'] = array(
    'class'    => 'Maintenance',
    'function' => 'maintenance_check',
    'filename' => 'Maintenance.php',
    'filepath' => 'hooks'
);

Your Maintenance Class would look something like (I've got some debug code in there to see what was going on.)

<?php
class Maintenance extends CI_Controller  {

  public function maintenance_check() {
    $this->load->database();
    $result = $this->db->query('SELECT * FROM maintenance');
    $mode = $result->row_array();
    var_dump($mode['mode']);
    if ($mode['mode'] == TRUE) {
        echo 'maintenance';
    }
  }
}

Not quite sure as to your Schema for your maintenance table. Sounds like it would be more suited to be an entry in an options table with id, name, value.

So maybe something like

public function maintenance_check() {
    $this->load->database();
    $result = $this->db->query("SELECT value FROM options WHERE name='maintenance'");
    $row = $result->row_array();
    if ($row['value'] == TRUE) {
        echo 'maintenance';
    }
}

error => Call to a member function database() on null – Partha Mar 15 '20 at 09:53 — Partha, Mar 15 '20 at 09:53

score 0 · Answer 2 · answered Mar 15 '20 at 10:06

hooks.php

$hook['post_controller_constructor'] = array(
'class'    => 'Maintenance',
'function' => 'maintenance_check',
'filename' => 'Maintenance.php',
'filepath' => 'hooks'
);

Maintenance.php

public function maintenance_check(){
  $this->CI = &get_instance();
  $result = $this->CI->db->query('SELECT * FROM maintenance');

  if($result[0]->mode === TRUE){
    echo 'maintenance';
  }
}

how to run query in codeignitor hook

2 Answers2