php - 使用 codeigniter 使用用户名或电子邮件登录

Question

嗨，我在 codeigniter 中有这个登录脚本，它运行良好。它使用用户名来登录。但我希望您也可以使用电子邮件地址登录。因此，当用户执行登录时，他/她可以选择用户名或电子邮件登录。我怎样才能做到这一点？如有任何帮助，我们将不胜感激。

这是我的登录 Controller :

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Login extends CI_Controller {


  public function __construct(){
    parent::__construct();
    $this->load->library('form_validation');
    $this->load->model('users_model','um');
    $this->load->library('session');

    if($this->session->userdata('loggedIn')){
      redirect('homepage');
    }
  }


  public function check_database($password){
    $username = $this->input->post('username');
    $result = $this->um->login($username, $password);
    if($result){
      $sess_array = array();
      foreach($result as $row){
        $sess_array = array(
                       'id'=>$row->id,
                       'username'=>$row->username
                      );
        $this->session->set_userdata('loggedIn',$sess_array);
      }
      return true;
    }else{
      $this->form_validation->set_message('check_database', 'Invalid Username or Password.');
      return false;
    }
  }

  public function verifyLogin(){
    $this->form_validation->set_rules('username', 'Username', 'trim|required|xss_clean');
    $this->form_validation->set_rules('password', 'Password', 'trim|required|xss_clean|callback_check_database');
    if($this->form_validation->run() == FALSE){
      $this->data['title'] = 'Login';

      $this->load->view('templates/header',$this->data);
      $this->load->view('pages/login');
      $this->load->view('templates/footer'); 
    }else{
     //redirect('homepage', 'refresh');
      redirect('homepage');
    }

  }

  public function index(){
    $this->data['title'] = 'Login ';

    $this->load->view('templates/header', $this->data);
    $this->load->view('pages/login');
    $this->load->view('templates/footer');
    }  
}

我的模型:

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Users_model extends CI_Model { 
  public function login($username, $password){
    $sha_password = sha1($password);
    $this->db->select('
                users.id,
                users.username,
                users.email,
                users.password')
              ->from('users')
              ->where('username', $username)
              ->where('password', $sha_password);
    $query = $this->db->get();
    if($query->num_rows() == 1){
      return $query->result();
    }else{
      return false;
    }
  }
}

有人可以帮我解决这个问题吗？非常感谢。

Answer 1

您需要稍微更改模型并在括号中添加 OR 子句:

    $this->db->select('
            users.id,
            users.username,
            users.email,
            users.password')
          ->from('users')
          ->where("(users.email = '$username' OR users.username = '$username')")
          ->where('password', $sha_password);