« Grid4php::03-docs creating-first-grid » : différence entre les versions

De wiki_pcwiki2
Aller à la navigationAller à la recherche
Page créée avec « KEYWORDS: GRID4PHP, DOCUMENTATION '''Le 14/02/2024: documentation pour grid4php »
 
Aucun résumé des modifications
 
Ligne 2 : Ligne 2 :


  '''Le 14/02/2024: documentation pour grid4php
  '''Le 14/02/2024: documentation pour grid4php
Creating First Grid
Step1: Add PHP Grid configuration code
<?php
include_once("../../config.php");
// include and create object
include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");
$db_conf = array(
                    "type"      => PHPGRID_DBTYPE,
                    "server"    => PHPGRID_DBHOST,
                    "user"      => PHPGRID_DBUSER,
                    "password"  => PHPGRID_DBPASS,
                    "database"  => PHPGRID_DBNAME
                );
$g = new jqgrid($db_conf);
// set few params
$opt["caption"] = "Sample Grid";
$g->set_options($opt);
// set database table for CRUD operations
$g->table = "clients";
 
// render grid and get html/js output
$out = $g->render("list1");
?>
Step2: Include JS and CSS files in your html page
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
<head>
    <!-- these css and js files are required by php grid -->
    <link rel="stylesheet" href="../../lib/js/themes/redmond/jquery-ui.custom.css"></link>
    <link rel="stylesheet" href="../../lib/js/jqgrid/css/ui.jqgrid.css"></link>
    <script src="../../lib/js/jquery.min.js" type="text/javascript"></script>
    <script src="../../lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
    <script src="../../lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
    <script src="../../lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
    <!-- these css and js files are required by php grid -->
</head>
Step3: Print the $out variable where you wish to display grid.
<body>
    <div style="margin:10px">
    <!-- display grid here -->
    <?php echo $out?>
    <!-- display grid here -->
    </div>
</body>
</html>
Resources
    Sample Code
    See Live Demo
    You can check this demo in archive demos/editing/index.php
Explanation
    The PHP Part configured the grid and rendered the output to $out variable.
    In HTML Part, we displayed the generated grid code $out along with few external css/js files. It's upto you to place external css and js files at appropriate locations.
    ->set_options() function is most of the customization, we'll be covering later.
    ->table is required, to enable automatic select,add,update,delete operations on that table. By default all columns of the table are selected on grid. We'll review how to select particular columns.
    ->render() will generate the final output, to be displayed in view. It takes Grid ID as input, which should be unique on a page.

Dernière version du 14 février 2024 à 11:28

KEYWORDS: GRID4PHP, DOCUMENTATION

Le 14/02/2024: documentation pour grid4php
Creating First Grid

Step1: Add PHP Grid configuration code

<?php
include_once("../../config.php");

// include and create object
include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");

$db_conf = array(
                   "type"      => PHPGRID_DBTYPE,
                   "server"    => PHPGRID_DBHOST,
                   "user"      => PHPGRID_DBUSER,
                   "password"  => PHPGRID_DBPASS,
                   "database"  => PHPGRID_DBNAME
               );
$g = new jqgrid($db_conf);

// set few params
$opt["caption"] = "Sample Grid";
$g->set_options($opt);

// set database table for CRUD operations
$g->table = "clients";
 
// render grid and get html/js output
$out = $g->render("list1");
?>

Step2: Include JS and CSS files in your html page

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

 

    
    
    
    
    
    
    
    
 
 
 
 Step3: Print the $out variable where you wish to display grid.
 
 
    
Resources
   Sample Code
   See Live Demo
   You can check this demo in archive demos/editing/index.php
Explanation

   The PHP Part configured the grid and rendered the output to $out variable.
   In HTML Part, we displayed the generated grid code $out along with few external css/js files. It's upto you to place external css and js files at appropriate locations.
   ->set_options() function is most of the customization, we'll be covering later.
   ->table is required, to enable automatic select,add,update,delete operations on that table. By default all columns of the table are selected on grid. We'll review how to select particular columns.
   ->render() will generate the final output, to be displayed in view. It takes Grid ID as input, which should be unique on a page.