Hi Tony,

I’ve implemented simple uppercase on post like this :

I’m using arraymap on data add and edit… but if you have any better solution, would be grateful .

Hi tony,

I don’t think to change on 200 firebird tables that has a bunch of records, would be wise.

Are there any other ways to change $_REQUEST filter before execute sql ? Just like I did when using jqgrid javascript ….

Already bought your subscription software…
please make it available for firebird PDO…

best regards,
Ari

Hello Tony,

I can assure you that our adodb working fine…
but not your grid..

<?php
ini_set(“display_errors”,”on”);
error_reporting(E_ALL);
require_once ‘../../jq-config.php’;
// include the jqGrid Class
require_once ABSPATH.”php/PHPSuito/jqGrid.php”;
require_once ABSPATH.”php/PHPSuito/DBdrivers/jqGridAdodb.php”;
// include the driver class
define(‘ADODB_ASSOC_CASE’, 2);
require_once ABSPATH.”php/PHPSuito/External/adodb5/adodb.inc.php”;

// Connection to the server
$conn = &ADONewConnection(‘firebird’);
$conn->PConnect(DB_DATABASE,DB_USER,DB_PASSWORD);

$sql = “select first 10 customerid, customer from customer”;

$rs = $conn->Execute($sql) or die(“err : “. $sql);

while ($array = $rs->FetchRow()) {
print_r($array); //this print working fine
echo “<br>”;
}

$conn->Execute(“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
$grid->showError = true;
$grid->debug = true;
$table = ‘CUSTOMER’;
//echo $table;
$grid->SelectCommand =’SELECT * FROM ‘.$table;

// set the ouput format to XML
$grid->dataType = ‘json’;
// Let the grid create the model
$grid->setPrimaryKeyId(“CUSTOMERID”);
$grid->setColModel();
$grid->table = $table;
// set labels in the header
$grid->setColProperty(“CUSTOMERID”, array(“label”=>”ID”));
$grid->setColProperty(“CUSTOMER”, array(“label”=>”Customer”));

$grid->setUrl(‘grid.php’);
// Set some grid options
$grid->setGridOptions(array(“rowNum”=>10,”rowList”=>array(10,20,30),”sortname”=>”CUSTOMER”));
// Enable toolbar searching
$grid->toolbarfilter = true;
$grid->navigator = true;
$grid->setNavOptions(‘navigator’,array(“csv”=>true, “pdf”=>true));
$grid->setFilterOptions(array(“stringResult”=>true));
// Enjoy
$grid->renderGrid(‘#grid’,’#pager’,true, null, null, true,true);
//echo “finish”;

Hi Tony…

I’ve been searching on how to run using adodb… but no luck…
I can assure that our database working properly.

here’s my code :

jq-config.php

<?php
// ** MySQL settings ** //
//define(‘DB_NAME’, ‘northwind’); // The name of the database
//define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
define(‘DB_DSN’,’firebird:host=localhost;dbname=northwind’);
define(‘DB_USER’, ‘SYSDBA’); // Your MySQL username
define(‘DB_PASSWORD’, ‘masterkey’); // …and password
define(‘DB_DATABASE’, ‘localhost://var/lib/firebird/2.5/data/northwind.fdb’); // …and password

define(‘ABSPATH’, ‘../../../../’);
// Form settings
$SERVER_HOST = “”; // the host name
$SELF_PATH = “”; // the web path to the project without http
$CODE_PATH = “../../../../php/PHPSuito/”; // the physical path to the php files

grid.php

<?php
require_once ‘../../jq-config.php’;
// include the jqGrid Class
require_once ABSPATH.”php/PHPSuito/jqGrid.php”;
require_once ABSPATH.”php/PHPSuito/DBdrivers/jqGridAdodb.php”;
// include the driver class
define(‘ADODB_ASSOC_CASE’, 2);
require_once ABSPATH.”php/PHPSuito/External/adodb5/adodb.inc.php”;

// Connection to the server
$conn = ADONewConnection(‘firebird’);

if (!$conn->Connect(‘localhost’,DB_USER,DB_PASSWORD,DB_DATABASE)) { echo ‘error : ‘.$conn->ErrorMsg(); }
//if (!$conn->Connect(‘localhost’,DB_USER,DB_PASSWORD,DB_DATABASE)) err($conn->ErrorNo(). $sep . $conn->ErrorMsg());

//$conn->Execute(“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 = ‘PRODUCTS’;
echo $table;
$grid->SelectCommand =’SELECT * FROM ‘.$table;

// set the ouput format to XML
$grid->dataType = ‘json’;
// Let the grid create the model
$grid->setPrimaryKeyId(“PRODUCTID”);
$grid->setColModel();
$grid->table = $table;
// set labels in the header
$grid->setColProperty(“PRODUCTID”, array(“label”=>”ID”));
$grid->setColProperty(“PRODUCTNAME”, array(“label”=>”Name”));
$grid->setColProperty(“QUANTITYPERUNIT”, array(“label”=>”Unit”));
$grid->setColProperty(“UNITPRICE”, array(“label”=>”Unit Price”));
// We can hide some columns
$grid->setColProperty(“SUPPLIERID”, array(“hidden”=>true));
$grid->setColProperty(“CATEGORYID”, array(“hidden”=>true));
$grid->setColProperty(“UNITSONORDER”, array(“hidden”=>true));
$grid->setColProperty(“REORDERLEVEL”, array(“hidden”=>true));
$grid->setColProperty(“DISCONTINUED”, array(“hidden”=>true));
// Set the url from where we obtain the data
echo “before grid”;
$grid->setUrl(‘grid.php’);
// Set some grid options
$grid->setGridOptions(array(“rowNum”=>10,”rowList”=>array(10,20,30),”sortname”=>”CATEGORYID”));
// Enable toolbar searching
$grid->toolbarfilter = true;
$grid->navigator = true;
$grid->setNavOptions(‘navigator’,array(“csv”=>true, “pdf”=>true));
$grid->setFilterOptions(array(“stringResult”=>true));
// Enjoy
$grid->renderGrid(‘#grid’,’#pager’,true, null, null, true,true);
echo “finish”;

and it’s getting stuck on setColModel().

Please I really need it . Would you like to give me working example jqgrid using adodb on firebird.. please…
I’ll buy your product then…

Regards,
Ari Adrianto

By the way… please support firebird PDO soon…
I really need it…

Regards,
Ari

I’m using firebird PDO …
or can I use adodb to firebird ?

Best Regards,
Ari Adrianto