[ben]

hi,

is it possible to render out the mysql query?

For example, i use this code to get all the tables in the database:    $this->db->list_tables();

How can i display the result (list of table names) in flexi-grid using grocery crud?  $output = $_crud->render();

regards

[Amit Shah]

i will recommend - use codeigniter profiling option and u will get all the queries that it ran through

[ben]

hi Amit, thanks. I've learnt new thing today: profiler . But this is not what i'm looking for. I want to display the query result in the grocery crud table. Is this possible?

[Amit Shah]

well that might need a certain hack but if not mistaken.. the profile should still run and generate the same query output in the ajax result also.

But anyways... all the queries that execute .. are all there in the grocery_crud_model.php... what i can suggest you to do is.. create a log file and make log entries of all the queries that gets executed - this way it will help u debug stuff whatever is required.. and not disturb the screen. Cuz if u noticed the queries ran in the profiler - there aint just 1 single query but many ...

if u look to specifically generate just 1 (main) query - that shows result then u need to just alter an echo @line 88 in the grocery_crud_model.php in function get_list ... just before the return - echo $this->db->last_query();

 

Hope that helps u resolve your requirements

 

Happy GCing :)