Пользователь
Регистрация: 29.08.2017
Сообщений: 25
|
Error 505/404 Jgrid
HELP, очень нужна помощь форумчан. Есть проблема с выводом на Grid данных из таблицы.
"Failed to load resource: the server responded with a status of 404 (Not Found) https://XXX/getdata.php?&_search=fal...index&sord=asc.
+ ошибка в js.min
f.send(a.hasContent&&a.data||null), b=function(c,e){var h,i,j;if(b&&(e||4===f.readyState))i f(delete Yc[g],b=void 0,f.onreadystatechange=n.noop,e)4!= =f.readyState&&f.abort();else{j={}, h=f.status,"string"==typeof f.responseText&&(j.text=f.responseT ext);try{i=f.statusText}catch(k){i= ""}h||!a.isLocal||a.crossDomain?122 3===h&&(h=204):h=j.text?200:404}
Ошибку найти не могу(
Сам вызов Grid:
Код:
<table id="list"></table>
<div id="pager"></div>
<script type="text/javascript">
jQuery(document).ready(function(){
jQuery("#list").jqGrid({
url:'getdata.php',
datatype: 'json',
mtype: 'POST',
colNames:['ID', 'Режим', 'От кого', 'Кому', 'Сообщение', 'Комментарий', 'Время подтверждения'],
colModel :[
{name:'om_index',index:'om_index', width:200},
{name:'timereg',index:'timereg', width:200,sortable:false,editable: true, editoptions: { readonly: "readonly" }},
{name:'from_lpu_index',index:'from_lpu_index', width:200, sortable:false, editable: true, editoptions: { readonly: "readonly" }},
{name:'to_lpu_index',index:'to_lpu_index', width:200, sortable:false, editable: true, editoptions: { readonly: "readonly" }},
{name:'mess_subj',index:'mess_subj', width:200, sortable:false, editable: true, editoptions: { readonly: "readonly" }},
{name:'mess_body',index:'mess_body', width:200, align:"right", sortable:false, editable: true, editoptions: { readonly: "readonly" },edittype:"textarea", editoptions:{rows:"2",cols:"20"}},
{name:'timechangestatus',index:'timechangestatus', width:200, align:"right",editable:true, editoptions: {
// dataInit is the client-side event that fires upon initializing the toolbar search field for a column
// use it to place a third party control to customize the toolbar
dataInit: function (element) {
$(element).datepicker({
id: 'timechangestatus_datePicker',
dateFormat: 'M/d/yy',
//minDate: new Date(2010, 0, 1),
maxDate: new Date(2020, 0, 1),
showOn: 'focus'
});
}
}}
],
pager: '#pager',
rowNum:10,
rowList:[5,10,30],
sortname: 'om_index',
sortorder: "desc",
viewrecords: true,
editurl: 'saverow.php',
caption: 'Лог сообщений'
});
jQuery("#list").jqGrid('navGrid',"#list",{ edit: true, add: false, del: false, search: false, refresh: true, view: false, align: "left" },
{ closeAfterEdit: true }, // default settings for edit
{}, // default settings for add
{}, // delete instead that del:false we need this
{}, // search options
{} /* view parameters*/
);
});
</script>
Код:
<?php
header('Content-Type: text/html; charset=utf-8');
//читаем параметры
try {
$from_us_name_new = $_REQUEST['login'];
$curPage = $_POST['page'];
$rowsPerPage = $_POST['rows'];
$sortingField = $_POST['sidx'];
$sortingOrder = $_POST['sord'];
//подключаемся к базе
$user = 'postgres';
$pass = '******';
$dbh = new PDO('pgsql:host=XX.XX.XX.XXX ;dbname=XXXX', $user, $pass);
//определяем количество записей в таблице
$rows = $dbh->query("SELECT COUNT(om_index) AS count FROM message.log where from_us_name = '$from_us_name_new' ");
$totalRows = $rows->fetch(PDO::FETCH_ASSOC);
$firstRowIndex = $curPage * $rowsPerPage - $rowsPerPage;
//получаем список пользователей из базы
$res = $dbh->query("SELECT om_index,
timereg,
from_lpu_index,
to_lpu_index,
from_us_name,
mess_subj,
mess_body,
om_status,
timesend
FROM olm.message_log ORDER BY '.$sortingField.' '.$sortingOrder.' LIMIT '.$firstRowIndex.', ".$rowsPerPage);
$response->page = $curPage;
$response->total = ceil($totalRows['count'] / $rowsPerPage);
$response->records = $totalRows['count'];
$i=0;
while($row = $res->fetch(PDO::FETCH_ASSOC)) {
$response->rows[$i]['id']=$row['om_index'];
$response->rows[$i]['cell']=array($row['om_index'], $row['timereg'], $row['from_lpu_index'], $row['to_lpu_index'], $row['mess_subj'],$row['mess_body'],$row['timechangestatus']);
$i++;
}
echo json_encode($response);
}
catch (PDOException $e) {
echo 'Database error: '.$e->getMessage();
}
?>
Последний раз редактировалось Asew; 10.03.2018 в 20:21.
|