Upgrading from 2.0.2 to 2.0.3

Upgrading from 2.0.2 to 2.1.0

Before performing an update you should take your site offline by replacing the index.php file with a static one.

diff --git a/user_guide/installation/upgrade_b11.html b/user_guide/installation/upgrade_b11.html index 7cf06cd9d..dc3c1f07c 100644 --- a/user_guide/installation/upgrade_b11.html +++ b/user_guide/installation/upgrade_b11.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/installation/upgrading.html b/user_guide/installation/upgrading.html index 58a45ee9d..d69b6bc9c 100644 --- a/user_guide/installation/upgrading.html +++ b/user_guide/installation/upgrading.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

@@ -60,7 +60,7 @@ Upgrading from a Previous Version

Please read the upgrade notes corresponding to the version you are upgrading from.

Upgrading from 2.0.2 to 2.0.3
Upgrading from 2.0.2 to 2.1.0
Upgrading from 2.0.1 to 2.0.2
Upgrading from 2.0 to 2.0.1
Upgrading from 1.7.2 to 2.0

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/caching.html b/user_guide/libraries/caching.html index 9b503f6d1..9808aaa51 100644 --- a/user_guide/libraries/caching.html +++ b/user_guide/libraries/caching.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/calendar.html b/user_guide/libraries/calendar.html index 724c08f8b..2abc43975 100644 --- a/user_guide/libraries/calendar.html +++ b/user_guide/libraries/calendar.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/cart.html b/user_guide/libraries/cart.html index f1e8473e7..b867b709c 100644 --- a/user_guide/libraries/cart.html +++ b/user_guide/libraries/cart.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/config.html b/user_guide/libraries/config.html index d522bbc5b..08b612e77 100644 --- a/user_guide/libraries/config.html +++ b/user_guide/libraries/config.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/email.html b/user_guide/libraries/email.html index d246254ab..7fc56d55b 100644 --- a/user_guide/libraries/email.html +++ b/user_guide/libraries/email.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/encryption.html b/user_guide/libraries/encryption.html index 5c64127cb..6ec629f96 100644 --- a/user_guide/libraries/encryption.html +++ b/user_guide/libraries/encryption.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/file_uploading.html b/user_guide/libraries/file_uploading.html index a88c67220..2cb1ef5ea 100644 --- a/user_guide/libraries/file_uploading.html +++ b/user_guide/libraries/file_uploading.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/form_validation.html b/user_guide/libraries/form_validation.html index d9d8a4502..2028bcd2c 100644 --- a/user_guide/libraries/form_validation.html +++ b/user_guide/libraries/form_validation.html @@ -27,7 +27,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/ftp.html b/user_guide/libraries/ftp.html index 6c7ed5c65..3dbb0530e 100644 --- a/user_guide/libraries/ftp.html +++ b/user_guide/libraries/ftp.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/image_lib.html b/user_guide/libraries/image_lib.html index 475f02a56..1caf791d8 100644 --- a/user_guide/libraries/image_lib.html +++ b/user_guide/libraries/image_lib.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/input.html b/user_guide/libraries/input.html index 311f76ee9..cfb0d5e1e 100644 --- a/user_guide/libraries/input.html +++ b/user_guide/libraries/input.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/javascript.html b/user_guide/libraries/javascript.html index 09530e246..3dda1fd69 100644 --- a/user_guide/libraries/javascript.html +++ b/user_guide/libraries/javascript.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/language.html b/user_guide/libraries/language.html index 1f670ea4b..a9afcef90 100644 --- a/user_guide/libraries/language.html +++ b/user_guide/libraries/language.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/loader.html b/user_guide/libraries/loader.html index af27176ad..53440c53c 100644 --- a/user_guide/libraries/loader.html +++ b/user_guide/libraries/loader.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/migration.html b/user_guide/libraries/migration.html new file mode 100644 index 000000000..ed99044d1 --- /dev/null +++ b/user_guide/libraries/migration.html @@ -0,0 +1,176 @@ + + + + + +Migration Class : CodeIgniter User Guide + + + + + + + + + + + + + + + + + + + +

+ + + + + + + + + + +

+ + +
+ + + +

+ + +

Migration Class

+ +

Migrations are a convenient way for you to alter your database in a structured and organized manner. You could edit fragments of SQL by hand but you would then be responsible for telling other developers that they need to go and run them. You’d also have to keep track of which changes need to be run against the production machines next time you deploy.

+ +

The database table migration tracks which migrations have already been run so all you have to do is update your application files and call $this->migrate->current() to work out which migrations should be run. The current version is found in config/migration.php.

+ +

Create a Migration

+ +

This will be the first migration for a new site which has a blog. All migrations go in the folder application/migrations/ and have names such as: 001_add_blog.php.

+ +

