From ca06da4b58aa38617ee8bb2f4c4d5c6a58e59db0 Mon Sep 17 00:00:00 2001 From: Derek Allard Date: Sat, 19 Jan 2008 17:55:42 +0000 Subject: guide fixes, remove 1.5.5 update file --- user_guide/database/active_record.html | 26 +++----- user_guide/installation/upgrade_155.html | 101 ------------------------------- 2 files changed, 7 insertions(+), 120 deletions(-) delete mode 100644 user_guide/installation/upgrade_155.html diff --git a/user_guide/database/active_record.html b/user_guide/database/active_record.html index 696b71171..4ba5bfd96 100644 --- a/user_guide/database/active_record.html +++ b/user_guide/database/active_record.html @@ -311,7 +311,7 @@ $this->db->or_where('id >', $id);

Generates a WHERE field IN ('item', 'item') SQL query joined with OR if appropriate

$names = array('Frank', 'Todd', 'James');
- $this->db->where_in_or('username', $names);
+ $this->db->or_where_in('username', $names);
// Produces: OR WHERE username IN ('Frank', 'Todd', 'James')

$this->db->where_not_in();

@@ -325,22 +325,9 @@ $this->db->or_where('id >', $id);

Generates a WHERE field NOT IN ('item', 'item') SQL query joined with OR if appropriate

$names = array('Frank', 'Todd', 'James');
- $this->db->where_in('username', $names);
+ $this->db->or_where_not_in('username', $names);
// Produces: OR WHERE username NOT IN ('Frank', 'Todd', 'James')

-

$this->db->raw_where();

-

Generates an unfiltered WHERE portion of the query exactly as the developer passes it. Separates multiple calls with AND
- $this->db->raw_where('(grade > 50 AND grade < 75)');
- // Produces: AND WHERE (grade > 50 AND grade < 75)

- -

$this->db->raw_or_where();

-

Generates an unfiltered WHERE portion of the query exactly as the developer passes it. Separates multiple calls with OR
- $this->db->raw_where('(grade > 50 AND grade < 75)');
- // Produces: OR WHERE (grade > 50 AND grade < 75)

- -

Note: All values passed through raw_where() and raw_or_where() are not escaped automatically, or otherwise touched. It is the responsibility of the developer to ensure all queries are safe. Consider using protect_identifiers() and escaping your queries as appropriate.

- -

$this->db->like();

This function enables you to generate LIKE clauses, useful for doing searches.

@@ -403,7 +390,7 @@ $this->db->or_like('body', $match); $this->db->like('title', 'match');
$this->db->or_not_like('body', 'match');

-// WHERE title LIKE '%match% OR body NOT LIKE 'match' +// WHERE title LIKE '%match% OR body NOT LIKE '%match%'

$this->db->group_by();

Permits you to write the GROUP BY portion of your query:

@@ -430,14 +417,15 @@ $this->db->or_not_like('body', 'match');

Permits you to write the HAVING portion of your query:

$this->db->having('user_id = 45'); -

// Produces: HAVING 'user_id = 45' - +

+// Produces: HAVING user_id = 45

You can also pass an array of multiple values as well:

$this->db->having(array('title =' => 'My Title', 'id <' => $id)); -

// Produces: HAVING title = 'My Title', 'id < 45' +

+// Produces: HAVING title = 'My Title', id < 45 diff --git a/user_guide/installation/upgrade_155.html b/user_guide/installation/upgrade_155.html deleted file mode 100644 index 33f6d6d69..000000000 --- a/user_guide/installation/upgrade_155.html +++ /dev/null @@ -1,101 +0,0 @@ - - - - -CodeIgniter User Guide : Upgrading from 1.5.3 to 1.5.4 - - - - - - - - - - - - - - - - - - - - - - -
- - - - - -

CodeIgniter User Guide Version 1.5.4

-
- - - - - - - - - -
- - -
- - - -
- -

Upgrading from 1.5.4 to 1.5.5

- -

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 these files and directories in your "system" folder with the new versions:

- - - -

Note: If you have any custom developed files in these folders please make copies of them first.

- -

Step 2: Add time_to_update to your config.php

-

Add the following to system/application/config/config.php with the other

-$config['sess_time_to_update'] = 300; -

Step 3: Update your user guide

-

Please also replace your local copy of the user guide with the new version.

- -
- - - - - - - \ No newline at end of file -- cgit v1.2.3-24-g4f1b