Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function get($params = array()) {
- $limit = isset($params['limit']) ? $params['limit'] : false;
- $order = isset($params['order']) ? $params['order'] : 'position ASC';
- $id = isset($params['id']) ? $params['id'] : false;
- $parent_id = isset($params['parent_id']) ? $params['parent_id'] : false;
- $sql = "SELECT * FROM ".$this->tb." WHERE name != '' ";
- $sql .= $id ? "AND id = '".$id."' " : "";
- $sql .= $parent_id ? "AND parent_id = '".$parent_id."' " : "";
- $sql .= $order ? "ORDER BY ".$order." " : "";
- $sql .= $limit ? "LIMIT ".$limit." " : "";
- $data = $this->db->query($sql)->result_array();
- return $id ? $data[0] : $this->_index($data);
- }
Add Comment
Please, Sign In to add comment