| | |
| | | |
| | | |
| | | /** |
| | | * PHP 4 object constructor |
| | | * |
| | | * @see rcube_mdb2::__construct |
| | | */ |
| | | function rcube_db($db_dsnw,$db_dsnr='') |
| | | { |
| | | $this->__construct($db_dsnw,$db_dsnr); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Connect to specific database |
| | | * |
| | | * @param string DSN for DB connections |
| | |
| | | |
| | | |
| | | /** |
| | | * Return SQL statement for case insensitive LIKE |
| | | * |
| | | * @param string Field name |
| | | * @param string Search value |
| | | * @return string SQL statement to use in query |
| | | * @access public |
| | | */ |
| | | function ilike($column, $value) |
| | | { |
| | | // TODO: use MDB2's matchPattern() function |
| | | switch($this->db_provider) |
| | | { |
| | | case 'pgsql': |
| | | return $this->quote_identifier($column).' ILIKE '.$this->quote($value); |
| | | default: |
| | | return $this->quote_identifier($column).' LIKE '.$this->quote($value); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Adds a query result and returns a handle ID |
| | | * |
| | | * @param object Query handle |
| | |
| | | if (empty($file_name) || !is_string($file_name)) |
| | | return; |
| | | |
| | | $data = ''; |
| | | if ($fd = fopen($file_name, 'r')) |
| | | { |
| | | $data = fread($fd, filesize($file_name)); |
| | | fclose($fd); |
| | | } |
| | | $data = file_get_contents($file_name); |
| | | |
| | | if (strlen($data)) |
| | | sqlite_exec($dbh->connection, $data); |