⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Get rows where field = "X".



Ahmad Zein

Ahmad Zein
  • profile picture
  • Member

Posted 28 October 2014 - 09:06 AM

hello, 

 

am trying to accomplish the following :

 

get only rows where permission = 1 ,

 

i have multiple users and i want to show only certain rows for each user  where they can edit.

 

something like that :

$crud->set_table('pages',"where permission =1"); <--------------------how to do this in the right way :'(
$crud->set_relation('pagetype','themes','name');
$crud->set_rules('systemTTL', 'System Title', 'trim|required|min_length[4]|xss_clean|alpha_dash');
$crud->callback_add_field('title',array($this,'edit_field_callback'));

Thank you 


Amit Shah

Amit Shah
  • profile picture
  • Member

Posted 29 October 2014 - 06:40 AM

well.. the same is already clearly mentioned in the GC documentation,

 

the same can be achieved by using $crud->where("permission", 1);

 

Happy GCing :)