Tова е кода с който извършвам търсенето, да не би в него някъде да е крешката
Това е хтмл кода на формата в която вадя резултатите:
А това е самият php-код който уж извършва търсенето обаче ми се стува че скрипта не работи
Код:
function doSearch(){
$('#dg').datagrid('load',{
vlekach_number: $('#vlekach_number').val(),
data_zarejdane: $('#data_zarejdane').val()
});
}
Код:
<body>
<div class="demo-info" style="margin-bottom:10px">
</div>
<table id="dg" title="Списъци" class="easyui-datagrid" style="width:860px;height:400px"
url="pages/get_zarejdane.php"
toolbar="#toolbar" pagination="true"
rownumbers="true" fitColumns="true" singleSelect="true">
<thead>
<tr>
<th field="vlekach" width="50" align="center">Влекач</th>
<th field="data" width="50">Дата</th>
<th field="strana" width="150">Държава</th>
<th field="bezinostancia" width="150">Бензиностанция</th>
<th field="kolichestvo" width="70">Количество</th>
<th field="kilometraj" width="70">Километраж</th>
<th field="tonaj" width="90">Тонаж</th>
<th field="full" width="50">Фулиран</th>
</tr>
</thead>
</table>
<div id="toolbar">
<a href="#" class="easyui-linkbutton" iconCls="icon-add" plain="true" onClick="newZarejdane()">Нов запис</a>
<a href="#" class="easyui-linkbutton" iconCls="icon-edit" plain="true" onClick="editZarejdane()">Редакция</a>
<a href="#" class="easyui-linkbutton" iconCls="icon-remove" plain="true" onClick="removeZarejdane()">Изтриване</a>
<span>Влекач номер:</span>
<input id="vlekach_number" style="line-height:26px;border:1px solid #ccc">
<span>Дата на зареждане:</span>
<input id="data_zarejdane" style="line-height:26px;border:1px solid #ccc">
<a href="#" class="easyui-linkbutton" plain="true" onClick="doSearch()">Търсене</a>
</div>
<div id="dlg" class="easyui-dialog" style="width:400px;padding:10px 20px"
closed="true" buttons="#dlg-buttons">
<div class="ftitle">Нов запис</div>
<form id="fm" method="post" novalidate>
<div class="fitem">
<label>Влекач:</label>
<input name="kamion" class="easyui-validatebox" required="true">
</div>
<div class="fitem">
<label>Дата:</label>
<input name="data" class="easyui-validatebox">
</div>
<div class="fitem">
<label>Страна:</label>
<input name="strana">
</div>
<div class="fitem">
<label>Бензиностанция:</label>
<input name="bezinostancia" class="easyui-validatebox">
</div>
<div class="fitem">
<label>Количество:</label>
<input name="kolichestvo" class="easyui-validatebox">
</div>
<div class="fitem">
<label>Километраж:</label>
<input name="kilometraj" class="easyui-validatebox">
</div>
<div class="fitem">
<label>Тонаж:</label>
<input name="tonaj" class="easyui-validatebox">
</div>
<div class="fitem">
<label>Фулиран:</label>
<input name="full" class="easyui-validatebox">
</div>
</form>
</div>
<div id="dlg-buttons">
<a href="#" class="easyui-linkbutton" iconCls="icon-ok" onClick="saveZarejdane()">Запис</a>
<a href="#" class="easyui-linkbutton" iconCls="icon-cancel" onClick="javascript:$('#dlg').dialog('close')">Отказ</a>
</div>
</body>
Код:
<?php
include 'conn.php';
$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
$vlekach_number = isset($_POST['vlekach_number']) ? mysql_real_escape_string($_POST['vlekach_number']) : '';
$data_zarejdane = isset($_POST['data_zarejdane']) ? mysql_real_escape_string($_POST['data_zarejdane']) : '';
$offset = ($page-1)*$rows;
$result = array();
mysql_query("SET CHARACTER SET utf8");
$where = "vlekach = '$vlekach_number%' and data like '$data_zarejdane%'";
$rs = mysql_query("select count(*) from zarejdania where `vlekach` LIKE '%$vlekach_number' ");
$row = mysql_fetch_row($rs);
$result["total"] = $row[0];
$rs = mysql_query("select * from zarejdania where vlekach LIKE '%$vlekach_number' limit $offset,$rows");
$items = array();
while($row = mysql_fetch_object($rs)){
array_push($items, $row);
}
$result["rows"] = $items;
echo json_encode($result);
?>