laravel select where and where condition

Question

I have this basic query i want to perform but an error keeps coming up  Probably due to my newness to laravel    here is the code    userRecord    this- gt where  email    email - gt where  password    password           echo  first name       userRecord- gt email    I am trying to get the user record matching the credentials where email AND password are a match  This is throwing an error      Undefined property  Illuminate Database Eloquent Builder   email   I ve checked the email and password being passed to the function  and they are holding values  what is the problem here   Thanks

User · Answer

Here is shortest way of doing it   userRecord   Model  where   email   gt  email   password   gt  password  - gt first

User · Answer

After rigorous testing  I found out that the source of my problem is Hash  make  password    Apparently this kept generating a different hash each time  SO I replaced this with my own hashing function  wrote previously in codeigniter  and viola  things worked well    Thanks again for helping out    Really appreciate it

User · Answer

After reading your previous comments  it s clear that you misunderstood the Hash  make function  Hash  make uses bcrypt hashing  By design  this means that every time you run Hash  make  password    the result will be different  due to random salting   That s why you can t verify the password by simply checking the hashed password against the hashed input    The proper way to validate a hash is by using   Hash  check  passwordToCheck   hashedPassword     So  for example  your login function would be implemented like this   public static function login  email   password         user   User  whereEmail  email - gt first        if     user   return null     check if user exists     if   Hash  check  password   user- gt password              return  user        else return null      And then you d call it like this    user   User  login  email aol com    password    if     user   echo  Invalid credentials    else echo  First name   user- gt firstName     I recommend reviewing the Laravel security documentation  as functions already exist in Laravel to perform this type of authorization   Furthermore  if your custom-made hashing algorithm generates the same hash every time for a given input  it s a security risk  A good one-way hashing algorithm should use random salting

User · Answer

The error is coming from  userRecord- gt email  You need to use the - gt get   or - gt first   methods when calling from the database otherwise you re only getting the Eloquent Builder object rather than an Eloquent Collection   The - gt first   method is pretty self-explanatory  it will return the first row found  - gt get   returns all the rows found   userRecord   Model  where  email         email - gt where  password         password - gt get    echo  First name       userRecord- gt email

User · Answer

userRecord   Model  where    email       email    password        password   - gt first      or   userRecord   self  where    email       email    password        password   - gt first      I  think this condition is better then 2 where  Its  where condition array in array of where conditions

User · Answer

You either need to use first   or get   to fetch the results     userRecord    this- gt where  email    email - gt where  password    password - gt first      You most likely need to use first   as you want only one result returned    If the record isn t found null will be returned  If you are building this query from inside an Eloquent class you could use self    for example     userRecord   self  where  email    email - gt where  password    password - gt first      More info here

User · Answer

this- gt where  email    email - gt where  password    password     is returning a Builder object which you could use to append more where filters etc   To get the result you need    userRecord    this- gt where  email    email - gt where  password    password - gt first

[laravel] laravel select where and where condition

Examples related to laravel

Examples related to laravel-4

Examples related to eloquent