+defined('BASEPATH') OR exit('No direct script access allowed');
+
+class Migration_Add_blog extends CI_Migration {
+
+	public function up()
+	{
+		$this->dbforge->add_field(array(
+			'blog_id' => array(
+				'type' => 'INT',
+				'constraint' => 5,
+				'unsigned' => TRUE,
+				'auto_increment' => TRUE
+			),
+			'blog_title' => array(
+				'type' => 'VARCHAR',
+				'constraint' => '100',
+			),
+			'blog_description' => array(
+				'type' => 'TEXT',
+				'null' => TRUE,
+			),
+		));
+		
+		$this->dbforge->create_table('blog');
+	}
+
+	public function down()
+	{
+		$this->dbforge->drop_table('blog');
+	}
+

+ +

Then in application/config/migration.php set $config['migration_version'] = 1;. + +

Usage Example

+ +

In this example some simple code is placed in application/controllers/migrate.php to update the schema.

+ +

+$this->load->library('migration');
+
+if ( ! $this->migration->current())
+{
+	show_error($this->migration->error_string());
+}
+

+ + +

Function Reference

+ +

$this->migration->current()

+ +

The current migration is whatever is set for $config['migration_version'] in application/config/migration.php.

+ + +

$this->migration->latest()

+ +

This works much the same way as current() but instead of looking for the $config['migration_version'] the Migration class will use the very newest migration found in the filesystem.

+ +

$this->migration->version()

+ +

Version can be used to roll back changes or step forwards programmatically to specific versions. It works just like current but ignores $config['migration_version'].

+ +

+$this->load->library('migration');
+
+$this->migration->version(5);
+

+ +

Migration Preferences

+ +

The following is a list of all the config options for migrations.

+ + + + + + + + + + + + + + + +

Preference	Default Value	Options	Description
migration_enabled	FALSE	TRUE / FALSE	Enable or disable migrations.
migration_version	0	None	The current version your database should use.
migration_path	APPPATH.'migrations/'	None	The path to your migrations folder.

+ + +

+ + + + + + + \ No newline at end of file diff --git a/user_guide/libraries/output.html b/user_guide/libraries/output.html index 7361d7961..77fe464ce 100644 --- a/user_guide/libraries/output.html +++ b/user_guide/libraries/output.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/pagination.html b/user_guide/libraries/pagination.html index 196555441..b5f971f5a 100644 --- a/user_guide/libraries/pagination.html +++ b/user_guide/libraries/pagination.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/parser.html b/user_guide/libraries/parser.html index b8a53452e..f449145ac 100644 --- a/user_guide/libraries/parser.html +++ b/user_guide/libraries/parser.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/security.html b/user_guide/libraries/security.html index dd62a4386..ad1d9ae86 100644 --- a/user_guide/libraries/security.html +++ b/user_guide/libraries/security.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/sessions.html b/user_guide/libraries/sessions.html index e09c31db3..dfb732491 100644 --- a/user_guide/libraries/sessions.html +++ b/user_guide/libraries/sessions.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/table.html b/user_guide/libraries/table.html index 1f34dd9e2..003916ef3 100644 --- a/user_guide/libraries/table.html +++ b/user_guide/libraries/table.html @@ -27,7 +27,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/trackback.html b/user_guide/libraries/trackback.html index a2912a594..035158463 100644 --- a/user_guide/libraries/trackback.html +++ b/user_guide/libraries/trackback.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/typography.html b/user_guide/libraries/typography.html index cd287933c..12be119cc 100644 --- a/user_guide/libraries/typography.html +++ b/user_guide/libraries/typography.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/unit_testing.html b/user_guide/libraries/unit_testing.html index 5ebec0cbf..7d27ff1dd 100644 --- a/user_guide/libraries/unit_testing.html +++ b/user_guide/libraries/unit_testing.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/uri.html b/user_guide/libraries/uri.html index 0e1c26f1e..f04bb9f10 100644 --- a/user_guide/libraries/uri.html +++ b/user_guide/libraries/uri.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/user_agent.html b/user_guide/libraries/user_agent.html index e1d3640d3..8b3dcee62 100644 --- a/user_guide/libraries/user_agent.html +++ b/user_guide/libraries/user_agent.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/xmlrpc.html b/user_guide/libraries/xmlrpc.html index 3635c221b..bb939dff4 100644 --- a/user_guide/libraries/xmlrpc.html +++ b/user_guide/libraries/xmlrpc.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/libraries/zip.html b/user_guide/libraries/zip.html index 21cf8017a..53fc71ef3 100644 --- a/user_guide/libraries/zip.html +++ b/user_guide/libraries/zip.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/license.html b/user_guide/license.html index a0d694f2e..f9769a417 100644 --- a/user_guide/license.html +++ b/user_guide/license.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/overview/appflow.html b/user_guide/overview/appflow.html index fbc68fab0..61bf907a6 100644 --- a/user_guide/overview/appflow.html +++ b/user_guide/overview/appflow.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/overview/at_a_glance.html b/user_guide/overview/at_a_glance.html index 641c04b22..7e93bd2a6 100644 --- a/user_guide/overview/at_a_glance.html +++ b/user_guide/overview/at_a_glance.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/overview/cheatsheets.html b/user_guide/overview/cheatsheets.html index b7b10b90c..60e655229 100644 --- a/user_guide/overview/cheatsheets.html +++ b/user_guide/overview/cheatsheets.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/overview/features.html b/user_guide/overview/features.html index 5f71c5083..d1d5c8c25 100644 --- a/user_guide/overview/features.html +++ b/user_guide/overview/features.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/overview/getting_started.html b/user_guide/overview/getting_started.html index 2b6b3f288..ad6fa01ed 100644 --- a/user_guide/overview/getting_started.html +++ b/user_guide/overview/getting_started.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/overview/goals.html b/user_guide/overview/goals.html index 6acaa65a2..f2263c7ae 100644 --- a/user_guide/overview/goals.html +++ b/user_guide/overview/goals.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/overview/index.html b/user_guide/overview/index.html index 08e61e283..f295d4e81 100644 --- a/user_guide/overview/index.html +++ b/user_guide/overview/index.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/overview/mvc.html b/user_guide/overview/mvc.html index 4721cbf67..4aebb1095 100644 --- a/user_guide/overview/mvc.html +++ b/user_guide/overview/mvc.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/tutorial/conclusion.html b/user_guide/tutorial/conclusion.html index ccf89175f..9cf146746 100644 --- a/user_guide/tutorial/conclusion.html +++ b/user_guide/tutorial/conclusion.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/tutorial/create_news_items.html b/user_guide/tutorial/create_news_items.html index 48c82c799..26b1ed10f 100644 --- a/user_guide/tutorial/create_news_items.html +++ b/user_guide/tutorial/create_news_items.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/tutorial/hard_coded_pages.html b/user_guide/tutorial/hard_coded_pages.html index 408634a78..b34e9f1be 100644 --- a/user_guide/tutorial/hard_coded_pages.html +++ b/user_guide/tutorial/hard_coded_pages.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/tutorial/index.html b/user_guide/tutorial/index.html index 4f665fe0a..65075fb2a 100644 --- a/user_guide/tutorial/index.html +++ b/user_guide/tutorial/index.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/tutorial/news_section.html b/user_guide/tutorial/news_section.html index b2d883184..cf3377ff9 100644 --- a/user_guide/tutorial/news_section.html +++ b/user_guide/tutorial/news_section.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

diff --git a/user_guide/tutorial/static_pages.html b/user_guide/tutorial/static_pages.html index 26c8306e1..da2c58cda 100644 --- a/user_guide/tutorial/static_pages.html +++ b/user_guide/tutorial/static_pages.html @@ -28,7 +28,7 @@

- +

CodeIgniter User Guide Version 2.0.3

CodeIgniter User Guide Version 2.1.0

Table of Contents Page

-- cgit v1.2.3-24-g4f1b From 5543fd7ba20a1ddc9bdd0fb9505c1de310e9b833 Mon Sep 17 00:00:00 2001 From: Phil Sturgeon Date: Thu, 27 Oct 2011 01:55:56 +0100 Subject: Added long missing Migration documentation. --- user_guide/nav/nav.js | 1 + user_guide/toc.html | 3 ++- 2 files changed, 3 insertions(+), 1 deletion(-) (limited to 'user_guide') diff --git a/user_guide/nav/nav.js b/user_guide/nav/nav.js index bc668ec27..b9b6e0943 100644 --- a/user_guide/nav/nav.js +++ b/user_guide/nav/nav.js @@ -103,6 +103,7 @@ function create_menu(basepath) '

' + '

' + '

' + + '

' + '

' + '

' + '

' + diff --git a/user_guide/toc.html b/user_guide/toc.html index bd6aaf510..01b5a7b92 100644 --- a/user_guide/toc.html +++ b/user_guide/toc.html @@ -29,7 +29,7 @@ @@ -157,6 +157,7 @@ Table of Contents

-- cgit v1.2.3-24-g4f1b From c53eb99a7cc5a49d2de7e96445146d88cf873f90 Mon Sep 17 00:00:00 2001 From: Phil Sturgeon Date: Thu, 27 Oct 2011 01:59:29 +0100 Subject: Removed PEAR snipe. --- user_guide/index.html | 1 - 1 file changed, 1 deletion(-) (limited to 'user_guide') diff --git a/user_guide/index.html b/user_guide/index.html index ac6d0f7f6..fa90983e1 100644 --- a/user_guide/index.html +++ b/user_guide/index.html @@ -77,7 +77,6 @@ minimizing the amount of code needed for a given task.

You want a framework that requires nearly zero configuration.

You want a framework that does not require you to use the command line.

You want a framework that does not require you to adhere to restrictive coding rules.

You are not interested in large-scale monolithic libraries like PEAR.

You do not want to be forced to learn a templating language (although a template parser is optionally available if you desire one).

You eschew complexity, favoring simple solutions.

You need clear, thorough documentation.

-- cgit v1.2.3-24-g4f1b From 9744670222ba409c05a857c61daf0a0a5fac8774 Mon Sep 17 00:00:00 2001 From: Phil Sturgeon Date: Thu, 27 Oct 2011 02:03:03 +0100 Subject: Removed a bunch of PHP 5 specific messages from FTP documentation. --- user_guide/libraries/ftp.html | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) (limited to 'user_guide') diff --git a/user_guide/libraries/ftp.html b/user_guide/libraries/ftp.html index 3dbb0530e..175efe19b 100644 --- a/user_guide/libraries/ftp.html +++ b/user_guide/libraries/ftp.html @@ -74,7 +74,7 @@ and deleted. The FTP class also includes a "mirroring" function that permits an

