PHP Codeigniter 框架支持 SQL Server

栏目: PHP · SQL Server · 码农笔记 · 发布时间: 8年前

内容简介:PHP Codeigniter 框架支持 SQL Server

数据库配置


// mysql 配置
$db['default'] = array(
	'db_type'=>'mysql',
    'hostname' => 'localhost',
    'username' => 'www.codercto.com',
    'password' => 'www.codercto.com',
    'database' => 'www.codercto.com',
    'dbdriver' => 'pdo',
    'port' => '3306',
    'dbprefix' => '',
    'pconnect' => TRUE,
    'db_debug' => TRUE,
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array()
);

// sql server 配置
$db['default'] = array(
	'db_type'=>'sqlsrv',
    'hostname' => 'localhost',
    'username' => 'www.codercto.com',
    'password' => 'www.codercto.com',
    'database' => 'www.codercto.com',
    'dbdriver' => 'pdo',
    'port' => '3341',
    'dbprefix' => '',
    'pconnect' => TRUE,
    'db_debug' => TRUE,
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array()
);

设置 dsn 信息

foreach($db as &$value)
{
	if($value['sqlsrv'] == 'sqlsrv')
	{
		$value['dsn'] = "sqlsrv:Server={$value['hostname']},{$value['port']};Database={$value['database']}";
	}
	else
	{
		$value['dsn'] = "mysql:host={$value['hostname']};port={$value['port']};dbname={$value['database']}";
	}
}

这样就可以和使用 mysql 一样使用 SQL Server


以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持 码农网

查看所有标签

本站部分资源来源于网络,本站转载出于传递更多信息之目的,版权归原作者或者来源机构所有,如转载稿涉及版权问题,请联系我们

Practical Algorithms for Programmers

Practical Algorithms for Programmers

Andrew Binstock、John Rex / Addison-Wesley Professional / 1995-06-29 / USD 39.99

Most algorithm books today are either academic textbooks or rehashes of the same tired set of algorithms. Practical Algorithms for Programmers is the first book to give complete code implementations o......一起来看看 《Practical Algorithms for Programmers》 这本书的介绍吧!

CSS 压缩/解压工具
CSS 压缩/解压工具

在线压缩/解压 CSS 代码

正则表达式在线测试
正则表达式在线测试

正则表达式在线测试

RGB HSV 转换
RGB HSV 转换

RGB HSV 互转工具