Tuesday, 15 September 2015

php - why does deleted record still get returned using eloquent model? -



php - why does deleted record still get returned using eloquent model? -

i'm new laravel, , first framework i'm learning in language, anyway, deleted records using :

public function getforcelogout() { $input = input::all(); $e = $input['email']; echo $e; db::select(db::raw("delete active_users email = '$e'")); }

but query executed through eloquent model returns object anyway, though has been been deleted (checked table in phpmyadmin)

public static function isloggedin() { $email = auth::user()->email; //$user = activeuser::where("email",$email); <== returns object $user = db::select(db::raw("select * active_users email = '$email'")); // <== works fine if ($user) { homecoming true; } else { auth::logout(); homecoming false; } }

why happening? doesn't eloquent model query database , works on cached records or similar?

edit: yes, pointed out, returns querybuilder object! mistake.

you doing this:

$user = activeuser::where("email",$email);

which returns querybuilder, querybuilders used laravel prepare queries while you're constructing them through eloquent model.

if want result database, should do:

$user = activeuser::where("email",$email)->first();

which should homecoming query result, or null if record doesn't exist.

php laravel laravel-4 eloquent

No comments:

Post a Comment