PHP在采用CI框架后无效手动初始化数据库连接,只要配合好基本信息后即可调用框架内方法对数据库执行操作;
第一步:修改数据库配置文件,来配置基本信息;路径如下:
Project -> application -> config -> database.php
$db['default']['hostname'] = 'localhost'; // host
$db['default']['username'] = 'root'; //username
$db['default']['password'] = '12*****'; // password
$db['default']['database'] = 'dbname'; // databdase name
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;
第二步:配置加载文件,来开启数据库加载;路径如下:
Project -> application -> config -> autoload.php
/*
| -------------------------------------------------------------------
| Auto-load Libraries
| -------------------------------------------------------------------
| These are the classes located in the system/libraries folder
| or in your application/libraries folder.
|
| Prototype:
|
| $autoload['libraries'] = array('database', 'session', 'xmlrpc');
*/
$autoload['libraries'] = array('database');
这是2.X的配置方法,配置libraries;
1.X貌似是:
$autoload['core'] = array('database');
第三步:现在就可以来操作数据库了;
1)查询(Query);
$result = $this->db->get ( 'users' );
以上是读取users表数据,并指向到$result
<?php foreach ($query->result() as $row):?>
<p><?php echo $row-> name?></p>
<p><?php echo $row-> age?></p>
<hr>
<?php endforeach;?>
在网页中输出;
查询的时候可以加入条件语句来选择查询:
$this->db->where ( 'id', $user_id );
$result = $this->db->get ( 'users' );
读取users表中id等于$user_id的数据;
2)插入(insert);
$this->db->insert ( 'users', $_POST );