php连接mysql,mssql,oracle

php连接mysql,mssql,oracle

1. dbtypedef.php
2. // 数据库部分参数设置
3. @define("DATABASE_ACCESS", 0);
4. @define("DATABASE_MSSQL", 1);
5. @define("DATABASE_ORACLE", 2);
6. @define("DATABASE_MYSQL", 3);
7. @define("DATABASE_POSTGRESQL",4);
8. @define("DATABASE_SQLITE", 5);
9. ?>
11. /*==============================================================*/
12. /* 文件名称: Model.class.php
13. /* 概要: 数据访问层数据库处理的公共父类模型). */
14. /* 作者:
15. /* 创建时间: 2010-10-20
16. /*==============================================================*/
17. class Model {
18. protected $mysqli; //
19. protected $messList; //提示信息列表
20. protected $tabName; //数据表
21. protected $fieldList; //数据列表
22. protected $oracle; //数据列表
24. public function __construct() {
26. if(DB_TYPE == DATABASE_MYSQL)
27. {
28. $this->mysqli = new mysqli ( DB_HOST, DB_USER, DB_PWD, DB_NAME );
29. $this->mysqli->query("set names utf8");
30. if (mysqli_connect_errno ()) {
31. echo "" . mysqli_connect_error ();
32. $this->mysqli = FALSE;
33. exit();
34. }
35. }
36. else if(DB_TYPE == DATABASE_MSSQL)
37. {
38. $conn=mssql_connect(DB_HOST, DB_USER, DB_PWD)or die("Couldn't connect to SQL Server on ".DB_HOST."");
39. mssql_select_db(DB_NAME,$conn);
40. mssql_query("set names utf8");
41. }
42. else if(DB_TYPE == DATABASE_ORACLE)
43. {
44. $ora_connstr = "(description=(address=(protocol=tcp) (host=".DB_HOST.")(port=".DB_PORT.")) (connect_data=(service_name=".DB_NAME.")))";
45. $this->oracle = oci_connect(DB_USER, DB_PWD,$ora_connstr);
46. if (!$this->oracle) {
47. echo "oracle连接失败";
48. $e = oci_error();
49. trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
50. }
51. }
52. }
53. }

复制代码