Latest Items : PHP CodeIgniter
I used SQLite3 in CodeIgniter2.0.1.
I made this SQLite3 in local environment.
【Environment】
・OSX MAMP PHP5.3
・SQLite3
【Tool】
・MAMP SQLiteManager
・SQLite Database Browser
・Firefox SQLite Manage
【I used PHP File】
・ http://codeigniter.com/wiki/PDO_SQLite3/
【Special Thanks】
・@shikoku2011
I got a lot of advice from him.
I thank him very much!!!
【Workflow】
(1) http://codeigniter.com/wiki/PDO_SQLite3/
The zip file is downloaded.
*Uniform resource locator of the file is this.
http://codeigniter.com/wiki/File:sqlite3_pdo_driver_0_02_by_xi.zip/
(2) system/database/drivers/pdo/ I installed a file in this.
(3) config/database.php I wrote a code.
【config/database.php】
$active_group = 'default';
$active_record = TRUE;
$db['default']['hostname'] = '';
$db['default']['username'] = '';
$db['default']['password'] = '';
$db['default']['database'] = 'sqlite:'.APPPATH.'database/report.sql3';
$db['default']['dbdriver'] = 'pdo';
/*
//I change it in comment :)
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = '';
$db['default']['dbcollat'] = '';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;
*/
[2] Goodby var_dump! Welcome Profiler of CodeIgniter!!!
This is a continuance of the last report.
http://press.nekoget.com/report/detail/1008/en
I expanded CI_Profiler Class.
I think that I must not be able to see profiler with the genuine server.
file path : application/libraries/MY_Profiler.php
The function that I added a hand to is run().
....Omission....
public function run()
{
if($this->CI->config->item("genuine_url")
&& $this->CI->config->item("genuine_url") == $this->CI->config->item("base_url")
)
{
return FALSE;
}
....Omission....
}
I wrote $config["genuine_url"] on config.php.
If I did not write it,I take this as a development environment and should display a result of profiler.
Because I wrote it, it answers false if I judged it with genuine environment, and It should answer a result of profiler if it is environment of the development.
Because Profiler Class serves as a duty, I can write it in this way.
$this->output->enable_profiler();
Goodby var_dump! Welcome Profiler of CodeIgniter!!!
Hi! PHP User.
Do you use 'var_dump' ?
I use it very frequently.
var_dump! var_dump! var_dump!!!
However, I did not use it very much.
(I use it a little)
Why?
I have begun to use CodeIgniter.
There is a very convenient library in CodeIgniter.
It is profiler.
This image is profiler of CodeIgniter. This image extracted it.
(This system use language file is Japanese.Therefore the text in the image is written in Japanese.)
I wanted to make it easy to use this library more.And I challenged it.
http://d.hatena.ne.jp/localdisk/20110521/1305964812
I referred to this BLOG.
(1) I make view file.
file path : /application/views/profiler.php
jquery is necessary for this javascript code.<script type="text/javascript">
//<!--
$(function(){
if ($('#codeigniter_profiler').length > 0) {
var prof = $('<div>', {
id: 'profiler',
html: $('<img>', {
id : 'profiler_button',
height: 35,
width: 178,
alt: 'Toggle Profiler',
title: 'Toggle Profiler',
src: '<?php echo base_url(); ?>common/images/profiler/nav_toggle_darker.png'
})
});
$('body').prepend(prof);
$('body').prepend($('#codeigniter_profiler'));
$('#profiler').css('text-align', 'right');
$('#profiler').css('border-top', '10px #000 solid');
$('#codeigniter_profiler').css('display', 'none');
$('#codeigniter_profiler').css('background', '#FFF');
$('#codeigniter_profiler').click(function () {
$('#codeigniter_profiler').slideToggle();
});
$('#profiler_button').hover(function(){
this.orgImage = $(this).attr('src');
this.rolloverImage = this.orgImage.replace(/(\.gif|\.jpg|\.png)/, "_on$1");
$(this).attr('src',this.rolloverImage);
},function(){
$(this).attr('src',this.orgImage);
});
}
});
// -->
</script>
My Impression : Study event of CodeIgniter in Tokyo
I participated in an event performed in Shinjuku on May 14.
It is event participation after a long absence.
The meeting place went over 80 people on that day.
The seat was Standing room only.
A lot of power supplies were a certain good meeting places.
The announcement of all people is splendid and is interesting.