PHP ADOConnection::Execute方法代码示例

 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);
     }
 }

 /**
  * Remove right
  *
  * @param array $params
  * @return void
  */
 public function removeRight(array $params)
 {
     $rightId = (int) $params['right_id'];
     // get permission
     $sql = 'SELECT right_define_name
             FROM ' . self::RIGHTS . "\n                WHERE right_id = {$rightId}";
     $permission = $this->db->GetOne($sql);
     // remove acl rules
     try {
         list($resource, ) = PermissionToAcl::translate($permission);
     } catch (\InvalidArgumentException $e) {
         return;
     }
     $sql = 'DELETE
             FROM ' . self::RULES . "\n                WHERE resource = '{$resource}'";
     $this->db->Execute($sql);
     // remove right
     $sql = 'DELETE
             FROM ' . self::RIGHTS . "\n                WHERE right_id = {$rightId}";
     $this->db->Execute($sql);
 }

 function Execute($sql, $inputarr = false)
 {
     return ADOConnection::Execute($sql, $inputarr);
 }

 function Execute($sql, $inputarr = false)
 {
     if ($this->is_utf) {
         $sql = preg_replace('/(\'.*\')/', 'N$1', $sql);
     }
     return parent::Execute($sql, $inputarr);
 }

 public function autoIncrement($sec)
 {
     $res = $this->db->Execute('SELECT :sec nextval FROM dual commit', array("sec" => $sec));
     return $res->_array[0]['NEXTVAL'];
 }

 /**
  * Create DB connection
  */
 protected function connect()
 {
     /** @var $this->connection \ADOConnection */
     $this->connection =& NewADOConnection($this->driver);
     $host = $this->host;
     if ($this->port) {
         $host .= ':' . $this->port;
     }
     // connect
     if ($this->db) {
         $this->connection->Connect($host, $this->user, $this->password, $this->db);
     } else {
         $this->connection->Connect($host, $this->user, $this->password);
     }
     // check connection
     if (!$this->connection->IsConnected()) {
         $errMsg = $this->connection->ErrorMsg();
         $this->utilityFuncs->throwException('db_connection_failed', $errMsg);
     }
     // execute initial statement
     if ($this->setDBinit) {
         $this->utilityFuncs->debugMessage('sql_request', [$this->setDBinit]);
         $this->connection->Execute($this->setDBinit);
         // error occured?
         if ($this->connection->ErrorNo() != 0) {
             $errMsg = $this->connection->ErrorMsg();
             $this->utilityFuncs->debugMessage('sql_request_error', [$errMsg], 3);
         }
     }
 }

 function CreateLogInfo($good_id, $is_auto = 1, $myinfo = '')
 {
     $query = "insert into loginfo(created, good_id, source, loginfo, ip)\n         values(now(), " . intval($good_id) . ", " . intval($is_auto) . ", '" . $this->ProtectString($myinfo) . "', '" . $_SERVER['REMOTE_ADDR'] . "')\n        ";
     $this->_main_conn->Execute($query);
 }

 /**
  * Get the string to select, insert, update or compare special fields
  * without a leading or trailing decimal point
  *
  * In case of comparison the chaining operator will be added in front of
  * every special field
  * @param \ADOConnection    $dbCon              The database connection
  * @param array             $data               The data to insert or
  *                                              update the entry
  * @param string            $comparator         Relational operator
  *                                              i.e. LIKE
  * @param string            $compareValue       Value to use with relational
  *                                              operator
  * @param string            $chainingOperator   Operator to chain
  *                                              comparisons i.e. OR
  * @return string
  */
 protected function getSpecialFieldsQueryPart($dbCon, $data = null, $comparator = '', $compareValue = '', $chainingOperator = ',')
 {
     $specialFields = array();
     // get amount of special fields
     $specialFieldCount = count($this->specialFields);
     if (empty($specialFieldCount)) {
         $specialFieldCount = $dbCon->Execute("SELECT COUNT(*) AS `count` FROM `" . DBPREFIX . "module_market_spez_fields` WHERE `lang_id` = 1");
         $specialFieldCount = $specialFieldCount->fields['count'];
     }
     for ($i = 1; $i <= $specialFieldCount; ++$i) {
         $value = '';
         // Data needs to  be updated or inserted
         if (!empty($data)) {
             $value = '=\'' . contrexx_input2db($data['spez_' . $i]) . '\'';
         }
         // Special fields are used in WHERE or similar comparison statements
         if (empty($data) && !empty($comparator) && !empty($compareValue)) {
             $value = ' ' . $comparator . ' ' . $compareValue;
         }
         $specialFields[] = 'spez_field_' . $i . $value;
     }
     $specialFields = join(' ' . $chainingOperator . ' ', $specialFields);
     return $specialFields;
 }

 /**
  * Set the Oracle password for a user, if they have an Oracle account. Since we cannot
  * use variable binding, validate the username and password before we pass them to
  * the script
  *
  * @param       $database \b ADOConnection an adodb connection
  * @param       $username \b string username
  * @param       $password \b string the new password
  */
 public static function setOraclePassword(ADOConnection $database, $username, $password)
 {
     $username = strtoupper($username);
     // do not proceed if user does not have an account in this database
     if (!$database->GetOne("SELECT 1 FROM dba_users WHERE username = :u", array('u' => $username))) {
         return false;
     }
     if (!self::validateOraclePassword($password)) {
         throw new Exception('Invalid password');
     }
     if (!self::validateOracleUsername($username)) {
         throw new Exception('Invalid username');
     }
     $password = str_replace('"', '\\"', $password);
     $database->Execute("ALTER USER {$username} IDENTIFIED BY \"{$password}\"");
     if ($database->ErrorNo() > 0) {
         throw new Exception("Database error:" . $database->ErrorMsg());
     }
     return true;
 }