Codeigniter 3 - 如何使用Forge Class创建数据库模式？(Codeigniter 3 - How to use Forge Class to create a database schema?)

 我使用CodeIgniter 3.1.0来开发一个应用程序。 为了改进安装，我写了一个Install_Controller和一个Install_Model。 
 
 我想使用Database Forge类来管理数据库模式，但在用户指南中不是很清楚，Google上也没有提供帮助。 
 
 我需要使用$ this-> dbforge-> create_database ，因为用户对数据库一无所知，所以他会做的只是MySQL“接下来，安装”，然后运行一个运行PHP作为Web服务器的批处理文件，所以从Chrome他可以使用URL来安装应用程序。 
 
 用户指南说： 为了初始化Forge类，您的数据库驱动程序必须已经运行，因为伪造类依赖它。 
 
 所以我已经用user，pwd，dbname等设置了config / database.php ...甚至因为我需要它在app中使用。 
 
 当我尝试加载URL来安装应用程序时，给我错误： 消息：mysqli :: real_connect（）：（HY000 / 1049）：未知数据库'测试' 
 
 那么，如果我需要首先创建数据库模式，我该如何使用Forge Class来创建数据库模式呢？ 
 
 一些代码... 
 
$db['default'] = array(
    'dsn' => '',
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => 'root',
    'database' => 'test',
    'dbdriver' => 'mysqli'
);

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

class Install extends CI_Controller
{
    public function __construct()
    {
        parent::__construct();
    }

    public function index()
    {
        $this->load->model('install_model');
        $this->install_model->createDabase();
    }
}

class Install_model extends CI_Model {
    function __construct() {
        parent::__construct();
    }

    function createDabase() {
        $this->load->dbforge();

        if ($this->dbforge->create_database('test'))
            echo 'Database created!';
        else
            echo 'Database error!';
    }
}

I'm using CodeIgniter 3.1.0 to develop an app. In order to improve installation, I've written an Install_Controller, and an Install_Model.
 
I want to use Database Forge class to manage the database schema, but it's not very clear in user guide and nothing on Google helps.
 
I need to use $this->dbforge->create_database, because the user knows nothing about database, so all he will do is MySQL "Next, next, install" and then run a batch file that run PHP as web server, so from Chrome he can use URL to install the app.
 
User guide says: In order to initialize the Forge class, your database driver must already be running, since the forge class relies on it.
 
So I have setup the config/database.php with user, pwd, dbname and so on... Even because I need it to use in app.
 
When I try to load the URL to install the app, give me the error: Message: mysqli::real_connect(): (HY000/1049): Unknown database 'test'
 
So, how can I use Forge Class to create database schema, if I need to have it first?
 
Some code...
 
$db['default'] = array(
    'dsn' => '',
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => 'root',
    'database' => 'test',
    'dbdriver' => 'mysqli'
);

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

class Install extends CI_Controller
{
    public function __construct()
    {
        parent::__construct();
    }

    public function index()
    {
        $this->load->model('install_model');
        $this->install_model->createDabase();
    }
}

class Install_model extends CI_Model {
    function __construct() {
        parent::__construct();
    }

    function createDabase() {
        $this->load->dbforge();

        if ($this->dbforge->create_database('test'))
            echo 'Database created!';
        else
            echo 'Database error!';
    }
}

原文：https://stackoverflow.com/questions/41697121