# CodeIgniter User Guide Version 1.6.3

Search User Guide

# Change Log

## Version 1.6.4

Release Date: In development
SVN Revision: XXXX

- No significant changes yet
- Other changes
  - Documented the language file use of `byte_format()` in the number helper.

### Bug fixes for 1.6.4

- Fixed a double opening <p> tag in the index pages of each system directory.

## Version 1.6.3

Release Date: June 26, 2008
SVN Revision: 1238

Version 1.6.3 is a security and maintenance release and is recommended for all users.

- Database
  - Modified MySQL/MySQLi Forge class to give explicit names to keys
  - Added ability to set multiple column non-primary keys to the Forge class
  - Added ability to set additional database config values in DSN connections via the query string.
- Libraries
  - Set the mime type check in the Upload class to reference the global mimes variable.
  - Added support for query strings to the Pagination class, automatically detected or explicitly declared.
  - Added `get_post()` to the Input class.
  - Documented `get()` in the Input class.
  - Added the ability to automatically output language items as form labels in the Language class.
- Helpers
  - Added a Language helper.
  - Added a Number helper.
  - Form helper refactored to allow `form_open()` and `form_fieldset()` to accept arrays or strings as arguments.
- Other changes
  - Improved security in `xss_clean()`.
  - Removed an unused Router reference in `_display_cache()`.
  - Added ability to use xss_clean() to test images for XSS, useful for upload security.
  - Considerably expanded list of mobile user-agents in config/user_agents.php.
  - Charset information in the userguide has been moved above title for internationalization purposes (#4614).
  - Added "Using Associative Arrays In a Request Parameter" example to the XMLRPC userguide page.
  - Removed maxlength and size as automatically added attributes of form_input() in the form helper.

### Bug fixes for 1.6.3

- Added a language key for valid_emails in validation_lang.php.
- Amended fixes for bug (#3419) with parsing DSN database connections.
- Moved the `_has_operators()` function (#4535) into DB_driver from DB_active_rec.
- Fixed a syntax error in upload_lang.php.
- Fixed a bug (#4542) with a regular expression in the Image library.
- Fixed a bug (#4561) where `orhaving()` wasn't properly passing values.
- Removed some unused variables from the code (#4563).
- Fixed a bug where `having()` was not adding an = into the statement (#4568).
- Fixed assorted user guide typos or examples (#4574, #4706).
- Added quoted-printable headers to Email class when the multi-part override is used.

## Version 1.6.2

Release Date: May 13, 2008
SVN Revision: 1155

- Active Record
  - Added the ability to prevent escaping in `having()` clauses.
  - Added `rename_table()` into DBForge.
  - Fixed a bug that wasn't allowing escaping to be turned off if the value of a query was NULL.
  - DB Forge is now assigned to any models that exist after loading (#3457).
- Database
  - Added Strict Mode to database transactions.
  - Escape behaviour in where() clauses has changed; values in those with the "FALSE" argument are no longer escaped (ie: quoted).
- Config
  - Added 'application/vnd.ms-powerpoint' to list of mime types.
  - Added 'audio/mpg' to list of mime types.
  - Added new user-modifiable file constants.php containing file mode and fopen constants.
  - Added the ability to set CRLF settings via config in the Email class.
- Libraries
  - Added increased security for filename handling in the Upload library.
  - Added increased security for sessions for client-side data tampering.
  - The MySQLi forge class is now in sync with MySQL forge.
  - Added the ability to set CRLF settings via config in the Email class.
  - Unit Testing results are now colour coded, and a change was made to the default template of results.
  - Added a valid_emails rule to the Validation class.
  - The Zip class now exits within `download()`.
  - The Zip class has undergone a substantial re-write for speed and clarity (thanks stanleyxu for the hard work and code contribution in bug report #3425!)
- Helpers
  - Added a Compatibility Helper for using some common PHP 5 functions safely in applications that might run on PHP 4 servers (thanks Seppo for the hard work and code contribution!)
  - Added `form_button()` in the Form helper.
  - Changed the `radio()` and `checkbox()` functions to default to not checked by default.
  - Added the ability to include an optional HTTP Response Code in the `redirect()` function of the URL Helper.
  - Modified `img()` in the HTML Helper to remove an unneeded space (#4208).
  - Modified `anchor()` in the URL helper to no longer add a default title= attribute (#4209).
  - The Download helper now exits within `force_download()`.
  - Added `get_dir_file_info()`, `get_file_info()`, and `get_mime_by_extension()` to the File Helper.
  - Added `symbolic_permissions()` and `octal_permissions()` to the File helper.
- Plugins
  - Modified captcha generation to first look for the function imagecreatetruecolor, and fallback to imagecreate if it isn't available (#4226).
- Other Changes
  - Added ability for xss_clean() to accept arrays.
  - Removed closing PHP tags from all PHP files to avoid accidental output and potential 'cannot modify headers' errors.
  - Removed "scripts" from the auto-load search path. Scripts were deprecated in Version 1.4.1 (September 21, 2006). If you still need to use them for legacy reasons, they must now be manually loaded in each Controller.
  - Added a Reserved Names page to the userguide, and migrated reserved controller names into it.
  - Added a Common Functions page to the userguide for globally available functions.
  - Improved security and performance of xss_clean().

### Bugfixes for 1.6.2

- Fixed a bug where SET queries were not being handled as "write" queries.
- Fixed a bug (#3191) with ORIG_PATH_INFO URI parsing.
- Fixed a bug in DB Forge, when inserting an id field (#3456).
- Fixed a bug in the table library that could cause identically constructed rows to be dropped (#3459).
- Fixed DB Driver and MySQLi result driver checking for resources instead of objects (#3461).
- Fixed an AR_caching error where it wasn't tracking table aliases (#3463).
- Fixed a bug in AR compiling, where select statements with arguments got incorrectly escaped (#3478).
- Fixed an incorrect documentation of $this->load->language (#3520).
- Fixed bugs (#3523, #4350) in get_filenames() with recursion and problems with Windows when $include_path is used.
- Fixed a bug (#4153) in the XML-RPC class preventing dateTime.iso8601 from being used.
- Fixed an AR bug with or_where_not_in() (#4171).
- Fixed a bug with xss_clean() that would add semicolons to GET URI variable strings.
- Fixed a bug (#4206) in the Directory Helper where the directory resource was not being closed, and minor improvements.
- Fixed a bug in the FTP library where delete_dir() was not working recursively (#4215).
- Fixed a Validation bug when set_rules() is used with a non-array field name and rule (#4220).
- Fixed a bug (#4223) where DB caching would not work for returned DB objects or multiple DB connections.
- Fixed a bug in the Upload library that might output the same error twice (#4390).
- Fixed an AR bug when joining with a table alias and table prefix (#4400).
- Fixed a bug in the DB class testing the $params argument.
- Fixed a bug in the Table library where the integer 0 in cell data would be displayed as a blank cell.
- Fixed a bug in `link_tag()` of the URL helper where a key was passed instead of a value.
- Fixed a bug in DB_result::row() that prevented it from returning individual fields with MySQL NULL values.
- Fixed a bug where SMTP emails were not having dot transformation performed on lines that begin with a dot.
- Fixed a bug in display_error() in the DB driver that was instantiating new Language and Exception objects, and not using the error heading.
- Fixed a bug (#4413) where a URI containing slashes only e.g. 'http://example.com/index.php?//' would result in PHP errors
- Fixed an array to string conversion error in the Validation library (#4425)
- Fixed bug (#4451, #4299, #4339) where failed transactions will not rollback when debug mode is enabled.
- Fixed a bug (#4506) with overlay_watermark() in the Image library preventing support for PNG-24s with alpha transparency
- Fixed assorted user guide typos (#3453, #4364, #4379, #4399, #4408, #4412, #4448, #4488).

## Version 1.6.1

Release Date: February 12, 2008
SVN Revision: 984

- Active Record
  - Added Active Record Caching.
  - Made Active Record fully database-prefix aware.
- Database drivers
  - Added support for setting client character set and collation for MySQLi.
- Core Changes
  - Modified `xss_clean()` to be more intelligent with its handling of URL encoded strings.
  - Added $_SERVER, $_FILES, $_ENV, and $_SESSION to sanitization of globals.
  - Added a Path Helper.
  - Simplified `_reindex_segments()` in the URI class.
  - Escaped the '-' in the default 'permitted_uri_chars' config item, to prevent errors if developers just try to add additional characters to the end of the default expression.
  - Modified method calling to controllers to show a 404 when a private or protected method is accessed via a URL.
  - Modified framework initiated 404s to log the controller and method for invalid requests.
- Helpers
  - Modified `get_filenames()` in the File Helper to return FALSE if the $source_dir is not readable.

### Bugfixes for 1.6.1

- Deprecated is_numeric as a validation rule. Use of numeric and integer are preferred.
- Fixed bug (#3379) in DBForge with SQLite for table creation.
- Made Active Record fully database prefix aware (#3384).
- Fixed a bug where DBForge was outputting invalid SQL in Postgres by adding brackets around the tables in FROM.
- Changed the behaviour of Active Record's update() to make the WHERE clause optional (#3395).
- Fixed a bug (#3396) where certain POST variables would cause a PHP warning.
- Fixed a bug in query binding (#3402).
- Changed order of SQL keywords in the Profiler $highlight array so OR would not be highlighted before ORDER BY.
- Fixed a bug (#3404) where the MySQLi driver was testing if $this->conn_id was a resource instead of an object.
- Fixed a bug (#3419) connecting to a database via a DSN string.
- Fixed a bug (#3445) where the routed segment array was not re-indexed to begin with 1 when the default controller is used.
- Fixed assorted user guide typos.

## Version 1.6.0

Release Date: January 30, 2008

- DBForge
  - Added DBForge to the database tools.
  - Moved `create_database()` and `drop_database()` into DBForge.
  - Added `add_field()`, `add_key()`, `create_table()`, `drop_table()`, `add_column()`, `drop_column()`, `modify_column()` into DBForge.
- Active Record
  - Added `protect_identifiers()` in Active Record.
  - All AR queries are backticked if appropriate to the database.
  - Added `where_in()`, `or_where_in()`, `where_not_in()`, `or_where_not_in()`, `not_like()` and `or_not_like()` to Active Record.
  - Added support for `limit()` into `update()` and `delete()` statements in Active Record.
  - Added `empty_table()` and `truncate_table()` to Active Record.
  - Added the ability to pass an array of tables to the `delete()` statement in Active Record.
  - Added `count_all_results()` function to Active Record.
  - Added `select_max()`, `select_min()`, `select_avg()` and `select_sum()` to Active Record.
  - Added the ability to use aliases with joins in Active Record.
  - Added a third parameter to Active Record's `like()` clause to control where the wildcard goes.
  - Added a third parameter to `set()` in Active Record that withholds escaping data.
  - Changed the behaviour of variables submitted to the where() clause with no values to auto set "IS NULL"
- Other Database Related
  - MySQL driver now requires MySQL 4.1+
  - Added $this->DB->save_queries variable to DB driver, enabling queries to get saved or not. Previously they were always saved.
  - Added $this->db->dbprefix() to manually add database prefixes.
  - Added 'random' as an `order_by()` option , and removed "rand()" as a listed option as it was MySQL only.
  - Added a check for NULL fields in the MySQL database backup utility.
  - Added "constrain_by_prefix" parameter to db->list_table() function. If set to TRUE it will limit the result to only table names with the current prefix.
  - Deprecated from Active Record; `getwhere()` for `get_where()`; `groupby()` for `group_by()`; `havingor()` for `having_or()`; `orderby()` for `order_by`; `orwhere()` for `or_where()`; and `orlike()` for `or_like()`.
  - Modified `csv_from_result()` to output CSV data more in the spirit of basic rules of RFC 4180.
  - Added 'char_set' and 'dbcollat' database configuration settings, to explicitly set the client communication properly.
  - Removed 'active_r' configuration setting and replaced with a global $active_record setting, which is more in harmony with the global nature of the behavior (#1834).
- Core changes
  - Added ability to load multiple views, whose content will be appended to the output in the order loaded.
  - Added the ability to auto-load Models.
  - Reorganized the URI and Routes classes for better clarity.
  - Added Compat.php to allow function overrides for older versions of PHP or PHP environments missing certain extensions / libraries
  - Added memory usage, GET, URI string data, and individual query execution time to Profiler output.
  - Deprecated Scaffolding.
  - Added is_really_writable() to Common.php to provide a cross-platform reliable method of testing file/folder writability.
- Libraries
  - Changed the load protocol of Models to allow for extension.
  - Strengthened the Encryption library to help protect against man in the middle attacks when MCRYPT_MODE_CBC mode is used.
  - Added Flashdata variables, session_id regeneration and configurable session update times to the Session class.
  - Removed 'last_visit' from the Session class.
  - Added a language entry for valid_ip validation error.
  - Modified prep_for_form() in the Validation class to accept arrays, adding support for POST array validation (via callbacks only)
  - Added an "integer" rule into the Validation library.
  - Added valid_base64() to the Validation library.
  - Documented clear() in the Image Processing library.
  - Changed the behaviour of custom callbacks so that they no longer trigger the "required" rule.
  - Modified Upload class $_FILES error messages to be more precise.
  - Moved the safe mode and auth checks for the Email library into the constructor.
  - Modified variable names in _ci_load() method of Loader class to avoid conflicts with view variables.
  - Added a few additional mime type variations for CSV.
  - Enabled the 'system' methods for the XML-RPC Server library, except for 'system.multicall' which is still disabled.
- Helpers & Plugins
  - Added link_tag() to the HTML helper.
  - Added img() to the HTML helper.
  - Added ability to "extend" Helpers.
  - Added an email helper into core helpers.
  - Added `strip_quotes()` function to string helper.
  - Added `reduce_multiples()` function to string helper.
  - Added `quotes_to_entities()` function to string helper.
  - Added `form_fieldset()`, `form_fieldset_close()`, `form_label()`, and `form_reset()` function to form helper.
  - Added support for external urls in `form_open()`.
  - Removed support for db_backup in MySQLi due to incompatible functions.
  - Javascript Calendar plugin now uses the months and days from the calendar language file, instead of hard-coded values, internationalizing it.
- Documentation Changes
  - Added Writing Documentation section for the community to use in writing their own documentation.
  - Added titles to all user manual pages.
  - Added attributes into <html> of userguide for valid html.
  - Added Zip Encoding Class to the table of contents of the userguide.
  - Moved part of the userguide menu javascript to an external file.
  - Documented `distinct()` in Active Record.
  - Documented the `timezones()` function in the Date Helper.
  - Documented unset_userdata in the Session class.
  - Documented 2 config options to the Database configuration page.

### Bug fixes for Version 1.6.0

- Fixed a bug (#1813) preventing using $CI->db in the same application with returned database objects.
- Fixed a bug (#1842) where the $this->uri->rsegments array would not include the 'index' method if routed to the controller without an implicit method.
- Fixed a bug (#1872) where word_limiter() was not retaining whitespace.
- Fixed a bug (#1890) in csv_from_result() where content that included the delimiter would break the file.
- Fixed a bug (#2542)in the clean_email() method of the Email class to allow for non-numeric / non-sequential array keys.
- Fixed a bug (#2545) in `_html_entity_decode_callback()` when 'global_xss_filtering' is enabled.
- Fixed a bug (#2668) in the parser class where numeric data was ignored.
- Fixed a bug (#2679) where the "previous" pagination link would get drawn on the first page.
- Fixed a bug (#2702) in _object_to_array that broke some types of inserts and updates.
- Fixed a bug (#2732) in the SQLite driver for PHP 4.
- Fixed a bug (#2754) in Pagination to scan for non-positive num_links.
- Fixed a bug (#2762) in the Session library where user agent matching would fail on user agents ending with a space.
- Fixed a bug (#2784) $field_names[] vs $Ffield_names[] in postgre and sqlite drivers.
- Fixed a bug (#2810) in the typography helper causing extraneous paragraph tags when string contains tags.
- Fixed a bug (#2849) where arguments passed to a subfolder controller method would be incorrectly shifted, dropping the 3rd segment value.
- Fixed a bug (#2858) which referenced a wrong variable in the Image class.
- Fixed a bug (#2875)when loading plugin files as _plugin. and not _pi.
- Fixed a bug (#2912) in `get_filenames()` in the File Helper where the array wasn't cleared after each call.
- Fixed a bug (#2974) in `highlight_phrase()` that caused an error with slashes.
- Fixed a bug (#3003) in the Encryption Library to support modes other than MCRYPT_MODE_ECB
- Fixed a bug (#3015) in the User Agent library where more then 2 languages where not reported with languages().
- Fixed a bug (#3017) in the Email library where some timezones were calculated incorrectly.
- Fixed a bug (#3024) in which master_dim wasn't getting reset by clear() in the Image library.
- Fixed a bug (#3156) in Text Helper highlight_code() causing PHP tags to be handled incorrectly.
- Fixed a bug (#3166) that prevented num_rows from working in Oracle.
- Fixed a bug (#3175) preventing certain libraries from working properly when autoloaded in PHP 4.
- Fixed a bug (#3267) in the Typography Helper where unordered list was listed "un.
- Fixed a bug (#3268) where the Router could leave '/' as the path.
- Fixed a bug (#3279) where the Email class was sending the wrong Content-Transfer-Encoding for some character sets.
- Fixed a bug (#3284) where the rsegment array would not be set properly if the requested URI contained more segments than the routed URI.
- Removed extraneous load of $CFG in _display_cache() of the Output class (#3285).
- Removed an extraneous call to loading models (#3286).
- Fixed a bug (#3310) with sanitization of globals in the Input class that could unset CI's global variables.
- Fixed a bug (#3314) which would cause the top level path to be deleted in delete_files() of the File helper.
- Fixed a bug (#3328) where the smiley helper might return an undefined variable.
- Fixed a bug (#3330) in the FTP class where a comparison wasn't getting made.
- Removed an unused parameter from Profiler (#3332).
- Fixed a bug in database driver where num_rows property wasn't getting updated.
- Fixed a bug in the upload library when allowed_files wasn't defined.
- Fixed a bug in `word_wrap()` of the Text Helper that incorrectly referenced an object.
- Fixed a bug in Validation where `valid_ip()` wasn't called properly.
- Fixed a bug in Validation where individual error messages for checkboxes wasn't supported.
- Fixed a bug in captcha calling an invalid PHP function.
- Fixed a bug in the cookie helper "set_cookie" function. It was not honoring the config settings.
- Fixed a bug that was making validation callbacks required even when not set as such.
- Fixed a bug in the XML-RPC library so if a type is specified, a more intelligent decision is made as to the default type.
- Fixed an example of comma-separated emails in the email library documentation.
- Fixed an example in the Calendar library for Showing Next/Previous Month Links.
- Fixed a typo in the database language file.
- Fixed a typo in the image language file "suppor" to "support".
- Fixed an example for XML RPC.
- Fixed an example of `accept_charset()` in the User Agent Library.
- Fixed a typo in the docblock comments that had CodeIgniter spelled CodeIgnitor.
- Fixed a typo in the String Helper (uniquid changed to uniqid).
- Fixed typos in the email Language class (email_attachment_unredable, email_filed_smtp_login), and FTP Class (ftp_unable_to_remame).
- Added a stripslashes() into the Upload Library.
- Fixed a series of grammatical and spelling errors in the language files.
- Fixed assorted user guide typos.

## Version 1.5.4

Release Date: July 12, 2007

- Added custom Language files to the autoload options.
- Added stripslashes() to the _clean_input_data() function in the Input class when magic quotes is on so that data will always be un-slashed within the framework.
- Added array to string into the profiler.
- Added some additional mime types in application/config/mimes.php.
- Added filename_security() method to Input library.
- Added some additional arguments to the Inflection helper singular() to compensate for words ending in "s". Also added a force parameter to pluralize().
- Added $config['charset'] to the config file. Default value is 'UTF-8', used in some string handling functions.
- Fixed MSSQL insert_id().
- Fixed a logic error in the DB trans_status() function. It was incorrectly returning TRUE on failure and FALSE on success.
- Fixed a bug that was allowing multiple load attempts on extended classes.
- Fixed a bug in the bootstrap file that was incorrectly attempting to discern the full server path even when it was explicity set by the user.
- Fixed a bug in the escape_str() function in the MySQL driver.
- Fixed a typo in the Calendar library
- Fixed a typo in rpcs.php library
- Fixed a bug in the Zip library, providing PC Zip file compatibility with Mac OS X
- Fixed a bug in router that was ignoring the scaffolding route for optimization
- Fixed an IP validation bug.
- Fixed a bug in display of POST keys in the Profiler output
- Fixed a bug in display of queries with characters that would be interpreted as HTML in the Profiler output
- Fixed a bug in display of Email class print debugger with characters that would be interpreted as HTML in the debugging output
- Fixed a bug in the Content-Transfer-Encoding of HTML emails with the quoted-printable MIME type
- Fixed a bug where one could unset certain PHP superglobals by setting them via GET or POST data
- Fixed an undefined function error in the insert_id() function of the PostgreSQL driver
- Fixed various doc typos.
- Documented two functions from the String helper that were missing from the user guide: trim_slashes() and reduce_double_slashes().
- Docs now validate to XHTML 1 transitional
- Updated the XSS Filtering to take into account the IE expression() ability and improved certain deletions to prevent possible exploits
- Modified the Router so that when Query Strings are Enabled, the controller trigger and function trigger values are sanitized for filename include security.
- Modified the is_image() method in the Upload library to take into account Windows IE 6/7 eccentricities when dealing with MIMEs
- Modified XSS Cleaning routine to be more performance friendly and compatible with PHP 5.2's new PCRE backtrack and recursion limits.
- Modified the URL Helper to type cast the $title as a string in case a numeric value is supplied
- Modified Form Helper form_dropdown() to type cast the keys and values of the options array as strings, allowing numeric values to be properly set as 'selected'
- Deprecated the use if `is_numeric()` in various places since it allows periods. Due to compatibility problems with `ctype_digit()`, making it unreliable in some installations, the following regular expression was used instead: `preg_match("/[^0-9]/", $n)`
- Deprecated: APPVER has been deprecated and replaced with CI_VERSION for clarity.

## Version 1.5.3

Release Date: April 15, 2007

- Added array to string into the profiler
- Code Igniter references updated to CodeIgniter
- pMachine references updated to EllisLab
- Fixed a bug in the repeater function of string helper.
- Fixed a bug in ODBC driver
- Fixed a bug in result_array() that was returning an empty array when no result is produced.
- Fixed a bug in the redirect function of the url helper.
- Fixed an undefined variable in Loader
- Fixed a version bug in the Postgre driver
- Fixed a bug in the textarea function of the form helper for use with strings
- Fixed doc typos.

## Version 1.5.2

Release Date: February 13, 2007

- Added subversion information to the downloads page.
- Added support for captions in the Table Library
- Fixed a bug in the download_helper that was causing Internet Explorer to load rather then download
- Fixed a bug in the Active Record Join function that was not taking table prefixes into consideration.
- Removed unescaped variables in error messages of Input and Router classes
- Fixed a bug in the Loader that was causing errors on Libraries loaded twice. A debug message is now silently made in the log.
- Fixed a bug in the form helper that gave textarea a value attribute
- Fixed a bug in the Image Library that was ignoring resizing the same size image
- Fixed some doc typos.

## Version 1.5.1

Release Date: November 23, 2006

- Added support for submitting arrays of libraries in the $this->load->library function.
- Added support for naming custom library files in lower or uppercase.
- Fixed a bug related to output buffering.
- Fixed a bug in the active record class that was not resetting query data after a completed query.
- Fixed a bug that was suppressing errors in controllers.
- Fixed a problem that can cause a loop to occur when the config file is missing.
- Fixed a bug that occurred when multiple models were loaded with the third parameter set to TRUE.
- Fixed an oversight that was not unsetting globals properly in the input sanitize function.
- Fixed some bugs in the Oracle DB driver.
- Fixed an incorrectly named variable in the MySQLi result driver.
- Fixed some doc typos.

## Version 1.5.0.1

Release Date: October 31, 2006

- Fixed a problem in which duplicate attempts to load helpers and classes were not being stopped.
- Fixed a bug in the word_wrap() helper function.
- Fixed an invalid color Hex number in the Profiler class.
- Fixed a corrupted image in the user guide.

## Version 1.5.0

Release Date: October 30, 2006

- Added DB utility class, permitting DB backups, CVS or XML files from DB results, and various other functions.
- Added Database Caching Class.
- Added transaction support to the database classes.
- Added Profiler Class which generates a report of Benchmark execution times, queries, and POST data at the bottom of your pages.
- Added User Agent Library which allows browsers, robots, and mobile devises to be identified.
- Added HTML Table Class , enabling tables to be generated from arrays or database results.
- Added Zip Encoding Library.
- Added FTP Library.
- Added the ability to extend libraries and extend core classes, in addition to being able to replace them.
- Added support for storing models within sub-folders.
- Added Download Helper.
- Added simple_query() function to the database classes
- Added standard_date() function to the Date Helper.
- Added $query->free_result() to database class.
- Added $query->list_fields() function to database class
- Added $this->db->platform() function
- Added new File Helper: get_filenames()
- Added new helper: Smiley Helper
- Added support for <ul> and <ol> lists in the HTML Helper
- Added the ability to rewrite short tags on-the-fly, converting them to standard PHP statements, for those servers that do not support short tags. This allows the cleaner syntax to be used regardless of whether it's supported by the server.
- Added the ability to rename or relocate the "application" folder.
- Added more thorough initialization in the upload class so that all class variables are reset.
- Added "is_numeric" to validation, which uses the native PHP is_numeric function.
- Improved the URI handler to make it more reliable when the $config['uri_protocol'] item is set to AUTO.
- Moved most of the functions in the Controller class into the Loader class, allowing fewer reserved function names for controllers when running under PHP 5.
- Updated the DB Result class to return an empty array when $query->result() doesn't produce a result.
- Updated the input->cookie() and input->post() functions in Input Class to permit arrays contained cookies that are arrays to be run through the XSS filter.
- Documented three functions from the Validation class that were missing from the user guide: set_select(), set_radio(), and set_checkbox().
- Fixed a bug in the Email class related to SMTP Helo data.
- Fixed a bug in the word wrapping helper and function in the email class.
- Fixed a bug in the validation class.
- Fixed a bug in the typography helper that was incorrectly wrapping block level elements in paragraph tags.
- Fixed a problem in the form_prep() function that was double encoding entities.
- Fixed a bug that affects some versions of PHP when output buffering is nested.
- Fixed a bug that caused CI to stop working when the PHP magic __get() or __set() functions were used within models or controllers.
- Fixed a pagination bug that was permitting negative values in the URL.
- Fixed an oversight in which the Loader class was not allowed to be exteneded.
- Changed _get_config() to get_config() since the function is not a private one.
- Deprecated "init" folder. Initialization happens automatically now. Please see documentation.
- Deprecated $this->db->field_names() USE $this->db->list_fields()
- Deprecated the $config['log_errors'] item from the config.php file. Instead, $config['log_threshold'] can be set to "0" to turn it off.

## Version 1.4.1

Release Date: September 21, 2006

- Added a new feature that passes URI segments directly to your function calls as parameters. See the Controllers page for more info.
- Added support for a function named _output(), which when used in your controllers will received the final rendered output from the output class. More info in the Controllers page.
- Added several new functions in the URI Class to let you retrieve and manipulate URI segments that have been re-routed using the URI Routing feature. Previously, the URI class did not permit you to access any re-routed URI segments, but now it does.
- Added $this->output->set_header() function, which allows you to set server headers.
- Updated plugins, helpers, and language classes to allow your application folder to contain its own plugins, helpers, and language folders. Previously they were always treated as global for your entire installation. If your application folder contains any of these resources they will be used instead the global ones.
- Added Inflector helper.
- Added element() function in the array helper.
- Added RAND() to active record orderby() function.
- Added delete_cookie() and get_cookie() to Cookie helper, even though the input class has a cookie fetching function.
- Added Oracle database driver (still undergoing testing so it might have some bugs).
- Added the ability to combine pseudo-variables and php variables in the template parser class.
- Added output compression option to the config file.
- Removed the is_numeric test from the db->escape() function.
- Fixed a MySQLi bug that was causing error messages not to contain proper error data.
- Fixed a bug in the email class which was causing it to ignore explicitly set alternative headers.
- Fixed a bug that was causing a PHP error when the Exceptions class was called within the get_config() function since it was causing problems.
- Fixed an oversight in the cookie helper in which the config file cookie settings were not being honored.
- Fixed an oversight in the upload class. An item mentioned in the 1.4 changelog was missing.
- Added some code to allow email attachments to be reset when sending batches of email.
- Deprecated the application/scripts folder. It will continue to work for legacy users, but it is recommended that you create your own libraries or models instead. It was originally added before CI had user libraries or models, but it's not needed anymore.
- Deprecated the $autoload['core'] item from the `autoload.php` file. Instead, please now use: `$autoload['libraries']`
- Deprecated the following database functions: $this->db->smart_escape_str() and $this->db->fields().

## Version 1.4.0

Release Date: September 17, 2006

- Added Hooks feature, enabling you to tap into and modify the inner workings of the framework without hacking the core files.
- Added the ability to organize controller files into sub-folders. Kudos to Marco for suggesting this (and the next two) feature.
- Added regular expressions support for routing rules.
- Added the ability to remap function calls within your controllers.
- Added the ability to replace core system classes with your own classes.
- Added support for % character in URL.
- Added the ability to supply full URLs using the anchor() helper function.
- Added mode parameter to file_write() helper.
- Added support for changing the port number in the Postgre driver.
- Moved the list of "allowed URI characters" out of the Router class and into the config file.
- Moved the MIME type array out of the Upload class and into its own file in the applications/config/ folder.
- Updated the Upload class to allow the upload field name to be set when calling do_upload().
- Updated the Config Library to be able to load config files silently, and to be able to assign config files to their own index (to avoid collisions if you use multiple config files).
- Updated the URI Protocol code to allow more options so that URLs will work more reliably in different environments.
- Updated the form_open() helper to allow the GET method to be used.
- Updated the MySQLi execute() function with some code to help prevent lost connection errors.
- Updated the SQLite Driver to check for object support before attempting to return results as objects. If unsupported it returns an array.
- Updated the Models loader function to allow multiple loads of the same model.
- Updated the MS SQL driver so that single quotes are escaped.
- Updated the Postgre and ODBC drivers for better compatibility.
- Removed a strtolower() call that was changing URL segments to lower case.
- Removed some references that were interfering with PHP 4.4.1 compatibility.
- Removed backticks from Postgre class since these are not needed.
- Renamed display() to _display() in the Output class to make it clear that it's a private function.
- Deprecated the hash() function due to a naming conflict with a native PHP function with the same name. Please use `dohash()` instead.
- Fixed an bug that was preventing the input class from unsetting GET variables.
- Fixed a router bug that was making it too greedy when matching end segments.
- Fixed a bug that was preventing multiple discrete database calls.
- Fixed a bug in which loading a language file was producing a "file contains no data" message.
- Fixed a session bug caused by the XSS Filtering feature inadvertently changing the case of certain words.
- Fixed some missing prefixes when using the database prefix feature.
- Fixed a typo in the Calendar class (cal_november).
- Fixed a bug in the form_checkbox() helper.
- Fixed a bug that was allowing the second segment of the URI to be identical to the class name.
- Fixed an evaluation bug in the database initialization function.
- Fixed a minor bug in one of the error messages in the language class.
- Fixed a bug in the date helper timespan function.
- Fixed an undefined variable in the DB Driver class.
- Fixed a bug in which dollar signs used as binding replacement values in the DB class would be treated as RegEx back-references.
- Fixed a bug in the set_hash() function which was preventing MD5 from being used.
- Fixed a couple bugs in the Unit Testing class.
- Fixed an incorrectly named variable in the Validation class.
- Fixed an incorrectly named variable in the URI class.
- Fixed a bug in the config class that was preventing the base URL from being called properly.
- Fixed a bug in the validation class that was not permitting callbacks if the form field was empty.
- Fixed a problem that was preventing scaffolding from working properly with MySQLi.
- Fixed some MS SQL bugs.
- Fixed some doc typos.

## Version 1.3.3

Release Date: June 1, 2006

- Models do not connect automatically to the database as of this version. More info here.
- Updated the Sessions class to utilize the active record class when running session related queries. Previously the queries assumed MySQL syntax.
- Updated alternator() function to re-initialize when called with no arguments, allowing multiple calls.
- Fixed a bug in the active record "having" function.
- Fixed a problem in the validation class which was making checkboxes be ignored when required.
- Fixed a bug in the word_limiter() helper function. It was cutting off the fist word.
- Fixed a bug in the xss_clean function due to a PHP bug that affects some versions of html_entity_decode.
- Fixed a validation bug that was preventing rules from being set twice in one controller.
- Fixed a calendar bug that was not letting it use dynamically loaded languages.
- Fixed a bug in the active record class when using WHERE clauses with LIKE
- Fixed a bug in the hash() security helper.
- Fixed some typos.

## Version 1.3.2

Release Date: April 17, 2006

- Changed the behavior of the validation class such that if a "required" rule is NOT explicitly stated for a field then all other tests get ignored.
- Fixed a bug in the Controller class that was causing it to look in the local "init" folder instead of the main system one.
- Fixed a bug in the init_pagination file. The $config item was not being set correctly.
- Fixed a bug in the auto typography helper that was causing inconsistent behavior.
- Fixed a couple bugs in the Model class.
- Fixed some documentation typos and errata.

## Version 1.3.1

Release Date: April 11, 2006

- Added a Unit Testing Library.
- Added the ability to pass objects to the insert() and update() database functions. This feature enables you to (among other things) use your Model class variables to run queries with. See the Models page for details.
- Added the ability to pass objects to the view loading function: $this->load->view('my_view', $object);
- Added `getwhere` function to Active Record class.
- Added `count_all` function to Active Record class.
- Added language file for scaffolding and fixed a scaffolding bug that occurs when there are no rows in the specified table.
- Added $this->db->last_query(), which allows you to view your last query that was run.
- Added a new mime type to the upload class for better compatibility.
- Changed how cache files are read to prevent PHP errors if the cache file contains an XML tag, which PHP wants to interpret as a short tag.
- Fixed a bug in a couple of the active record functions (where and orderby).
- Fixed a bug in the image library when realpath() returns false.
- Fixed a bug in the Models that was preventing libraries from being used within them.
- Fixed a bug in the "exact_length" function of the validation class.
- Fixed some typos in the user guide

## Version 1.3

Release Date: April 3, 2006

- Added support for Models.
- Redesigned the database libraries to support additional RDBMs (Postgre, MySQLi, etc.).
- Redesigned the Active Record class to enable more varied types of queries with simpler syntax, and advanced features like JOINs.
- Added a feature to the database class that lets you run custom function calls.
- Added support for private functions in your controllers. Any controller function name that starts with an underscore will not be served by a URI request.
- Added the ability to pass your own initialization parameters to your custom core libraries when using $this->load->library()
- Added support for running standard query string URLs. These can be optionally enabled in your config file.
- Added the ability to specify a "suffix", which will be appended to your URLs. For example, you could add .html to your URLs, making them appear static. This feature is enabled in your config file.
- Added a new error template for use with native PHP errors.
- Added "alternator" function in the string helpers.
- Removed slashing from the input class. After much debate we decided to kill this feature.
- Change the commenting style in the scripts to the PEAR standard so that IDEs and tools like phpDocumenter can harvest the comments.
- Added better class and function name-spacing to avoid collisions with user developed classes. All CodeIgniter classes are now prefixed with CI_ and all controller methods are prefixed with _ci to avoid controller collisions. A list of reserved function names can be found here.
- Redesigned how the "CI" super object is referenced, depending on whether PHP 4 or 5 is being run, since PHP 5 allows a more graceful way to manage objects that utilizes a bit less resources.
- Deprecated: $this->db->use_table() has been deprecated. Please read the Active Record page for information.
- Deprecated: $this->db->smart_escape_str() has been deprecated. Please use this instead: $this->db->escape()
- Fixed a bug in the exception handler which was preventing some PHP errors from showing up.
- Fixed a typo in the URI class. $this->total_segment() should be plural: $this->total_segments()
- Fixed some typos in the default calendar template
- Fixed some typos in the user guide

## Version 1.2

Release Date: March 21, 2006

- Redesigned some internal aspects of the framework to resolve scoping problems that surfaced during the beta tests. The problem was most notable when instantiating classes in your constructors, particularly if those classes in turn did work in their constructors.
- Added a global function named get_instance() allowing the main CodeIgniter object to be accessible throughout your own classes.
- Added new File Helper: delete_files()
- Added new URL Helpers: base_url(), index_page()
- Added the ability to create your own core libraries and store them in your local application directory.
- Added an `overwrite` option to the Upload class, enabling files to be overwritten rather than having the file name appended.
- Added Javascript Calendar plugin.
- Added search feature to user guide. Note: This is done using Google, which at the time of this writing has not crawled all the pages of the docs.
- Updated the parser class so that it allows tag pars within other tag pairs.
- Fixed a bug in the DB "where" function.
- Fixed a bug that was preventing custom config files to be auto-loaded.
- Fixed a bug in the mysql class bind feature that prevented question marks in the replacement data.
- Fixed some bugs in the xss_clean function

## Version Beta 1.1

Release Date: March 10, 2006

- Added a Calendaring class.
- Added support for running multiple applications that share a common CodeIgniter backend.
- Moved the "uri protocol" variable from the index.php file into the config.php file
- Fixed a problem that was preventing certain function calls from working within constructors.
- Fixed a problem that was preventing the $this->load->library function from working in constructors.
- Fixed a bug that occurred when the session class was loaded using the auto-load routine.
- Fixed a bug that can happen with PHP versions that do not support the E_STRICT constant
- Fixed a data type error in the form_radio function (form helper)
- Fixed a bug that was preventing the xss_clean function from being called from the validation class.
- Fixed the cookie related config names, which were incorrectly specified as $conf rather than $config
- Fixed a pagination problem in the scaffolding.
- Fixed a bug in the mysql class "where" function.
- Fixed a regex problem in some code that trimmed duplicate slashes.
- Fixed a bug in the br() function in the HTML helper
- Fixed a syntax mistake in the form_dropdown function in the Form Helper.
- Removed the "style" attributes form the form helpers.
- Updated the documentation. Added "next/previous" links to each page and fixed various typos.

## Version Beta 1.0

Release Date: February 28, 2006

First publicly released version.