【无标题】

@extends('layout.grail')
@section('main')
    <h2>新闻列表</h2>
    <table class="table">
        <thead>
        <tr>
            <th>编号</th><th>标题</th><th >作者</th><th>类别</th><th>操作</th>
        </tr>

        </thead>
        <tbody>
            @foreach($newsList as $news)
            <tr>
                <td>{{$news->id}}</td>
                <td>{{$news->title}}</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')
                        <button onclick="return confirm('您确定要删除吗？')">删除</button>
                        @csrf
                    </form>

                </td>
            </tr>
            @endforeach
        
        </tbody>
    </table>
     
@endsection
<style>
    button{
        border:none;
        color: #0d6efd;

    }
    table a{
        display: block;
        text-decoration-line: none;
        margin-right: 20px;
    }
    table a:hover{
        text-decoration-line: underline;
    }
   .optgroup>a,button:hover {
        text-decoration-line:underline;
    }
    .operation{
        display: flex;
    }
</style>

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class NewsController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        //
        $newsList=DB::table('news')->get();
        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)
    {
        //
        //dd($request->all());
        $data=$request->except('_token');
        $data['user_id']=1;
        //dd($data);
        $res=DB::table('news')->insert($data);
        if($res)
            return redirect('/news/index');
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
        $news=DB::table('news')->where('id',$id)->first();
        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)
    {
        //
    }

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

    }
}