agustin asked 10 years ago
Hello good, I bought your http://www.shuttlelux.es code for the site and have the following error, please would need to fix it ..
Error
( ! ) Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:wampwwwxxxxcompradodemoseditingindex.php on line 14
My config.php
<?php
// PHP Grid database connection settings
define("PHPGRID_DBTYPE","Mysqli"); // or mysqli
define("PHPGRID_DBHOST","localhost");
define("PHPGRID_DBUSER","pepe");
define("PHPGRID_DBPASS","");
define("PHPGRID_DBNAME","griddemo");
// Automatically make db connection inside lib
define("PHPGRID_AUTOCONNECT",0);
// Basepath for lib
define("PHPGRID_LIBPATH",dirname(__FILE__).DIRECTORY_SEPARATOR."lib".DIRECTORY_SEPARATOR);
?>
Abu Ghufran answered 10 years ago
also set
define("PHPGRID_AUTOCONNECT",1);
If you need custom connection without config file, 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);
