Guest User

Untitled

a guest
Jul 20th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.68 KB | None | 0 0
  1. function get($params = array()) {
  2.  
  3.     $limit          = isset($params['limit']) ? $params['limit'] : false;
  4.     $order          = isset($params['order']) ? $params['order'] : 'position ASC';
  5.     $id             = isset($params['id']) ? $params['id'] : false;
  6.     $parent_id      = isset($params['parent_id']) ? $params['parent_id'] : false;
  7.  
  8.     $sql            = "SELECT * FROM ".$this->tb." WHERE name != '' ";
  9.  
  10.     $sql            .= $id ?  "AND id = '".$id."' " : "";
  11.     $sql            .= $parent_id ?  "AND parent_id = '".$parent_id."' " : "";
  12.     $sql            .= $order ? "ORDER BY ".$order." " : "";
  13.     $sql            .= $limit ? "LIMIT ".$limit." " : "";
  14.    
  15.     $data           = $this->db->query($sql)->result_array();
  16.  
  17.     return          $id ? $data[0] : $this->_index($data);
  18. }
Add Comment
Please, Sign In to add comment