Usage Examples

In this example a connection is opened to the FTP server, and a local file is read and uploaded in ASCII mode. The -file permissions are set to 755. Note: Setting permissions requires PHP 5.

+file permissions are set to 755.


 $this->load->library('ftp');

@@ -185,8 +185,7 @@ Example:
 Mode options are:  ascii, binary, and auto (the default). If
 auto is used it will base the mode on the file extension of the source file.
 
-Permissions are available if you are running PHP 5 and can be passed as an octal value in the fourth parameter.
-
+Permissions can be passed as an octal value in the fourth parameter.
 
 $this->ftp->download()
 
@@ -267,7 +266,7 @@ $this->ftp->mirror('/path/to/myfolder/', '/public_html/myfolder/');
 $this->ftp->mkdir()
 
 Lets you create a directory on your server.  Supply the path ending in the folder name you wish to create, with a trailing slash.
-Permissions can be set by passed an octal value in the second parameter (if you are running PHP 5).
+Permissions can be set by passed an octal value in the second parameter.
 
 
 // Creates a folder named "bar"

-- 
cgit v1.2.3-24-g4f1b


From fd82e02ee3636ed7feeedfeefeef794cf77c3a70 Mon Sep 17 00:00:00 2001
From: Phil Sturgeon 
Date: Sun, 4 Sep 2011 13:55:28 +0100
Subject: Removed reference is IS_CLI in the documentation, which should have
 been $this->input->is_cli_request()

