PHP Connection Mysql,mssql,oracle

PHP Connection Mysql,mssql,oracle dbtypedef.php Database part parameter settings @define ("Database_access", 0); @define ("Database_mssql", 1); @define ("Database_oracle", 2); @define ("Database_mysql", 3); @define ("Database_postgresql", 4); @define ("Database_sqlite", 5); ?> /*==============================================================*/ /* File name: Model.class.php /* Summary: The public parent class model that the data access layer database processes. */ /* Author: /* Created on: 2010-10-20 /*==============================================================*/ Class Model { protected $mysqli; // protected $messList; List of prompt information protected $tabName; Data Sheet protected $fieldList; Data list protected $oracle; Data list Public Function __construct () { if (Db_type = = Database_mysql) { $this->mysqli = new Mysqli (Db_host, Db_user, Db_pwd, db_name); $this->mysqli->query ("Set names UTF8"); if (Mysqli_connect_errno ()) { echo "". Mysqli_connect_error (); $this->mysqli = FALSE; Exit (); } } else if (Db_type = = Database_mssql) { $conn =mssql_connect (Db_host, Db_user, db_pwd) or Die ("couldn ' t connect to SQL Server on". Db_host. ""); mssql_select_db (db_name, $conn); Mssql_query ("Set names UTF8"); } else if (Db_type = = database_oracle) { $ora _connstr = "(Description= (address= (protocol=tcp) (host=). Db_host. ") (port= ". Db_port. ")) (Connect_data= (service_name= ". Db_name. ")))"; $this->oracle = Oci_connect (Db_user, db_pwd, $ora _connstr); if (! $this->oracle) { echo "Oracle connection Failed"; $e = Oci_error (); Trigger_error (Htmlentities ($e [' message '], ent_quotes), e_user_error); } } } } Copy Code

