MySQL未知列“0”

Question

在尝试实现Laravel模型时，我遇到了最奇怪的“未知列“0”错误。

SQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'where clause' (SQL: select * from `users` where `username` = smithjd and `0` = 1 limit 1)

我的应用程序中的所有其他数据都是API驱动的，但我认为通过内置的ORM进行用户身份验证和管理可能更容易。

我已经为MySQL设置了一个用户表：

+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| id             | int(11)      | NO   | PRI | NULL    | auto_increment |
| remember_token | varchar(100) | YES  |     | NULL    |                |
| username       | varchar(100) | YES  |     | NULL    |                |
| password       | varchar(100) | YES  |     | NULL    |                |
| first_name     | varchar(100) | YES  |     | NULL    |                |
| last_name      | varchar(100) | YES  |     | NULL    |                |
| email          | varchar(100) | YES  |     | NULL    |                |
+----------------+--------------+------+-----+---------+----------------+

这是模型-它实际上没有从默认值更改：

使用Illumb\Auth\UserInterface；使用Illumb\Auth\Employers\EmployableInterface；

class User extends Eloquent implements UserInterface, RemindableInterface {

    protected $fillable = array('email', 'username', 'password', 'first_name', 'last_name');

    /**
     * The database table used by the model.
     *
     * @var string
     */
    protected $table = 'users';

    /**
     * The attributes excluded from the model's JSON form.
     *
     * @var array
     */
    protected $hidden = array('password');

    /**
     * Get the unique identifier for the user.
     *
     * @return mixed
     */
    public function getAuthIdentifier()
    {
        return $this->getKey();
    }

    /**
     * Get the password for the user.
     *
     * @return string
     */
    public function getAuthPassword()
    {
        return $this->password;
    }

    /**
     * Get the token value for the "remember me" session.
     *
     * @return string
     */
    public function getRememberToken()
    {
        return $this->remember_token;
    }

    /**
     * Set the token value for the "remember me" session.
     *
     * @param  string  $value
     * @return void
     */
    public function setRememberToken($value)
    {
        $this->remember_token = $value;
    }

    /**
     * Get the column name for the "remember me" token.
     *
     * @return string
     */
    public function getRememberTokenName()
    {
        return 'remember_token';
    }

    /**
     * Get the e-mail address where password reminders are sent.
     *
     * @return string
     */
    public function getReminderEmail()
    {
        return $this->email;
    }

}

这就是我如何使用它

$user_data = Input::all();
Auth::attempt(array('username' => $user_data['username'], 'password' => $user_data['password']));

我以前从未尝试在Laravel中实现内置模型，我需要一些帮助。谁能给我指出正确的方向吗？

Answer 1

为什么不var_dumpInput:：only（'username'，'password'）这样您就可以检查Laravel是否真的可以访问您的凭据。Laravel试图从您的表单获取的密码有问题。用这样的东西来测试和前进：

$credentials = Input::only('username', 'password');

return var_dump($credentials);

if(Auth::attempt($credentials))
{
    return Redirect::intended('/someurl');
}

return Redirect::back()->withInput();