I have seen a few people asking how to load a view from a database (or something other than a physical file in the “views” folder).
In my particular case, a client wants the ability to edit HTML and TEXT email templates. Without giving them direct access to editing the physical files, I decided to move the views being used for email to the database instead. Continue reading
I can’t remember what all I looked at for references, but this completed tool will generate the SQL commands necessary to convert your database, tables and fields from any collation and character set into another.
It goes without saying to make a backup of your database before running such commands. If you don’t make a backup first, shame on you 
Continue reading
Load the helper:
$this->load->helper(‘database’);
Call the function:
$enums = field_enums(‘table_name’, ‘field_name’);
For a while I had been wanting to author a generic database table model for CodeIgniter. Here are the results of those efforts… Continue reading
I had a problem where CodeIgniter sessions stored in the database were creating multiple session_id’s (each time the session library was called) for the same user.
Here is how my session configuration is defined…
$config['sess_cookie_name'] = 'my-session'; $config['sess_expiration'] = 60*60*2; //2 hours $config['sess_expire_on_close'] = TRUE; $config['sess_encrypt_cookie'] = FALSE; $config['sess_use_database'] = TRUE; $config['sess_table_name'] = 'sessions'; $config['sess_match_ip'] = FALSE; $config['sess_match_useragent'] = TRUE; $config['sess_time_to_update'] = 300;
Here is the updated table structure…
CREATE TABLE IF NOT EXISTS `sessions` ( `session_id` varchar(32) NOT NULL default '0', `ip_address` varchar(16) NOT NULL default '0', `user_agent` varchar(255) NOT NULL, `last_activity` int(10) unsigned NOT NULL default '0', `user_data` text NOT NULL, PRIMARY KEY (`session_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
My solution… First, I increased the user_agent field to 255 characters in length. Then, since session_id is always 32 characters in length, I reduced that from 40. If you have any other suggestions, feel free to leave a comment.
Hope this helps someone else having the same problem with CodeIgniter sessions that are being stored in the database 