| | |
| | | | | |
| | | | This file is part of the Roundcube Webmail client | |
| | | | Copyright (C) 2005-2009, The Roundcube Dev Team | |
| | | | Licensed under the GNU GPL | |
| | | | | |
| | | | Licensed under the GNU General Public License version 3 or | |
| | | | any later version with exceptions for skins & plugins. | |
| | | | See the README file for a full license statement. | |
| | | | | |
| | | | PURPOSE: | |
| | | | PEAR:DB wrapper class that implements PEAR MDB2 functions | |
| | |
| | | $db_options['disable_smart_seqname'] = true; |
| | | $db_options['seqname_format'] = '%s'; |
| | | } |
| | | $this->db_error = false; |
| | | $this->db_error_msg = null; |
| | | |
| | | $dbh = MDB2::connect($dsn, $db_options); |
| | | |
| | |
| | | |
| | | $this->db_handle = $this->dsn_connect($dsn); |
| | | $this->db_connected = !PEAR::isError($this->db_handle); |
| | | |
| | | // use write-master when read-only fails |
| | | if (!$this->db_connected && $mode == 'r') { |
| | | $mode = 'w'; |
| | | $this->db_handle = $this->dsn_connect($this->db_dsnw); |
| | | $this->db_connected = !PEAR::isError($this->db_handle); |
| | | } |
| | | |
| | | if ($this->db_connected) |
| | | $this->db_mode = $mode; |
| | |
| | | else { |
| | | $params = (array)$params; |
| | | $q = $this->db_handle->prepare($query, null, $mode=='w' ? MDB2_PREPARE_MANIP : null); |
| | | if ($this->db_handle->isError($q)) { |
| | | if (MDB2::isError($q)) { |
| | | $this->db_error = true; |
| | | $this->db_error_msg = $q->userinfo; |
| | | |
| | |
| | | |
| | | $id = $this->db_handle->lastInsertID($table); |
| | | |
| | | return $this->db_handle->isError($id) ? null : $id; |
| | | return MDB2::isError($id) ? null : $id; |
| | | } |
| | | |
| | | |
| | |
| | | { |
| | | $func = ''; |
| | | $args = func_get_args(); |
| | | if (is_array($args[0])) |
| | | $args = $args[0]; |
| | | |
| | | switch($this->db_provider) { |
| | | case 'mysql': |
| | |
| | | case 'mssql': |
| | | case 'sqlsrv': |
| | | $delim = ' + '; |
| | | // Modify arguments, because + operator requires them to be of type varchar (#1488505) |
| | | // with SQL Server 2012 we can use just CONCAT(), but we need to support older versions |
| | | foreach ($args as $idx => $arg) { |
| | | $args[$idx] = "CAST($arg AS varchar)"; |
| | | } |
| | | break; |
| | | default: |
| | | $delim = ' || '; |