---
 user_guide/general/cli.html | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'user_guide')

diff --git a/user_guide/general/cli.html b/user_guide/general/cli.html
index 70ab13802..5dda24b56 100644
--- a/user_guide/general/cli.html
+++ b/user_guide/general/cli.html
@@ -83,7 +83,7 @@ Running via the CLI
 
 
 	Run your cron-jobs without needing to use wget or curl
-	Make your cron-jobs inaccessible from being loaded in the URL by checking for IS_CLI
+	Make your cron-jobs inaccessible from being loaded in the URL by checking for $this->input->is_cli_request()
 	Make interactive "tasks" that can do things like set permissions, prune cache folders, run backups, etc.
 	Integrate with other applications in other languages. For example, a random C++ script could call one command and run code in your models!
 
-- 
cgit v1.2.3-24-g4f1b


From 0a4fe3128341264999e0826b4fbb55cfa441a619 Mon Sep 17 00:00:00 2001
From: mmestrovic 
Date: Thu, 1 Sep 2011 03:30:43 +0300
Subject: Updated download links for current and older versions.

---
 user_guide/installation/downloads.html | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'user_guide')

diff --git a/user_guide/installation/downloads.html b/user_guide/installation/downloads.html
index 5420dec8d..074fd8bcd 100644
--- a/user_guide/installation/downloads.html
+++ b/user_guide/installation/downloads.html
@@ -58,7 +58,9 @@ Downloading CodeIgniter
 Downloading CodeIgniter
 
 
-	CodeIgniter V 2.0.2 (Current version)
+	CodeIgniter V 2.1.0 (Current version)
+	CodeIgniter V 2.0.3
+	CodeIgniter V 2.0.2
 	CodeIgniter V 2.0.1
 	CodeIgniter V 2.0.0
 	CodeIgniter V 1.7.3
-- 
cgit v1.2.3-24-g4f1b


From 33d0502628df3e45b26d2a4075929016b2a7f8a8 Mon Sep 17 00:00:00 2001
From: Greg Aker 
Date: Sat, 20 Aug 2011 16:53:52 -0500
Subject: Removing duplicate instructions in the 2.0.3 update instructions.

---
 user_guide/installation/upgrade_203.html | 12 ++++--------
 1 file changed, 4 insertions(+), 8 deletions(-)

(limited to 'user_guide')

diff --git a/user_guide/installation/upgrade_203.html b/user_guide/installation/upgrade_203.html
index 2a0ab52be..3aceb7ff1 100644
--- a/user_guide/installation/upgrade_203.html
+++ b/user_guide/installation/upgrade_203.html
@@ -65,25 +65,21 @@ Upgrading from 2.0.2 to 2.1.0
 Replace all files and directories in your "system" folder and replace your index.php file. If any modifications were made to your index.php they will need to be made fresh in this new one.
 
 Note: If you have any custom developed files in these folders please make copies of them first.
-
-Step 2: Update CodeIgniter files
-
-Replace the files and directories in your "system" folder with the new versions:
 	
-Step 3: Update your main index.php file
+Step 2: Update your main index.php file
 
 If you are running a stock index.php file simply replace your version with the new one.
 
 If your index.php file has internal modifications, please add your modifications to the new file and use it.
 
-Step 4: Replace config/user_agents.php
+Step 3: Replace config/user_agents.php
 
 This config file has been updated to contain more user agent types, please copy it to application/config/user_agents.php.
 
-Step 5: Change references of the EXT constant to ".php"
+Step 4: Change references of the EXT constant to ".php"
 Note: The EXT Constant has been marked as deprecated, but has not been removed from the application.  You are encouraged to make the changes sooner rather than later.
 
-Step 6: Remove APPPATH.'third_party' from autoload.php
+Step 5: Remove APPPATH.'third_party' from autoload.php
 
 Open application/autoload.php, and look for the following:
 
-- 
cgit v1.2.3-24-g4f1b


From 7fdfd219ab64a8dc8436a2897cea3982ff8253c5 Mon Sep 17 00:00:00 2001
From: mmestrovic 
Date: Wed, 14 Sep 2011 01:26:15 +0300
Subject: Added link: "Upgrading from 2.0.3 to 2.1.0"

---
 user_guide/installation/upgrading.html | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'user_guide')

diff --git a/user_guide/installation/upgrading.html b/user_guide/installation/upgrading.html
index d69b6bc9c..c3f5ae6dd 100644
--- a/user_guide/installation/upgrading.html
+++ b/user_guide/installation/upgrading.html
@@ -60,7 +60,8 @@ Upgrading from a Previous Version
 Please read the upgrade notes corresponding to the version you are upgrading from.
 
 
-	Upgrading from 2.0.2 to 2.1.0
+	Upgrading from 2.0.3 to 2.1.0
+	Upgrading from 2.0.2 to 2.0.3
 	Upgrading from 2.0.1 to 2.0.2
 	Upgrading from 2.0 to 2.0.1
 	Upgrading from 1.7.2 to 2.0
