Databases FAQs
Databases FAQs
Q) For SQL Server demos, I get "mssqlnative extension not installed". Where do I get that extension so I can view that Demo?
Here is link from MS SQL Server website. http://www.microsoft.com/en-us/download/details.aspx?id=20098
You need to enable the extension in php after installation.
Q) How to use mysqli or PDO extension?
Here is the config settings.
$db_conf = array();
$db_conf["type"] = "mysqli";
$db_conf["server"] = "localhost"; // or you mysql ip
$db_conf["user"] = "root"; // username
$db_conf["password"] = "test"; // password
$db_conf["database"] = "griddemo"; // database
// include and create object
$base_path = strstr(realpath("."),"demos",true)."lib/";
include($base_path."inc/jqgrid_dist.php");
$g = new jqgrid($db_conf);
After that, all calls will use mysqli extension.
For PDO extension,
$db_conf = array();
$db_conf["type"] = "pdo";
$db_conf["server"] = "mysql:host=localhost";
$db_conf["user"] = PHPGRID_DBUSER; // username
$db_conf["password"] = PHPGRID_DBPASS; // password
$db_conf["database"] = PHPGRID_DBNAME; // database
include($base_path."inc/jqgrid_dist.php");
$g = new jqgrid($db_conf);