function &ew_Connect($info = NULL) { $GLOBALS["ADODB_FETCH_MODE"] = ADODB_FETCH_BOTH; $conn = new mysqlt_driver_ADOConnection(); $conn->debug = EW_DEBUG_ENABLED; $conn->debug_echo = FALSE; if (!$info) { $info = array("host" => EW_CONN_HOST, "port" => EW_CONN_PORT, "user" => EW_CONN_USER, "pass" => EW_CONN_PASS, "db" => EW_CONN_DB); } // Database connecting event Database_Connecting($info); $conn->port = intval($info["port"]); $conn->raiseErrorFn = 'ew_ErrorFn'; $conn->Connect($info["host"], $info["user"], $info["pass"], $info["db"]); if (EW_MYSQL_CHARSET != "") { $conn->Execute("SET NAMES '" . EW_MYSQL_CHARSET . "'"); } $conn->raiseErrorFn = ''; // Database connected event Database_Connected($conn); return $conn; }
function ew_ConnectDb(&$info) { $GLOBALS["ADODB_FETCH_MODE"] = ADODB_FETCH_BOTH; $GLOBALS["ADODB_COUNTRECS"] = FALSE; // Database connecting event Database_Connecting($info); $dbid = @$info["id"]; $dbtype = @$info["type"]; if ($dbtype == "MYSQL") { if (EW_USE_ADODB) { if (EW_USE_MYSQLI) { $conn = ADONewConnection('mysqli'); } else { $conn = ADONewConnection('mysqlt'); } } else { $conn = new mysqlt_driver_ADOConnection(); } } elseif ($dbtype == "POSTGRESQL") { $conn = ADONewConnection('postgres7'); } elseif ($dbtype == "MSSQL") { $conn = ADONewConnection('ado_mssql'); } elseif ($dbtype == "ACCESS") { $conn = ADONewConnection('ado_access'); } elseif ($dbtype == "ORACLE") { $conn = ADONewConnection('oci8'); $conn->NLS_DATE_FORMAT = 'RRRR-MM-DD HH24:MI:SS'; } $conn->debug = EW_DEBUG_ENABLED; $conn->debug_echo = FALSE; if ($dbtype == "MYSQL" || $dbtype == "POSTGRESQL" || $dbtype == "ORACLE") { $conn->port = intval(@$info["port"]); } if ($dbtype == "ORACLE") { $conn->charSet = @$info["charset"]; } $conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"]; if ($dbtype == "MYSQL" || $dbtype == "POSTGRESQL" || $dbtype == "ORACLE") { if ($dbtype == "MYSQL") { $conn->Connect(@$info["host"], @$info["user"], @$info["pass"], @$info["db"], @$info["new"]); } else { $conn->Connect(@$info["host"], @$info["user"], @$info["pass"], @$info["db"]); } if ($dbtype == "MYSQL" && EW_MYSQL_CHARSET != "") { $conn->Execute("SET NAMES '" . EW_MYSQL_CHARSET . "'"); } if ($dbtype == "ORACLE") { // Set schema $conn->Execute("ALTER SESSION SET CURRENT_SCHEMA = " . ew_QuotedName(@$info["schema"], $dbid)); $conn->Execute("ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'yyyy-mm-dd hh24:mi:ss'"); $conn->Execute("ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'yyyy-mm-dd hh24:mi:ss'"); } if ($dbtype == "POSTGRESQL") { // Set bytea_output $ver = explode(".", @$conn->version["version"]); if (intval($ver[0]) >= 9) { // PostgreSQL 9 $conn->Execute("SET bytea_output = 'escape'"); } } } elseif ($dbtype == "ACCESS" || $dbtype == "MSSQL") { if (EW_CODEPAGE > 0) { $conn->charPage = EW_CODEPAGE; } if ($dbtype == "ACCESS") { $relpath = @$info["relpath"]; $dbname = @$info["dbname"]; $provider = @$info["provider"]; $password = @$info["password"]; if ($relpath == "") { $datasource = realpath($GLOBALS["EW_RELATIVE_PATH"] . $dbname); } elseif (substr($relpath, 0, 1) == ".") { // Relative path starting with "." or ".." (relative to app root) $datasource = ew_ServerMapPath($relpath . $dbname); } elseif (substr($relpath, 0, 2) == "\\\\" || strpos($relpath, ":") !== FALSE) { // Physical path $datasource = $relpath . $dbname; } else { // Relative to app root $datasource = ew_AppRoot() . str_replace("/", "\\", $relpath) . $dbname; } if ($password != "") { $connstr = $provider . ";Data Source=" . $datasource . ";Jet OLEDB:Database Password="******";"; } elseif (strtoupper(substr($dbname, -6)) == ".ACCDB") { // AccDb $connstr = $provider . ";Data Source=" . $datasource . ";Persist Security Info=False;"; } else { $connstr = $provider . ";Data Source=" . $datasource . ";"; } } else { $connstr = @$info["connectionstring"]; } $conn->Connect($connstr, FALSE, FALSE); // Set date format if ($dbtype == "MSSQL" && EW_DEFAULT_DATE_FORMAT != "") { $conn->Execute("SET DATEFORMAT ymd"); } } //$conn->raiseErrorFn = ''; // Database connected event Database_Connected($conn); $info["conn"] =& $conn; }
function &ew_Connect($info = NULL) { $GLOBALS["ADODB_FETCH_MODE"] = ADODB_FETCH_BOTH; $GLOBALS["ADODB_COUNTRECS"] = FALSE; $conn = ADONewConnection('ado_mssql'); $conn->debug = EW_DEBUG_ENABLED; $conn->debug_echo = FALSE; if (!$info) { $info = "Provider=SQLNCLI11;Persist Security Info=False;Data Source=186.64.110.212;Initial Catalog=PbMillenium2;User Id=consultas;Password=consultas*;DataTypeCompatibility=80"; // ADO connection string } // Database connecting event Database_Connecting($info); $conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"]; if (EW_CODEPAGE > 0) { $conn->charPage = EW_CODEPAGE; } $conn->Connect($info, FALSE, FALSE); // Set date format if (EW_DEFAULT_DATE_FORMAT != "") { $conn->Execute("SET DATEFORMAT ymd"); } $conn->raiseErrorFn = ''; // Database connected event Database_Connected($conn); return $conn; }