From 11c5f1654d2d13113ad06da46f560628d7e31dd3 Mon Sep 17 00:00:00 2001
From: Aaron Kuzemchak
Date: Sat, 3 Sep 2011 20:59:07 -0400
Subject: Enables real page numbers for URI segment in Pagination library
---
user_guide/libraries/pagination.html | 6 +++++-
1 file changed, 5 insertions(+), 1 deletion(-)
(limited to 'user_guide')
diff --git a/user_guide/libraries/pagination.html b/user_guide/libraries/pagination.html
index 196555441..6a144114d 100644
--- a/user_guide/libraries/pagination.html
+++ b/user_guide/libraries/pagination.html
@@ -119,7 +119,11 @@ something different you can specify it.
The number of "digit" links you would like before and after the selected page number. For example, the number 2
will place two digits on either side, as in the example links at the very top of this page.
-$config['page_query_string'] = TRUE
+
+$config['use_page_numbers'] = TRUE;
+By default, the URI segment will use the starting index for the items you are paginating. If you prefer to show the the actual page number, set this to TRUE.
+
+$config['page_query_string'] = TRUE;
By default, the pagination library assume you are using URI Segments, and constructs your links something like
http://example.com/index.php/test/page/20
If you have $config['enable_query_strings'] set to TRUE your links will automatically be re-written using Query Strings. This option can also be explictly set. Using $config['page_query_string'] set to TRUE, the pagination link will become.
--
cgit v1.2.3-24-g4f1b
From 6f5b52bfd80319c3bba3ae57fb636df3890fe8f7 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 | 1 +
1 file changed, 1 insertion(+)
(limited to 'user_guide')
diff --git a/user_guide/installation/upgrading.html b/user_guide/installation/upgrading.html
index 58a45ee9d..0f4a29bfd 100644
--- a/user_guide/installation/upgrading.html
+++ b/user_guide/installation/upgrading.html
@@ -60,6 +60,7 @@ Upgrading from a Previous Version
Please read the upgrade notes corresponding to the version you are upgrading from.
+ - 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
--
cgit v1.2.3-24-g4f1b
From 45697901e4a44ecf1411a21a6014c8ff16e20c91 Mon Sep 17 00:00:00 2001
From: saintnicster
Date: Wed, 14 Sep 2011 16:30:21 -0500
Subject: Copied into GitHub from @kenjis 's bitbucket
repo.https://bitbucket.org/kenjis/ci-user-guide/changeset/3d579dd14afe
---
user_guide/database/active_record.html | 37 +++++++++++++++++++++++++++++++++-
1 file changed, 36 insertions(+), 1 deletion(-)
(limited to 'user_guide')
diff --git a/user_guide/database/active_record.html b/user_guide/database/active_record.html
index 10259a4af..70aecbdb5 100644
--- a/user_guide/database/active_record.html
+++ b/user_guide/database/active_record.html
@@ -543,7 +543,7 @@ $data = array(
)
);
-$this->db->update_batch('mytable', $data);
+$this->db->insert_batch('mytable', $data);
// Produces: INSERT INTO mytable (title, name, date) VALUES ('My title', 'My name', 'My date'), ('Another title', 'Another name', 'Another date')
@@ -666,6 +666,41 @@ You can optionally pass this information directly into the update function as a
You may also use the $this->db->set() function described above when performing updates.
+$this->db->update_batch();
+Generates an update string based on the data you supply, and runs the query. You can either pass an
+array or an object to the function. Here is an example using an array:
+
+
+$data = array(
+ array(
+ 'title' => 'My title' ,
+ 'name' => 'My Name 2' ,
+ 'date' => 'My date 2'
+ ),
+ array(
+ 'title' => 'Another title' ,
+ 'name' => 'Another Name 2' ,
+ 'date' => 'Another date 2'
+ )
+);
+
+$this->db->update_batch('mytable', $data, 'title');
+
+// Produces:
+// UPDATE `mytable` SET `name` = CASE
+// WHEN `title` = 'My title' THEN 'My Name 2'
+// WHEN `title` = 'Another title' THEN 'Another Name 2'
+// ELSE `name` END,
+// `date` = CASE
+// WHEN `title` = 'My title' THEN 'My date 2'
+// WHEN `title` = 'Another title' THEN 'Another date 2'
+// ELSE `date` END
+// WHERE `title` IN ('My title','Another title')
+
+The first parameter will contain the table name, the second is an associative array of values, the third parameter is the where key.
+
+Note: All values are escaped automatically producing safer queries.
+
Deleting Data
--
cgit v1.2.3-24-g4f1b
From badaf2f3389502f02e086f7e34818ad52065213b Mon Sep 17 00:00:00 2001
From: Andrey Andreev
Date: Sat, 17 Sep 2011 21:58:21 +0300
Subject: Update the ChangeLog
---
user_guide/changelog.html | 1 +
1 file changed, 1 insertion(+)
(limited to 'user_guide')
diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index 8dd64a3a2..b86204438 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -91,6 +91,7 @@ Change Log
-
Added additional option 'none' for the optional third argument for $this->db->like() in the Database Driver.
+ - Added support for the configured database character set in OCI8 driver.
Libraries
--
cgit v1.2.3-24-g4f1b
From 4f04b81bb03587cf8c81513b18fa08c27dba8352 Mon Sep 17 00:00:00 2001
From: Andrey Andreev
Date: Sat, 17 Sep 2011 22:01:14 +0300
Subject: Updated ChangeLog.
---
user_guide/changelog.html | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
(limited to 'user_guide')
diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index b86204438..8a4a70642 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -91,7 +91,6 @@ Change Log
Added additional option 'none' for the optional third argument for $this->db->like() in the Database Driver.
- Added support for the configured database character set in OCI8 driver.
Libraries
@@ -129,6 +128,7 @@ Change Log
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.
Version 2.0.3
--
cgit v1.2.3-24-g4f1b
From 44e6182d2e50aef657511660b96486a2c8f8d78d Mon Sep 17 00:00:00 2001
From: Aaron Kuzemchak
Date: Tue, 20 Sep 2011 21:29:30 -0400
Subject: Updating changelog
---
user_guide/changelog.html | 1 +
1 file changed, 1 insertion(+)
(limited to 'user_guide')
diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index fb6e4493a..ad4f6c703 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -97,6 +97,7 @@ Change Log
Added max_filename_increment config setting for Upload library.
CI_Loader::_ci_autoloader() is now a protected method.
Added is_unique to the Form Validation library.
+ Added $config['use_page_numbers'] to the Pagination library, which enables real page numbers in the URI.
Core
--
cgit v1.2.3-24-g4f1b
From ef3e2402b22a7687730520971c27bec466b5167d Mon Sep 17 00:00:00 2001
From: Andrey Andreev
Date: Wed, 21 Sep 2011 14:39:29 +0300
Subject: Fix issue #182 in system/database/drivers/oci8_result.php by caching
the num_rows property after statement execution
---
user_guide/changelog.html | 1 +
1 file changed, 1 insertion(+)
(limited to 'user_guide')
diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index 8a4a70642..b205d5e3b 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -129,6 +129,7 @@ Change Log
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.
Version 2.0.3
--
cgit v1.2.3-24-g4f1b
From 19277f05c20a3de4beaebcac722659a0ed30a374 Mon Sep 17 00:00:00 2001
From: Adrian Macneil
Date: Thu, 22 Sep 2011 11:17:58 -0700
Subject: Documented third $after_field parameter of dbforge->add_column()
---
user_guide/database/forge.html | 4 ++++
1 file changed, 4 insertions(+)
(limited to 'user_guide')
diff --git a/user_guide/database/forge.html b/user_guide/database/forge.html
index 6b8709892..528d1a24c 100644
--- a/user_guide/database/forge.html
+++ b/user_guide/database/forge.html
@@ -201,6 +201,10 @@ already be running, since the forge class relies on it.
$this->dbforge->add_column('table_name', $fields);
// gives ALTER TABLE table_name ADD preferences TEXT
+An optional third parameter can be used to specify which existing column to add the new column after.
+
+$this->dbforge->add_column('table_name', $fields, 'after_field');
+
$this->dbforge->drop_column()
Used to remove a column from a table.
$this->dbforge->drop_column('table_name', 'column_to_drop');
--
cgit v1.2.3-24-g4f1b
From 99c6dd49e61c463499d1e50945ac29a3f383ec48 Mon Sep 17 00:00:00 2001
From: Andrey Andreev
Date: Fri, 23 Sep 2011 03:07:01 +0300
Subject: Add ->db->insert_batch() support to the OCI8 (Oracle) driver
---
user_guide/changelog.html | 1 +
1 file changed, 1 insertion(+)
(limited to 'user_guide')
diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index 8a4a70642..950a0d482 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -91,6 +91,7 @@ Change Log
Added additional option 'none' for the optional third argument for $this->db->like() in the Database Driver.
+ Added $this->db->insert_batch() support to the OCI8 (Oracle) driver.
Libraries
--
cgit v1.2.3-24-g4f1b