jquerydatatables使用codeigniter只更新数据库sql中的一半数据

vohkndzv  于 2021-06-20  发布在  Mysql
关注(0)|答案(0)|浏览(253)

救命啊。我似乎不能使我的代码工作。它只限制我更新300个数据。我正在使用codeigniter。我的htaccess或者我的模型有什么问题吗?
以下是用户界面:

以下是330种产品:

我不知道为什么它只更新300个数据
这是我在js datatable中的代码

$(document).ready(function(){
	var table = $('#table').DataTable({
	"bJQueryUI": true,
	"bProcessing": true,
	"processing": true,
	"bDeferRender": true,

	ajax: window_location+'/htdocs/reconciliation_items1',
	columns: [
			{
				mRender: function(row, setting, full){
					return "<input type='hidden' name='unitPrice[]' value='"+full.unitPrice+"'>"+"<input type='hidden' name='itemNum[]' value='"+full.itemNum+"'>"+
							"<input type='hidden' name='ph_id[]' value='"+full.ph_id+"'>"+full.prodName;
				}
			},
			{
				mRender: function(row, setting, full){
					return full.prodQty + ' units';
				}
			},
			{
				mRender: function(row, setting, full){
					return "<input name='physical_count[]' type='number' min='0' step='1' class='physical_count' >" +
						"<input name='status[]' type='hidden'>" +
						"<input name='computed[]' type='hidden'>" +
						"<input name='initial[]' type='hidden' value='"+full.prodQty+"'>";
				}
			},
			{
				mRender: function(row, setting, full){
					return "<label class='status'></label>";
				}
			},
			{
				mRender: function(row, setting, full){
					return "<textarea name='remarks[]' class='remarks'></textarea>";
				}
			}
			],
	scrollX: true,
	columnDefs: [{targets: 0, width: '100px'}, {targets: [1,2,3,4], width: '50px'}],
	ordering: false,
	bPaginate: false,
	language: {
		info: 'Total number of products: <b> _MAX_ </b>',
		infoEmpty: 'Total number of products: <b> 0 </b>'
	}
});
<script type="text/javascript" src='<?php echo base_url(); ?>assets/js/submit.js'></script>

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题