Laravel增删改查

小毕在努力*

于 2022-05-09 22:39:43 发布

阅读量436

点赞数

文章标签： php 开发语言 laravel

本文链接：https://blog.csdn.net/m0_64863890/article/details/124677255

版权

代码

NewsController.php
<?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');
        
        
    }
}

show.php

@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

index.php

@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 onclick="return confirm('您确定要删除吗')">删除</button>
    </form>
    </td>
   
</tr>
@endforeach
    </tbody>
</table>


    

@endsection