mysqli and get_dropdown_values

Questionsmysqli and get_dropdown_values
Richard asked 6 years ago

I get an error when using get_dropdown_values together with mysqli.

$db_conf["type"] = "mysqli";
$db_conf["server"] = "localhost"; // or you mysql ip
$db_conf["user"] = "user"; // username
$db_conf["password"] = "password"; // password
$db_conf["database"] = "dbname"; // database

$str = $g->get_dropdown_values("select team_id as k, team_name as v from t_teams");

Error:
"Couldn't execute query. Access denied for user 'apache'@'localhost' (using password: NO) – select team_id as k, team_name as v from t_teams"

Any ideas?

2 Answers
Abu Ghufran answered 6 years ago

Hello,

This comes when you provide incorrect credentials (user/pass) of mysql database.

Plus one more update, If you are dealing with utf8 characters, you need to replace a line in jqgrid_dist.php.
Updated for next version.

This:
if ($db_conf["type"] == "mysql")
$this->con->Execute("SET NAMES 'utf8'");

With:
if ($db_conf["type"] == "mysql" || $db_conf["type"] == "mysqli")
$this->con->Execute("SET NAMES 'utf8'");

Richard answered 6 years ago

Thanks for the tip re jqgrid_dist.php.

It may help someone else to know that my problem was caused by incorrectly using

$g = new jqgrid();
instead of
$g = new jqgrid($db_conf);

Your Answer

2 + 10 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!