tp5 curd 增删改查

一时失言乱红尘 2022-02-22 02:15 159阅读 0赞

路由定义：

//curd首页
    Route::any('curdindex','index/Curd/index');
    //curd新增
    Route::post('curdadd','index/Curd/add');
    //curd删除
    Route::post('curddel','index/Curd/delete');
    //curd修改
    Route::post('curdsave','index/Curd/save');

控制器：

<?php
    
    namespace app\index\controller;
    use think\Db;
    use think\Controller;
    use think\Request;
    class Curd extends Controller
    {
        /**
         * curd显示
         *
         * @return \think\Response
         */
        public function index()
        {
    		$sql=Db::name('tp_curd')->order('id','desc')->select();
            return view('curd/index',['info'=>$sql]);
        }
    
        /**
         * curd新增
         *
         * @return \think\Response
         */
        public function add()
        {
            if(request()->isPost()){
    			$data=input('post.');
    			$data['date']=date('Y-m-d H:i:s');
    			$sql=Db::name('tp_curd')->insert($data);
    			if($sql){
    				return json(['status' => '20000','msg' => '评论成功']);
    			}else{
    				return json(['status' => '40003','msg' => '评论失败']);
    			}
    		}
        }
    
    
        /**
         * curd修改
         *
         */
        public function save()
        {
              if(request()->isPost()){
                $data=input('post.');
    			$content=$data['content'];
    			$id=$data['id'];
                $save=Db::name('tp_curd')->update(['content' => $content,'id'=>$id]);
            	if($save){
            		return json(['status' => '20000','msg' => '修改成功']);
            	}else{
            		return json(['status' => '40011','msg' => '修改失败']);
            	}
            }else{
            	return json(['status' => '40003','msg' => '提交错误']);
            }
        }
    
        /**
         * curd删除
         *
         * @param  int  $id
         * @return \think\Response
         */
        public function delete()
        {
             if(request()->isPost()){
            	$data=input('post.');
            	$del=Db::name('tp_curd')->delete($data);
    			if($del){
    				return json(['status' => '20000','msg' => '删除成功']);
    			}else{
    				return json(['status' => '40011','msg' => '删除失败']);
    			}
    		 }else{
    			 	return json(['status' => '40003','msg' => '提交错误']);
    		 }
        }
    }

视图：

