Почему мои DataTables не работают должным образом?

Я использую Laravel 5.5 с этим пакетом https://github.com/yajra/laravel-datatables
Я получаю следующий ответ на вкладке моего браузера вместо таблицы. Без функции данных страница прекрасно загружается со статическим содержимым. Кто-нибудь может указать мне, что мне не хватает в моих отрывках?

127.0.0.1:8000/product

{"draw":0,"recordsTotal":20,"recordsFiltered":20,"data":[{"id":"1","name":"Beef Burger","price":"150","person_serves":"1","category":"Snacks"},{"id":"2","name":"Chicken Burger","price":"140","person_serves":"1","category":"Snacks"},{"id":"3","name":"Mutton Burger","price":"180","person_serves":"1","category":"Snacks"},{"id":"4","name":"Vegetable Burger","price":"100","person_serves":"1","category":"Snacks"},{"id":"5","name":"Chilli Beef Burger","price":"170","person_serves":"1","category":"Snacks"},{"id":"6","name":"Special Cafe Burger","price":"150","person_serves":"1","category":"Snacks"},{"id":"7","name":"Club Sanswitch","price":"90","person_serves":"1","category":"Snacks"},{"id":"8","name":"Beef Sandwitch","price":"150","person_serves":"1","category":"Snacks"},{"id":"9","name":"Beef Burger","price":"150","person_serves":"1","category":"Snacks"},{"id":"10","name":"Chicke Sharma","price":"150","person_serves":"1","category":"Snacks"},{"id":"11","name":"Beef Kebab","price":"150","person_serves":"1","category":"Kebab"},{"id":"12","name":"Chicken Sharma","price":"150","person_serves":"1","category":"Berb-Q"},{"id":"13","name":"Beef Chap","price":"300","person_serves":"2","category":"Kebab"},{"id":"14","name":"Fried Chicken","price":"100","person_serves":"1","category":"Snacks"},{"id":"15","name":"Berbq Grill Chicken","price":"150","person_serves":"1","category":"Berb-Q"},{"id":"16","name":"Fish Kebab","price":"450","person_serves":"2","category":"Kebab"},{"id":"17","name":"Pan Pizza","price":"300","person_serves":"3","category":"Snacks"},{"id":"18","name":"Pizza Regular","price":"150","person_serves":"2","category":"Snacks"},{"id":"19","name":"Mocktail","price":"150","person_serves":"1","category":"Drinks"},{"id":"20","name":"Chocolate Latte","price":"150","person_serves":"1","category":"Drinks"}],"queries":[{"query":"select count(*) as aggregate from (select '1' as `row_count` from `products`) count_row_table","bindings":[],"time":1.71},{"query":"select `id`, `name`, `price`, `person_serves`, `category` from `products`","bindings":[],"time":0.46}],"input":[]}

web.php

Route::get('home', 'HomeController@home');
Route::get('product', 'ProductController@index')->name('product');
Route::get('product', 'ProductController@getdata')->name('product.getdata');

ProductController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Product;
use Yajra\DataTables\Facades\DataTables;

class ProductController extends Controller
{
function index()
{
//http://127.0.1:8000/product
return view('product.index');
}

function getdata()
{
$products = Product::select(
'id',
'name',
'price',
'person_serves',
'category'
);
return DataTables::of($products)->make(true);
}
}

product.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Product extends Model
{
//
}

ресурсы / виды / продукта / index.blade.php

@extends('theme.default')
@section('content')
<div class="agile-grids">
<!-- blank-page -->
<!---728x90--->

<div class="banner">
<h2>
<a href="index.html">Home</a>
<i class="fa fa-angle-right"></i>
<span>Blank</span>
</h2>
</div>
<!---728x90--->

<div class="blank">
<div class="blank-page">
<br />
<h3 align="center">Product Lists</h3>
<br />
<table id="product_table" class="table table-bordered" style="width:100%">
<thread>
<tr>
<th>ID</th>
<th>Name</th>
<th>Price</th>
<th>People Serves</th>
<th>Category</th>
</tr>
</thread>
</table>
</div>
</div>
<!-- //blank-page -->
</div>
<script type="text/javascript">
$(document).ready(function()
{
$('#product_table').DataTable(
{
"processing"    : true;
"serverSide"    : true;
"ajax"          : "{{ route('product/getdata') }}""columns"       : [
{ "data": "id"},
{ "data": "name"},
{ "data": "price"},
{ "data": "person_serves"},
{ "data": "category"}
]
});
});
</script>

@endsection

0

Решение

Вы установили два действия с одинаковым URL /product и тот же метод get в web.php, В этом случае Laravel использует последний ProductController@getdata так что вы получите JSON вместо HTML в вашем браузере.

Просто измените URL для AJAX следующим образом:

Route::get('product-data', 'ProductController@getdata')->name('product.getdata');

Также замените route('product/getdata') с route('product.getdata');

0

Другие решения

Других решений пока нет …

По вопросам рекламы [email protected]