Support the ongoing development of Laravel.io →
Database Eloquent

User.php

class User extends EloquentUser implements AuthenticatableContract, AuthorizableContract, CanResetPasswordContract
{
    use Authenticatable, Authorizable, CanResetPassword, Eloquence;

    /**
     * The database table used by the model.
     *
     * @var string
     */
    use SoftDeletes;
    protected $dates = ['deleted_at'];
    protected $table = 'users';

MySQL

mysql> select id,username,email from users where email='silver';
+-----+----------+--------+
| id  | username | email  |
+-----+----------+--------+
| 166 | si91msn  | silver |
+-----+----------+--------+
1 row in set (0.00 sec)

Tinker

>>> $user_id = User::where('email', '=', 'silver')->first(['id']);
=> null
>>>

What the heck is going on?

Last updated 3 years ago.
0

Just off the top I see the 'email', '='. 'silver'. For comparison, you use '=='. The single '=' is an assignment operator. From the perspective of the code, you are trying to assign 'email' the value of 'silver' rather than compare to see if the emails on the database are equal to 'silver'.

0

Not in sql.

0

Sign in to participate in this thread!

PHPverse

Your banner here too?

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2025 Laravel.io - All rights reserved.