2 Answers
You can create 2 datagrid object with different connections. The main connection code is used above each grid code sample.
e.g.
$db_conf = array(
“type” => PHPGRID_DBTYPE,
“server” => PHPGRID_DBHOST,
“user” => PHPGRID_DBUSER,
“password” => PHPGRID_DBPASS,
“database” => PHPGRID_DBNAME
);
$grid1 = new jqgrid($db_conf);
Replace all constants with the values you set in config.php, Just like $grid1, replicate same code with $grid2 with different values.
You can later call database queries using:
$grid1->get_one(“<sql>”);
$grid1->get_all(“<sql>”);
OR
$grid2->execute_query(“<SQL>”);
Your Answer