- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

@@ -45,7 +45,7 @@ window.onload = function() {

-Code Igniter Home › +CodeIgniter Home › User Guide Home › Database Library › Active Record @@ -66,10 +66,10 @@ Active Record

Active Record Class

Code Igniter uses a modified version of the Active Record Database Pattern. +

CodeIgniter uses a modified version of the Active Record Database Pattern. This pattern allows information to be retrieved, inserted, and updated in your database with minimal scripting. In some cases only one or two lines of code are necessary to perform a database action. -Code Igniter does not require that each database table be its own class file. It instead provides a more simplified interface.

+CodeIgniter does not require that each database table be its own class file. It instead provides a more simplified interface.

Beyond simplicity, a major benefit to using the Active Record features is that it allows you to create database independent applications, since the query syntax is generated by each database adapter. It also allows for safer queries, since the values are escaped automatically by the system.

@@ -146,7 +146,7 @@ $query = $this->db->get('mytable');

// Produces: SELECT title, content, date FROM mytable -

Note: If you are selecting all (*) from a table you do not need to use this function. When omitted, Code Igniter assumes you wish to SELECT *

Note: If you are selecting all (*) from a table you do not need to use this function. When omitted, CodeIgniter assumes you wish to SELECT *

$this->db->from();

@@ -604,7 +604,7 @@ Previous Topic: Query Helper Functions User Guide Home · Next Topic: Transactions

diff --git a/user_guide/database/caching.html b/user_guide/database/caching.html index c39c6fd56..b5248d31a 100644 --- a/user_guide/database/caching.html +++ b/user_guide/database/caching.html @@ -2,7 +2,7 @@ -Code Igniter User Guide +CodeIgniter User Guide @@ -22,7 +22,7 @@ window.onload = function() { - + @@ -33,7 +33,7 @@ window.onload = function() {

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -45,7 +45,7 @@ window.onload = function() {

-Code Igniter Home › +CodeIgniter Home › User Guide Home › Database Library › Database Caching Class @@ -86,7 +86,7 @@ when caching is enabled. Do NOT load this class manually.

How Does Caching Work?

Code Igniter's query caching system happens dynamically when your pages are viewed. +

CodeIgniter's query caching system happens dynamically when your pages are viewed. When caching is enabled, the first time a web page is loaded, the query result object will be serialized and stored in a text file on your server. The next time the page is loaded the cache file will be used instead of accessing your database. Your database usage can effectively be reduced to zero for any pages that have been cached.

@@ -113,7 +113,7 @@ single answer to the question of whether you should cache your database. It rea

How are Cache Files Stored?

Code Igniter places the result of EACH query into its own cache file. Sets of cache files are further organized into +

CodeIgniter places the result of EACH query into its own cache file. Sets of cache files are further organized into sub-folders corresponding to your controller functions. To be precise, the sub-folders are named identically to the first two segments of your URI (the controller class name and function name).

@@ -218,7 +218,7 @@ Previous Topic: Custom Function CallsUser Guide Home · Next Topic: Database Utilities Class

diff --git a/user_guide/database/call_function.html b/user_guide/database/call_function.html index 167c5d6f7..f73082fa4 100644 --- a/user_guide/database/call_function.html +++ b/user_guide/database/call_function.html @@ -2,7 +2,7 @@ -Code Igniter User Guide +CodeIgniter User Guide @@ -22,7 +22,7 @@ window.onload = function() { - + @@ -33,7 +33,7 @@ window.onload = function() {

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -45,7 +45,7 @@ window.onload = function() {

-Code Igniter Home › +CodeIgniter Home › User Guide Home › Database Library › Custom Function Calls @@ -66,9 +66,9 @@ Custom Function Calls

$this->db->call_function();

This function enables you to call PHP database functions that are not natively included in Code Igniter, in a platform independent manner. +

This function enables you to call PHP database functions that are not natively included in CodeIgniter, in a platform independent manner. For example, lets say you want to call the mysql_get_client_info() function, which is not natively supported -by Code Igniter. You could do so like this: +by CodeIgniter. You could do so like this:

$this->db->call_function('get_client_info'); @@ -116,7 +116,7 @@ Previous Topic: Field MetaData User Guide Home · Next Topic: Query Caching

diff --git a/user_guide/database/configuration.html b/user_guide/database/configuration.html index cf8958da0..dd883d192 100644 --- a/user_guide/database/configuration.html +++ b/user_guide/database/configuration.html @@ -2,7 +2,7 @@ -Code Igniter User Guide +CodeIgniter User Guide @@ -22,7 +22,7 @@ window.onload = function() { - + @@ -33,7 +33,7 @@ window.onload = function() {

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -45,7 +45,7 @@ window.onload = function() {

-Code Igniter Home › +CodeIgniter Home › User Guide Home › Database Library › Configuration @@ -65,7 +65,7 @@ Configuration

Database Configuration

Code Igniter has a config file that lets you store your database connection values (username, password, database name, etc.). +

CodeIgniter has a config file that lets you store your database connection values (username, password, database name, etc.). The config file is located at:

application/config/database.php

@@ -113,7 +113,7 @@ for the primary connection, but it too can be renamed to something more relevant

password - The password used to connect to the database.

database - The name of the database you want to connect to.

dbdriver - The database type. ie: mysql, postgre, obdc, etc. Must be specified in lower case.

dbprefix - An optional table prefix which will added to the table name when running Active Record queries. This permits multiple Code Igniter installations to share one database.

dbprefix - An optional table prefix which will added to the table name when running Active Record queries. This permits multiple CodeIgniter installations to share one database.

pconnect - TRUE/FALSE (boolean) - Whether to use a persistent connection.

db_debug - TRUE/FALSE (boolean) - Whether database errors should be displayed.

active_r - TRUE/FALSE (boolean) - Whether to load the Active Record Class. If you are not using the active record class you can have it omitted when the database classes are initialized in order to utilize less resources.

@@ -138,7 +138,7 @@ Previous Topic: Quck Start: Usage ExamplesUser Guide Home · Next Topic: Connecting to your Database

diff --git a/user_guide/database/connecting.html b/user_guide/database/connecting.html index f8e55ddf1..011e15345 100644 --- a/user_guide/database/connecting.html +++ b/user_guide/database/connecting.html @@ -2,7 +2,7 @@ -Code Igniter User Guide +CodeIgniter User Guide @@ -22,7 +22,7 @@ window.onload = function() { - + @@ -33,7 +33,7 @@ window.onload = function() {

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -45,7 +45,7 @@ window.onload = function() {

-Code Igniter Home › +CodeIgniter Home › User Guide Home › Database Library › Connecting @@ -165,7 +165,7 @@ Previous Topic: Database ConfigurationUser Guide Home · Next Topic: Queries

diff --git a/user_guide/database/examples.html b/user_guide/database/examples.html index 64ec34739..010f9cd1e 100644 --- a/user_guide/database/examples.html +++ b/user_guide/database/examples.html @@ -2,7 +2,7 @@ -Code Igniter User Guide +CodeIgniter User Guide @@ -22,7 +22,7 @@ window.onload = function() { - + @@ -33,7 +33,7 @@ window.onload = function() {

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -46,7 +46,7 @@ window.onload = function() {

-Code Igniter Home › +CodeIgniter Home › User Guide Home › Database Library › Database Example Code @@ -215,7 +215,7 @@ Previous Topic: Database Class User Guide Home · Next Topic: Database Configuration

diff --git a/user_guide/database/fields.html b/user_guide/database/fields.html index 710fc9171..d390a3172 100644 --- a/user_guide/database/fields.html +++ b/user_guide/database/fields.html @@ -2,7 +2,7 @@ -Code Igniter User Guide +CodeIgniter User Guide @@ -22,7 +22,7 @@ window.onload = function() { - + @@ -33,7 +33,7 @@ window.onload = function() {

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -44,7 +44,7 @@ window.onload = function() {

-Code Igniter Home › +CodeIgniter Home › User Guide Home › Database Library › Field Names @@ -166,7 +166,7 @@ Previous Topic: Table Data User Guide Home · Next Topic: Custom Function Calls

diff --git a/user_guide/database/helpers.html b/user_guide/database/helpers.html index 6c25a557d..685dd8d44 100644 --- a/user_guide/database/helpers.html +++ b/user_guide/database/helpers.html @@ -2,7 +2,7 @@ -Code Igniter User Guide +CodeIgniter User Guide @@ -22,7 +22,7 @@ window.onload = function() { - + @@ -33,7 +33,7 @@ window.onload = function() {

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -45,7 +45,7 @@ window.onload = function() {

-Code Igniter Home › +CodeIgniter Home › User Guide Home › Database Library › Query Helpers @@ -149,7 +149,7 @@ Previous Topic: Query Results User Guide Home · Next Topic: Active Record Pattern

diff --git a/user_guide/database/index.html b/user_guide/database/index.html index 2321675e1..0bb9ce162 100644 --- a/user_guide/database/index.html +++ b/user_guide/database/index.html @@ -2,7 +2,7 @@ -Code Igniter User Guide +CodeIgniter User Guide @@ -22,7 +22,7 @@ window.onload = function() { - + @@ -33,7 +33,7 @@ window.onload = function() {

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -45,7 +45,7 @@ window.onload = function() { @@ -64,7 +64,7 @@ Database Library

The Database Class

Code Igniter comes with a full-featured and very fast abstracted database class that supports both traditional +

CodeIgniter comes with a full-featured and very fast abstracted database class that supports both traditional structures and Active Record patterns. The database functions offer clear, simple syntax.

Config Class

User Guide Home

Quick Start: Usage Examples

Code Igniter User Guide

CodeIgniter User Guide

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -45,7 +45,7 @@ window.onload = function() {

-Code Igniter Home › +CodeIgniter Home › User Guide Home › Database Library › Queries @@ -88,7 +88,7 @@ It simply lets you submit a query. Most users will rarely use this function.

Escaping Queries

It's a very good security practice to escape your data before submitting it into your database. -Code Igniter has two functions that help you do this:

+CodeIgniter has two functions that help you do this:

Connecting to your Database

User Guide Home

Query Results

Code Igniter User Guide

CodeIgniter User Guide

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -45,7 +45,7 @@ window.onload = function() {

-Code Igniter Home › +CodeIgniter Home › User Guide Home › Database Library › Query Results @@ -236,7 +236,7 @@ Previous Topic: Queries User Guide Home · Next Topic: Query Helper Functions

diff --git a/user_guide/database/table_data.html b/user_guide/database/table_data.html index 23fa7c760..6a0177b18 100644 --- a/user_guide/database/table_data.html +++ b/user_guide/database/table_data.html @@ -2,7 +2,7 @@ -Code Igniter User Guide +CodeIgniter User Guide @@ -22,7 +22,7 @@ window.onload = function() { - + @@ -33,7 +33,7 @@ window.onload = function() {

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -45,7 +45,7 @@ window.onload = function() {

-Code Igniter Home › +CodeIgniter Home › User Guide Home › Database Library › Table Data @@ -111,7 +111,7 @@ Previous Topic: Transactions User Guide Home · Next Topic: Field Metadata

diff --git a/user_guide/database/transactions.html b/user_guide/database/transactions.html index d2222e00f..bb7c4369f 100644 --- a/user_guide/database/transactions.html +++ b/user_guide/database/transactions.html @@ -2,7 +2,7 @@ -Code Igniter User Guide +CodeIgniter User Guide @@ -22,7 +22,7 @@ window.onload = function() { - + @@ -33,7 +33,7 @@ window.onload = function() {

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -46,7 +46,7 @@ window.onload = function() {

-Code Igniter Home › +CodeIgniter Home › User Guide Home › Database Library › Transactions @@ -66,7 +66,7 @@ Transactions

Transactions

Code Igniter's database abstraction allows you to use transactions with databases that support transaction-safe table types. In MySQL, you'll need +

CodeIgniter's database abstraction allows you to use transactions with databases that support transaction-safe table types. In MySQL, you'll need to be running InnoDB or BDB table types rather then the more common MyISAM. Most other database platforms support transactions natively.

If you are not familiar with @@ -74,9 +74,9 @@ transactions we recommend you find a good online resource to learn about them fo have a basic understanding of transactions.

Code Igniter's Approach to Transactions

CodeIgniter's Approach to Transactions

Code Igniter utilizes an approach to transactions that is very similar to the process used by the popular database class ADODB. We've chosen that approach +

CodeIgniter utilizes an approach to transactions that is very similar to the process used by the popular database class ADODB. We've chosen that approach because it greatly simplifies the process of running transactions. In most cases all that is required are two lines of code.

Traditionally, transactions have required a fair amount of work to implement since they demand that you to keep track of your queries @@ -191,7 +191,7 @@ Previous Topic: Field MetaData User Guide Home · Next Topic: Table Metadata

diff --git a/user_guide/database/utilities.html b/user_guide/database/utilities.html index f4977b16e..643231057 100644 --- a/user_guide/database/utilities.html +++ b/user_guide/database/utilities.html @@ -2,7 +2,7 @@ -Code Igniter User Guide +CodeIgniter User Guide @@ -22,7 +22,7 @@ window.onload = function() { - + @@ -33,7 +33,7 @@ window.onload = function() {

- +

Code Igniter User Guide Version 1.5.2

CodeIgniter User Guide Version 1.5.3

Table of Contents Page

@@ -45,7 +45,7 @@ window.onload = function() {