Georges asked 11 years ago
First congratulation for this wondefull grid.
Is there any possibility for using native php sqlite3 databse instead of mysql ?
thanks
Abu Ghufran answered 11 years ago
Hello,
This tool uses adodb as database layer, and it supports sqlite db.
http://phplens.com/lens/adodb/docs-adodb.htm
Although, i don't have any working samples now, but it should work.
Georges answered 11 years ago
Thanks to answer ,
is adodb available in free version ?
i want to buy premium but it's only to be used with sqlite3 db so i would like to be sure it work.
this is what i'v tried
include('../include/adodb/adodb.inc.php');
include("../grid/inc/jqgrid_dist.php");
// set up DB
$conn = &ADONewConnection('sqlite3');
$conn->Connect('..tempArticles.db3');
$col = array();
$g = new jqgrid();
$g->select_command = "SELECT * FROM Articles WHERE ActualStock != 0";
$g->table = "Articles";
g->set_columns($cols);
$g->set_options($grid);
$out = $g->render("list1");
…..
and it return
Couldn't execute query. No database selected
Can you please tell me more
Thanks
Abu Ghufran answered 11 years ago
I've emailed you package for evaluation.
Kindly override files and recheck.
e.g. usage for pqsql. You can check docs of adodb for sqlite.
$db_conf = array();
$db_conf["type"] = "postgres"; // mysql,oci8(for oracle),mssql,postgres,sybase
$db_conf["server"] = "localhost";
$db_conf["user"] = "postgres";
$db_conf["password"] = "a";
$db_conf["database"] = "testdb";
include($base_path."inc/jqgrid_dist.php");
$g = new jqgrid($db_conf);
David answered 10 years ago
Hi Abu ,
did you find a solution that works for Sqlite3 ?
Cause adodb does not work !
$db_conf = array();
$db_conf["type"] = "sqlite3";
$db_conf["server"] = "localhost";
$db_conf["user"] = "";
$db_conf["password"] = "";
$db_conf["database"] = "Cards.db3";
include('../include/adodb/adodb.inc.php');
include("../grid/lib/inc/jqgrid_dist.php");
$conn = &ADONewConnection('sqlite3');
$conn->Connect('..tempCards.db3');
Blank Page with nothing in firebug console log.
only <body></body>
Any help ?
Thanks
Abu Ghufran answered 10 years ago
Sqlite support is not ready, and in backlog. Due to other important features, we've delayed it's release.
