+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Need some idea (/showthread.php?tid=69553)
Need some idea - googlemy - 12-13-2017
Hi All,
I want call database like below,
right now I manually add.
PHP Code:
function get_permission_conditions()
{
return array(
'dashboard' => array(
'View' => true,
'ViewOwn' => true,
'Edit' => true,
'Create' => true,
'Delete' => true
),
'users' => array(
'View' => true,
'ViewOwn' => false,
'Edit' => true,
'Create' => true,
'Delete' => true,
),
'user_plans' => array(
'View' => false,
'ViewOwn' => false,
'Edit' => false,
'Create' => true,
'Delete' => true,
),
'roles' => array(
'View' => true,
'ViewOwn' => false,
'Edit' => true,
'Create' => true,
'Delete' => true
),
'user_groups' => array(
'View' => true,
'ViewOwn' => false,
'Edit' => false,
'Create' => false,
'Delete' => false
),
'ip_blocking' => array(
'View' => true,
'ViewOwn' => false,
'Edit' => true,
'Create' => false,
'Delete' => false
),
'currencies' => array(
'View' => true,
'ViewOwn' => false,
'Edit' => true,
'Create' => true,
'Delete' => true
),
'email_templates' => array(
'View' => true,
'ViewOwn' => false,
'Edit' => true,
'Create' => true,
'Delete' => true
),
'custom_fields' => array(
'View' => true,
'ViewOwn' => false,
'Edit' => true,
'Create' => true,
'Delete' => true
),
'logs' => array(
'View' => true,
'ViewOwn' => false,
'Edit' => true,
'Create' => true,
'Delete' => true
),
'settings' => array(
'View' => true,
'ViewOwn' => false,
'Edit' => true,
'Create' => false,
'Delete' => false
),
'staff' => array(
'View' => true,
'ViewOwn' => false,
'Edit' => true,
'Create' => true,
'Delete' => true
)
);
}
Database
![[Image: 5EpJC2XzQEieCTP4Z-jjrg.png]](https://image.prntscr.com/image/5EpJC2XzQEieCTP4Z-jjrg.png)
Example:
How to make enableView == 1 as true
PHP Code:
function get_permission_conditions()
{
$CI =& get_instance();
$permissions = $CI->db->get('permissions');
return array(
foreach($permissions->array_result() as $p) {
$p['shortname'] => array(
'View' => true,
'ViewOwn' => true,
'Edit' => true,
'Create' => true,
'Delete' => true
),
}
);
}
Thanks you....
RE: Need some idea - Wouter60 - 12-13-2017
Remember to put database function inside a model, not a library.
A model doesn't need the & get_instance(), you can refer to $this.
So, in your model, make this function:
PHP Code:
function get_permission_conditions()
{
$permissions = $this->db->get('permissions');
$rv = array();
foreach($permissions->result() as $p) {
$rv[$p->shortname] = array(
'View' => $p->enableView,
'ViewOwn' => $p->enableViewOwn,
'Create'=> $p->enableCreate,
'Edit' => $p->enableEdit,
'Delete' => $p->enableDelete,
);
}
return $rv;
}
RE: Need some idea - googlemy - 12-13-2017
Its working now!! thanks you so much!!