CodeIgniter for Oracle: ADOdb Database Abstraction vs CodeIgniter Database Library

Share

Early last year, I got the chance to learn and develop a huge web application using CodeIgniter PHP Framework. It was my first project using the framework so at that time we have decided to avoid using CodeIgniter default Database Library in fear of incompatibility with oci8 or Oracle10g.

Only afterward did I got a chance to test out CodeIgniter Database Library or ActiveRecord Library on project using MySQL. At this point, the simplicity of ActiveRecord really caught my attention but how would it be enough compared to ADOdb when using Oracle Database?
[Click here to read more...]

Regular Expression Rules in Form Validation for Ext.CodeIgniter

Share

logoYes, I have a problem with CodeIgniter built-in Form Validation Library, the lack of direct Regular Expression test/rule is a huge turn off for me especially when I need to use Regular Expression to as a rule to verify user input.

There are alternative with the use of “callback” to by creating an additional method inside your Controller. The solution is good if you have a complex filtering but why bother when all you need to do is a simple RegExp verification. Based on my Twitter status:

[Click here to read more...]

CRUD Library for Ext.CodeIgniter: An Example

Share

logoOne of the drawback on CodeIgniter is the Scaffolding Class which is only suitable for testing or development stage. In order to do the same functionality you might find in other PHP Framework for CRUD you have to combine few available libraries in CodeIgniter including Table, Pagination, Form Validation and etc. All the libraries are great but you will end up having to write a long list of function and code to do still CRUD process.

To make the learning process much easier to understand I would actually try to convert CodeIgniter From Scratch: Day 5 – CRUD from Nettuts+ from using available libraries to Ext.CodeIgniter CRUD Library.

Requirements and Basic Informations

  • is based and developed on CodeIgniter 1.7.1, it might work with previous version but please do test it out first.
  • requires Table, Pagination, Form (Ext.CodeIgniter Library), Form Validation libraries and Form helper.
  • callback can be optimized with Template Library for Ext.CodeIgniter.
  • your model code can be minimized with ActiveRecord, you may require more works if using raw SQL.

[Click here to read more...]

Template Library for Ext.CodeIgniter

Share

logo

For someone who spent 3 years maintaining my own PHP Framework I find it hard to understand why CodeIgniter bundle in a Template Library. There are actually a few good 3rd party Template Engine which you can find for CodeIgniter but let me share with you a port over Template Library for my so call own PHP Framework.

Requirements and Basic Informations

  • is based and developed on CodeIgniter 1.7.1, it might work with previous version but please do test it out first.
  • the library is build on top of Loader and Output Library allowing you to fully utilize caching, profiler output etc.
  • support Parser Library.

[Click here to read more...]

Database Table Prefix in CodeIgniter

Share

I must say one of the main reason why I started to look into ActiveRecord for CodeIgniter was the availability to use database table name prefix.

|    ['dbprefix'] You can add an optional prefix, which will be added
|                 to the table name when using the  Active Record class
$db['default']['dbprefix'] = "feed_";

For example: TABLE feed_item

$this->db->get('item');

Many might not know that you can also use it with normal database query using 'swap_pre'. In ./system/application/config/database.php

|    ['dbprefix'] You can add an optional prefix, which will be added
|                 to the table name when using the  Active Record class
$db['default']['dbprefix'] = "feed_";
$db['default']['swap_pre'] = "{PRE}";

So now you can actually use.

$sql = "SELECT * FROM {PRE}item";
$query = $this->db->query($sql);