| | |
| | | $result = $this->db_handle->limitQuery($query,$offset,$numrows,$params); |
| | | } |
| | | else |
| | | $result = $this->db_handle->query($query,$params); |
| | | $result = $this->db_handle->query($query, $params); |
| | | |
| | | if (DB::isError($result)) |
| | | { |
| | |
| | | 'type' => 'db', |
| | | 'line' => __LINE__, |
| | | 'file' => __FILE__, |
| | | 'message' => $result->getMessage()), TRUE, FALSE); |
| | | 'message' => $result->getMessage().'; QUERY: '.$query), TRUE, FALSE); |
| | | return false; |
| | | } |
| | | |
| | |
| | | return $result; |
| | | |
| | | case 'mysql': // This is unfortuneate |
| | | return mysql_insert_id(); |
| | | return mysql_insert_id($this->db_handle->connection); |
| | | |
| | | case 'mysqli': |
| | | return mysqli_insert_id($this->db_handle->connection); |
| | | |
| | | case 'sqlite': |
| | | return sqlite_last_insert_rowid($this->db_handle->connection); |
| | | |
| | |
| | | return $result->fetchRow(DB_FETCHMODE_ASSOC); |
| | | } |
| | | |
| | | function quoteIdentifier ( $str ) |
| | | |
| | | function quote($input, $type=null) |
| | | { |
| | | if (!$this->db_handle) |
| | | $this->db_connect('r'); |
| | | |
| | | return $this->db_handle->quote($input); |
| | | } |
| | | |
| | | |
| | | function quoteIdentifier($str) |
| | | { |
| | | if (!$this->db_handle) |
| | | $this->db_connect('r'); |
| | | |
| | | return $this->db_handle->quoteIdentifier($str); |
| | | } |
| | | |
| | | function quote_identifier($str) |
| | | { |
| | | return $this->quoteIdentifier($str); |
| | | } |
| | | |
| | | |
| | | function unixtimestamp($field) |
| | | { |
| | |
| | | { |
| | | if (!is_string($query)) |
| | | return ($query); |
| | | |
| | | $search = array('/NOW\(\)/', |
| | | '/`/'); |
| | | $replace = array("datetime('now')", |
| | | '"'); |
| | | |
| | | $search = array('/NOW\(\)/i', '/`/'); |
| | | $replace = array("datetime('now')", '"'); |
| | | $query = preg_replace($search, $replace, $query); |
| | | |
| | | return ($query); |