我的帖子的类别表1,3,4,8这个数字是类别的ID
例如,帖子X在数据库中有4个类别(2,7,13,24
好的,现在我用下面的代码展示我的类别
控制器代码
    namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class categoryController extends Controller
{
    public function index($category_name)
    {
        $category_name_exist = DB::table("category")->where('cat_name', $category_name)->exists();
        if ($category_name_exist) {
            $category_name = DB::table("category")->where('cat_name', $category_name)->first();
            return view('category/index', ['category' => $category_name]);
        } else {
            return view('404');
        }
    }
}路由代码
Route::get('category/{category_name}','categoryController@index');查看代码
    @extends('layout/main')
@section('title') Category @stop
@section('content')
<section class="page-title-section section-padding">
    <div class="container">
        <div class="row">
            <div class="col-md-12 ">
                <h2 class="page-tagline text-center">Now view the category domains</h2>
                <h1 class="page-title text-center xl">{{$category->cat_name}}</h1>
            </div>
        </div>
    </div>
</section>
@stop但是我不知道如何在页面中显示分类的帖子
在学习Laravel之前,我将此代码用于每个类别的显示帖子,但现在我不知道如何在laravel中使用此代码
请帮帮我。谢谢
    $get_domain_cat_id = $_GET['id'];
$query_cat = $conn->query("select * from category WHERE cat_id='$get_domain_cat_id'");
if ($query_cat->rowCount() == 0) {
    header("location:$url");
}
$fetchall = $query_cat->fetchObject();
$query_cats2 = $conn->query("select * from domains WHERE  FIND_IN_SET('$get_domain_cat_id',category)");
$fetchalls2 = $query_cats2->fetchall();发布于 2020-04-23 22:55:20
你应该在控制器里试试这个
 $category = DB::table("category")->where('cat_name', $category_name)->first();       
 return view('category/index', compact('category'));https://stackoverflow.com/questions/61388625
复制相似问题