I'm trying to make pagination after sorting in my Laravel project , so I did this method, it sorts my data but when I want to see next paginate table it shows me this error SQLSTATE[42S22]: Column not found: 1054…
So my front-end Lists of Businesses are not in paginated style. But I do not know how to do it. Can anyone please help? The code I posted is in my BusinessListController.php BusinessListController.php `<?php namespace AppHttpControllers; use AppModelsBusiness; use AppModelsCategory;…
I am running a script that stores the collected data in csv. It's working like that: $responce = Excel::store(new UsersExport($formatted_data), 'fileName.csv', null, MaatwebsiteExcelExcel::CSV); And that's my class: class UsersExport implements FromArray { protected $invoices; public function __construct(array $invoices) { $this->invoices…
I have a function which return the view with multiple variable. The code is HomeController.php public function profilePage(){ $data = User::all(); $book = Library::all(); return view('page.profile' , compact(array('data', 'book'))); } profile.blade.php @include('layouts.sidebar') . . . @foreach($book as $Library) <tr> <td>{{$Library->book}}</td>…
I get this error form helper.php. I need sale prices of product. but I get this error.And I dont understand when I get this error. helper.php public static function getSalesPriceUsingProductIDCode($id, $customerId) { $data = PosCustomerProducts::valid()->where('complete_status',0)->where('customer_id', $customerId)->where('product_id', $id) ->select('product_id', 'sales_price') ->first()->sales_price;…
Im using an achor to click a button to navigate to other page. However, it doesnt work and return a 404 error not found. My destination blade is : inventory.blade.php: <a class="d-xl-flex align-items-xl-center" href="{{ url('inventory/add')}}" style="padding-right: 0px;margin-right: 15px;"><button class="btn btn-primary…
when I enter the detail page in Laravel, it gives an error. I don't understand where the error is coming from. My codes are as follows. where is the problem? actually it says it's empty, but it needs to pull…
I'm trying to make a "create profile page" and there is a section where the user enters their experiences, in this section, the user can, insert, edit and delete their experiences. the only way i know it is possible to…
var url = "{{ route('order-detail',':slug') }}"; console.log(url); I want to add one more parameter id after slug: var url = "{{ route('order-detail',':slug',':id') }}"; console.log(url); This is the error: Missing required parameter for [Route: order-detail] [URI: orders/detail/{slug}/{id}] [Missing parameter: id]. (View:…
I have 2 columns with one-to-one relation users and doctors: Users _____________ | id | name | |____|______| | 1 | John | |____|______| Doctors _____________________ | id | dep | user_id | |____|_____|_________| | 1 | 2 | 1…