I am using Laravel 5.2 and I am trying to execute to sql query with laravel eloquent.
But Oracle doesnt understand laravel query.
Here is Laravel Code:
public function postLogincheck(Request $request){
$rules = array(
'name' => 'required|min:3',
'password' => 'required|alphaNum|min:3'
);
$messages = array(
'required'=>':attribute alanı gereklidir.',
'min'=>':attribute alanına en az :min karakter girmelisiniz',
'alphaNum'=>':attribute alanına alfanümerik karakterler girebilirsiniz'
);
$validator = Validator::make(Input::all(), $rules,$messages);
if ($validator->fails()) {
return Redirect::to('login')
->withErrors($validator)
->withInput(Input::except('password'));
} else {
if (Auth::attempt(array('name' => $request->name, 'password' => $request->password))) {
flash()->success('Giriş başarılı');
return Redirect::to('/');
}
flash()->error('Giriş başarısız');
return Redirect::to('/login');
}
}
This method checking the login user.And laravel convert query like this:
select * from (select * from ReportUsers where upper(name) = upper(tsim)) where rownum = 1
But oracle expecting this query:
select * from (select * from "ReportUsers" where upper("name") = upper('tsim')) where rownum = 1
I am using yajra laravel-oci8 connector for connecting the Oracle DB.
How can I gain this problem?
Thanks
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire