1 在app/Admin/Controllers 创建 viewtestController.php
<?php
namespace App\Admin\Controllers;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\DB;
class SqltestController extends Controller
{
public function index()
{
$users = DB::table('user_age')->select('username', 'userid')->get();
return view('index', ['data'=>$users]);
}
}
2 .在 /resources/views 下自主创建 index.blade.php
@foreach($data as $key=>$value)
{{$value->username}}
@endforeach
3测试