【无标题】

代码

<?php

namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;

use Illuminate\Http\Request;

use function PHPUnit\Framework\returnSelf;

class NewsController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $newsList = DB::table('news')->orderBy('id','desc')->get();
        // dd($newsList);
        return view('news.index',compact('newsList'));
        //
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return view('news.addnews');
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //name起作用，
        // dd($request->all());
        $data = $request->except('_token');
        $data['user_id']=1;
       $res = DB::table('news')->insert($data);
        if($res){
            return redirect('/news');
        }
        dd($data);
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
       $news = DB::table('news')->where('id',$id)->first();
        return view('news.show',compact('news'));
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
        $news = DB::table('news')->find($id);
        return view('news.edit',compact('news'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
        $news = $request->except('_token','_method');
        // dd($news);
        $res =DB::table('news')->where('id',$id)->update($news);
        // dd($news,$res);
        return redirect('news');

    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
       $res = DB::table('news')->where('id',$id)->delete();
    //    dd($res);
        return redirect('news');
        
        
    }
}

@extends('layout.grail')
@section('title','添加文章')
@section('main')
<form action="{{route('news.store')}}" method="post">
    <div class="form_group">
        <label for="title">
            标题
        </label>
        <input type="text" name="title" id="title" class="form-control">
    </div>
    <div class="form-group">
        <label for="category_id">类别</label>
        <select name="category_id" id="category_id" class="form_control">
            <option value="0">请选择新闻类别</option>
            <option value="1">时政要闻</option>
            <option value="2">经济动态</option>
            <option value="3">健康信息</option>
            <option value="4">体育新闻</option>
            <option value="5">娱乐八卦</option>
            <option value="6">国际新闻</option>
        </select>
    </div>
    <div>
        <div class="form-group"></div>
        <label for="content">内容</label>
        <textarea name="content" id="content" cols="30" rows="10" class="form-control"></textarea>
    </div>
    <div>
        <input type="submit" name="" id="" value="添加">
    </div>
    @csrf
</form>
@endsection

@extends('layout.grail')
@section('title','修改标题')
@section('main')
<form action="{{route('news.update',$news->id)}}" method="post">
    @method  ('put')
    <div class="form_group">
        <label for="title">
            标题
        </label>
        <input type="text" name="title" id="title" class="form-control" value="{{$news->title}}">
    </div>
    <div class="form-group">
        <label for="category_id">类别</label>
        <select name="category_id" id="category_id" class="form_control">
            <option value="0">请选择新闻类别</option>
            <option value="1">时政要闻</option>
            <option value="2">经济动态</option>
            <option value="3">健康信息</option>
            <option value="4">体育新闻</option>
            <option value="5">娱乐八卦</option>
            <option value="6">国际新闻</option>
        </select>
    </div>
    <div>
        <div class="form-group"></div>
        <label for="content">内容</label>
        <textarea name="content" id="content" cols="30" rows="10" class="form-control">
            {{$news->content}}
        </textarea>
    </div>
    <div>
        <input type="submit" name="" id="" value="修改">
    </div>
    @csrf
</form>
@endsection

@extends('layout.grail')
@section('title','新闻列表')
@section('main')
<h2>新闻列表</h2>
<table border="1">
    <thead>
        <tr>  
        <th>新闻id</th>
        <th>新闻标题</th>
        <th>用户id</th>
        <th>种类id</th>
    </tr>
      
    </thead>
    <tbody>
    @foreach ($newsList as $news )
<tr>
    <td>{{$news->id}}</td>
    <!-- url('news/').$news->id' -->
    
    <td><a href="{{route('news.show',$news->id)}}">{{$news->title}}</a></td>
    <td>{{$news->user_id}}</td>
    <td>{{$news->category_id}}</td>
    <td>
        <a href="{{route('news.edit',$news->id)}}" title="">修改</a>
        <form action="{{route('news.destroy',$news->id)}}" method="post">
        @method('delete')
        @csrf
        <button οnclick="return confirm('您确定要删除吗')">删除</button>
    </form>
    </td>
   
</tr>
@endforeach
    </tbody>
</table>


    

@endsection

@extends('layout.grail')
@section('title',$news->title)
@section('main')
<div>
    <div>
        {{$news->title}}
    </div>
    <p>{{$news->user_id}}</p>
    <div>{{$news->content}}</div>
</div>
@endsection