douqi3195 2019-07-10 10:01
浏览 56
已采纳

如何使用config.php文件中的变量连接MySQLi?

I'm trying to make a MySQL & PHP based control panel for my community. And I've made a settings.php file with arrays with configs. I have class files for functions but there is MySQL function, which will not connect with data I've entered on settings.php..

I've tried other config file options, but none of them works...

on settings.php I have MySQL data like this:

$config['database']['host'] = "---"; 
$config['database']['user'] = "---";
$config['database']['password'] = "---";
$config['database']['database'] = "---";

And on userdata.php class file, where I'm trying to use those config variables I have:

$mysql = new mysqli($config['database']['host'], $config['database']['user'], $config['database']['password'], $config['database']['database']);

obviously, on userdata.php I have also required the settings.php..

I was expecting the output to be correct, but it shows only 'wrong MySQL data' errors...

  • 写回答

2条回答 默认 最新

  • dongyun51582 2019-07-11 19:45
    关注

    I got it working with settings.php file like:

    $config = array (
    'db_host' => 'xxx',
    'db_user' => 'xxx',
    'db_pass' => 'xxx',
    'db_database' => 'xxx'
    

    and userdata.php like:

    include 'settings.php';
    
    $host = $config['db_host'];
    $user = $config['db_user'];
    $pass = $config['db_pass'];
    $database = $config['db_database'];
    
    $mysql = new mysqli($host, $user, $pass, $database);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 ecplise在连接数据库时显示加载驱动成功但是数据库连接失败
  • ¥15 visionmaster启动失败,提示为“机器不满足授权而被禁用”
  • ¥50 用logisim设计16位单时钟周期cpu
  • ¥15 IDEA中圈复杂度如何具体设置
  • ¥50 labview采集不了数据
  • ¥15 Multisim红外倒车雷达仿真中距离问题
  • ¥15 请上面代码做什么处理或什么混淆
  • ¥15 英雄联盟自定义房间置顶
  • ¥15 W5500网线插上无反应
  • ¥15 如何用字典的Key,显示在WPF的xaml中