jQuery Grid Plugin - jqGridForum

Topic RSS

jqgrid

21/08/2014
15:02

hindos

Member

Members

Forum Posts: 5

Member Since:
21/08/2014

Offline

hii !!! i using jqgrid Â (jqsuitePHP 4.6 ) but nothing appears Â what's the problem !! pleaaase helpÂ

grid.php

<?php
require_once 'jq-config.php';
// include the jqGrid Class
require_once ABSPATH."php/jqGrid.php";
// include the driver class
require_once ABSPATH."php/jqGridPdo.php";
// Connection to the server
$dns = 'mysql:host=localhost;dbname=gestion_conges';
$utilisateur = 'root';
$motDePasse = '';
$conn= new PDO( $dns, $utilisateur, $motDePasse );
// MySQL specific command for the charset
// Tell the db that we use utf-8
$conn->query("SET NAMES utf8");
// Create the jqGrid instance
$grid = new jqGridRender($conn);
// Data from this SQL is 1252 encoded, so we need to tell the grid
// Set the SQL Data source
$table = 'personnel';
$grid->SelectCommand ='SELECT * FROM '.$table;
// set the ouput format to XML
$grid->dataType = 'json';
// Let the grid create the model
$grid->setColModel();
// set labels in the header
$grid->setColProperty("nom", array("label"=>"Nom"));
$grid->setColProperty("prenom", array("label"=>"Prenom"));
$grid->setColProperty("date", array("label"=>"Date de naissance"));
$grid->setColProperty("cin", array("label"=>"CIN"));
$grid->setColProperty("type", array("label"=>"Type"));
$grid->setColProperty("num1", array("label"=>"TÃ©lÃ©phone(1)"));
$grid->setColProperty("num2", array("label"=>"TÃ©lÃ©phone(2)"));
$grid->setColProperty("adresse", array("label"=>"Adresse"));
$grid->setColProperty("matricule", array("label"=>"Matricule"));

$grid->setUrl('grid.php');
// Set some grid options
//$grid->setGridOptions(array("rowNum"=>10,"rowList"=>array(10,20,30),"sortname"=>"CategoryID"));
// Enable toolbar searching
/*$sql = 'SELECT * FROM personnel';
$req = $conn->query($sql);
while($row = $req->fetch()) {
echo $row['nom']."<br/>";
}
$req->closeCursor(); */
$grid->toolbarfilter = true;
$grid->setFilterOptions(array("stringResult"=>true));
// Enjoy
$grid->renderGrid('#grid','#pager',true, null, null, true,true);
$conn = null;
?>

grid.html

<?php
require_once 'tabs.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>jqGrid PHP Demo</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" media="screen" href="themes/redmond/jquery-ui-1.8.2.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="themes/ui.jqgrid.css" />
<link rel="stylesheet" type="text/css" media="screen" href="themes/ui.multiselect.css" />
<style type="text">
html, body {
margin: 0; /* Remove body margin/padding */
padding: 0;
overflow: hidden; /* Remove scroll bars on browser window */
font-size: 75%;
}
</style>
<script src="js/jquery.js" type="text/javascript"></script>
<script src="js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script type="text/javascript">
$.jgrid.no_legacy_api = true;
$.jgrid.useJSON = true;
</script>
<script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="js/jquery-ui-1.8.2.custom.min.js" type="text/javascript"></script>
</head>
<body>
<div>
<?php include ("grid.php");?>
</div>
<br/>
<?php tabs(array("grid.php"));?>
</body>
</html>

jqGrid PHP Demo

21/08/2014
17:02

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Please post your question here

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.

22/08/2014
16:09

hindos

Member

Members

Forum Posts: 5

Member Since:
21/08/2014

Offline

tony said
Hello,

Â

Please post your question here

Â

Regards

there is a Â problem Â of registration!!!!!!!!!!

25/08/2014
18:05

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Try to clear your browser cache and try to register.

Also in this case we recommend you to use Chrome browser.

Please report this problem to support at trirand dot net.

If you can not register, please send the problem to the above e-mail.

Kind Regards

Tony

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.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
37 Guest(s)

Currently Browsing this Page:
1 Guest(s)