在laravel中通过ajax在表中显示来自sql查询的数据

Route::get('/getData', 'DataController@getData')->name('getData');

php artisan make:controller DataController

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\YourModel; // 替换为你的模型

class DataController extends Controller
{
    public function getData(Request $request)
    {
        $data = YourModel::all(); // 替换为你的模型查询逻辑

        return response()->json($data);
    }
}

<table id="data-table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Email</th>
        </tr>
    </thead>
    <tbody>
        <!-- 这里将通过Ajax请求动态加载数据 -->
    </tbody>
</table>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
    $(document).ready(function() {
        $.ajax({
            url: "{{ route('getData') }}",
            type: "GET",
            dataType: "json",
            success: function(response) {
                var tableBody = '';

                $.each(response, function(index, data) {
                    tableBody += '<tr>';
                    tableBody += '<td>' + data.id + '</td>';
                    tableBody += '<td>' + data.name + '</td>';
                    tableBody += '<td>' + data.email + '</td>';
                    tableBody += '</tr>';
                });

                $('#data-table tbody').html(tableBody);
            }
        });
    });
</script>