Recently I have deleted my vendor folder and reinstalled. After that change my all get queries are throwing error. I have no clue what i am missing.
Thanks
/Error/ SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset 0' at line 1
My Code:
public function couponList(Request $request){
$sort_by = $request->get('sort-by');
$order_by = $request->get('order-by');
$homeTitle = 'Coupons and List';
$coupons = DB::table('sb_coupons AS CO')
->select('CO.*','CO.status as couponStatus','CO.created_at as couponOrderDate','UT.*',
'UT.firstname as userName')
->leftJoin('sb_customer AS UT', 'UT.customer_id', '=', 'CO.user_id');
if(!empty($request->s)){
$coupons->Where('CO.coupon_code', 'like', '%' . $request->s . '%');
}
if ($request->has('status')) {
$coupons->where('CO.status', $request->status);
}
$coupons = $coupons->paginate(env('RECORD_PER_PAGE'));
$coupons->appends($request->s);
return view('admin.coupons.coupon-list',array('homeTitle'=>$homeTitle,'coupons'=>$coupons,'params'=>$request, 'sort_by'=> $sort_by , 'order_by' => $order_by))
->with('i', ($request->input('page', 1) - 1) * env('RECORD_PER_PAGE'));
}
***.env *
APP_NAME=DeliverMyOrders
APP_ENV=local
APP_KEY=base64:LiLofkwJXFVZd4ZeUvGz/UADUFOeqx+Yeqv7L1gBHvY=
APP_DEBUG=true
APP_LOG_LEVEL=debug
APP_URL=http://localhost
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=delivermyorders
DB_USERNAME=root
DB_PASSWORD=
BROADCAST_DRIVER=log
CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync
REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379
MAIL_DRIVER=smtp
MAIL_HOST=smtp.mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=
RECORD_PER_PAGE=10
FACEBOOK_ID=458516817946384
FACEBOOK_SECRET=9660233aee1cf8b443e4586ea864ea1a
FACEBOOK_URL=http://localhost:8000/auth/facebook/callback/
GOOGLE_ID=1512483269952
GOOGLE_SECRET=AIzaSyB-AiSA4Kd-R36M6J7NSTXxAWbVs7z4C_s
GOOGLE_URL=http://localhost:8000/auth/google/callback
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire