我正在尝试学习jqGrid,但有些烦人
我不知道的问题。我正在使用导航网格进行添加,
编辑和删除数据。问题是,我可以添加,编辑或删除
来自网络的数据。但是更改不会应用于我的服务器。所以
例如,如果我编辑第一行,它将在导航网格中更改,但是
如果我重新加载页面,它再次出现。
NavGridHTML.html
<!DOCTYPE html>
<html>
<head>
<title>Navigation Grid</title>
<link rel="stylesheet" type="text/css" media="screen" href="css/jquery-ui.css" />
<link rel="stylesheet" type="text/css" media="screen" href="css/ui.jqgrid.css" />
<style type="text/css">
html, body {
margin: 0;
padding: 0;
font-size: 75%;
}
</style>
<script src="js/jquery-1.11.0.min.js" type="text/javascript"></script>
<script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script type="text/javascript">
$(function () {
jQuery("#navgrid").jqGrid({
url: "GridPHP.php",
editurl:"GridEditPHP.php",
datatype: "json",
mtype: "GET",
//cellEdit: true,
//cellsubmit: "remote",
//cellurl: "GridEditPHP.php",
colNames: ["Film ID","Title","Description","Length","Rating"],
colModel: [
{ name: "film_id", index: "film_id", width: 40, editable: false, editoptions: {readonly:true,size: 10}},
{ name: "title", index: "title", width: 180, editable:true, editoptions: {size: 10}},
{ name: "description", index: "description", width: 700, sortable: false, editable:true, edittype: "textarea", editoptions: {rows:"3", cols:"30"}},
{ name: "length", index: "length", width: 50, align: "right", editable:true, editoptions: {size: 10}},
{ name: "rating", index: "rating", width: 70, align: "right", editable:true, editoptions: {size: 10}}
],
pager: "#pagernav",
rowNum: 10,
rowList: [10,20,30],
sortname: "film_id",
sortorder: "asc",
viewrecords: true,
//gridview: true,
//autoencode: true,
caption: "Navigation Table"
// height: 210
});
jQuery("#navgrid").jqGrid('navGrid','#pagernav',
{edit:true,add:true,del:true, search: false, view: true}, // options
{height: 280, reloadAfterSubmit:false, recreateForm: true, closeAfterEdit: true, editCaption: "The Edit Dialog", saveData: "Data has been changed! Save changes?", closeOnEscape: true}, // edit options
{height: 280, reloadAfterSubmit:false, recreateForm: true, closeAfterAdd: true, closeOnEscape: true}, // add options
{reloadAfterSubmit:false, closeOnEscape: true}, // del options
{}, // search options
{closeOnEscape: true}
);
});
</script>
</head>
<body>
<table id="navgrid"><tr><td></td></tr></table>
<div id="pagernav"></div>
</body>
</html>
GridPHP.php
<?php
include("GridCONFIG.php");
$page = $_REQUEST["page"];
$limit = $_REQUEST["rows"];
$sidx = $_REQUEST["sidx"];
$sord = $_REQUEST["sord"];
if (!$sidx) $sidx = 1;
$totalrows = isset($_REQUEST["totalrows"]) ? $_REQUEST["totalrows"]: false;
if($totalrows) {
$limit = $totalrows;
}
$db =mysqli_connect($host, $username, $password, $database) or die ("Connection Error: " . mysqli_error($db));
mysqli_select_db($db,$database) or die ("Error connecting to db!");
$result = mysqli_query($db,"SELECT COUNT(*) AS count FROM film");
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
$count = $row['count'];
if ($count > 0 ) {
$var = @($count/$limit);
$totalpages = ceil ($var);
} else {
$totalpages = 0;
}
if ($page > $totalpages) $page=$totalpages;
if ($limit < 0) $limit = 0;
$start = $limit*$page - $limit;
if ($start < 0) $start = 0;
$sql = "SELECT film_id, title, description, length, rating FROM film ORDER BY $sidx $sord LIMIT $start , $limit";
$result = mysqli_query($db,$sql) or die ("Couldn't execute query! ".mysqli_error($db));
$responce = new \stdClass();
$responce -> success = false;
$responce -> page = $page;
$responce -> total = $totalpages;
$responce -> records = $count;
$i = 0;
while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$responce -> rows[$i]["id"] = $row["film_id"];
$responce -> rows[$i]['cell'] = array($row["film_id"],$row["title"],$row["description"],$row["length"],$row["rating"]);
$i++;
}
echo json_encode($responce);
mysqli_close($db);
?>
GridEditPHP.php
<?php
include("GridCONFIG.php");
$db =mysqli_connect($host, $username, $password, $database) or die ("Connection Error: " . mysqli_error($db));
mysqli_select_db($db,$database) or die ("Error connecting to db.");
$filmid = $_POST["film_id"];
$title = $_POST["title"];
$description = $_POST["description"];
$length = $_POST["length"];
$rating = $_POST["rating"];
//switch($_REQUEST["oper"]) {
//
// case "add":
// $sql = "INSERT INTO film (film_id,title,description,length,rating) VALUES ($filmid,$title,$description,$length,$rating)";
// mysqli_query($db, $sql);
// break;
//
// case "edit":
// $sql = "UPDATE film SET film_id=$filmid, title=$title, description=$description, length=$length, rating=$rating";
// mysqli_query($db, $sql);
// break;
//
// case "del":
// $sql = "DELETE FROM film";
// mysqli_query($db, $sql);
// break;
echo "TEST!!!";
if($_REQUEST["oper"]=='add') {
$sql = "INSERT INTO film (film_id,title,description,length,rating) VALUES ($filmid,$title,$description,$length,$rating)";
if(mysqli_query($db, $sql)) {
echo "Film added.";
} else {
echo "Error adding film: " .mysqli_error($db);
}
} elseif($_REQUEST["oper"]=='edit') {
$sql = "UPDATE film SET title=$title, description=$description, length=$length, rating=$rating WHERE film_id=$filmid";
if(mysqli_query($db, $sql)) {
echo "Film edited.";
} else {
echo "Error editing film: " .mysqli_error($db);
}
} elseif($_POST["oper"]=='del') {
$sql = "DELETE FROM film WHERE film_id=$filmid";
if(mysqli_query($db, $sql)) {
echo "Film deleted.";
} else {
echo "Error deleting film: " .mysqli_error($db);
}
}
mysqli_close($db);
?>
如果有人可以解决这个烦人的问题,我将不胜感激。
仅出于信息方面的考虑,我已经阅读了Documentation,并查看了互联网上的每个示例或解决方案。但是仍然找不到任何解决方案。
还有一个问题:如何查看GridEditPHP.php
echo "TEST!!!";
的输出...我的意思是,我可以在我的网站上看到它吗?
该数据库是名为“ sakila”的示例数据库。
最佳答案
在GridEditPHP.php中,出现语法错误。
elseif($_REQUEST["oper"]=='edit') {
$sql = "UPDATE film SET title=$title, description=$description, length=$length, rating=$rating WHERE film_id=$filmid";
if(mysqli_query($db, $sql)) {
echo "Film edited.";
} else {
echo "Error editing film: " .mysqli_error($db);
}
$ sql应该这样设置:
$sql = "UPDATE film SET title='$title', description='$description', length=$length, rating='$rating' WHERE film_id=$filmid";
现在一切正常。.我可以通过Web服务器从服务器添加,编辑或删除任何数据。
另外感谢@Oleg,我通过他的建议弄清楚了。请参见Network Tab - Developer Tools或Fiddler