thinkphp? ? ??????? ??? ??? ? ????. 1. ?????? ?? ?? ?? ?? ?? ??? "'DB_HOST' => 'localhost'..."? ?? ?? ????? ?????. ???? ?????? ?? ??? ?? ?? ??? ?????. 3. ????? ? "$User = M('User','other_','mysql://root..."? ?? ??? ???? ?????? ?? ??? ?????.

? ????? ?? ??: Windows 7 ???, ThinkPHP ?? 5, Dell G3 ???

thinkphp? ? ??????? ????? ??? ? ?????

?.

Thinkphp ?? - ?????? ??

Connect to Database

ThinkPHP?? ??? ?????? ??? ????? ?? ?????? ??? ??? ???? ?? ?? ??? ?? ??? ???? ??? ????? ?? Db ???? ???? ???. ?? ??????? ?? Db ???? ??? ?? ?? ?????? ????? ???? ?????. ?? ???????? Mysql, SqlServer, PgSQL, Sqlite, Oracle, Ibase ? Mongo? ????

???????? ???? ?? ??? ????. ?????? ?? ??? ???? ???.

1. ?? ?? ??

???? ?? ??? ?????? ?? ?? ?? ?? ?? ??? ?? ?? ????? ???? ????.

//數(shù)據(jù)庫配置信息'DB_TYPE' => 'mysql', // 數(shù)據(jù)庫類型
'DB_HOST' => 'localhost', // 服務(wù)器地址
'DB_NAME' => 'thinkphp', // 數(shù)據(jù)庫名
'DB_USER' => 'root', // 用戶名
'DB_PWD' => '123456', // 密碼
'DB_PORT' => 3306, // 端口
'DB_PREFIX' => 'think_', // 數(shù)據(jù)庫表前綴
'DB_CHARSET'=> 'utf8', // 字符集

?????? ??? DB_TYPE ????? ?? ?????. ?? ???? ?????? ??? ??? ????.

DB_TYPE? PDO ??? ???? ?? ?????? ??? DB_DSN ??? ?? ?????.

?? ?? ??

'DB_DSN' => 'mysql://root:123456@localhost:3306/thinkphp#utf8'

DB_DSN ?? ??? ???? ?? ????? ???? ? ????. DSN ???? ??? ??? ????. ?? 3.2.1 ??? ?????. ?? ??? ???? ?? ?? ???? utf8???. ? ?? ????? ??? ???? ?? DB_DSN ?? ????? ?????.

??: ????? ??

PDO ????? ???? ?? ?? **DB_TYPE**.pdo? ??? ? ??? ?? ?? ????? ??? ???? ???.

??: PDO ??? DB_DSN ?? ??? ???, ?????? ??? ?? ??? ????. ??? ??? PHP ???? ?????.

?? ??? ??? ??????? ????? ?????. ????? ??????? ?????? ??? ??? ???? ??? ? ????? ???? ??????? ??? ? ???? ?? ????? ???? ??? ??? ????.

???? ?? ?? ?????? ?? ??? ??? ? ????. ??? ??? ?? ??? ??? ?????? ??? ?? ???? ???? ?????? ?? ??? ??? ?? ????.

2. ?? ??? ??

?? ???? ?? ??? ???? ??? ????? ?? ??????? ???? ?? ??? ??? ?? ?? ?? ?? ??? ?????? ?? ??? ??? ?? ??? ??????? ? ?????.

//PDO連接方式
'DB_TYPE' => 'pdo', // 數(shù)據(jù)庫類型
'DB_USER' => 'root', // 用戶名
'DB_PWD' => '', // 密碼
'DB_PREFIX' => 'think_', // 數(shù)據(jù)庫表前綴
'DB_DSN' => 'mysql:host=localhost;dbname=thinkphp;charset=UTF-8'

? ?? ?? ??? ???? ?? ?????? ?? ??? ?? ??:

//在模型里單獨(dú)設(shè)置數(shù)據(jù)庫連接信息
namespace Home\ Model;
use Think\ Model;
class UserModel extends Model{
protected $connection = array(
'db_type' => 'mysql',
'db_user' => 'root',
'db_pwd' => '1234',
'db_host' => 'localhost',
'db_port' => '3306',
'db_name' => 'thinkphp',
'db_charset' => 'utf8',
);
}

?? ?? ?? ??? ?? ?????? ?? ??? ??? ?? :

//在模型里單獨(dú)設(shè)置數(shù)據(jù)庫連接信息
namespace Home\ Model;
use Think\ Model;
class UserModel extends Model{
//或者使用DSN定義
protected $connection = 'mysql://root:1234@localhost:3306/thinkphp#utf8';
}

?? ?? ?? ???? ?? ??? ???? ??? ? ????.

//數(shù)據(jù)庫配置1
'DB_CONFIG1' => array(
'db_type' => 'mysql',
'db_user' => 'root',
'db_pwd' => '1234',
'db_host' => 'localhost',
'db_port' => '3306',
'db_name' => 'thinkphp',
'db_charset'=> 'utf8',
),
//數(shù)據(jù)庫配置2
'DB_CONFIG2' => 'mysql://root:1234@localhost:3306/thinkphp#utf8';

3. ????? ??

??? ??? ? ?????? ?? ??? ???? ? ??? ?????? ?? ??? ?????? ? ??? ?? ????. ?? ?? M ???? ???? ??? ??????? ?? ?? ?????? ?? ??? ??? ? ????. ?? ??

//在模型里單獨(dú)設(shè)置數(shù)據(jù)庫連接信息
namespace Home\ Model;
use Think\ Model;
class UserModel extends Model{
//調(diào)用配置文件中的數(shù)據(jù)庫配置1
protected $connection = 'DB_CONFIG1';
}
//在模型里單獨(dú)設(shè)置數(shù)據(jù)庫連接信息
namespace Home\ Model;
use Think\ Model;
class InfoModel extends Model{
//調(diào)用配置文件中的數(shù)據(jù)庫配置1
protected $connection = 'DB_CONFIG2';
}

? User ??? ??????? ?? ???? ??? ?? ??????? other_user ???? ?? ????. using ?? ??? ? ?? ????? ?????. ???? ?? ???? DB_CONFIG2? ??? ?? ??? ??? ?? ????.

$User = M('User','other_','mysql://root:1234@localhost/demo#utf8');

ThinkPHP? ?????? ??? ???? ??? ?????? ? ??????? ???? ??? ?? ??????? ?? ?? ???? ????. ???? ??? ?? ?????(?? ???? ???? ??? ?????? ? ???? ??????? ???? ?? ?? ???? ???? ??? ???? ?? ??? ????).

?? ??: "

thinkPHP ??? ????

"

? ??? thinkphp?? ? ??????? ??? ??? ? ????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!