-- 
cgit v1.2.3-24-g4f1b


From f7149f2562c6173f617b32538f438a1be3a4398d Mon Sep 17 00:00:00 2001
From: Phil Sturgeon 
Date: Thu, 27 Oct 2011 12:42:01 +0100
Subject: Added upgrade guide for 2.1.0.

---
 user_guide/installation/upgrade_203.html |  4 +-
 user_guide/installation/upgrade_210.html | 89 ++++++++++++++++++++++++++++++++
 2 files changed, 91 insertions(+), 2 deletions(-)
 create mode 100644 user_guide/installation/upgrade_210.html

(limited to 'user_guide')

diff --git a/user_guide/installation/upgrade_203.html b/user_guide/installation/upgrade_203.html
index 3aceb7ff1..d0d37677f 100644
--- a/user_guide/installation/upgrade_203.html
+++ b/user_guide/installation/upgrade_203.html
@@ -42,7 +42,7 @@
 
 CodeIgniter Home  › 
 User Guide Home  › 
-Upgrading from 2.0.2 to 2.1.0
+Upgrading from 2.0.2 to 2.0.3
 
 Search User Guide   
 
@@ -55,7 +55,7 @@ Upgrading from 2.0.2 to 2.1.0
 
 
 
-Upgrading from 2.0.2 to 2.1.0
+Upgrading from 2.0.2 to 2.0.3
 
 Before performing an update you should take your site offline by replacing the index.php file with a static one.
 
diff --git a/user_guide/installation/upgrade_210.html b/user_guide/installation/upgrade_210.html
new file mode 100644
index 000000000..7edab2e7d
--- /dev/null
+++ b/user_guide/installation/upgrade_210.html
@@ -0,0 +1,89 @@
+
+
+
+
+
+Upgrading from 2.0.2 to 2.1.0 : CodeIgniter User Guide
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+CodeIgniter User Guide Version 2.1.0 Table of Contents Page
+
+
+
+
+
+
+
+
+
+
+
+CodeIgniter Home  › 
+User Guide Home  › 
+Upgrading from 2.0.2 to 2.1.0
+ Search User Guide   
+
+
+

+
+
+
+
+
+Upgrading from 2.0.3 to 2.1.0
+
+Before performing an update you should take your site offline by replacing the index.php file with a static one.
+
+Step 1: Update your CodeIgniter files
+
+Replace all files and directories in your "system" folder and replace your index.php file. If any modifications were made to your index.php they will need to be made fresh in this new one.
+
+Note: If you have any custom developed files in these folders please make copies of them first.
+	
+Step 2: Replace config/user_agents.php
+
+This config file has been updated to contain more user agent types, please copy it to application/config/user_agents.php.
+
+
+
+
+
+
+
+
+Previous Topic:  Installation Instructions
+   ·  
+Top of Page   ·  
+User Guide Home   ·  
+Next Topic:  Troubleshooting
+
+CodeIgniter  ·  Copyright © 2006 - 2011  ·  EllisLab, Inc.
+
+
+
+
\ No newline at end of file
-- 
cgit v1.2.3-24-g4f1b


From f2bae2cb50d040e17ca0323b394a60499e639834 Mon Sep 17 00:00:00 2001
From: Phil Sturgeon 
Date: Thu, 27 Oct 2011 12:46:52 +0100
Subject: Corrected 2.0.3 to 2.1.0.

---
 user_guide/installation/upgrade_203.html | 2 +-
 user_guide/installation/upgrade_210.html | 4 ++--
 2 files changed, 3 insertions(+), 3 deletions(-)

(limited to 'user_guide')

diff --git a/user_guide/installation/upgrade_203.html b/user_guide/installation/upgrade_203.html
index d0d37677f..d4b703af0 100644
--- a/user_guide/installation/upgrade_203.html
+++ b/user_guide/installation/upgrade_203.html
@@ -3,7 +3,7 @@
 
 
 
-Upgrading from 2.0.2 to 2.1.0 : CodeIgniter User Guide
+Upgrading from 2.0.2 to 2.0.3 : CodeIgniter User Guide
 
 
 
diff --git a/user_guide/installation/upgrade_210.html b/user_guide/installation/upgrade_210.html
index 7edab2e7d..d9a7213a9 100644
--- a/user_guide/installation/upgrade_210.html
+++ b/user_guide/installation/upgrade_210.html
@@ -3,7 +3,7 @@
 
 
 
-Upgrading from 2.0.2 to 2.1.0 : CodeIgniter User Guide
+Upgrading from 2.0.3 to 2.1.0 : CodeIgniter User Guide
 
 
 
@@ -42,7 +42,7 @@
 
 CodeIgniter Home  › 
 User Guide Home  › 
-Upgrading from 2.0.2 to 2.1.0
+Upgrading from 2.0.3 to 2.1.0
 
 Search User Guide   
 
-- 
cgit v1.2.3-24-g4f1b


From e06f2cb3700edd13426af4b66d3f2a4d0fefd080 Mon Sep 17 00:00:00 2001
From: Phil Sturgeon 
Date: Thu, 27 Oct 2011 13:00:00 +0100
Subject: Updated changelog.

---
 user_guide/changelog.html | 25 ++++++++++++++++++++++++-
 1 file changed, 24 insertions(+), 1 deletion(-)

(limited to 'user_guide')

diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index 35946a217..faa96b82f 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -79,6 +79,7 @@ Change Log
 	Database
 		
 			Added a CUBRID driver to the Database Driver. Thanks to the CUBRID team for supplying this patch.
+			Added a PDO driver to the Database Driver.
 			Typecast limit and offset in the Database Driver to integers to avoid possible injection.
 		
 	
@@ -88,6 +89,13 @@ Change Log
 			Added support to set an optional parameter in your callback rules of validation using the Form Validation Library.
 			Added a Migration Library to assist with applying incremental updates to your database schema.
 			Driver children can be located in any package path.
+			
+		
+	
+	Core
+		
+			Changed private functions in CI_URI to protected so MY_URI can override them.
+			Removed CI_CORE boolean constant from CodeIgniter.php (there are no longer Reactor and Core versions).
 		
 	
 
@@ -97,7 +105,22 @@ Change Log
 	Fixed #378 Robots identified as regular browsers by the User Agent class.
 	If a config class was loaded first then a library with the same name is loaded, the config would be ignored.
 	Fixed a bug (Reactor #19) where 1) the 404_override route was being ignored in some cases, and 2) auto-loaded libraries were not available to the 404_override controller when a controller existed but the requested method did not.
-	Fixed a bug (Reactor #89) where MySQL export would fail if the table had hyphens or other non alphanumeric/underscore characters.
+	Fixed a bug (Reactor #89) where MySQL export would fail if the table had hyphens or other non alphanumeric/underscore characters.
+	Fixed a bug (#200) where MySQL queries would be malformed after calling count_all() then db->get()
+	Fixed bug #105 that stopped query errors from being logged unless database debugging was enabled
+	Fixed a bug (#181) where a mis-spelling was in the form validation language file.
+	Fixed a bug (#160) - Removed unneeded array copy in the file cache driver.
+	Fixed a bug (#150) - field_data() now correctly returns column length.
+	Fixed a bug (#8) - load_class() now looks for core classes in APPPATH first, allowing them to be replaced.
+	Fixed a bug (#24) - ODBC database driver called incorrect parent in __construct().
+	Fixed a bug (#85) - OCI8 (Oracle) database escape_str() function did not escape correct.
+	Fixed a bug (#344) - Using schema found in Saving Session Data to a Database, system would throw error "user_data does not have a default value" when deleting then creating a session.
+	Fixed a bug (#112) - OCI8 (Oracle) driver didn't pass the configured database character set when connecting.
+	Fixed a bug (#182) - OCI8 (Oracle) driver used to re-execute the statement whenever num_rows() is called.
+	Fixed a bug (#82) - WHERE clause field names in the DB update_string() method were not escaped, resulting in failed queries in some cases.
+	Fixed a bug (#89) - Fix a variable type mismatch in DB display_error() where an array is expected, but a string could be set instead.
+	Fixed a bug (#467) - Suppress warnings generated from get_magic_quotes_gpc() (deprecated in PHP 5.4)
+	Fixed a bug (#484) - First time _csrf_set_hash() is called, hash is never set to the cookie (in Security.php).
 	Fixed a bug (#60) - Added _file_mime_type() method to the File Uploading Library in order to fix a possible MIME-type injection (also fixes bug #394).
 	Fixed a bug (#537) - Support for all wav type in browser.
 	Fixed a bug (#576) - Using ini_get() function to detect if apc is enabled or not.
-- 
cgit v1.2.3-24-g4f1b


From da6aa15a41c2286ca161d036a02f6857ce060e27 Mon Sep 17 00:00:00 2001
From: Nithin Meppurathu 
Date: Sun, 21 Aug 2011 12:05:17 -0400
Subject: updated changelog and documentation for active record new 3rd
 argument option #none# to like clause

---
 user_guide/changelog.html              | 3 +++
 user_guide/database/active_record.html | 7 +++++++
 2 files changed, 10 insertions(+)

(limited to 'user_guide')

diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index faa96b82f..37dcaea45 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -81,6 +81,8 @@ Change Log
 			Added a CUBRID driver to the Database Driver. Thanks to the CUBRID team for supplying this patch.
 			Added a PDO driver to the Database Driver.
 			Typecast limit and offset in the Database Driver to integers to avoid possible injection.
+			Added additional option 'none' for the optional third argument for $this->db->like() in the Database Driver.
+


 	
 	Libraries
@@ -124,6 +126,7 @@ Change Log
 	
Fixed a bug (#60) - Added _file_mime_type() method to the File Uploading Library in order to fix a possible MIME-type injection (also fixes bug #394).
 	Fixed a bug (#537) - Support for all wav type in browser.
 	Fixed a bug (#576) - Using ini_get() function to detect if apc is enabled or not.
+	Fixed a bug (#160) - Removed unneeded array copy in the file cache driver.

+ + +

Tutorial − News section

+ +

In the last section, we went over some basic concepts of the framework by writing a class that includes static pages. We cleaned up the URI by adding custom routing rules. Now it's time to introduce dynamic content and start using a database.

+ +

Setting up your model

+ +

Instead of writing database operations right in the controller, queries should be placed in a model, so they can easily be reused later. Models are the place where you retrieve, insert, and update information in your database or other data stores. They represent your data.

+ +

Open up the application/models directory and create a new file called news_model.php and add the following code. Make sure you've configured your database properly as described here.

+ +

+<?php
+class News_model extends CI_Model {
+
+	function __construct()
+	{
+		$this->load->database();
+
+	}
+}
+

+ +

This code looks similar to the controller code that was used earlier. It creates a new model by extending CI_Model and loads the database library. This will make the database class available through the $this->db object.

+ +

Before querying the database, a database schema has to be created. Connect to your database and run the SQL command below. Also add some seed records.

+ +

+CREATE TABLE news (
+	id int(11) NOT NULL AUTO_INCREMENT,
+	title varchar(128) NOT NULL,
+	slug varchar(128) NOT NULL,
+	text text NOT NULL,
+	PRIMARY KEY (id),
+	KEY slug (slug)
+);
+

+ +

Now that the database and a model have been set up, you'll need a method to get all of our posts from our database. To do this, the database abstraction layer that is included with CodeIgniter — ActiveRecord — is used. This makes it possible to write your 'queries' once and make them work on all supported database systems. Add the following code to your model.

+ +

+function get_news($slug = FALSE)
+{
+	if ($slug === FALSE)
+	{
+		$query = $this->db->get('news');
+		return $query->result_array();
+
+	}
+	else
+	{
+		$query = $this->db->get_where('news', array('slug' => $slug));
+		return $query->row_array();
+
+	}
+
+}
+

+ +

With this code you can perform two different queries. You can get all news records, or get a news item by its slug. You might have noticed that the $slug variable wasn't sanitized before running the query; Active Record does this for you.

+ +

Display the news

+ +

Now that the queries are written, the model should be tied to the views that are going to display the news items to the user. This could be done in our pages controller created earlier, but for the sake of clarity, a new "news" controller is defined. Create the new controller at application/controllers/news.php.

+ +

+<?php
+class News extends CI_Controller{
+
+	function __construct()
+	{
+		parent::__construct();
+		$this->load->model('news_model');
+
+	}
+
+	function index()
+	{
+		$data['news'] = $this->news_model->get_news();
+
+	}
+
+	function view($slug)
+	{
+		$data['news'] = $this->news_model->get_news($slug);
+
+	}
+
+}
+

+ +

Looking at the code, you may see some similarity with the files we created earlier. First, the "__construct" method: it calls the constructor of its parent class (CI_Controller) and loads the model, so it can be used in all other methods in this controller.

+ +

Next, there are two methods to view all news items and one for a specific news item. You can see that the $slug variable is passed to the model's method in the second method. The model is using this slug to identify the news item to be returned.

+ +

Now the data is retrieved by the controller through our model, but nothing is displayed yet. The next thing to do is passing this data to the views.

+ +

+function index()
+{
+	$data['news'] = $this->news_model->get_news();
+	$data['title'] = 'News archive';
+
+	$this->load->view('templates/header', $data);
+	$this->load->view('news/index', $data);
+	$this->load->view('templates/footer');
+
+}
+

+ +

The code above gets all news records from the model and assigns it to a variable. The value for the title is also assigned to the $data['title'] element and all data is passed to the views. You now need to create a view to render the news items. Create application/views/news/index.php and add the next piece of code.

+ +

+<?php foreach ($news as $news_item): ?>
+
+    <h2><?php echo $news_item['title'] ?></h2>
+    <div id="main">
+        <?php echo $news_item['text'] ?>
+    </div>
+    <p><a href="news/<?php echo $news_item['slug'] ?>">View article</a></p>
+
+<?php endforeach ?>
+

+ +

Here, each news item is looped and displayed to the user. You can see we wrote our template in PHP mixed with HTML. If you prefer to use a template language, you can use CodeIgniter's Template Parser class or a third party parser.

+ +

The news overview page is now done, but a page to display individual news items is still absent. The model created earlier is made in such way that it can easily be used for this functionality. You only need to add some code to the controller and create a new view. Go back to the news controller and add the following lines to the file.

+ +

+function view($slug)
+{
+	$data['news_item'] = $this->news_model->get_news($slug);
+
+	if (empty($data['news_item']))
+	{
+		show_404();
+	}
+
+	$data['title'] = $data['news_item']['title'];
+
+	$this->load->view('templates/header', $data);
+	$this->load->view('news/view', $data);
+	$this->load->view('templates/footer');
+
+}
+

+ +

Instead of calling the get_news() method without a parameter, the $slug variable is passed, so it will return the specific news item. The only things left to do is create the corresponding view at application/views/news/view.php. Put the following code in this file.

+ +

+<?php
+echo '<h2>' . $news_item['title'] . '</h2>';
+echo $news_item['text'];
+

+ +

Routing

Because of the wildcard routing rule created earlier, you need need an extra route to view the controller that you just made. Modify your routing file (application/config/routes.php) so it looks as follows. This makes sure the requests reaches the news controller instead of going directly to the pages controller. The first line routes URI's with a slug to the view method in the news controller.

+ +

+$route['news/(:any)'] = 'news/view/$1';
+$route['news'] = 'news';
+$route['(:any)'] = 'pages/view/$1';
+$route['default_controller'] = 'pages/view';
+

+ +

Point your browser to your document root, followed by index.php/news and watch your news page.

+ +

wrapchars	76		Character count to wrap at.
mailtype	text	text or html	Type of mail. If you send HTML email you must send it as a complete web page. Make sure you don't have any relative links or relative image paths otherwise they will not work.	mailtype	text	text or html	Type of mail. If you send HTML email you must send it as a complete web page. Make sure you don't have any relative links or relative image paths otherwise they will not work.
charset	utf-8		Character set (utf-8, iso-8859-1, etc.).
validate	FALSE	TRUE or FALSE (boolean)	Whether to validate the email address.	validate	FALSE	TRUE or FALSE (boolean)	Whether to validate the email address.
priority	3	1, 2, 3, 4, 5	Email Priority. 1 = highest. 5 = lowest. 3 = normal.	priority	3	1, 2, 3, 4, 5	Email Priority. 1 = highest. 5 = lowest. 3 = normal.
crlf
$legacy_mode	MCRYPT_MODE_ECB	The Mcrypt mode that was used to generate the original encrypted data. CodeIgniter 1.x's default was MCRYPT_MODE_ECB, and it will +	The Mcrypt mode that was used to generate the original encrypted data. CodeIgniter 1.x's default was MCRYPT_MODE_ECB, and it will assume that to be the case unless overridden by this parameter.
$key	n/a	The encryption key. This it typically specified in your config file as outlined above.	The encryption key. This it typically specified in your config file as outlined above.

upload_path	None	None	The path to the folder where the upload should be placed. The folder must be writable and the path can be absolute or relative.	The path to the folder where the upload should be placed. The folder must be writable and the path can be absolute or relative.
allowed_types	None	None	The mime types corresponding to the types of files you allow to be uploaded. Usually the file extension can be used as the mime type. Separate multiple types with a pipe.	The mime types corresponding to the types of files you allow to be uploaded. Usually the file extension can be used as the mime type. Separate multiple types with a pipe.
None	Desired file name	- If set CodeIgniter will rename the uploaded file to this name. The extension provided in the file name must also be an allowed file type. + If set CodeIgniter will rename the uploaded file to this name. The extension provided in the file name must also be an allowed file type.
max_size	0	None	The maximum size (in kilobytes) that the file can be. Set to zero for no limit. Note: Most PHP installations have their own limit, as specified in the php.ini file. Usually 2 MB (or 2048 KB) by default.	The maximum size (in kilobytes) that the file can be. Set to zero for no limit. Note: Most PHP installations have their own limit, as specified in the php.ini file. Usually 2 MB (or 2048 KB) by default.
max_width	0	None	The maximum width (in pixels) that the file can be. Set to zero for no limit.	The maximum width (in pixels) that the file can be. Set to zero for no limit.
max_height	0	None	The maximum height (in pixels) that the file can be. Set to zero for no limit.	The maximum height (in pixels) that the file can be. Set to zero for no limit.
max_filename	0	None	The maximum length that a file name can be. Set to zero for no limit.	The maximum length that a file name can be. Set to zero for no limit.
The file name without the extension
orig_name	The original file name. This is only useful if you use the encrypted name option.
The original file name. This is only useful if you use the encrypted name option.
client_name	The file name as supplied by the client user agent, prior to any file name preparation or incrementing.
The file size in kilobytes
is_image	Whether the file is an image or not. 1 = image. 0 = not.
Whether the file is an image or not. 1 = image. 0 = not.
image_width	Image width.
Image height
image_type	Image type. Typically the file extension without the period.
Image type. Typically the file extension without the period.
image_size_str	A string containing the width and height. Useful to put into an image tag.
A string containing the width and height. Useful to put into an image tag.

Bug fixes for 2.0.1

Version 2.0.0

Version 2.0.0

Version 1.5.3

$this->db->get();

$this->db->where_in();

$this->db->group_by();

$this->db->distinct();

$this->db->or_having();

$this->db->order_by();

$this->db->count_all_results();

$this->db->count_all();

$this->db->insert();

$this->db->insert_batch();

Updating Data

$this->db->update();

Method Chaining

How are Cache Files Stored?

Managing your Cache Files

$this->db->cache_on() / $this->db->cache_off()

$this->db->cache_delete_all()

Active Record

Database Quick Start: Example Code

Standard Query With Multiple Results (Object Version)

Standard Query With Multiple Results (Array Version)

Testing for Results

Standard Query With Single Result (Array version)

Standard Insert

$this->db->field_exists()

$this->dbforge->add_field()

Passing strings as fields

Adding Keys

Dropping a table

Renaming a table

$this->dbforge->drop_column()

$this->db->affected_rows()

$this->db->count_all();

$this->db->last_query();

$this->db->simple_query();

result_array()

row()

row_array()

$query->num_fields()

$query->free_result()

$this->db->list_tables();

$this->db->table_exists();

Transactions

CodeIgniter's Approach to Transactions

Strict Mode

Enabling Transactions

$this->dbutil->database_exists();

$this->dbutil->xml_from_result($db_result)

$this->dbutil->backup()

Usage Example

Foo Class

Alternate PHP Syntax for View Files

Automatic Short Tag Support

Alternative Control Structures

How Does Caching Work?

Deleting Caches

is_really_writable('path/to/file')

set_status_header(code, 'text');

Let's try it: Hello World!

Loading multiple views

Storing Views within Sub-folders

Returning views as data

element()

random_element()

elements()

set_cookie()

get_cookie()

delete_cookie()

now()

mdate()

local_to_gmt()

gmt_to_local()

human_to_unix()

days_in_month()

read_file('path')

write_file('path', $data)

`$this->db->where_in();`

is_really_writable('`path/to/file`')

set_status_header(`code`, '`text`');

read_file('`path`')

write_file('`path`', `$data`)

delete_files('`path`')

get_dir_file_info('`path/to/directory/`', `$top_level_only` = TRUE)

get_file_info('`path/to/file`', `$file_information`)

get_mime_by_extension('`file`')

symbolic_permissions(`$perms`)