francisco jose noya asked 7 years ago
Hello Abu,
I have a grid that works well with msql connection.
Now I have to insert it into a project that uses a mysqli connection file.
It is mandatory that I use the existing connection file in this grid script.
When I include it, this error appears on the screen:
This page does not work
The page pedralbesbooking.es can not process this request now.
HTTP ERROR 500
This is the connection file
This is the grid script
Thanks for your help.
Francisco
Abu Ghufran Staff answered 7 years ago
To switch from mysql to mysqli, you only need to change
$db_conf[“type”] = “mysql”;
to
$db_conf[“type”] = “mysqli”;
This configuration could be in config.php OR your grid code.
e.g.
$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
$g = new jqgrid($db_conf);