<!DOCTYPE html>
    <html>
    <head>
    <meta charset="UTF-8">
    <title>评论插件</title>
    <link rel="stylesheet" type="text/css" href="http://www.jq22.com/jquery/bootstrap-3.3.4.css">
    <style>
    	.container{
    		width: 1000px;
    	}
    	.commentbox{
    		width: 900px;
    		margin: 20px auto;
    	}
    	.mytextarea {
    	    width: 100%;
    	    overflow: auto;
    	    word-break: break-all;
    	    height: 100px;
    	    color: #000;
    	    font-size: 1em;
    	    resize: none;
    	}
    	.comment-list{
    		width: 900px;
    		margin: 20px auto;
    		clear: both;
    		padding-top: 20px;
    	}
    	.comment-list .comment-info{
    		position: relative;
    		margin-bottom: 20px;
    		margin-bottom: 20px;
    		border-bottom: 1px solid #ccc;
    	}
    	.comment-list .comment-info header{
    		width: 10%;
    		position: absolute;
    	}
    	.comment-list .comment-info header img{
    		width: 100%;
    		border-radius: 50%;
    		padding: 5px;
    	}
    	.comment-list .comment-info .comment-right{
    		padding:5px 0px 5px 11%; 
    	}
    	.comment-list .comment-info .comment-right h3{
    		margin: 5px 0px;
    	}
    	.comment-list .comment-info .comment-right .comment-content-header{
    		height: 25px;
    	}
    	.comment-list .comment-info .comment-right .comment-content-header span,.comment-list .comment-info .comment-right .comment-content-footer span{
    		padding-right: 2em;
    		color: #aaa;
    	}
    	.comment-list .comment-info .comment-right .comment-content-header span,.comment-list .comment-info .comment-right .comment-content-footer span.reply-btn,.send,.reply-list-btn{
    		cursor: pointer;
    	}
    	.comment-list .comment-info .comment-right .reply-list {
    		border-left: 3px solid #ccc;
    		padding-left: 7px;
    	}
    	.comment-list .comment-info .comment-right .reply-list .reply{
    		border-bottom: 1px dashed #ccc;
    	}
    	.comment-list .comment-info .comment-right .reply-list .reply div span{
    		padding-left: 10px;
    	}
    	.comment-list .comment-info .comment-right .reply-list .reply p span{
    		padding-right: 2em;
    		color: #aaa;
    	}
    </style>
    </head>
    <body>
    
    <div class="container">
    	<div class="commentbox">
    		<textarea cols="80" rows="50" placeholder="来说几句吧......" class="mytextarea" id="content"></textarea>
    		<div class="btn btn-info pull-right" id="comment" onclick="Add()">评论</div>
    	</div>
    	{volist name="info" id="v"}
    	<div class="comment-list" >
    		<div class="comment-info">
    			<header><img src="/static/images/img.jpg"></header>
    			<div class="comment-right">
    				<h3>猪年大吉</h3>
    				<div class="comment-content-header"><span><i class="glyphicon glyphicon-time"></i> {$v.date}</span><span><i class="glyphicon glyphicon-map-marker"></i>北京</span></div>
    				<p class="content" onclick="save({$v.id})">
    					<input value="{$v.content}" id="c{$v.id}" style="display:none" onblur="onsave({$v.id})">
    				<span id="a{$v.id}">{$v.content}</span>
    				</p>
    				<div class="comment-content-footer">
    					<div class="row">
    						<div class="col-md-10">
    							<span><i class="glyphicon glyphicon-pushpin"></i> 来自:win10 </span><span><i class="glyphicon glyphicon-globe"></i> chrome 55.0.2883.87</span>
    						</div>
    						<div class="col-md-2"><span class="reply-btn" onclick="del({$v.id})">删除</span></div>
    					</div>
    				</div>
    				<div class="reply-list"></div>
    			</div>
    		</div>
    	</div>
    	{/volist}
    </div>
    
    <script type="text/javascript" src="/static/js/jquery.min.js"></script>
    <script type="text/javascript" src="/static/js/jquery.comment.js" ></script>
    
    </body>
    </html>
    <script src="/static/jq.js" ></script>
    <script>
    
    	function Add(){
    		var content=$('.mytextarea').val();
    		if(content==""){
    			alert('输入为空');
    			return false;
    		}
    		$.ajax({
    			url:"{:url('/curdadd')}",
    			type:"post",
    			data:{content:content},
    			success:function(data){
    				if(data.status==20000){
    					alert(data.msg);
    					window.location.href="{:url('/curdindex')}"
    				}else{
    					alert(data.msg);
    					
    				}
    			}
    		})
    	}
    	function del(id){
    		var id=id;
    		$.ajax({
    			url:"{:url('/curddel')}",
    			type:"post",
    			data:{id:id},
    			success:function(data){
    				if(data.status==20000){
    					alert(data.msg);
    					window.location.href="{:url('/curdindex')}"
    				}else{
    					alert(data.msg);
    						
    				}
    			}
    		})
    	}
    </script>
    <script>
    	function save(id){
    		document.getElementById('a'+id).innerHTML="";
    		document.getElementById('c'+id).style.display="block";
    	}
    	function onsave(id){
    		var content=$('#c'+id).val();
    		$.ajax({
    			url:"{:url('/curdsave')}",
    			type:"post",
    			data:{id:id,content:content},
    			success:function(data){
    				if(data.status==20000){
    					document.getElementById('a'+id).innerHTML=content;
    					document.getElementById('c'+id).style.display="none";
    				}else{
    					alert(data.msg);
    				}
    			}
    		})
    	}
    </script>