loading...

last query in ci

pakainfocom profile image pakainfo ・1 min read

We can get last executed query using last_query() function of db class in codeigniter. It is a very simple to use $this->db->last_query() function to see SQL statements of last executed query in php codeigniter app. You have to simple code that function after your main query that you wanted check

public function test_db()
{
    $query = $this->db->get("products");
  
    $str = $this->db->last_query();
   
    print_r($str);
    exit;
}

Also You can learn more way about last query in ci

Discussion

pic
Editor guide