如何在控制器中动态定义数据库连接
如何在控制器中动态定义数据库连接呢?请大家赐教
[ 本帖最后由 analyzer 于 2008-9-16 21:52 编辑 ] 什么叫做动态定义? 意思就是说在控制器中定义数据库的连接字符串等属性
比如:数据库名称,用户名及密码等
[ 本帖最后由 analyzer 于 2008-9-17 19:30 编辑 ] 你可以动态修改数据库配置,他只是一个数组而已。 如下
$config ['hostname'] = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.x)(PORT=1522))(CONNECT_DATA=(SID=etrack)))';
$config ['username'] = $_POST ['em_user'];
$config ['password'] = $_POST ['em_pass'];
$config ['database'] = "xxx";
$config ['dbdriver'] = "oci8";
$config ['dbprefix'] = "";
$config ['pconnect'] = FALSE;
$config ['db_debug'] = TRUE;
$config ['cache_on'] = FALSE;
$config ['cachedir'] = "";
$config ['char_set'] = "utf8";
$config ['dbcollat'] = "utf8_general_ci";
if ($this->load->database ( $config )) {
页:
[1]