tags:

views:

60

answers:

0

How to work this code without pdo connection.? want to use normal db connection. if i use normal db connection, jqGridRender class not found. plz give me the soln..

enter code here <? php
                 require_once 'jq-config.php';
                // include the jqGrid Class
                require_once "php/jqGrid.php";
                // include the PDO driver class
                require_once "php/jqGridPdo.php";
                // Connection to the server
                $conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
                // Tell the db that we use utf-8
                $conn->query("SET NAMES utf8");

                // Create the jqGrid instance
                $grid = new jqGridRender($conn);
                // Write the SQL Query
                $grid->SelectCommand = 'SELECT seq, name, id, pass, mail FROM TM_Staff';
                // set the ouput format to json
                $grid->dataType = 'json';
                // Let the grid create the model
                $grid->setColModel();
                // Set the url from where we obtain the data
                $grid->setUrl('myfirstgrid.php');
                // Set grid caption using the option caption
                $grid->setGridOptions(array(
                      "caption"=>"This is custom Caption",
                      "rowNum"=>10,
                      "sortname"=>"seq",
                      "hoverrows"=>true,
               "rowList"=>array(10,20,50),
                ));
               // Change some property of the field(s)
               $grid->setColProperty("seq", array("label"=>"ID", "width"=>60));
               // Enjoy
               $grid->renderGrid('#grid','#pager',true, null, null, true,true);
               $conn = null;

?>