function connexion_base() { $DB = NewADOConnection(BASE_TYPE); $DB->Connect(SERVEURBASE, USERBASE, USERPASSWD, BASE); //$DB->debug = true; return $DB; }
/** * Connect to database. */ public static function Connect() { if (isset(self::$ado)) { //return forced new adodb connection $new = NewADOConnection(DATABASE_DRIVER); $new->autoRollback = true; // default is false if (!@$new->NConnect(DATABASE_HOST, DATABASE_USER, DATABASE_PASSWORD, DATABASE_NAME)) { throw new Exception("Connect to database failed"); } } else { self::$ado = NewADOConnection(DATABASE_DRIVER); self::$ado->autoRollback = true; // default is false if (!@self::$ado->Connect(DATABASE_HOST, DATABASE_USER, DATABASE_PASSWORD, DATABASE_NAME)) { die("Connect to database failed"); } $new = self::$ado; } if (self::is_mysql()) { // For MySQL $new->Execute('SET NAMES "utf8"'); } elseif (self::is_postgresql()) { // For PostgreSQL @$new->Execute('SET bytea_output = "escape";'); } return $new; }
function setup() { if ($this->isType('mysql')) { if ($this->getCreateTarget() == true) { $this->connection =& NewADOConnection($this->dbConfig->getDBType()); $ok = $this->connection->NConnect($this->dbConfig->getHostName(), $this->dbConfig->getRootUserName(), $this->dbConfig->getRootPassword()); if (!$ok) { throw new DatabaseBackupException(DatabaseBackupErrorCode::$DB_CONNECT_ERROR, DatabaseBackup::$langString['DestConnectFailed']); } // Drop database if already exists $sql = "drop database IF EXISTS " . $this->dbConfig->getDatabaseName(); $result = $this->connection->Execute($sql); $this->checkError($result, $sql); $sql = 'create database ' . $this->dbConfig->getDatabaseName(); if ($this->supportUTF8 == true) { $sql .= " default character set utf8 default collate utf8_general_ci"; } $result = $this->connection->Execute($sql); $this->checkError($result, $sql); $this->connection->Close(); } $this->connection =& NewADOConnection($this->dbConfig->getDBType()); $ok = $this->connection->NConnect($this->dbConfig->getHostName(), $this->dbConfig->getUserName(), $this->dbConfig->getPassword(), $this->dbConfig->getDatabaseName()); if (!$ok) { throw new DatabaseBackupException(DatabaseBackupErrorCode::$DB_CONNECT_ERROR, DatabaseBackup::$langString['DestConnectFailed']); } $result = $this->connection->_Execute("SET interactive_timeout=28800", false); $result = $this->connection->_Execute("SET wait_timeout=28800", false); $result = $this->connection->_Execute("SET net_write_timeout=900", false); } }
/** * Open a connection to the database and set connection parameters * @param string $dbhost hostname where the database server uses * @param string $dbuser username to connect to the database * @param string $dbpass password to connect to the database * @param string $dbname * @param string $dbtype database driver to use, currently : * "mysql", "mysqli","pdo_mysql" "pgsql", "pdo_pgsql" should work correctly. * @param string $dbprefix database prefix. */ public function dbOpen($dbhost = '', $dbuser = '', $dbpass = '', $dbname = '', $dbtype = '', $dbprefix = '') { $this->dbtype = $dbtype; $this->dbprefix = $dbprefix; $ADODB_COUNTRECS = false; $this->dblink = NewADOConnection($this->dbtype); $this->dblink->Connect($dbhost, $dbuser, $dbpass, $dbname); if ($this->dblink === false || !empty($this->dbprefix) && !preg_match('/^[a-z][a-z0-9_]+$/i', $this->dbprefix)) { die('Flyspray was unable to connect to the database. ' . 'Check your settings in flyspray.conf.php'); } $this->dblink->SetFetchMode(ADODB_FETCH_BOTH); /* * this will work only in the following systems/PHP versions * * PHP4 and 5 with postgresql * PHP5 with "mysqli" or "pdo_mysql" driver (not "mysql" driver) * using mysql 4.1.11 or later and mysql 5.0.6 or later. * * in the rest of the world, it will silently return FALSE. */ $this->dblink->SetCharSet('utf8'); //enable debug if constact DEBUG_SQL is defined. !defined('DEBUG_SQL') || ($this->dblink->debug = true); if ($dbtype === 'mysql' || $dbtype === 'mysqli') { $dbinfo = $this->dblink->ServerInfo(); if (isset($dbinfo['version']) && version_compare($dbinfo['version'], '5.0.2', '>=')) { $this->dblink->Execute("SET SESSION SQL_MODE='TRADITIONAL'"); } } }
function smarty_modifier_glossary($input) { $plain = strtolower(preg_replace('/[^a-zA-Z0-9]+/', ' ', str_replace("'", '', strip_tags($input)))); $words = preg_split('/ +/', $plain); $db = NewADOConnection($GLOBALS['DSN']); if (!$db) { die('Database connection failed'); } print "<pre>{$plain}</pre>"; $all = $db->getAssoc("select \n\tsource_word,\n\tgroup_concat(tran_word) as tran_word,\n\tgroup_concat(tran_lang) as tran_lang,\n\tgroup_concat(tran_dialect) as tran_dialect,\n\tgroup_concat(tran_definition) as tran_definition,\n\tgroup_concat(source_lang) as source_lang,\n\tgroup_concat(source_dialect) as source_dialect\n\tfrom glossary\n\tgroup by source_word"); foreach ($all as $word => $row) { $wordregex = str_replace(')(*', '\\w*)(', str_replace('*)(', ')(\\w*', '(\\b)(' . $word . ')(\\b)')); if (strpos($row['tran_word'], ',') !== FALSE) { $tran_words = explode(',', $row['tran_word']); $tran_langs = explode(',', $row['tran_lang']); $tran_dialects = explode(',', $row['tran_dialect']); $tran_definitions = explode(',', $row['tran_definition']); $source_langs = explode(',', $row['source_lang']); $source_dialects = explode(',', $row['source_dialect']); $text = ''; foreach ($tran_words as $i => $tran_word) { if ($text) { $text .= "\n-------------------------------\n"; } $text .= "Meaning: {$tran_word} ({$tran_langs[$i]} {$tran_dialects[$i]})\n{$tran_definitions[$i]}\n Source: {$source_langs[$i]} {$source_dialects[$i]}"; } } else { $text = "Meaning: {$row['tran_word']} ({$row['tran_lang']} {$row['tran_dialect']})\n{$row['tran_definition']}\n Source: {$row['source_lang']} {$row['source_dialect']}"; } $input = preg_replace('/' . $wordregex . '/i', "\$1<acronym title=\"{$text}\">\$2</acronym>\$3", $input); } return $input; }
function getConnID() { require_once 'library/adodb/adodb.inc.php'; //导入ADODB类库 $this->connID = NewADOConnection($this->dbType); //生成数据库连接对象 if ($this->dbType == 'mysql' || $this->dbType == 'mssql') { //如果为MySQL数据库或者SQL Server数据库 $this->connID->Connect($this->host, $this->userName, $this->password, $this->dbName); //通过Connect()方法建立与数据库连接 if ($this->dbType == 'mysql') { $this->connID->Execute('set names gb2312'); //设置数据库编码 } } elseif ($this->dbType == 'access') { //如过为ACCESS数据库 $this->connID->Connect('Driver = {Microsoft Access Driver (*.mdb)}; Dbq =' . realpath($this->dbName) . ';Uid = ' . $this->userName . ';Pwd = ' . $this->password . ';'); } else { return false; } $this->connID->debug = $this->isDebug; //是否调试 return $this->connID; //返回数据库连接对象 }
/** * Gets an instance of AdoDb database connection * * Whenever a database connection is required you can get a * reference to the default database connection by doing: * * $db =& Ak:db(); // get an adodb instance * * AdoDB manual can be found at http://phplens.com/adodb/ * * @access public * @param string $dns A string containing Data Source Name (information * regarding database connection) * http://phplens.com/adodb/code.initialization.html#dsnsupport * @static * @return resource Php AdoDb instance. */ function &db($dsn = null, $connection_id = null) { static $db, $default_connection_id; // In order to retrieve a database connection we just need to provide its identifier if(empty($default_connection_id)){ $default_connection_id = md5($dsn); } $connection_id = empty($connection_id) ? $default_connection_id : $connection_id; if(empty($db[$connection_id])){ require_once(AK_CONTRIB_DIR.DS.'adodb'.DS.'adodb.inc.php'); if(substr($dsn, 0, 6) == 'mysql:'){ $dsn = substr_replace($dsn, 'mysqlt:', 0, 6); } if (!$db[$connection_id] = (AK_DEBUG ? NewADOConnection($dsn) : @NewADOConnection($dsn))){ error_reporting(E_ALL); if(defined('AK_DATABASE_CONNECTION_FAILURE_CALLBACK') && function_exists(AK_DATABASE_CONNECTION_FAILURE_CALLBACK)){ $fn = AK_DATABASE_CONNECTION_FAILURE_CALLBACK; $fn(); } if(!AK_PHP5 && substr($dsn,0,6) == 'sqlite'){ echo "\nWarning, sqlite support is not available by default on PHP4.\n Check your PHP version by running \"env php -v\", and change the first line in your scripts/ so they point to a php5 binary\n\n"; } die(Ak::t('Connection to the database failed.').' '. (AK_DEBUG?preg_replace('/\/\/(\w+):(.*)@/i','//$1:******@', urldecode($dsn))."\n":'')); } $db[$connection_id]->debug = AK_DEBUG == 2; defined('AK_DATABASE_CONNECTION_AVAILABLE') ? null : define('AK_DATABASE_CONNECTION_AVAILABLE', true); $dsn = ''; } return $db[$connection_id]; }
function bBlog() { // connect to database $this->_adb = NewADOConnection('mysql://' . DB_USERNAME . ':' . DB_PASSWORD . '@' . DB_HOST . '/' . DB_DATABASE . '?persist'); //$this->_db = new db(DB_USERNAME, DB_PASSWORD, DB_DATABASE, DB_HOST); $this->num_rows =& $this->_db->num_rows; $this->insert_id =& $this->_db->insert_id; //Load the config $config =& new configHandler($this->_adb); $config->loadConfig(); $this->assign('blogname', C_BLOGNAME); $this->assign('blogdescription', C_BLOG_DESCRIPTION); $this->assign('blogurl', BLOGURL); $this->assign('bblogurl', BBLOGURL); $this->assign('metakeywords', C_META_KEYWORDS); $this->assign('metadescription', C_META_DESCRIPTION); $this->assign('charset', C_CHARSET); $this->assign('direction', C_DIRECTION); $this->assign('C_CAPTCHA_ENABLE', C_CAPTCHA_ENABLE); // initial time from config table, based on last updated stuff. // this is just the initial value. //$this->lastmodified = C_LAST_MODIFIED; //$this->register_postfilter("update_when_compiled"); // load up the sections $this->get_sections(); //start the session that we need so much ;) if (!session_id()) { session_start(); } $this->_ph =& new postHandler(&$this->_adb); Smarty::Smarty(); }
/** * Establishes a DB connection * @access public * @return bool */ public function open() { // check if connected already if ($this->db) { return true; } // need adodb and exceptions include_once EP_LIBS_ADODB . '/adodb-exceptions.inc.php'; include_once EP_LIBS_ADODB . '/adodb.inc.php'; // connect db now try { // $this->db = & ADONewConnection($this->dsn); $this->db =& NewADOConnection('pdo'); // convert PEAR DSN into PDO DSN $dsn_pdo = $this->_convertDsn($this->dsn, $username, $password, $phptype); // set db type $this->_setDbType($phptype); // connect through PDO $this->db->Connect($dsn_pdo, $username, $password); } catch (Exception $e) { throw new epExceptionDbAdodb('Cannot connect db: ' . $e->getMessage()); return false; } // set fetch mode to assoc $this->db->SetFetchMode(ADODB_FETCH_ASSOC); return true; }
/** * This function creates the DB on new installs */ function make_db($dbhost, $dbuname, $dbpass, $dbname, $prefix_table, $dbtype, $dbmake) { global $db; echo '<font class="oos-title">' . INPUT_DATA . '</font>'; echo '<table align="center"><tr><td align="left">'; if ($dbmake) { $db =& NewADOConnection($dbtype); $dbh = $db->Connect($dbhost, $dbuname, $dbpass); if (!$dbh) { $dbpass = ""; die("{$dbtype}://{$dbuname}:{$dbpass}@{$dbhost} failed to connect" . $db->ErrorMsg()); } $dict = NewDataDictionary($db); if (!$dict) { continue; } $dict->debug = 1; // ToDo CREATE DATABASE $dbname DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; $sqlarray = $dict->CreateDatabase($dbname); $dict->ExecuteSQLArray($sqlarray); } oosDBInit($dbhost, $dbuname, $dbpass, $dbname, $dbtype); if (!$prefix_table == '') { $prefix_table = $prefix_table . '_'; } include 'newtables.php'; echo '</td></tr></table>'; }
function connect() { if ($this->openqrm->get('config', 'DATABASE_TYPE') === "db2") { $db =& ADONewConnection('odbc'); $db->PConnect($this->openqrm->get('config', 'DATABASE_NAME'), $this->openqrm->get('config', 'DATABASE_USER'), $this->openqrm->get('config', 'DATABASE_PASSWORD')); $db->SetFetchMode(ADODB_FETCH_ASSOC); return $db; } else { if ($this->openqrm->get('config', 'DATABASE_TYPE') === "oracle") { $db = NewADOConnection("oci8po"); $db->Connect($this->openqrm->get('config', 'DATABASE_NAME'), $this->openqrm->get('config', 'DATABASE_USER'), $this->openqrm->get('config', 'DATABASE_PASSWORD')); } else { if (strlen($this->openqrm->get('config', 'DATABASE_PASSWORD'))) { $dsn = $this->openqrm->get('config', 'DATABASE_TYPE') . '://'; $dsn .= $this->openqrm->get('config', 'DATABASE_USER') . ':'; $dsn .= $this->openqrm->get('config', 'DATABASE_PASSWORD') . '@'; $dsn .= $this->openqrm->get('config', 'DATABASE_SERVER') . '/'; $dsn .= $this->openqrm->get('config', 'DATABASE_NAME') . '?persist'; } else { $dsn = $this->openqrm->get('config', 'DATABASE_TYPE') . '://'; $dsn .= $this->openqrm->get('config', 'DATABASE_USER') . '@'; $dsn .= $this->openqrm->get('config', 'DATABASE_SERVER') . '/'; $dsn .= $this->openqrm->get('config', 'DATABASE_NAME') . '?persist'; } $db =& ADONewConnection($dsn); } } $db->SetFetchMode(ADODB_FETCH_ASSOC); return $db; }
/** Connect this object to the database! */ function DbConnect() { $ADODB_CACHE_DIR = '/tmp'; /* $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; */ require_once 'adodb/adodb.inc.php'; if ($this->ini_cfg['database']['dbtype'] == "postgres") { if (isset($this->ini_cfg["database"]['hostname']) && strlen($this->ini_cfg["database"]['hostname']) > 0) { $datasource = 'pgsql://' . $this->ini_cfg["database"]['user'] . ':' . $this->ini_cfg["database"]['password'] . '@' . $this->ini_cfg["database"]['hostname'] . '/' . $this->ini_cfg["database"]['dbname']; } else { $datasource = 'pgsql://dbname=' . $this->ini_cfg["database"]['dbname'] . ' user='******'user']; if (strlen($this->ini_cfg["database"]['password'])) { $datasource .= ' password='******'password']; } } } else { $datasource = 'mysql://' . $this->ini_cfg['database']['user'] . ':' . $this->ini_cfg['database']['password'] . '@' . $this->ini_cfg['database']['hostname'] . '/' . $this->ini_cfg['database']['dbname']; } //echo "Datasource: $datasource \n"; $this->dbhandle = NewADOConnection($datasource); if (!$this->dbhandle) { return false; } $this->dbhandle->setFetchMode(ADODB_FETCH_ASSOC); return true; }
function ConnectionHandler($ruta_raiz) { if (!defined('ADODB_ASSOC_CASE')) { define('ADODB_ASSOC_CASE', 1); } include "{$ruta_raiz}/adodb/adodb.inc.php"; include_once "{$ruta_raiz}/adodb/adodb-paginacion.inc.php"; include_once "{$ruta_raiz}/adodb/tohtml.inc.php"; include "{$ruta_raiz}/config.php"; $ADODB_COUNTRECS = false; $this->driver = $driver; //$dsn= $driver.'://'.$usuario.':'.$contrasena.'@'.$servidor.'/'.$servicio; $this->conn = NewADOConnection($driver); // $this->conn->debug=true; $this->rutaRaiz = $ruta_raiz; if (!$this->conn or $this->conn->Connect($servidor, $usuario, $contrasena, $servicio) == false) { die("Error de conexión a la B.D. comuníquese con el Administrador"); } $this->entidad = $entidad; $this->entidad_largo = $entidad_largo; $this->entidad_tel = $entidad_tel; $this->entidad_dir = $entidad_dir; if ($this->driver == 'mssql') { $this->conn->query("Set DateFirst 1"); } }
/** * connect to database * @param $host * @param $user * @param $pass * @param $dbname */ public static function connect($host, $user, $pass, $dbname) { global $DB; $DB = NewADOConnection('mysql'); $conn = $DB->Connect(DB_HOST, DB_USER, DB_PASS, DB_NAME); return $conn; }
/** * Opens connection to the database. * You must call this function after instanciating your class, before doing queries. * Otherways all queries will fail! You also must have authentificated a user, before * you can use this class! */ function open($dbhost = "", $dbuser = "", $dbpasswd = "", $database = "") { global $c; // initialize configuratin variables. if ($dbhost == "") { $dbhost = $c["dbhost"]; } if ($dbuser == "") { $dbuser = $c["dbuser"]; } if ($dbpasswd == "") { $dbpasswd = $c["dbpasswd"]; } if ($database == "") { $database = $c["database"]; } if ($c["dbdriver"] == "mysql") { $this->ADODB = NewADOConnection($this->type); $this->ADODB->PConnect($dbhost, $dbuser, $dbpasswd, $database); } else { if ($c["dbdriver"] == "mssql") { $this->ADODB =& ADONewConnection("ado_mssql"); $dsn = "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=" . $dbhost . ";DATABASE=" . $database . ";UID=" . $dbuser . ";PWD=" . $dbpasswd . ";"; $this->ADODB->Connect($dsn); } } }
private function __construct() { $this->DBConnector = new DBConnector; $this->mode = ADODB_FETCH_ASSOC; $this->conn = NewADOConnection($this->DBConnector->getDBMS()); if (!($this->conn->Connect($this->DBConnector->getHost(), $this->DBConnector->getUser(), $this->DBConnector->getPasswd(), $this->DBConnector->getDBName()))) { echo "Probleme mit der Datenbank"; exit(); } else { $SQLQuery ="SET NAMES 'UTF8'"; //MG 11.09.2007 try { $this->conn->debug=false; $this->conn->Execute($SQLQuery); } catch (exception $e) { //print_r($e); } } }
function initConnect() { $this->_db = NewADOConnection('mysqli'); $this->_db->Connect($this->_dbAddr, $this->_dbUser, $this->_dbPwd, $this->_dbName); $this->_db->Query('set names utf8'); $this->_db->SetFetchMode(ADODB_FETCH_ASSOC); }
function db_connect_real($host,$user,$pass,$db_name,$db_type, $port = "3306", $retries = 20) { global $cnn_id; $i = 0; $cnn_id = NewADOConnection($db_type); // set oracle date format if (isset($cnn_id->NLS_DATE_FORMAT)) { $cnn_id->NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'; } $hostport = $host . ":" . $port; while ($i <= $retries) { if ($cnn_id->PConnect($hostport,$user,$pass,$db_name)) { return(1); } $i++; usleep(40000); } die("FATAL: Cannot connect to server on '$host'. Please make sure you have specified a valid database name in 'include/config.php'\n"); return(0); }
/** * Gets MongoDb Collection * * @return ADOConnection Returns the instance of the ADOConnection */ protected function getDb() { if ($this->db === null) { $this->db = NewADOConnection($this->options['dsn']); $this->db->SetFetchMode(ADODB_FETCH_ASSOC); } return $this->db; }
public function __construct($type, $host, $user, $pass, $db) { $vendorDir = __DIR__ . '/../../../../../../vendor'; require_once $vendorDir . '/adodb/adodb-php/adodb.inc.php'; require_once $vendorDir . '/adodb/adodb-php/adodb-exceptions.inc.php'; $this->_db = NewADOConnection($type); $this->_db->Connect($host, $user, $pass, $db); }
/** * Synchronize a single course ID. * @global type $db * @param int $course_id */ public function __construct($course_id = null, $cperiod_id = null) { global $db; $course = Models_Course::get($course_id); if ($course) { $audience = $course->getAudience($cperiod_id); if ($audience) { $ldap_sync_date = time(); foreach ($audience as $a) { $a->setLdapSyncDate($ldap_sync_date); if (!$a->update()) { application_log("error", "Unable to update ldap_sync_date for caudience_id " . $a->getID() . "."); } } } } $this->ldap_connection = NewADOConnection("ldap"); $this->ldap_connection->SetFetchMode(ADODB_FETCH_ASSOC); $query = "SELECT a.`course_code`, a.`course_id`, a.`organisation_id`, b.`cperiod_id`, b.`audience_value` AS `group_id`, c.`curriculum_type_id`, c.`start_date`, c.`finish_date`, a.`sync_ldap_courses`, a.`sync_groups`\n FROM `courses` AS a\n JOIN `course_audience` AS b\n ON a.`course_id` = b.`course_id`\n JOIN `curriculum_periods` AS c\n ON b.`cperiod_id` = c.`cperiod_id`\n WHERE a.`course_id` = ?\n AND a.`sync_ldap` = '1'\n AND a.`course_active` = '1'\n AND b.`audience_active` = '1'\n AND c.`active` = '1'\n AND UNIX_TIMESTAMP(NOW()) > c.`start_date` - 1209600 \n AND UNIX_TIMESTAMP(NOW()) < c.`finish_date`"; $results = $db->GetAll($query, array($course_id)); if ($results) { foreach ($results as $result) { $this->ldap_audience = array(); $this->course = $result; $this->course_year = date("Y", $this->course["start_date"]); $this->setQueryParams($this->course["start_date"], $this->course["organisation_id"]); $this->fetchCourseCodes(); if (!$this->fetchGroupID()) { $this->createCourseGroup(); } $this->fetchCourseAudienceMembers(); if ($this->fetchCommunityID()) { $this->fetchCommunityAudience(); } if (!empty($this->course_codes)) { if ($this->fetchLdapAudience()) { foreach ($this->ldap_audience as $course_audience_member) { $member_ldap_data = $this->fetchLdapAudienceMemberDetails($course_audience_member); $this->handleUser($member_ldap_data); } if (!empty($this->community_audience)) { // The audience members remaining were not in the ldap sync, they need to be deactiviated. foreach ($this->community_audience as $audience_member => $cmember) { $this->removeCommunityAudienceMember($audience_member); } } } } else { application_log("error", "There were no course codes attached to this course. That should be impossible."); } if ($this->course["sync_groups"] == "1") { $this->syncCourseGroups(); } } } else { return false; } }
public function __construct() { try { $this->db = NewADOConnection('mysqli'); $this->db->connect(DB_HOST, DB_USER, DB_PASS, DB_NAME); } catch (exception $e) { echo 'Connection failed: ' . $e->getMessage(); } }
static function getInstance() { global $sqltype, $host, $username, $password, $database; $DB = NewADOConnection($sqltype); $DB->Connect($host, $username, $password, $database); $DbInstance = new self(); $DbInstance->db = $DB; return $DbInstance; }
public static function conn() { static $conn; if (!$conn) { $conn = NewADOConnection(DSN); $conn->SetFetchMode(ADODB_FETCH_ASSOC); } return $conn; }
function getDB() { $dbhandle = NewADOConnection("pgsql://dbname=nmtest host=localhost"); if (!$dbhandle) { throw new Exception("Cannot connect to db!"); } $dbhandle->setFetchMode(ADODB_FETCH_ASSOC); return $dbhandle; }
function insertAuditLog($strId, $errorcounter, $runcounter, $ip, $action) { $db = NewADOConnection(getDbType()); $db->Connect("localhost", "xxxxx", "xxxxx", "xxxxxx"); $sql = "INSERT INTO open_audit_log_t (oac_errorn, oac_runn, oac_user, oac_ip, oac_action)VALUES({$errorcounter}, {$runcounter}, '{$strId}', '{$ip}', {$action})"; $db->Execute($sql); $db->Close(); return 0; }
/** * Constructor */ function UploadManager() { global $CONF; $this->db = NewADOConnection($GLOBALS['DSN']); if (!$this->db) { die('Database connection failed: ' . mysql_error()); } $this->tmppath = isset($CONF['photo_upload_dir']) ? $CONF['photo_upload_dir'] : '/tmp'; }
function getJournal($str) { global $config; global $ADODB_FETCH_MODE; $db = NewADOConnection('mysql'); $db->Connect("localhost", $config['db_user'], $config['db_passwd'], $config['db_name']); // Ensure fields are (only) indexed by column name $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; $str = str_replace(' of ', ' ', $str); $str = str_replace(' for ', ' ', $str); $str = preg_replace('/^The /', '', $str); $str = str_replace('(', '', $str); $str = str_replace(')', '', $str); $str = str_replace(',', '', $str); $str = str_replace(':', '', $str); $str = str_replace('\'', '', $str); $str = str_replace('.', '%', $str); // Yuck! $str = str_replace('é', 'e', $str); $str = preg_replace('/\\s\\s*/', ' ', $str); $str = str_replace(' ', '%', $str); $str .= '%'; $sql = 'SELECT * FROM issn WHERE title LIKE ' . $db->Quote($str) . ' ORDER BY title LIMIT 10'; //echo $sql; $result = $db->Execute($sql); if ($result == false) { die("failed"); } $json = "{\"results\":\n["; $count = 0; while (!$result->EOF) { if ($count > 0) { $json .= ","; } $json .= "\n"; $json .= "{"; // fix quotes $title = $result->fields['title']; $title = str_replace("'", "\\\\'", $title); $title = str_replace('"', '\\"', $title); // Note UTF-8 encoding // $json .= '"title":"' . utf8_encode($title) . '",'; // Use as-is because table is in UTF-8 $json .= '"title":"' . $title . '",'; $json .= '"issn":"' . $result->fields['issn'] . '",'; $json .= '"language_code":"' . $result->fields['language_code'] . '"'; $json .= "}"; $count++; $result->MoveNext(); } $json .= "\n]\n}\n"; return $json; }
/** * Constructor */ public function __construct() { global $config; $this->sid = session_id(); if (empty($this->sid)) { session_start(); } $this->db = NewADOConnection($config['dbtype']); $this->db->Connect($config['dbhost'], $config['dbuser'], $config['dbpass'], $config['dbname']); }
private function open_connection() { $SERVIDOR = filter_input_array(INPUT_SERVER); $PATH = $SERVIDOR['DOCUMENT_ROOT'] . "/kamarena/quiniclubs_server"; include "{$PATH}/core/adodb5/adodb.inc.php"; $bd = NewADOConnection("mysql"); $bd->Connect(self::$db_host, self::$db_user, self::$db_pass, self::$db_name); mysql_query("SET NAMES 'utf8'"); self::$conn = $bd; }