jQuery Grid Plugin - jqGridForum

Topic RSS

jqgrid edit delete add buttons

28/08/2014
00:15

hindos

Member

Members

Forum Posts: 5

Member Since:
21/08/2014

Offline

hiiiii im a newbie in using jqgrid the bottons in the navgrid are non cliquable ??? and pleaase i need someone to check and correct my code or provide me with an example to edit and delete and thanks a lotÂ

final.htmlÂ

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>jqGrid Demo</title>
<style>
html, body {
margin: 0; /* Remove body margin/padding */
padding: 0;
overflow: auto; /* Remove scroll bars on browser window */
font: 12px "Lucida Grande", "Lucida Sans Unicode", Tahoma, Verdana;
}
</style>

<link rel="stylesheet" type="text/css" media="screen" href="themes/redmond/jquery-ui-1.8.2.custom.css" />

<script src="js/jquery.min.js" type="text/javascript"></script>
<script src="js\src\i18n\grid.locale-fr.js" type="text/javascript"></script>

<script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>

],
// pager parameter define that we want to use a pager bar
// in this case this must be a valid html element.
// note that the pager can have a position where you want
pager: jQuery('#pager2'),
// rowNum parameter describes how many records we want to
// view in the grid. We use this in example.php to return
// the needed data.
//rowNum:10,
// rowList parameter construct a select box element in the pager
//in wich we can change the number of the visible rows
//rowList:[10,20,30],
// sortname sets the initial sorting column. Can be a name or number.
// this parameter is added to the url
sortname: 'nom',
//viewrecords defines the view the total records from the query in the pager
//bar. The related tag is: records in xml or json definitions.
viewrecords: true,
gridview: true,
//mtype: 'GET',
autoencode: true,
//sets the sorting order. Default is asc. This parameter is added to the url
sortorder: "desc",
editurl: "finalEdit.php",
caption: "liste des utilisateurs"
//autowidth:true

});
jQuery("#list2").jqGrid('navGrid','#pager2',{edit:true,add:false,del:false,search:true,refresh:true},
{},{},{},{multipleSearch:true});
});

$("#bedata").click(function(){
var gr = mygrid.jqGrid('getGridParam','selrow');
if( gr != null )
mygrid.jqGrid('editGridRow',gr,{height:480,reloadAfterSubmit:false});
else alert("Please Select Row");
});
$("#dedata").click(function(){
var gr = jQuery("#delgrid").jqGrid('getGridParam','selrow');
//getSelectedRow();
if( gr != null ) jQuery("#delgrid").jqGrid('delGridRow',gr,{reloadAfterSubmit:false});
else alert("Please Select Row to delete!");
});
</script>
</head>
<body>
<center>

<table id="list2"></table>

<div id="pager2"></div>
<center>
</body>
</html>

final.php

<?php
// Include the information needed for the connection to
// MySQL data base server.
include("dbconfig.php");
//since we want to use a JSON data we should include
//encoder and decoder for JSON notation
//If you use a php >= 5 this file is not needed
//include("JSON.php");

// create a JSON service
//$json = new Services_JSON();

// to the url parameter are added 4 parameter
// we shuld get these parameter to construct the needed query
// for the pager

// get the requested page

$page = $_GET['page'];

// get how many rows we want to have into the grid
// rowNum parameter in the grid
$limit = $_GET['rows'];
// get index row - i.e. user click to sort
// at first time sortname parameter - after that the index from colModel
$sidx = $_GET['sidx'];
// sorting order - at first time sortorder
$sord = $_GET['sord'];

// if we not pass at first time index use the first column for the index
if(!$sidx) $sidx =1;
// connect to the MySQL database server
$db = mysql_connect("localhost", "root", "")
or die("Connection Error: " . mysql_error());

// select the database
mysql_select_db("gestion_conges") or die("Error conecting to db.");

// calculate the number of rows for the query. We need this to paging the result
$result = mysql_query("SELECT COUNT(*) AS count FROM utilisateur ");
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$count = $row['count'];

// calculation of total pages for the query
if( $count >0 ) {
$total_pages = ceil($count/$limit);
} else {
$total_pages = 0;
}

// if for some reasons the requested page is greater than the total
// set the requested page to total page
if ($page > $total_pages) $page=$total_pages;

// calculate the starting position of the rows
$start = $limit*$page - $limit; // do not put $limit*($page - 1)
// if for some reasons start position is negative set it to 0
// typical case is that the user type 0 for the requested page
if($start <0) $start = 0;

// the actual query for the grid data
$SQL = "SELECT * FROM utilisateur ORDER BY $sidx $sord LIMIT $start , $limit";
$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error());

// constructing a JSON

$responce= new stdClass ();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i=0;
$tab=array();
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {

$element=array('id'=>$row['cin'],
'cell' =>array($row['nom'],$row['prenom'],$row['date'],$row['cin'],$row['role']));

// $responce->rows[$i]['id']=$row[0];
// $responce->rows[$i]['cell']=array($row[nom],$row[prenom],$row[date],$row[cin],$row[type],$row[num1],$row[num2],$row[adresse],$row[matricule]);
$i++;
$tab[]=$element;
}
$responce->rows=$tab;
// return the formated data
//echo $json->encode($responce);
echo json_encode($responce);
?>

finalEdit.php

<?php
mysql_connect("localhost","root","");
mysql_select_db("gestion_conges");
if (($_POST['oper']) == "edit") {
$updateSQL = sprintf("UPDATE utilisateur SET nom=%s, prenom=%s, date=%s, role=%s WHERE cin=%s",
GetSQLValueString($_POST['nom'], "text"),
GetSQLValueString($_POST['prenom'], "text"),
GetSQLValueString($_POST['date'], "date"),
GetSQLValueString($_POST['role'], "text"),
GetSQLValueString($_POST['cin'], "text"));

$Result1 = mysql_query($updateSQL) or die(mysql_error());
}
else if (($_POST['oper']) == "del") {

$deleteSQL = sprintf("DELETE FROM utilisateur WHERE id=%s",
GetSQLValueString($_POST['cin'], "text"));
mysql_select_db($database_intranet);
$Result1 = mysql_query($deleteSQL) or die(mysql_error());
}
?>

29/08/2014
11:00

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

You define the pager as jQuery object.

Not sure, but try to define it only as string i.e

pager: '#pager2',

Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.