Why Codeigniter cache db is not working in get query?

Question

Hi I need to cache only one query in my CI app. I dont understand what to do now. For example I have this in my config/database.php

$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = APPPATH . 'cache';

And this is my model:

public function get_languages() {
        $this->db->cache_on();
        $this->db->save_queries = TRUE;
        log_message("error", "getLanguages!!!!!!!!!!!!!");
        $this->db->from('tbl_language'); 
        $result = $this->db->get();
        $results = $result->result_array();
        log_message("error", $this->db->last_query());
        return $results;
}

I always see the query is executed in DB. Some help please! What is wrong?

user27976 · Accepted Answer · 2021-05-19 06:28:41Z

2

below code worked me!

public function get_languages() {
        $this->db->cache_on();
        $this->db->save_queries = TRUE;
        log_message("error", "getLanguages!!!!!!!!!!!!!");
        $this->db->from('tbl_language'); 
        $result = $this->db->get();
        $results = $result->result_array();
        var_dump($results);//print for checking
        $count = $result->num_rows();
        log_message("error", $this->db->last_query());
        if($count>0)
        {
            foreach($results as $list)
            {
                echo $list['id'];
            }           
        }
}

answered May 19, 2021 at 6:28

user27976

1491 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why Codeigniter cache db is not working in get query?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related