/** * Find a single user based on a field/value match, including role information. * * @param string $field The field to match. If 'both', attempt to find a user * with the $value field matching either the username or email. * @param string $value The value to search for. * @param string $type The type of where clause to create ('and' or 'or'). * * @return boolean|object An object with the user's info, or false on failure. */ public function find_by($field = null, $value = null, $type = 'and') { return parent::find_by($field, $value, $type); }
public function find_by($field = null, $value = null) { $this->db->join('roles', 'roles.role_id = users.role_id', 'left'); if ($field == 'both') { $field = array('username' => $value, 'email' => $value); return parent::find_by($field, null, 'or'); } return parent::find_by($field, $value); }
/** * Find a single user based on a field/value match, including role information. * * @param string $field The field to match. If 'both', attempt to find a user * with the $value field matching either the username or email. * @param string $value The value to search for. * @param string $type The type of where clause to create ('and' or 'or'). * * @return boolean|object An object with the user's info, or false on failure. */ public function find_by($field = null, $value = null, $type = 'and') { $this->preFind(); return parent::find_by($field, $value, $type); }
/** * Locates a single user based on a field/value match, with their role information. * If the $field string is 'both', then it will attempt to find the user * where their $value field matches either the username or email on record. * * @access public * * @param string $field A string with the field to match. * @param string $value A string with the value to search for. * @param string $type The type of where clause to create. Either 'and' or 'or'. * * @return bool|object An object with the user's info, or FALSE on failure. */ public function find_by($field = null, $value = null, $type = 'and') { if (empty($this->selects)) { $this->select($this->table_name . '.*, role_name'); } $this->db->join($this->roles_table, $this->roles_table . '.role_id = ' . $this->table_name . '.role_id', 'left'); return parent::find_by($field, $value, $type); }
public function find_by($field = null, $value = null) { $this->db->join('news_categories', 'news_categories.id = news_articles.category_id', 'left'); $this->db->join('news_status', 'news_status.id = news_articles.status_id', 'left'); if (empty($this->selects)) { $this->select($this->table . '.*, category'); } return parent::find_by($field, $value); }