@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');
}
}