我的帖子的类别表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
复制相似问题