写了一个设置pdoDSN的方法想请大家看看_PHP教程
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了写了一个设置pdoDSN的方法想请大家看看_PHP教程，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3455字，纯文字阅读大概需要5分钟。
内容图文
写了一个设置pdo DSN的方法想请大家看看ORACLE跟SQLITE 都只有数据库主机，连数据库名都没有，我不知道怎么设置。
发出来大家看看吧 private function setDSN()
{
switch (strtoupper($this->datatype)){
case 'MYSQL':
$_DSN = 'mysql:host='.$this->hostname.';dbname='.$this->database.';port='.$this->hostport;
break;
case 'MSSQL':
case 'DB2':
$_DSN = 'dblib:host='.$this->hostname.':'.$this->hostport.';dbname='.$this->database;
break;
case 'ORACLE':
$_tns = "
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP )(HOST = $this->hostname)(PORT = $this->hostport))
)
(CONNECT_DATA =
(SERVICE_NAME = $this->database)
)
)";
$_DSN = 'oci:dbname='.$_tns;
break;
case 'SQLITE':
$_DSN = 'sqlite:'.$this->hostname;
break;
case 'PGSQL':
$_DSN = 'pgsql:host='.$this->hostname.'port='.$this->hostport.';dbname='.$this->database;
break;
case 'FIREBIRD':
$_DSN = 'firebird:dbname='.$this->hostname.':'.$this->database;
break;
case 'ODBC':
$_DSN = 'odbc:DSN='.$this->hostname.';UID='.$this->username.';PWD='.$this->password;
break;
}
return $_DSN;
}
ORACLE 看了一下cn.php.com上的又修改了一下。
[ ]
我来回答
D8888D回贴内容-------------------------------------------------------
我是来学习的[img]http://www.111cn.cn/bbs/images/smilies/default/lol.gif[/img]
D8888D回贴内容-------------------------------------------------------
分少的原因?怎么没人回复呢`
D8888D回贴内容-------------------------------------------------------
见过
D8888D回贴内容-------------------------------------------------------
这两个数据库 都木用过
D8888D回贴内容-------------------------------------------------------
学习一下，只看程序思路，不看用啥数据库
D8888D回贴内容-------------------------------------------------------
请查阅手册上相关的资料
Example#1 PDO_SQLITE DSN examples
The following examples show PDO_SQLITE DSN for connecting to SQLite databases: sqlite:/opt/databases/mydb.sq3
sqlite::memory:
sqlite2:/opt/databases/mydb.sq2
sqlite2::memory:
cursade at hotmail dot com
2006-04-21 14:29
if oracle and oracle instant client has been installed,
without db in the same host
For UNIX/LINUX，set $LD_LIBRARY_PATH
appent your instant client path and client/lib path to it,
For windows set PATH like this
After set the path ,set TNS_ADMIN everioment ,point to
where tnsnames.ora located.
Then,you can use service name to connect to your Database
Test coding
$param = $_POST;
$db_username = "youusername";
$db_password = "yourpassword";
$db = "oci:dbname=yoursid";
$conn = new PDO($db,$db_username,$db_password);
$name = $param['module'];
$file = $param['file'];
$stmt = $conn->exec("INSERT INTO AL_MODULE (AL_MODULENAME, AL_MODULEFILE) VALUES ('$name', '$file')");
?>
cursade at hotmail dot com
2006-04-20 17:43
If instant client has been installed but the full oracle client
not yet ,you can use pdo to connect to oracle database
like following coding:
$tns = "
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yourip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
";
$db_username = "youname";
$db_password = "yourpassword";
try{
$conn = new PDO("oci:dbname=".$tns,$db_username,$db_password);
}catch(PDOException $e){
echo ($e->getMessage());
}
?>
1、SQLite不是数据主机，而是数据库文件
2、ORACEL的主机格式可能有多种形式，说不定人家是一个数据集群呢？
[ ]
http://www.bkjia.com/PHPjc/632606.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/632606.htmlTechArticle写了一个设置pdo DSN的方法想请大家看看 ORACLE跟SQLITE 都只有数据库主机，连数据库名都没有，我不知道怎么设置。 发出来大家看看吧 priv...
内容总结
以上是互联网集市为您收集整理的写了一个设置pdoDSN的方法想请大家看看_PHP教程全部内容，希望文章能够帮你解决写了一个设置pdoDSN的方法想请大家看看_PHP教程所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】