dtn36013 2017-03-08 12:48
浏览 88

Codeigniter无法连接到DB

Alright so for some reason no matter what I do CI is refusing to connect to database. I've tried using another DB and so on and nothing happens

This is what I've ended up using as alternative way to connect to DB since default wont work either.

class ContentLoader extends CI_Model {
    public function __construct() {
        $this->load->database(); 
    }

    public function foo() {
        $res = $this->load->database();

        if($res == false) {
            echo "conn_failed";
        }
    }
}

And this is my config

$active_group = 'default';
$query_builder = TRUE;

$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => '',
    'database' => 'first_igniter',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);
  • 写回答

1条回答 默认 最新

  • dps43633 2017-03-08 12:52
    关注

    Double check

    1. username
    2. password
    3. database Name

    and in config/autoload.php load database as well

    $autoload['libraries'] = array('database');
    

    and try simple select methods instead of your code. Use $this->db->select(); it will show the rest of error

    评论

报告相同问题?

悬赏问题

  • ¥15 C++ yoloV5改写遇到的问题
  • ¥20 win11修改中文用户名路径
  • ¥15 win2012磁盘空间不足,c盘正常,d盘无法写入
  • ¥15 用土力学知识进行土坡稳定性分析与挡土墙设计
  • ¥70 PlayWright在Java上连接CDP关联本地Chrome启动失败,貌似是Windows端口转发问题
  • ¥15 帮我写一个c++工程
  • ¥30 Eclipse官网打不开,官网首页进不去,显示无法访问此页面,求解决方法
  • ¥15 关于smbclient 库的使用
  • ¥15 微信小程序协议怎么写
  • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?