larave框架ajaxl批量增加

最新推荐文章于 2021-02-22 22:22:11 发布

lwc863481702

最新推荐文章于 2021-02-22 22:22:11 发布

阅读量412

点赞数

分类专栏： php

本文链接：https://blog.csdn.net/lwc863481702/article/details/52639913

版权

php 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>插入数据</title>
	<script src="jquery-1.7.2.min.js"></script>
</head>
<body>
 <center>
 <h2>商品添加</h2>
 	
 		<table>
 		<input type="hidden" name="_token" value="<?php echo csrf_token(); ?>">
 		<div id="goods">
 			<tr>
 				<td>商品名</td>
 				<td><p class="p1"><input type="text" name="goods_name[]"></p></td>
 			</tr>
 			<tr>
 				<td>价格</td>
 				<td><span ><input type="text" name="goods_price"></span></td>
 			</tr>
 		</div>
 		<div id="attend"></div>
 			<tr>
 				<td><button value="+" class="insertall">+</button></td>
 				<td ><input type="button" value="提交"></td>
 			</tr>
 		</table>
 	

 </center>
</body>
</html>
<script>
$(function(){
	$(".insertall").click(function(){
       $("p").append('商品名<input type="text" name="goods_name[]">');
       $("span").append('价格<input type="text" name="goods_price">');
       
      
})	

	$("input[type='button']").click(function(){
		    var str="";
            var a= $("input[name='goods_name[]']");
            //alert(a.length)
            for(var i=0;i<a.length;i++){
                str =str+","+a[i].value;
		   }
		      str= str.substr(1); 
		       //alert(str);
       
        var str1="";
            var b= $("input[name='goods_price']");
            //alert(b.length)
            for(var i=0;i<b.length;i++){
                str1 =str1+","+b[i].value;
		   }
		      str1= str1.substr(1); 
	       // alert(str1)
		    location.href="insert_do?id="+str+"&str1="+str1;
})
	})
</script>

后台处理，批量添加，日志更新

//插入入库
    public function  insert_do(){
    	$goods_name = Request::input('id');
    	//echo $goods_name;die;
    	$goods_price = Request::input('str1');
    	$str1 = array();
    	//$str2 = array();

    	//var_dump($a);die;
    	$a= explode(",",$goods_name);
    	$b = explode(",",$goods_price);

    	foreach($a as $k=>$v){    
    		foreach($b as $key=>$val){      
              $str1[$k]['goods_name']=$v;
              $str1[$key]['goods_price']=$val;
              //$str2['goods_price']=$val;
    	
    	}
    	}
    	//var_dump($str1);die;
    	foreach($str1 as $k=>$v){ 
    	   DB::table('goods')->insert($v);
    	}
        //更新日志
    	$arr['content']="添加Id为".$goods_name."数据";
      $arr['date']=date("Y-m-d H:i:s");
      $arr['u_id'] = Session::get('user');
     DB::table('rizhi')->insert($arr);
       return  redirect("lists");
    }