laravel CURD

最新推荐文章于 2022-05-12 09:09:20 发布

青春已被放纵了

最新推荐文章于 2022-05-12 09:09:20 发布

阅读量607

点赞数

CC 4.0 BY-SA版权

分类专栏： laravel

本文链接：https://blog.youkuaiyun.com/qq_36373262/article/details/54881479

laravel 专栏收录该内容

17 篇文章

订阅专栏

本文介绍了一个基于 Laravel 框架实现的简单 CRUD (创建、读取、更新、删除) 功能示例。该示例展示了如何使用 PHP 和 Laravel 的 DB 门面进行数据库操作，并提供了基本的界面布局及搜索功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
    <style>
        ul{ margin-left: 150px; }
        li{ list-style: none;float:left;align-content: center;
            margin: 5px; }
    </style>
</head>
<body>
<form action="curd" method="get">
    <input type="text" name="class" value="{{$search}}">
    <input type="submit" value="搜索">
</form>
<table border="1">
    <tr>
        <td>ID</td>
        <td>班级</td>
        <td>人数</td>
        <td>操作</td>
    </tr>
    @foreach ($user as $arr)
    <tr>
        <td>{{$arr->id}}</td>
        <td>{{$arr->class}}</td>
        <td>{{$arr->class_num}}</td>
        <td><a href="curd_delete/{{$arr->id}}">删除</a></td>
        <td><a href="curd_update/{{$arr->id}}">修改</a></td>
    </tr>
    @endforeach
</table>
{{--{!! $user->appends($search)->links() !!}--}}
{!! $user->appends(['class' => $search])->render() !!}
</body>
</html>


<?php
/**
 * Created by PhpStorm.
 * User: 青春已被放纵了
 * Date: 2017/2/5
 * Time: 14:02
 */
namespace App\Http\Controllers;

use DB;
use Illuminate\Support\Facades\Input;

class CurdController extends Controller {
    public function curd_index(){
        if(Input::get("class") != ""){
            $search=Input::get('class');

            $user = DB::table('class')->where('class',"$search")->paginate(5);
        }else{
            $search='';
            $user = DB::table('class')->paginate(5);
        }
        return view("curd/index",['user'=>$user,'search'=>$search]);
    }
    public function curd_delete($id){
        $delete = DB::table("class")->where('id',$id)->delete();
//        print_r($update);die;
        if($delete){
            echo "<script>alert('删除成功');location.href='../curd'</script>";
        }else{
            echo "<script>alert('删除失败');location.href='../curd'</script>";
        }
    }
    public function curd_update($id){
        $update = DB::table("class")->where("id",$id)->get();
        $update = json_decode(json_encode($update),true);
        return view("curd/update",['update'=>$update]);
    }
    public function curd_updated(){
        $class = Input::get("class");
        $class_num = Input::get("class_num");
        $id = Input::get("id");
        $update = DB::table("class")->where('id',$id)->update(['class'=>$class,'class_num'=>$class_num]);
        if($update){
            echo  "<script>alert('修改成功');location.href='curd'</script>";
        }else{
            echo  "<script>alert('修改失败');location.href='curd'</script>";
        }

    }

}


//CURD操作
Route::get("curd","CurdController@curd_index");
Route::get("curd_update/{id}","CurdController@curd_update");
Route::get("curd_delete/{id}","CurdController@curd_delete");
Route::post("curd_updated","CurdController@curd_updated");
Route::get("curd_saerch","CurdController@curd_saerch");