Fantasy pig

A happy new year 2011

2011-01-03T02:00:00.000-08:00

A happy new year 2011

Oh my oh, in this first 3 days, I gained a lot. :p
Because the meals were so delicious!

So do you think what is the delicious meal?
It is a Japanese traditional meal called "Osechi"!

It looks colorful flowers isn't it?
Not only an appearance, but also the taste is nice. :)
If you have chance, come to Japan and try it!

Anyway, I wish you will be happy this year! :)

(weight 91.1ｋｇ　BMI 33%)

Try Zend Framework vol.13 "Dispatch Like Mojavi"

2010-11-24T04:39:00.019-08:00

Do you remember "Mojavi" framework? :)
Once upon a time, there was a fantastic framework which is called "Mojavi".
If you were a PHP programmer, once you have probably heard that name.
But, it's not seems to be developed no longer.

So, tonight we look back old days and revive "Mojavi" as Zend dispacher! :)

Before talking about Mojavi, Let's talk about Ruby on Rails and frameworks around it.
After Ruby on Rails (RoR) was shown in the world, it became very famous and common as rapid web development tool.
It gives you cool architecture and the speed until making a product up.
Then many frameworks imitate to RoR, and they became similar to RoR.
And I think Zend Framework is also the one of them. :)

RoR style dispach is very simple and easy to understand, then keeps class and file less. When I saw that architechture first time, I was so impressed of its simpleness.

RoR style is very nice, but it is too hard to throw away Mojavi style.
I think Mojavi style is also simple and easy to identify the area of influence.

To know the diffrences between two styles, let's see both architechtures.
Comparing two of them, let's see Zend Frameworks' default structure.

There are "Model", "Controller" and "Action".

In Zend Framework, the standard dispatcher interprets "Module", "Controller" and "Action" from the executed url.
Actually it depends on the router, but for now , let's think about "Standard" dispatcher. ;)

OK, see the url below.
http://zf.f-pig.net/foo/bar/buz

There are three paths foo, bar and buz, it would be interpreted by dispatcher like this.
1.foo is "Module" and it is "Direcotry".
2.bar is "Controller" and it is "Class file".
3.buz is "Action" and it is "Method" of bar (controller).

And it looks like this.

application/
|~modules/
| |~foo/(module)
| | |~controllers/
| | | `~BarController.php (has "buz" method as action method.)

In BarController.php

class Foo_BarController extends Zend_Controller_Action
{
public function buzAction()
{
// this is buz action.
}
}

OK, that is Zend Framework style.

Then now, let's look back old days!!

From here I'm going to talk about Mojavi Framework style.
Mojavi interprets that url like this.
http://zf.f-pig.net/foo/bar/buz

1. foo is "Moduel" and it is "Directory".
2. bar is "Controller" it is also "Direcotry".
3. buz is "Action" and it is "Class file". It has a method to execute it self.

And it looks like this.

application/
|~modules/
| |~foo/(module)
| | |~controllers/
| | | `~Bar/(controller)
| | |   `-BuzAction.php(action having "execute" method.)

In BuzAction.php

class Foo_Bar_BuzAction extends Zend_Controller_Action
{
// this is action.

public function execute()
{
// this is an executive method of this action "class".
}
}

You may feel Mojavi style is too detailed style, and makes many class files and feel it messy.

But, this Mojavi style sometimes helps you.
There are some situations that Mojavi style can solve.

Case 1.
Let's think, you want to write some method which is for buzAction.
You probably write that method on BarController.
On the one hand, it's pretty normal, because there is no place to write that method,
on the other hand, you need to name that method to specify the aim that the method is for buzAction.

Case 2.
Zend_Controller_Action gives some useful methods like init, preDispatch and postDispatch.
But, these methods are on Controller, so every action method was called it would be called automatically.
Even if you don't want to call preDispatch when another action methods called, it would be called automatically.
Or you may need to write a "if statement" in these methods.

Case 3.
Imagine you are working with many coworkers whose skills are not same level as you.
They may touch a same class at the same project.
And you need to share the class file with them.
A coworker may use generic name even it only work for buzAction.
Once that code is released, it's pretty hard to refactor and release, isn't it?

Oops, I'm talking too much. :)
It's time to write Mojavi dispacher!

To make Mojavi style architecture, we need to make a new dispatcher!
Let's call it "Hoge_Controller_Dispatcher_MojaviLike".
Hoge_Controller_Dispatcher_MojaviLike

<?php
/**
* Hoge_Controller_Dispatcher_MojaviLike
* Dispatch like mojavi.
*/
class Hoge_Controller_Dispatcher_MojaviLike extends Zend_Controller_Dispatcher_Standard
{
/**
* Execute method name.
* @var string
*/
protected $_executeMethod = 'execute';

/**
* Set executable method name.
* @return void
*/
public function setExecuteMethod($name)
{
$this->_executeMethod = $name;
}

/**
* Get executable method name.
* @return executetable method name.
*/
public function getExecuteMethod()
{
return $this->_executeMethod;
}

/**
* Formats a string into a controller name.
* @param string $unformatted
* @return string
*/
public function formatControllerName($unformatted)
{
return ucfirst($this->_formatName($unformatted));
}

/**
* Formats a string into an action name.
* @param string $unformatted
* @return string
*/
public function formatActionName($unformatted)
{
return ucfirst(parent::formatActionName($unformatted));
}

/**
* Get action class name
*
* @param Zend_Controller_Request_Abstract $request
* @return string|false Returns class name on success
*/
public function getActionClass(Zend_Controller_Request_Abstract $request)
{
// controller info.
$controllerName = $request->getControllerName();
if (empty($controllerName)) {
if (!$this->getParam('useDefaultControllerAlways')) {
return false;
}
$controllerName = $this->getDefaultControllerName();
$request->setControllerName($controllerName);
}
$controllerName = $this->formatControllerName($controllerName);


// action info.
$actionName = $request->getActionName();
if (empty($actionName)) {
if (!$this->getParam('useDefaultActionAlways')) {
return false;
}
$actionName = $this->getDefaultAction();
$request->setActionName($actionName);
}
$actionName = $this->formatActionName($actionName);

// build class name.
$className = $controllerName . $this->getPathDelimiter() . $actionName;

$controllerDirs = $this->getControllerDirectory();
$module = $request->getModuleName();
if ($this->isValidModule($module)) {
$this->_curModule    = $module;
$this->_curDirectory = $controllerDirs[$module];
} elseif ($this->isValidModule($this->_defaultModule)) {
$request->setModuleName($this->_defaultModule);
$this->_curModule    = $this->_defaultModule;
$this->_curDirectory = $controllerDirs[$this->_defaultModule];
} else {
require_once 'Zend/Controller/Exception.php';
throw new Zend_Controller_Exception('No default module defined for this application');
}

return $className;
}

/**
* Returns TRUE if the Zend_Controller_Request_Abstract object can be
* @param Zend_Controller_Request_Abstract $action
* @return boolean
*/
public function isDispatchable(Zend_Controller_Request_Abstract $request)
{
$className = $this->getActionClass($request);
if (!$className) {
return false;
}
$finalClass  = $className;
if (($this->_defaultModule != $this->_curModule)
|| $this->getParam('prefixDefaultModule'))
{
$finalClass = $this->formatClassName($this->_curModule, $className);
}
if (class_exists($finalClass, false)) {
return true;
}

$fileSpec    = $this->classToFilename($className);
$dispatchDir = $this->getDispatchDirectory();
$test        = $dispatchDir . DIRECTORY_SEPARATOR . $fileSpec;
return Zend_Loader::isReadable($test);
}

/**
* Dispatch to a controller/action
* @param Zend_Controller_Request_Abstract $request
* @param Zend_Controller_Response_Abstract $response
* @return void
* @throws Zend_Controller_Dispatcher_Exception
*/
public function dispatch(Zend_Controller_Request_Abstract $request, Zend_Controller_Response_Abstract $response)
{
$this->setResponse($response);

/**
* Get action class
*/
if (!$this->isDispatchable($request)) {
$action = $request->getControllerName();
if (!$this->getParam('useDefaultActionAlways') && !empty($action)) {
require_once 'Zend/Controller/Dispatcher/Exception.php';
throw new Zend_Controller_Dispatcher_Exception(
'Invalid controller/action specified (' .
$request->getControllerName() . '/' . $request->getActionName() . ')');
}
$className = $this->getDefaultActionClass($request);
} else {
$className = $this->getActionClass($request);
if (!$className) {
$className = $this->getDefaultActionClass($request);
}
}

/**
* Load the action class file
*/
$className = $this->loadClass($className);

$action = new $className($request, $this->getResponse(), $this->getParams());
if (!($action instanceof Zend_Controller_Action_Interface) &&
!($action instanceof Zend_Controller_Action)) {
require_once 'Zend/Controller/Dispatcher/Exception.php';
throw new Zend_Controller_Dispatcher_Exception(
'Action "' . $className . '" is not an instance of
Zend_Controller_Action_Interface'
);
}

/**
* Retrieve the execution name
*/
$execute = $this->getExecuteMethod();

$request->setDispatched(true);

// by default, buffer output
$disableOb = $this->getParam('disableOutputBuffering');
$obLevel   = ob_get_level();
if (empty($disableOb)) {
ob_start();
}

try {
$action->dispatch($execute);
} catch (Exception $e) {
// Clean output buffer on error
$curObLevel = ob_get_level();
if ($curObLevel > $obLevel) {
do {
ob_get_clean();
$curObLevel = ob_get_level();
} while ($curObLevel > $obLevel);
}
throw $e;
}

if (empty($disableOb)) {
$content = ob_get_clean();
$response->appendBody($content);
}

// Destroy the page controller instance and reflection objects
$action = null;
}

/**
* Retrieve default action class
*
* @param Zend_Controller_Request_Abstract $request
* @return string
*/
public function getDefaultActionClass(Zend_Controller_Request_Abstract $request)
{
$controller = $this->getDefaultControllerName();
$defaultController = $this->formatControllerName($controller);

$action = $this->getDefaultAction();
$defaultAction = $this->formatControllerName($action);

$default = $defaultController . $this->getPathDelimiter() . $defaultAction;

$request->setControllerName($controller)
->setActionName($action);

$module              = $request->getModuleName();
$controllerDirs      = $this->getControllerDirectory();
$this->_curModule    = $this->_defaultModule;
$this->_curDirectory = $controllerDirs[$this->_defaultModule];

if ($this->isValidModule($module)) {
$found = false;
if (class_exists($default, false)) {
$found = true;
} else {
$moduleDir = $controllerDirs[$module];
$fileSpec  = $moduleDir . DIRECTORY_SEPARATOR . $this->classToFilename($default);
if (Zend_Loader::isReadable($fileSpec)) {
$found = true;
$this->_curDirectory = $moduleDir;
}
}
if ($found) {
$request->setModuleName($module);
$this->_curModule = $this->formatModuleName($module);
}
} else {
$request->setModuleName($this->_defaultModule);
}

return $default;
}

To switch dispatcher.

$frontController = Zend_Controller_Front::getInstance();
$frontController->setDispatcher(new Hoge_Controller_Dispatcher_MojaviLike())

With this Mojavi dispacher, Controller class will be Action class.
It looks like this.

application/modules/foo/controllers/Bar/BuzAction.php

<?php
class Foo_Bar_BuzAction extends Zend_Controller_Action
{
/** 
* init
*/
public function init()
{   
$this->view->class = '"' . __CLASS__ . '" class';
$this->view->init = '"' . __FUNCTION__ . '" is called';
}   

/** 
* preDispatch
*/
public function preDispatch()
{   
$this->view->preDispatch = '"' . __FUNCTION__ . '" is called';
}   

/** 
* postDispatch
*/
public function postDispatch()
{   
$this->view->postDispatch = '"' . __FUNCTION__ . '" is called';
}   

/** 
* execute this class. 
*/
public function execute()
{   
$this->view->execute = '"' . __FUNCTION__ . '" is called';
}   
}

How about templates?
There is no need to change anything!

To show registered view values above template looks like this.

application/modules/foo/views/scripts/bar/buz.phtml

<b>Mojavi Like</b>
<? foreach ($this as $key =>  $prop): ?>
<?= $prop ?><br />
<? endforeach ?>

But, I also think Zend style is pretty nice and enough. :)
The Controller and Action method should be as small as they can.
The logic should be written in Model class?! Actually I'm not sure if it should be. :p

But, please don't forget, in the real world,
it's pretty hard that all coworkers write source code beautifully and same style. : <

In these case, "Mojavi" style might help you.

At last, thank Mojavi to appeared in this world. And good bye!! :)

(weight 89.6ｋｇ　BMI 32%)

A happy new year 2010

2010-01-01T07:58:00.002-08:00

A happy new year 2010!
I wish you will be happy this year! :)

(weight 94.6ｋｇ　BMI 34%)

Try Zend Framework vol.12 "Service My Mini City"

2009-02-12T18:16:00.010-08:00

Recentry I got a new work making a web site with php.
Then I luckly to get a chance to use Zend Framework again :)

So, I restarted to try Zend Framework!
But, before trying hard one, I wanted to start trying easy one like Zend_Service.
While thinking about it I recall a web service called "My Mini City" which is very fun and exciting.

I wanted a blog tool of it, but could not find it. So I decide to make blog tool of it looks like this.

At first, make library which scrapes your MyMiniCity page.

librarly/Hoge/Service/MyMiniCity.php

<?php
/**
 * @see Zend_Service_Abstract
 */
require_once 'Zend/Service/Abstract.php';

/**
 * Hoge_Service_MyMiniCity is a concrete implementation of the myminicity web service
 */
class Hoge_Service_MyMiniCity extends Zend_Service_Abstract
{
    /**
     * Basic URI
     */
    const API_URI  = 'http://%s.myminicity.com';
 
    /**
     * XML path
     */
    const PATH_XML = '/xml';
 
    /**
     * RSS path
     */
    const PATH_RSS = '/rss';
 
    /**
     * Xml string
     *
     * @var xml string
     */
    protected $_xml;

    /**
     * Account
     *
     * @var string city name
     */
    protected $_city;

    /**
     * Constructs a new myminicity Web Service Client
     * The myminicity.com requires "Referer" and "User-Agent"
     * otherwise you can not get the page.
     *
     * @param string $city city name
     * @return void
     */
    public function __construct($city)
    {
        $this->_city = $city;
        self::getHttpClient()->setHeaders('Referer', sprintf(self::API_URI, $city));
        self::getHttpClient()->setHeaders('User-Agent', $_SERVER['HTTP_USER_AGENT']);
    }

    /**
     * Get response body.
     * @reutrn string response body.
     */
    protected function _getResponse($path = '')
    {
        $uri = sprintf(self::API_URI . $path, $this->_city);
        return self::getHttpClient()->setUri($uri)->request()->getBody();
    }

    /**
     * Get Xml data
     *
     * @return string xml string
     */
    protected function _getXml()
    {
        if ($this->_xml) return $this->_xml;
        $this->_xml = $this->_getResponse(self::PATH_XML);
        return $this->_xml;
    }

    /**
     * Get Simple Xmle Element
     *
     * @return object $obj SimpleXmlElement
     */
    protected function _getSimpleXmlElement()
    {
        return simplexml_load_string($this->_getXml());
    }

    /**
     * Convert xml to array
     *
     * @return array   converted array data from xml string.
     */
    protected function _xmlToArray()
    {
        $items = array();
        foreach ($this->_getSimpleXmlElement() as $key => $val) {
            if ($key == 'region') {
                foreach($val->attributes() as $key2 => $val2) {
                    $items[$key][$key2] = (string) $val2;
                }
                $items[$key][0] = (string) $val;
            }
            else if ($key === 'bases') {
                foreach($val->attributes() as $key2 => $val2) {
                    $items[$key][$key2] = (string) $val2;
                }
            }
            else {
                $items[$key] = (string) $val;
            }
        }
        return $items;
    }
 
    /**
     * Flash vars
     * Perse string look like below in source
     * The purpose of scraping source is to get k parameter.
     * so.addParam("FlashVars","name=kawadu&pop=129&ind=36&tra=8&sec=0&env=0&com=0&k=949e4");
     *
     * @return string flash parameters.
     * @throws Exception    In case it failed to get flash parameters.
     */
    public function getFlashVars()
    {
        $pattern = '/so.addParam\("FlashVars","(name=.*?&k=.*?)"\)/';
        if (preg_match($pattern, $this->_getResponse(), $matches)) {
            return $matches[1];
        }
        throw new Zend_Service_Exception('Could not perse "k" parameter.');
    }
 
    /**
     * Get embed tag
     *
     * @param  int    $height height
     * @param  int    $width  width
     * @return string         embed tag
     */
    public function getEmbedTag($height = '100%', $width = '100%', $showdetail = false)
    {
         $str ='(function(){
             city = arguments[0];

             html = "<embed "
             html += "quality=\"high\" "
             html += "allowscriptaccess=\"always\" "
             html += "flashvars=\"" + city.flashvars + "\" "
             html += "type=\"application/x-shockwave-flash\" "
             html += "src=\"http://data.myminicity.com/swf/client.swf?v=5\" "
             html += "bgcolor=\"#deecfe\" "
             html += "id=\"client\" "
             html += "height=\"" + city.height + "\" "
             html += "width=\"" + city.width + "\" "
             html += "scale=\"scale\" "
             html += "name=\"client\" "
             html += "></embed>"
             document.write(html);

             if (city.showdetail) {
                 html = "<ul>";
                 html += "<li>name : " + city.name + "</li>";
                 html += "<li>region : " + city.region + "</li>";
                 html += "<li>ranking : " + city.ranking + "</li>";
                 html += "<li>population : " + city.population + "</li>";
                 html += "<li>incomes : " + city.incomes + "</li>";
                 html += "<li>unemployment : " + city.unemployment + "</li>";
                 html += "<li>transport : " + city.transport + "</li>";
                 html += "<li>criminality : " + city.criminality + "</li>";
                 html += "<li>pollution : " + city.population + "</li>";
                 html += "<li>nextnuke : " + city.nextnuke + "</li>";
                 html += "<li>signatures : " + city.signatures + "</li>";
                 html += "</ul>";
                 document.write(html);
             }
 
             html = "<ul>";
             html += "<li><a href=\"http://" + city.host + "\" target=\"_blank\">Increase population</a></li>";
             html += "<li><a href=\"http://" + city.host + "/ind\" target=\"_blank\">Increase industry</a></li>";
             html += "<li><a href=\"http://" + city.host + "/tra\" target=\"_blank\">Improve the transport network</a></li>";
             html += "<li><a href=\"http://" + city.host + "/sec\" target=\"_blank\">Increase security</a></li>";
             html += "<li><a href=\"http://" + city.host + "/env\" target=\"_blank\">Increase environment</a></li>";
             html += "<li><a href=\"http://" + city.host + "/com\" target=\"_blank\">Increase business</a></li>";
             html += "</ul>";
             document.write(html);

         })({
             height: "' . $height . '",
             width: "' . $width .'",
             host : "' . $this->host . '",
             name: "' . $this->name . '",
             region: "' . $this->region . '",
             ranking: "' . $this->ranking . '",
             population: "' . $this->population . '",
             incomes: "' . $this->incomes . '",
             unemployment: "' . $this->unemployment . '",
             transport: "' . $this->transport . '",
             criminality: "' . $this->criminality . '",
             pollution: "' . $this->population . '",
             nextnuke:"' . $this->nextnuke . '",
             signatures:"' . $this->signatures . '",
             flashvars:"' . $this->flashvars . '",
             showdetail:"' . $showdetail . '"
         });
         ';
         return $str;
    }

    /**
     * Get Xml
     * @return string xml string.
     */
    public function getXml()
    {
        return $this->_getXml();
    }
 
    /**
     * Get Rss
     * @return string Rss string
     */
    public function getRss()
    {
        return $this->_getResponse(self::PATH_RSS);
    }
 
    /**
     * Get Json
     * get json string from xml data
     * @return string json string
     */
    public function getJson()
    {
        require_once 'Zend/Json.php';
        return Zend_Json::fromXml($this->_getXml(), false);
    }
 
    /**
     * Get Array
     * Get array values from xml data
     *
     * @return array data array converted from xml data
     */
    public function getArray()
    {
        return $this->_xmlToArray($this->_getSimpleXmlElement());
    }
 
    /**
     * Get specified data from xml data
     *
     * @return string|array specified data.
     */
    public function __get($name)
    {
        return $this->__call($name);
    }
 
    /**
     * Get parameter (magic method call)
     * Getting value from Xml data.
     *
     * @param  $name  key to get data from xml
     * @param  $argv  no needs
     * @return string|array  specified key's value.
     */
    public function __call($name, $argv = null)
    {
        $data = $this->getArray();
        switch ($name) {
            case 'region':
                return $data['region'][0];
            case 'code':
                return $data['region']['code'];
            case 'com':
            case 'env':
            case 'ind':
            case 'sec':
            case 'tra':
                return $data['bases'][$name];
            case 'rss':
                return $this->getRss();
            case 'xml':
                return $this->getXml();
            case 'embed':
                return $this->getEmbedTag();
            case 'json':
                return $this->getJson();
            case 'array':
                return $this->getArray();
            case 'flashvars':
                return $this->getFlashVars();
            default:
                return (isset($data[$name])) ? $data[$name] : null;
        }
    }
}

Ok. Let's make API application.
For here, I want to make the url looks like this.

http://yoursite/?city=your_city_name

application/controllers/IndexController.php

<?php
class IndexController extends Zend_Controller_Action
{
    public function indexAction()
    {
        $city = $this->_getParam('city');
        $height = $this->_getParam('height', null);
        $width = $this->_getParam('width', null);
        $showdetail = $this->_getParam('showdetail', false);
        $s = new Hoge_Service_MyMiniCity($city);
        echo $s->getEmbedTag($height, $width, $showdetail);
    }
}

To get data in other way. You can get it as property.

echo $s->xml;
echo $s->json;
echo $s->array;
echo $s->embed; // but you can not set size or show detail setting.
echo $s->rss;

To show blog tool in your site, use javascript.

<script src="http://yoursite/path/to/application/?city=your_city_name" type="text/javascript"></script>

Don't have a time? Or feel bothering to make it?
Here is a sample.
http://api.f-pig.net/myminicity/?city=your_city_name
Try your city name insted of "your_city_name" :)

Any way, Zend Framework is nice and fun. I will try more.

Oops, I have to win the game with my co-workers what if I can lose my weight about 6kg until end of March, I will win!!
(weight 94.7ｋｇ　BMI 34%)

A Happy New Year 2009

2009-01-04T08:38:00.003-08:00

A happy new year 2009!

Looking back 2008, I didn't write entry so much. :P
I will write it this year!!
And this is the first entry in 2009.

Anyway, I hope everyone happy this year! :)

oops, I ate new year meals too much. :<
(weight 93.3ｋｇ　BMI 33%)

Zend Framework 1.7 is released!!

2008-11-18T07:34:00.006-08:00

Yahoooooooooooooooooooooooooooooooooooooo!!

Zend Framework 1.7 is released !

Zend_AMF will become a rainbow bridge to the Actionscripters!
ZendX_JQuery will become a lighthouse for the Javascripters!

Any way, I restarted to use Zend Framework for my new project :)
And so happy to forget how fatty I am!!
(weight I don't ｋｇ　BMI care%)

Zend Framework 1.6 is released!!

2008-09-03T07:46:00.005-07:00

Yahoooooooooooooooooooooooooooooooooooooo!!

Zend Framework 1.6 is released !
With dojo ?? Oh OKay.
It has been enhanced a lot while I haven't checked. :)

Any way, it's been a long time since I worte the last entry :P
And so happy to forget how fatty I am!!
(weight I don't ｋｇ　BMI care%)

How do you pronounce?

2008-05-02T02:41:00.002-07:00

It's been a long time since I started to use PostgreSQL.
But I haven't known how to pronounce it correctly :P
And, it's impossible for me to sleep with this curious.

There was an interesting survey about "How do you pronounce 'PostgreSQL'?".
My result was "post-gres".

For me, the answer "post-gres-q-l" is pretty difficult!!

And, there is an answer here !!

Ok, from now on, I can sleep well. :)

(weight 89.4ｋｇ　BMI 30%)

Zend Framework 1.5 is released!!

2008-03-17T08:19:00.000-07:00

Yahoooooooooooooooooooooooooooooooooooooo!!

Zend Framework 1.5 is released today! :p

And so happy to forget how fatty I am!!
(weight I don't ｋｇ　BMI care%)

Things I'm impressed by pipe

2008-03-11T07:23:00.013-07:00

When I dump DB data I usually do this way.

pg_dump -U postgres foo > dump.sql

pg_dump -U postgres foo | gzip > dump.sql.gz

Then restore it from file. (Uncompress the file if you compressed the dump data)

psql -U postgres bar < dump.sql

But, if you use pipe, you don't need to dump it to a file.
Just send stream to a new DB!!

pg_dump -U postgres foo | psql -U postgres bar

It looks not so impressive. But, let's think two databases are located on each separated servers.
you can do this.

pg_dump -U postgres -h 192.168.0.1 foo | psql -U postgres -h 192.168.0.2 bar

Oh pipe! Thank god!! Thank person who made pipe!!! :-)
(weight 89.2ｋｇ　BMI 30%)

Two sweets for you

2008-03-06T07:07:00.007-08:00

Long time no write this blog.
While I haven't written this blog I could meet two nice sweets.
So let me introduce them.

1. HanaBatake farm's hand-made raw caramel.
Looks cute. Left one is caramel taste and right one is chocolate taste.

Open it! They are wrapped one by one. What a kind work it is.

It suddenly melted as you put it into mouth. I felt happy in the mouth. :-( happy! )

2.Smiley Panapp
It looks like smiley!
According to the company's official information, You can meet this radiant face in the probability of 1/10.

Zoom in! Wow big smile and cute.

I wish you will meet smiley panapp!
That's it for today. Good night.
(weight 89.6ｋｇ　BMI 31%)

Zend Framework 1.0.4 is released!!

2008-02-26T17:10:00.000-08:00

Yahoooooooooooooooooooooooooooooooooooooo!!

Zend Framework 1.0.4 is released today! :p

And so happy to forget how fatty I am!!
(weight I don't ｋｇ　BMI care%)

Try Zend Framework vol.11 "Save session data into DB"

2008-01-27T06:24:00.002-08:00

How do you handle session in your site? Usually you may not need to change it from default.
Let's think your site is on the several web servers and need to use unique session. You probably want to store session into database.
Zend Framework provides interface of session save handler. so you just need to implement the interface when you create your own session save handler.
Then I tried to write my own session save handler here.
But before writing it, I draw upon Zend Developer Zone tips below.

Trick-Out Your Session Handler
To know how to write session save handler.

Zend_Session_SaveHandler_DbTable
To know the concept of the session save handler for Zend Framework.
But I did not implement all of them but some of them.

According to "Trick-Out Your Session Handler", I should write opening database connection in "open()" method, and closing database connection in "close()" method. But in my class I just made it return "true". :P

First, we are going to store session into this table(in this case I used PostgreSQL, you may change timestamp to datetime with MySQL)

CREATE TABLE sessions (
id char(32) default NULL,
lifetime timestamp default NULL,
data text
);

OK, here this is a session save handler of database.
library/Hoge/Session/SaveHandler/Db.php

<?php
require_once 'Zend/Db/Table/Abstract.php';

/**
 * Hoge_Session_SaveHandler_Db
 */
class Hoge_Session_SaveHandler_Db extends Zend_Db_Table_Abstract implements Zend_Session_SaveHandler_Interface
{
    /**
     * constatns
     */
    // session table name
    const TABLE_NAME         = 'sessions';
    // primary key column name
    const COLUMN_PRIMARY_KEY = 'id';
    // lifetime column name
    const COLUMN_LIFETIME    = 'lifetime';
    // data column name
    const COLUMN_DATA        = 'data';

    /**
     * primary key
     * @var string
     */
    protected $_primary = self::COLUMN_PRIMARY_KEY;

    /**
     * table name
     * @var string
     */
    protected $_name = self::TABLE_NAME;

    /**
     * table columns.
     * @var array
     */
    protected $_columnMap = array(
        self::COLUMN_PRIMARY_KEY => self::COLUMN_PRIMARY_KEY,
        self::COLUMN_LIFETIME    => self::COLUMN_LIFETIME,
        self::COLUMN_DATA        => self::COLUMN_DATA
    );

    /**
     * session maxlifetime
     * @var null|intger
     */
    protected $_lifetime = null;

    /**
     * constructor
     * @param string $table      Session table name
     * @param array  $columnMap  Session table column names
     */
    public function __construct($table = null, $columnMap = null)
    {
        // set table name
        if ($table) {
            $this->_name = $table;
        }

        if ($columnMap) {
            // set primary key name
            if (isset($columnMap[self::COLUMN_PRIMARY_KEY])) {
                $this->_columnMap[self::COLUMN_PRIMARY_KEY] = $columnMap[self::COLUMN_PRIMARY_KEY];
                $this->_primary = $columnMap[self::COLUMN_PRIMARY_KEY];
            }
            // set lifetime column name
            if (isset($columnMap[self::COLUMN_LIFETIME])) {
                $this->_columnMap[self::COLUMN_LIFETIME] = $columnMap[self::COLUMN_LIFETIME];
            }
            // set session data column name
            if (isset($columnMap[self::COLUMN_DATA])) {
                $this->_columnMap[self::COLUMN_DATA] = $columnMap[self::COLUMN_DATA];
            }
        }

        parent::__construct();
    }

    /**
     * Set session max lifetime.
     * @param $lifetime
     */
    public function setLifetime($lifetime)
    {
        $this->_lifetime = $lifetime;
    }

    /**
     * Open Session - retrieve resources
     *
     * @param string $save_path
     * @param string $name
     */
    public function open($save_path, $name)
    {
        return true;
    }

    /**
     * Close Session - free resources
     *
     */
    public function close()
    {
        return true;
    }

    /**
     * Read session data
     *
     * @param string $id
     * @return string
     */
    public function read($id)
    {
        $return = '';
        $where = $this->getAdapter()->quoteInto($this->_columnMap[self::COLUMN_PRIMARY_KEY] . "=?", $id);
        if ($row = $this->fetchRow($where)) {
            $return = $row->{$this->_columnMap[self::COLUMN_DATA]};
        }
        return $return;
    }

    /**
     * Write Session - commit data to resource
     *
     * @param string $id
     * @param mixed $data
     * @return bool
     */
    public function write($id, $data)
    {
        $return = false;
        $dataSet = array(
            $this->_columnMap[self::COLUMN_PRIMARY_KEY] => $id,
            $this->_columnMap[self::COLUMN_LIFETIME]    => date("Y-m-d H:i:s", mktime()),
            $this->_columnMap[self::COLUMN_DATA]        => $data
        );
        $where = $this->getAdapter()->quoteInto($this->_columnMap[self::COLUMN_PRIMARY_KEY] . "=?", $id);

        if ($this->fetchRow($where)) {
            $return = ($this->update($dataSet, $where)) ? true : false;
        } else {
            $return = ($this->insert($dataSet)) ? true: false;
        }

        return $return;
    }

    /**
     * Destroy Session - remove data from resource for
     * given session id
     *
     * @param string $id
     * @return bool
     */
    public function destroy($id)
    {
        $where = $this->getAdapter()->quoteInto($this->_columnMap[self::COLUMN_PRIMARY_KEY] . "=?", $id);
        return ($this->delete($where)) ? true : false;
    }

    /**
     * Garbage Collection - remove old session data older
     * than $maxlifetime (in seconds)
     *
     * @param int $maxlifetime
     * @return bool
     */
    public function gc($maxlifetime)
    {
        $lifetime = ($this->_lifetime) ? $this->_lifetime : $maxlifetime;
        $expiry = date("Y-m-d H:i:s", mktime() - $lifetime);
        $where = $this->getAdapter()->quoteInto($this->_columnMap[self::COLUMN_LIFETIME] . "<=?", $expiry);
        return ($this->delete($where)) ? true : false;
    }
}

Well, Let's use that session save handler.
Basically all you need to do is initialize that save handler and set it to Zend_Session_SaveHandler.

www/index.php

require_once 'Hoge/Session/SaveHandler/Db.php';
$saveHandler = new Hoge_Session_SaveHandler_Db();
Zend_Session::setSaveHandler($saveHandler);

If you want to change table name and column name, set it on constructor.

$table = 'hoge';
$columns = array('id'=>'foo', 'lifetime'=>'bar', 'data'=> 'buz');
$saveHandler = new Hoge_Session_SaveHandler_Db($table, $columns);

If you want to set session max life time, use lifetime setter.

$saveHandler = new Hoge_Session_SaveHandler_Db();
$saveHandler->setLifetime(60*60*12);

That's it. But Zend Framework release version 1.5 soon or later.
It may includes "Zend_Session_SaveHandler_DbTable".
May be it much flexible and useful :)
But I didn't want to wait it. Just wanted to write it like somebody talked to me "Don't wait somebody write code, just write as you need!" :)
(weight 88.6ｋｇ　BMI 31%)

Try Zend Framework vol.10 "Mailing an error log"

2008-01-12T05:30:00.000-08:00

Zend Framework has great logging system like "Zend_Log_Writer_Stream", "Zend_Log_Writer_Db".
But if some trouble happens, you might want to know it ASAP or don't want to know it forever, don't you :P

Let's make a log writer for mail first.

library/Hoge/Log/Writer/Mail.php

<?php
/** Zend_Log_Writer_Abstract */
require_once 'Zend/Log/Writer/Abstract.php';

/** Zend_Log_Formatter_Simple */
require_once 'Zend/Log/Formatter/Simple.php';

class Hoge_Log_Writer_Mail extends Zend_Log_Writer_Abstract
{
  /**
   * Mailer
   * @var Zend_Mail
   */
  private $_mail;

  /**
   * Class constructor
   *
   * @param Zend_Mail $mail   Mail instance
   */
  public function __construct($mail)
  { 
      $this->_mail = $mail;
      $this->_formatter = new Zend_Log_Formatter_Simple();
  } 

  /**
   * Write a message to the log.
   *
   * @param  array  $event  event data
   * @return void
   */
  protected function _write($event)
  { 
      $line = $this->_formatter->format($event);
      $this->_mail->setBodyText($line);
      $this->_mail->send();
  } 

}

Settings for Mail Logger.
www/index.php

<?php
require_once 'Zend/Registry.php';
require_once 'Zend/Mail.php';
require_once 'Zend/Log.php';
require_once 'Hoge/Log/Writer/Mail.php';

// Create mail object.
$mail = new Zend_Mail();                                                                                                                                                      
$mail->addTo('foo@example.com', 'System members');                                                                                                                          
$mail->setSubject('Error Occured!');                                                                                                                                         
$mail->setFrom('foo@example.com');

// Set writer
$writer = new Hoge_Log_Writer_Mail($mail);

// Set logger and writer
$logger = new Zend_Log();
$logger->addWriter($writer);

// Set in registry
Zend_Registry::set('logger', $logger);

To use it. Get logger from registry.
application/controllers/HogeController.php

<?php
class HogeController extends Zend_Controller_Action
{
  function loggerAction()                                                                                                                                                  
  {                                                                                                                                                                            
      $logger = Zend_Registry::get('logger');                                                                                                                               
      $logger->log('Information log', Zend_Log::INFO);                                                                                                                      
      $logger->emerg('Emerg log');
      exit;
  }
}

Ok, that's it. From now, you cannot escape from error mail!
If you don't want to get error mail just create system without bugs!! :)
(weight 88.7ｋｇ　BMI 30%)

CakePHP 1.2 is released!!

2008-01-03T11:08:00.000-08:00

Yahoooooooooooooooooooooooooooooooooooooo!!

CakePHP 1.2 is released today! :p

And so happy to forget how fatty I am!!
(weight I don't ｋｇ　BMI care%)

Try Zend Framework vol.9 "Adding Json method on Rowset class"

2008-01-01T11:45:00.000-08:00

Recently I started to study javascript and it's pretty interesting to use ajax.
When you deal with ajax, you probably want to get data as JSON. Don't you?

Zend Framework has data set handling class which is called
"Zend_Db_Table_Row" and "Zend_Db_Table_Rowset". And they have data conversion method "toArray()"

If they have JSON conversion method like "toJson()", it's helpful. isn't it? :)

Ok, Let's say you have data like below. We are going to convert this data to JSON.

mysql> select * from data;
+----+---------+
| id | data    |
+----+---------+
|  1 | data 1  |
|  2 | data 2  |
|  3 | data 3  |
|  4 | data 4  |
|  5 | data 5  |
+----+---------+

Add a new method toJson() on Row class.
library/Hoge/Db/Table/Row.php

<?php
/**
* @see Zend_Db_Table_Row
*/
require_once 'Zend/Db/Table/Row.php';

class Hoge_Db_Table_Row extends Zend_Db_Table_Row
{
  /**
   * Returns the column/value data as json.
   *
   * @return string
   */
  public function toJson()
  {
      require_once 'Zend/Json.php';
      return Zend_Json::encode($this->_data);
  }
}

For Rowset class.
library/Hoge/Db/Table/Rowset.php

<?php
/**
* @see Zend_Db_Table_Rowset
*/
require_once 'Zend/Db/Table/Rowset.php';

class Hoge_Db_Table_Rowset extends Zend_Db_Table_Rowset
{
  /**
   * Returns all data as a json.
   *
   * @return string
   */
  public function toJson()
  {
      require_once 'Zend/Json.php';
      return Zend_Json::encode($this->_data);
  }
}

Ok, Let's use these extended classes.
There are several ways to specify these new classes.

1.Set names of these classes via setter methods.
application/controllers/HogeController.php


function jsonAction() {
  require_once 'Hoge/Db/Table/Data.php';
  $data = new Data();
  $data->setRowClass('Hoge_Db_Table_Row');
  $data->setRowsetClass('Hoge_Db_Table_Rowset');
  $res = $data->fetchAll()->toJson();
  print_r($res);
  exit;
}

2.Set names of these classes in the Table_Abstract class.
library/Hoge/Db/Table/Abstract.php

<?php
require_once 'Zend/Db/Table/Abstract.php';

abstract class Hoge_Db_Table_Abstract extends Zend_Db_Table_Abstract
{

  public function __construct()
  {
      $config = array(
          'rowClass' => 'Hoge_Db_Table_Row',
          'rowsetClass' => 'Hoge_Db_Table_Rowset'
      );
      parent::__construct($config);
  }
}

To use toJson() method. The usage is same as toArray() method.
application/controllers/HogeController.php


function jsonAction()
{
  require_once 'Hoge/Db/Table/Data.php';
  $data = new Data();
  $res = $data->fetchAll()->toJson();
  print_r($res);
  exit;
}

It returns JSON data like below.

[{"id":"1","data":"data 1"},{"id":"2","data":"data 2"},{"id":"3","data":"data 3"},{"id":"4","data":"data 4"},{"id":"5","data":"data 5"}]

(weight 89.0ｋｇ　BMI 31%)

A happy new year !!

2007-12-31T20:24:00.000-08:00

A happy new year 2008 !!
I hope your life will be wonderful this year !!
(weight 88.8ｋｇ　BMI 30%)

My mini city

2007-12-22T00:58:00.000-08:00

A interesting web service "MyMiniCity" has launched.

Build your own city!

No need to sign up, nothing to download! Follow its evolution from your web browser.

There are several mini cities. My friends also made cities. It's pretty fun to kill time!

Then I found a interesting city "phpcity".
So I looked for another "language" cities. :P

phpcity

rubycity

javacity

But I could not find "perlcity", "javascriptcity" and "haskellcity" yet.
And I do not know many languages.
If you know any other languages, please try to visit the city. :)

Anyway, my city is here . Pretty small !!
(weight 87.6ｋｇ　BMI 29%)

Been to GU drinking!

2007-12-19T08:11:00.000-08:00

I went to GU drinking yesterday.
I could have great time with GU guys.
But not all of them were GU. Some of them were.
I could get several knowledge from them. They were nice, gentle and not pessimistic.
I hope they will get over from their GU. And I believe they will be able to do. :-)
(weight 87.2ｋｇ　BMI 29%)

Try Zend Framework vol.8 "Using Layout with ViewRenderer"

2007-12-15T04:45:00.000-08:00

**************************************** Notice ****************************************
"Zend_Layout" is out after version 1.5 !!
It's much more flexible and easy to use . So you should read the documentation and use it. :-)
**************************************** Notice ****************************************

When you use Zend Framework, you probably write full HTML for each action in your controllers.
It's kind of wasting time to write HTML for every template. isn't is?
And if you need to put additional code like css or javascript, you need to write same code for every template.
I think the concept of "Layout" is very powerful and useful, so I wrote ViewRenderer which can handle layout.

First you need to create a new ViewRenderer which extends Zend_Controller_Action_Helper_ViewRenderer. And just change a little on postDispatch() and add some methods.

library/Hoge/Controller/Action/Helper/ViewRenderer.php

<?php
require_once 'Zend/Controller/Action/Helper/ViewRenderer.php';

/**
* View script integration
*/
class Hoge_Controller_Action_Helper_ViewRenderer extends Zend_Controller_Action_Helper_ViewRenderer
{
   /**
    * postDispatch - auto render a view
    * @return void
    */
   public function postDispatch()
   {
       if ($this->getFrontController()->getParam('noViewRenderer')) {
           return;
       }

       if (!$this->_neverRender
           && !$this->_noRender
           && (null !== $this->_actionController)
           && $this->getRequest()->isDispatched()
           && !$this->getResponse()->isRedirect())
       {
           if($this->hasViewLayout()) {
               $this->render();
               $this->view->contens = $this->getResponse()->getBody();
               $this->getResponse()->clearBody();
               $this->render($this->getViewLayout(), null, true);
           } else {
               $this->render();
           }
       }
   }

   /**
    * if layout is sat.
    * @return bool
    */
   function hasViewLayout()
   {
       if ($this->getActionController()->layout) {
           return true;
       }
       return false;
   }

   /**
    * Get layout template
    * @return string
    */
   function getViewLayout()
   {
       return $this->getActionController()->layout;
   }
}

Next, you need to add Views' Script Path.
www/index.php

$view = new Zend_View();
$view->setScriptPath(dirname(dirname(__FILE__)) . '/application/views/scripts/');
$view->addScriptPath(dirname(dirname(__FILE__)) . '/application/views/layouts/');

so now, it will look for templates not only scripts but also layouts directory.
*Don't forget to set setScriptPath, too. Otherwise it only see layouts directory.
Then, use new ViewRenderer which you just made.
www/index.php

$viewRenderer = new Hoge_Controller_Action_Helper_ViewRenderer($view);
Zend_Controller_Action_HelperBroker::addHelper($viewRenderer);

To use it you nedd to set layout. Set $layout variable and put the name of layout template.

appplication/controllers/HogeController.php

class HogeController extends Zend_Controller_Action
{
   var $layout = 'default';

And make layout template
application/views/layouts/default.phtml

<html>
<head>
</head>
<body>
<?= $this->contens ?>
</body>
</html>

That's it. :-)

Be careful, under these case like bellow, ViewRenderer will not work. :P

Call setNoRender() in the Controller.
application/controllers/HogeController.php

$this->_helper->viewRenderer->setNoRender();

Call render() on purpose.
application/controllers/HogeController.php

function indexAction()
{
   $this->render();
}

Set noViewRenderer.
www/index.php

$front = Zend_Controller_Front::getInstance();
$front->setParam('noViewRenderer', true);

(weight 87.0ｋｇ　BMI 29%)

Zend Framework 1.0.3 is released!!

2007-11-30T09:01:00.000-08:00

Yahoooooooooooooooooooooooooooooooooooooo!!

Zend Framework 1.0.3 is released today! :p

And so happy to forget how fatty I am!!
(weight I don't ｋｇ　BMI care%)

Try Zend Framework vol.7 "Using Simplate as Template Enginge"

2007-11-23T08:47:00.000-08:00

As you guys know "Smarty" is pretty famous template engine.
But, "Simplate" is likely faster than "Smarty".
And the way of writing template is almost same as smarty.
So I tried using it as zend view template.

First, you need to install simplate as php extension, but don't worry it's pretty easy.
All you need to do is bellow.
* In my case installed php at /usr/local/php525, and make simbolick link like below.

php5 -> /usr/local/php525/bin/php
phpize5 -> /usr/local/php525/bin/phpize.

Ok, install simplate extension.

# cd /usr/local/src
# wget http://simplate.aimy.jp/archive/simplate-0.3.7.tar.gz
# tar zxvf simplate-0.3.7.tar.gz
# cd simplate-0.3.7
# phpize5
# ./configure \
--enable-simplate \
--with-php-config=/usr/local/php525/bin/php-config \
--prefix=/usr/local/php525 \
# make
# make install

If you see the message like below, you would success to install simplate extension.

Installing shared extensions:     /usr/local/php525/lib/php/extensions/no-debug-non-zts-20060613/

Next, you need to modify php.ini.

# vim /usr/local/php525/lib/php.ini

Add this line.

extension=simplate.so

Then reload apache. Don't forget to check if the extension is installed like this.

php5 -i | grep simplate

You should see message like this.

simplatesimplate support => enabled

Ok, we are ready to make simplate view!

library/Hoge/View/Simplate.php

<?php
require_once 'Zend/View/Interface.php';

class Hoge_View_Simplate implements Zend_View_Interface
{
 /**
  * Simplate object
  * @var Simplate
  */
 protected $_simplate;

 /**
  * constructor
  *
  * @param string $tmplPath
  * @param array $extraParams
  * @return void
  */
 public function __construct($tmplPath = null, $extraParams = array())
 {
     $this->_simplate = new Simplate;
     if (null !== $tmplPath) {
         $this->setScriptPath($tmplPath);
     }
     foreach ($extraParams as $key => $value) {
         $this->_simplate->$key = $value;
     }
 }

 /**
  * Return template enginge object.
  *
  * @return Simplate
  */
 public function getEngine()
 {
     return $this->_simplate;
 }

 /**
  * Set template's path
  *
  * @param strimg $path Directory path
  * @return void
 public function setScriptPath($path)
 {
     if (is_readable($path)) {
         $this->_simplate->template_dir = $path;
         return;
     }
     throw new Exception("You specified unrecognized path '{$path}'");
 }

 /**
  * Get current template path.
  * @return string
  */
 public function getScriptPaths()
 {
     return $this->_simplate->template_dir;
 }

 /**
  * Alias of setScript path.
  *
  * @param string $path
  * @param string $prefix Unused
  * @return void
  */
 public function setBasePath($path, $prefix = 'Zend_View')
 {
     return $this->setScriptPath($path);
 }

 /**
  * Alias of setScript path.
  *
  * @param string $path
  * @param string $prefix unused
  *
  * @return void
  */
 public function addBasePath($path, $prefix = 'Zend_View')
 {
     return $this->setScriptPath($path);
 }

 /**
  * Set valiables to template.
  *
  * @param string $key valiable name
  * @param mixed  $val valiable value
  * @return void
  */
 public function __set($key, $value)
 {
     $this->_simplate->assign($key, $value);
 }

 /**
  * Get value.
  *
  * @param string $key valiable name
  * @return mixed valiable value
  */
 public function __get($key)
 {
     return $this->_simplate->_tpl_vars[$key];
 }

 /**
  * Enable test for empty() isset().
  *
  * @param string $key
  * @return boolen
  */
 public function __isset($key)
 {
     return isset($this->_simplate->_tpl_vars[$key]);
 }

 /**
  * Enable unset to object valiable.
  * @return void
  */
 public function __unset($key)
 {
     unset($this->_simplate->_tpl_vars[$key]);
 }

 /**
  * Set valiable to template.
  * set value to specific key.
  * set  at once by key => value array.
  *
  * @see __set()
  * @param string|array $spec type of settin value (key or key => value array)
  * @param mixed $value  (optionale)  specify the name of key. set here.
  * @return void
  */
 public function assign($spec, $value = null)
 {
     if (is_array($spec)) {
         foreach($spec as $key => $value) {
             $this->_simplate->assign($key, $value);
         }
         return;
     }
     $this->_simplate->assign($spec, $value);
 }

 /**
  * Clear all valiables.
  * Clear all valiables sat to Zend_View by {@link assign()} or {@link __get()}/{@link __set()}.
  *
  * @return void
  */
 public function clearVars()
 {
     $this->_simplate->_tpl_vars = null;
 }

 /**
  * Dispatch template and return result.
  *
  * @param string $name template name
  * @return string result
  */
 public function render($name)
 {
     return $this->_simplate->fetch($name);
 }
}

Make method for displaying simplate template with assigning 20000 variables.
* Don't forget writing $this->_helper->viewRenderer->setNoRender();
otherwise zf automatically expect the template which has same name as method and has phtml suffix then render it, even if you specify another desired template.

application/controllers/HogeController.php

function simplateAction()
{
   $this->_helper->viewRenderer->setNoRender();
   require_once 'Hoge/View/Simplate.php';
   $tplPath = dirname(dirname(__FILE__)) . '/views/scripts/hoge/';
   $params = array(
       'compile_dir' => dirname(dirname(__FILE__)) . '/views/templates_c',
       'left_delimiter' => '{',
       'right_delimiter' => '}',
   );
   $view = new Hoge_View_Simplate($tplPath, $params);
   foreach(range(0, 20000) as $i) {
       $vars[$i] = "Hello World $i";
   }
   $view->vars = $vars;
   echo $view->render('simplate.tpl');
}

This is template.

<html>
 <head></head>
 <body>
 {foreach key=key item=item from=$vars}
 {$key} : {$item} <br />
 {/foreach}
 </body>
</html>

That's it. You will see 20000 Hello Worlds!

But, it's not enough, because I didn't check if simplate is faster than smaty template.
So, I compare "Smaty" with "Simplate".

Get time before execution.

application/controllers/HogeController.php

function preDispatch()
{
   $this->startTime = microtime(true);
}

function postDispatch()
{
   echo (microtime(true) - $this->startTime);
}

For Smaty template view you should see here

Controllers' method is this. Almost same as simplate.
application/controllers/HogeController.php

function smartyAction()
{
   $this->_helper->viewRenderer->setNoRender();
   require_once 'Hoge/View/Smarty.php';
   $tplPath = dirname(dirname(__FILE__)) . '/views/scripts/hoge/';
   $params = array(
       'compile_dir' => dirname(dirname(__FILE__)) . '/views/templates_c',
   );
   $view = new Hoge_View_Smarty($tplPath, $params);
   foreach(range(0, 20000) as $i) {
       $vars[$i] = "Hello World $i";
   }
   $view->vars = $vars;
   echo $view->render('smarty.tpl');
}

Template is same as simplate.

Here the result of rendering time.

Simplate: 0.137821912766
Smarty : 0.153032064438

Faster than smaty. :-)
(weight 89.4ｋｇ　BMI 33%)

A good news for every vimmer !

2007-11-20T17:21:00.000-08:00

A wonderful web service "Vimpi" has opened !

Vimpi is vim plugins watching service.
You can generate own update notification rss with favorite plugins

Check it out !! (by rin kozue)
(weight 89.0ｋｇ　BMI 33%)

Try Zend Framework vol.6 "Simple Pager"

2007-10-21T09:08:00.004-07:00

When I look back in my old days, the pagination was my first obstacle to understand how it works like my friend introduced here.
PEAR::Pager was so impressive for me to make pagination. :-)
So, I wrote a simple pager for Zend Framework view helper.

Let's say you have data like below. The total record is 1000.

mysql> select * from data limit 10;
+----+---------+
| id | data    |
+----+---------+
|  1 | data 1  |
|  2 | data 2  |
|  3 | data 3  |
|  4 | data 4  |
|  5 | data 5  |
|  6 | data 6  |
|  7 | data 7  |
|  8 | data 8  |
|  9 | data 9  |
| 10 | data 10 |
+----+---------+

Here the pager helper.
It basically requires total number of record for pagination.
library/Hoge/View/Helper/Pager.php

<?php
require_once 'Zend/View/Helper/Url.php';

/**
* Pager Helper
*/

class Hoge_View_Helper_Pager
{
   /**
    * Current page
    * @var integer
    */
   protected $currentPage = 1;

   /**
    * Per page
    * How many items to display per pages.
    * @var integer
    */
   protected $perPage = 20;

   /**
    * Display links
    * How many page to display in the pagination links.
    * @var integer
    */
   protected $pageRange = 10;

   /**
    * Total number of items
    * @var integer
    */
   protected $total = 0;

   /**
    * Start page
    * @var integer
    */
   protected $startPage = 1;

   /**
    * End page
    * @var integer
    */
   protected $endPage = 1;

   /**
    * Pager format.
    */
   const FORMAT_FIRST              = '<a href="%s" class="pager_first">&#171;</a>';
   const FORMAT_PREVIOUS           = '<a href="%s" class="pager_previous">&#139;</a>';
   const FORMAT_PREVIOUS_RANGE     = '<a href="%s" class="pager_previous_range">...</a>';
   const FORMAT_NAVIGATION_LINK    = '<a href="%s" class="pager_navigation_link">%d</a>';
   const FORMAT_NAVIGATION_CURRENT = '<b class="pager_navigation_current">%d</b>';
   const FORMAT_NEXT_RANGE         = '<a href="%s" class="pager_next_range">...</a>';
   const FORMAT_NEXT               = '<a href="%s" class="pager_next">&#155;</a>';
   const FORMAT_LAST               = '<a href="%s" class="pager_last">&#187;</a>';

   /**
    * Base link formats
    * @var array
    */
   protected $baseFormats =
       array(
           'first'             => self::FORMAT_FIRST,
           'previous'          => self::FORMAT_PREVIOUS,
           'previousRange'     => self::FORMAT_PREVIOUS_RANGE,
           'navigationLink'    => self::FORMAT_NAVIGATION_LINK,
           'navigationCurrent' => self::FORMAT_NAVIGATION_CURRENT,
           'nextRange'         => self::FORMAT_NEXT_RANGE,
           'next'              => self::FORMAT_NEXT,
           'last'              => self::FORMAT_LAST
       );

   /**
    * Pager instance
    * @var object
    */
   static protected $pager;

   /**      
    * Pager
    *
    * @access public
    *
    * @param integer $total Total records
    * @param integer $perPage How many to display per page
    *
    * @return object pager
    */
   public function pager($total = null, $perPage = 20)
   {
       if(isset(self::$pager)) return self::$pager;

       $page = Zend_Controller_Front::getInstance()->getRequest()->getParam('page');

       if ($page > 0) {
           $this->currentPage = $page;
       }

       // Number of total data.
       $this->total = $total;

       // How many rows to display per page.
       $this->perPage = $perPage;

       // Number of total page
       $this->totalPage = ceil($this->total / $this->perPage);

       // If total page is smaller than called page.
       if ($this->totalPage < $this->currentPage) $this->currentPage = 1;

       // Page numnber of core pages.
       $corePage = ceil($this->currentPage / $this->pageRange);

       // Max page number.
       $this->endPage = ($this->pageRange * $corePage);

       // Start page number.
       $this->startPage = ($this->endPage - $this->pageRange) + 1;

       // Set to static instance
       self::$pager = $this;

       return $this;
   }


   /**
    * Display a simple pagination ex:[<< < ... 1 2 3 ... > >>]
    *
    * @param  array $formats An array of links to use sprintf()
    * @return string A link to the desired page page of the pagination
    */
   public function paginate(array $formats = array())
   {
       $formats = array_merge($this->baseFormats, $formats);

       $this->pager($this->total, $this->perPage);
       $pagination = array();
       $pagination[] = $this->pager()->first($formats['first']);
       $pagination[] = $this->pager()->previous($formats['previous']);
       $pagination[] = $this->pager()->previousRange($formats['previousRange']);
       $pagination[] = $this->pager()->navigation($formats['navigationLink'], $formats['navigationCurrent']);
       $pagination[] = $this->pager()->nextRange($formats['nextRange']);
       $pagination[] = $this->pager()->next($formats['next']);
       $pagination[] = $this->pager()->last($formats['last']);

       return join('', $pagination);
   }

   /**
    * Display link of the navigation links ex:[1 2 3]
    *
    * @param  string $linkFormat Format string to display page number links to use sprintf()
    * @param  string $currentFormat Format string to display current page to use sprintf()
    * @return string A link to the desired page page of the pagination
    */
   public function navigation($linkFormat = self::FORMAT_NAVIGATION_LINK, $currentFormat = self::FORMAT_NAVIGATION_CURRENT)
   {
       $return = null;
       // Display [1,2,3__]
       for ($p = $this->startPage; $p <= $this->endPage; $p++) {
           // Unlink if the page is selected
           if ($p <= $this->totalPage) {
               if ($this->currentPage != $p) {
                   $url = $this->url(array('page' => $p));
                   $return[] = sprintf($linkFormat, $url, $p);
               } else {
                   $return[] = sprintf($currentFormat, $p);
               }
           }
       }
       return join('', $return);
   }

   /**
    * Display link of the next range ex:[...]
    *
    * @param  string $format Format string of link to use sprintf()
    * @return string A link to the previous range of the pagination
    */
   public function previousRange($format = self::FORMAT_PREVIOUS_RANGE)
   {
       $return = null;
       if ($this->pageRange < $this->currentPage) {
           $url = $this->url(array('page' => ($this->startPage - 1)));
           $return = sprintf($format, $url);
       }
       return $return;
   }

   /**
    * Display link of the next range ex:[...]
    *
    * @param  string $format Format string of link to use sprintf()
    * @return string A link to the next range of the pagination
    */
   public function nextRange($format = self::FORMAT_NEXT_RANGE)
   {
       $return = null;
       if ($this->endPage < $this->totalPage) {
           $url = $this->url(array('page' => ($this->endPage + 1)));
           $return = sprintf($format, $url);
       }
       return $return;
   }

   /**
    * Display link of the previous page ex:[<<]      
    *      
    * @param  string $format Format string of link to use sprintf()      
    * @return string A link to the first page of the pagination      
    */     
   public function first($format = self::FORMAT_FIRST)     
   {
       $return = null;
       if ($this->currentPage != 1) {
           $url = $this->url(array('page' => 1));
           $return = sprintf($format, $url);
       }
       return $return;
   }

   /**
    * Display link of the previous page ex:[<]      
    *      
    * @param  string $format Format string of link to use sprintf()      
    * @return string A link to the previous page of the pagination      
    */
   public function previous($format = self::FORMAT_PREVIOUS)
   {
       $return = null;
       if ($this->currentPage != 1) {
           $url = $this->url(array('page' => ($this->currentPage - 1)));
           $return = sprintf($format, $url);
       }
       return $return;
   }

   /**
    * Display link of the next page ex:[>]
    *
    * @param  string $format Format string of link to use sprintf()
    * @return string A link to the next page of the pagination
    */
   public function next($format = self::FORMAT_NEXT)
   {
       $return = null;
       if($this->currentPage != $this->totalPage) {
           $url = $this->url(array('page' => ($this->currentPage + 1)));
           $return = sprintf($format, $url);
       }
       return $return;
   }

   /**
    * Display link of the last page ex:[>>]
    *
    * @param  string $format Format string of link to use sprintf()
    * @return string A link to the last page of the pagination
    */
   public function last($format = self::FORMAT_LAST)
   {
       $return = null;
       if($this->currentPage != $this->totalPage) {
           $url = $this->url(array('page' => $this->totalPage));
           $return = sprintf($format, $url);
       }
       return $return;
   }


   /**
    * Generates an url given the name of a route.
    *
    * @access public
    *
    * @see    Zend_View_Helper::url()
    * @param  array $urlOptions Options passed to the assemble method of the Route object.
    * @param  mixed $name The name of a Route to use. If null it will use the current Route
    * @param  bool $reset Whether or not to reset the route defaults with those provided
    * @return string Url for the link href attribute.
    */
   public function url(array $urlOptions = array(), $name = null, $reset = false)
   {
       $obj = new Zend_View_Helper_Url();                                                                                                                                      
       $url = $obj->url($urlOptions, $name, $reset);                                                                                                                           
       return $url;                                      
   }

}

Pager needs to know how many total record the object paged has.
In this case, I want to count DB record.
So I added a method to count simple record of Zend_Db_Table object.
library/Hoge/Db/Table/Abstract.php

public function numRows($where = null)
{
    $select = $this->_db->select();
    $select->from($this->_name, "COUNT(*)", $this->_schema);
    // the WHERE clause
    $where = (array) $where;
    foreach ($where as $key => $val) {
        // is $key an int?
        if (is_int($key)) {
            // $val is the full condition
            $select->where($val);
        } else {
            // $key is the condition with placeholder,
            // and $val is quoted into the condition              
            $select->where($key, $val);           
        }          
    }
    // return the results
    $stmt = $this->_db->query($select);
    $data = $stmt->fetchColumn(0);       
    return $data;   
}

To use it.
It is not related to Db model. So you need to calculate the offset and limit.
But it not so difficult, isn't it? :p
application/controllers/HogeController.php

function pagerAction()
{
    $this->view->setHelperPath(dirname(dirname(dirname(__FILE__))) . '/library/Hoge/View/Helper', 'Hoge_View_Helper');
    $this->view->addHelperPath(dirname(dirname(__FILE__)) . '/View/Helper', 'Hoge_View_Helper');

    require_once 'Hoge/Db/Table/Data.php';
    $data = new Data();
    $perPage = 20; // Should be defined.
    $offset = ($this->_getParam('page') > 0) ? $perPage * ($this->_getParam('page') - 1) : 0;
    $this->view->data  = $data->fetchAll(null, null, $perPage, $offset)->toArray();
    $this->view->total = $data->numRows();
}

In the view script. Write like this.
In case you want to handle each parts of pager.

<html>
<head></head>
<body>
<? $this->pager($this->total) ?>
<?= $this->pager()->first() ?>
<?= $this->pager()->previous() ?>
<?= $this->pager()->previousRange() ?>
<?= $this->pager()->navigation() ?>
<?= $this->pager()->nextRange() ?>
<?= $this->pager()->next() ?>
<?= $this->pager()->last() ?>

<ul>
<? foreach($this->data as $k => $v): ?>
 <li><?= "{$v['id']} : {$v['data']}" ?></li>
<? endforeach ?>
</ul>
</body>
</html>

In case you want to display simple pager.

<html>
<head></head>
<body>
<?= $this->pager($this->total)->paginate() ?>
<ul>
<? foreach($this->data as $k => $v): ?>
 <li><?= "{$v['id']} : {$v['data']}" ?></li>
<? endforeach ?>
</ul>
</body>
</html>

Both of them look like this.

«‹...11121314151617181920...›»

The helper class only have responsibility creating pagination, NOT dataset, so you need to set offset and limit.
If you want to get more sophisticated "Pagination helper" see here :^)
The author is introducing a pagination helper which related to dataset.

(weight 88.6ｋｇ　BMI 31%)

From eight hells

2007-10-15T02:58:00.000-07:00

It's about a story that I had been to eight hells.

1st hell "Tatsumaki Jigoku (Tornado hell)".
In the hell, the hot water was blown up every 30~60 minutes.
The water was incredibly hot and the tornado was brew everything off.
People around us was screaming.

2nd hell "Chino Ike Jigoku (Bloody pond hell)".
In the hell, there was a large pond and it looked like full of blood.
People around us were quiet and gazed the pond.

3rd hell "Umi Jigoku (Sea hell)".
In the hell, there was a pond which looked beautiful white blue.
But once you got into it, you would never get out of it.
It opened big mouth to swallow everything.
People around us were just trying to escape from the pond.

4th hell "Bouzu Jigoku (Bouzu hell)".
In the hell, there were many pond consists of clay.
It was boiled violently.
Peopole around us were just trembled frighteningly for fear.

5th hell "Yama Jigoku (Mountain hell)".
In the hell, there were so many creatures.
One of them looked like elephant, one of them looked like condor having sharp claw.
Their eyes gazed us scarly.
People around us was trying not to match eyes.

6th hell "Kamado Jigoku (Steam hell)".
In the hell, it was too hot to be there. A huge hot steam blew to us.
We hardly open our eyes while being through the hell.
People around us were looking for water to enrich the dryness of the throat.

7th hell "Oniyama Jigoku (Devil mountain hell)".
In the hell, so many crocodilian were waiting for prey.
Some of them opened its huge mouth and show us sharp fangs.
People around us were frightened if they called to be prey.

8th hell "Shiraike Jigoku (White pond hell)".
In the hell, there ware beautiful white ponds. We could put our foot into the pond.
It releaved our pain of foot.
People around us were screaming of comfortableness.

We hopefully could come back from eight hells. And really enjoyed hells.
If we can have chance to be back there, we will try again.
(weight 89.0ｋｇ　BMI 33%)

Over the river

2007-10-07T01:03:00.000-07:00

Since my working place has changed, I haven't been able to ride my pretty bike.
These days, I could get a chance to have long vacation for 2 weeks. It's just unbelievable! Thank god !
So I decide to ride my bike while my vacation.

Then my friend suggest me to come to the place he lives. It sounds like a kind of joke, because it's too far to get by bike.
It's so challenging and I really like it. I had been wondering if I could try.

But, it kind of wasting time to think again and again.
My heart told me "No need to think, Just do it !".

So, I left my house at 14PM.
At the moment of leaving my house, I was kind of scared if I can arrive there.
After few minutes, my anxiety has blown out!
It was so comfortable to ride the bike. And so fun! My foot never stop riding!

Around 16PM. I got around "Omiya". I was almost lost my consciousness and I was at a lost there. I asked the way to "Kawa Goe" at the police station.

Around 17PM. I called my friend to ask the way to his house. He was just surprised that I was there. He kindly told me how to get his house.

Around 17:30PM. I arrived his house !! So satisfied !!
Talking for 1 hour. His son came back with mother, This was the first time to meet him, at first site, he was kind of scared :<. Because I have beard and mustache, may be so scarly for him. He was almost crying but he was so cute !! When I left his house, finally he waved his hand to me. I believe we are friend now!

Around 19PM. I left his house. I forget to take a light. I just worried if the police catch me. My friend lent me a small stand light! Wow, useless, man! It's useless!
Anyway I bought some battery to use it, and grab it while riding bike :p.
Sorry I was wrong, It helped me sometimes. You were right, friend.

Around 21PM. I could arrive at my house. Almost dead :<.

Around 21:30PM I went out with my another friend to drink beer!!

BEER! BEER! BEER! BEER! BEER!

After traveling a long distance! The taste of beer is incredibly good! It ran throw my throat!
Anyway, I really enjoyed this small trip with my cute bike!
(weight 87.8ｋｇ　BMI 30%)

Try Zend Framework vol.5 "Always absolute url"

2007-10-03T20:46:00.000-07:00

Zend Framework has some cute View Helpers.
One of them is Zend_View_Helper_Url which generates url easily.
But, it gives part of url. Sometimes I want to get absolute path. :<
Don't you want? :>

library/Hoge/View/Helper/Url.php

<?php
require_once 'Zend/View/Helper/Url.php';

class Hoge_View_Helper_Url extends Zend_View_Helper_Url
{

  public function url(array $urlOptions = array(), $name = null, $reset = false)
  {
    $server = Zend_Controller_Front::getInstance()->getRequest()->getServer();
    $url = parent::url($urlOptions, $name, $reset);

    return strtolower(trim(array_shift(split('/', $server['SERVER_PROTOCOL'])))) . '://' . $server['HTTP_HOST'] . $url;
  }

}

To use it. Nothing changes from default usage.

application/views/scripts/hoge/url.phtml


<?= $this->url() ?>

I strongly inspired by this entry. So I could write the code above. :p
(weight 86.8ｋｇ　BMI 29%)

Do you like "Sushi" ?

2007-10-03T09:59:00.000-07:00

Have you ever tried to make "Sushi" ?
I tried before, but it just a simple one which is called "Maki Sushi".

The owner of this site has outstanding skill.
There are several Sushies which she had made.

Some of them look delicious, but some of them takes more courage to eat. :p
But who cares?!
She said "Every Day is a Sushi Day!"
She is so cool ! She enjoys making Sushi every day!!

I really look up to her.
I also want to have that motivation to create something.
(weight 87.0ｋｇ　BMI 30%)

Call me if you can.

2007-09-29T21:08:00.000-07:00

I was born in a small town.
And that area is called "郡" which means country side of country sides.
But, one letter from my family tells me that I no longr am "郡民".
The return address on the letter shows "由布市" which used to be "大分郡".

What? what is this address? City?

Oh yes, the letter which I just saw means "City".
Yes, yes, yes, I'm a City boy!!

" C I T Y " Boy.

Guys! Call me "City boy !" as big voice as you can !!
(weight 86.6ｋｇ　BMI 29%)

Zend Framework 1.0.2 is released!!

2007-09-25T21:18:00.001-07:00

Yahoooooooooooooooooooooooooooooooooooooo!!

Zend Framework 1.0.2 is released today! :p

And so happy to forget how fatty I am!!
(weight I don't ｋｇ　BMI care%)

Try Zend Framework vol.4 "Validate Date"

2007-09-25T09:21:00.000-07:00

As you know, Zend Framework has a lot of fancy validators like Zend_Validte_Ccnum.
But, it comes to "Zend_Validate_Date", I have to be quiet, because it only allows "YYYY-mm-dd" format.
Date sometimes look like "YYYY/mm/dd" but the validator returns "false". :<

It's Okay. But it should be more flexible, isn't it?

Zend Framework has Date class which is pretty powerful to create date object, but it's also powerful as Date validator.
So I wrote a Date validator.

library/Hoge/Validate/Date.php

<php
require_once 'Zend/Validate/Abstract.php';
require_once 'Zend/Date.php';

class Hoge_Validate_Date extends Zend_Validate_Abstract
{

  /**
   * Invalid date error message.
   */
  const INVALID = 'dateInvalid';

  /**
   * Validation failure message template.
   *
   * @var array
   */
  protected $_messageTemplates = array(
      self::INVALID => "'%value%' does not appear to be a valid date"
  );

  /**
   * Defined by Zend_Validate_Interface
   *
   * Return if the date is correct.
   *
   * @param  string $value
   * @return boolean
   */
  public function isValid($value)
  { 

      $valueString = (string) $value;

      $this->_setValue($valueString);

      if (!Zend_Date::isDate($value)) {
          $this->_error(self::INVALID);
          return false;
      } 

      return true;
  } 

}

To use it
application/controller/HogeController.php

<php
function dateValidateAction()
{
  $date = '2004/02/29';

  require 'Hoge/Validate/Date.php';
  $validator = new Hoge_Validate_Date();
  echo $validator->isValid($date);
  exit;
}

Return "true".
It distinguish "/" and validate the Date correctly!! :p

(weight 86.4ｋｇ　BMI 29%)

Faster than it was !

2007-09-24T06:04:00.000-07:00

Chaged Mac book's memory 512 to 1G.
It's much faster than it was! So confotable!!!

(weight 86.5ｋｇ　BMI 30%)

Try Zend Framework vol.3 "Extends Zend_View_Helper_Select"

2007-09-22T07:03:00.000-07:00

Zend Framwrok has some useful helpers.
One of them is "Zend_View_Helper_Select".
Using it, you may set arguments like this.

controller/views/scripts/hoge/index.phtml

<?= $this->formSelect('hoge', null, null, array(''=>'', 'foo'=>'foo', 'bar'=>'bar')) ?>

You may not want to set blank as the default of options.

So, I extends Zend_View_Helper_FormSelect and add an argument to set default options.
library/Hoge/View/Helper/FormSelect.php

<php
require_once 'Zend/View/Helper/FormSelect.php';

class Hoge_View_Helper_FormSelect extends Zend_View_Helper_FormSelect
{
public function formSelect($name, $value = null, $attribs = null,
 $options = null, $default_options = null, $listsep = "<br />\n")
  {
    $options = (is_array($default_options)) ? array_merge($default_options, $options) : $options;
    return parent::formSelect($name, $value, $attribs, $options, $listsep);
  }
}

It's just added argument for setting default options.
But, be careful it changes the number of arguments and changed order. :>

To use it.

<?= $this->formSelect('hoge', null, null, array('foo'=>'foo', 'bar'=>'bar'), array('' => '')) ?>

Simple right? :p
(weight 86.5ｋｇ　BMI 30%)

Tagging PukiWiki

2007-09-20T04:17:00.000-07:00

PukiWiki is a pretty useful tools.
But, if only it has tagging functionality, it would be much more useful.

My friend made a sophisticated plugin and introduce how to use it on his wiki.
Now my wiki is tagged elegant!!

It must help you a lot! :>
(weight 85.7ｋｇ　BMI 29%)

Try Zend Framework vol.2 "Debug Utils"

2007-09-18T09:04:00.000-07:00

It's sometimes annoying to type "print_r" "get_class_methods".
"print_r" has 7 characters.
"get_class_methods" has 17 characters.
It just unbelievable!!
You might get hurt on your fingers.
And they just show the results as messy. It's not easy to read.

Zend Framework gives us a great class "Zend_Debug" for debugging.
It formats the result for you to read easily!

But, when you use the class you still need to type "Zend_Debug::dump()".
muu...18 characters. :<>

<php
require_once 'Zend/Debug.php';                                                                                                                                                     

function d($val)                                                                                                                                                                   
{                                                                                                                                                                                  
 Zend_Debug::dump($val);                                                                                                                                                       
}                                                                                                                                                                                 

function m($val)                                                                                                                                                                  
{                                                                                                                                                                                 
 Zend_Debug::dump(get_class_methods($val));                                                                                                                                    
}

It's just simple functions but gives you time to make coffee instead of typing a lot of long letter functions. Isn't it? :p

(weight 85.4ｋｇ　BMI 30%)

Been to Shibuya.js on 2007/09/15

2007-09-15T10:13:00.001-07:00

I had been to shibuya.js.
Some entries were so fun.

I felt "Javascript can do everything!!"

I need to study Javascript.
Already late? :p

(weight 85.6ｋｇ　BMI 30%)

Try Zend Framework vol.1 "Extends Zend_Db_Table"

2007-07-25T09:24:00.001-07:00

I tryed Zend Framework!
It's so exciteing trying on a new staff. Isn't it?

I wrote a small class which enhance "Zend_Db_Table".
I need to write down before forgetting. :p
library/Hoge/Db/Table/Abstract.php

<?php
require_once 'Zend/Db/Table/Abstract.php';

abstract class Hoge_Db_Table_Abstract extends Zend_Db_Table_Abstract
{
 protected function __call($name, $args)
 {
   $db = $this->getAdapter();

   $parts = split('By', $name);
   $how = $parts[0];
   $conds = split('And', $parts[1]);

   $where = array();
   foreach($conds as $i => $cond) {
     $cond = strtolower($cond);
     $where[] = $db->quoteInto("{$cond}=?", $args[$i]);
   }

   switch ($how) {
   case 'fetch' :
     return $this->fetchAll($where);
     break;

   case 'find' :
     return $this->fetchRow($where);
     break;

   default:
     throw new Exception("Undefined method {$name} called. 'fetchByXXX' or 'findByXXX' is allowed to call.");
   }
 }
}

Extends the class from Hoge class like this.
library/Hoge/Db/Table/Hoge.php

<php
require_once 'Hoge/Db/Table/Abstract.php'

class Hoge extends Hoge_Db_Table_Abstract
{
 protected $_name    = 'hoges';
 protected $_primary = 'id';

}

Use the extended class like this.
application/controllers/HogeController.php

<php
require_once 'Zend/Controller/Action.php';                                     
require_once 'Hoge/Db/Table/Hoge.php';

class HogeController extends Zend_Controller_Action                            
{                                                                          
 function indexAction()                                                     
 {                                                 
   $code = '01';                                                         
   $name = 'foo';                                                    
                                            
   $hoge = new Hoge();                         
   $res = $hoge->findByCodeAndName($code, $name);
 }
}

Any way I gained a lot!
(weight 85.0ｋｇ　BMI 29%)

Zend Framework 1.0 is released!!

2007-07-01T00:33:00.000-07:00

Yahoooooooooooooooooooooooooooooooooooooo!!

Zend Framework 1.0 is released today! :p

And so happy to forget how fatty I am!!
(weight I don't ｋｇ　BMI care%)

Things I didn't know about PEAR::DB

2007-04-16T23:58:00.000-07:00

I have used PEAR::DB for a log time. But I have never read a inside of it.
Today, I got to a problem about placefolder. Let me tell you about it.

I worte a SQL statement like this.

SELECT * FROM hoge WHERE id ! = ?

It looks fine isn't it? But it shows an error like this.

Fatal error: Failed to select from entry[db_error: message="DB Error: mismatch" code=-7 mode=return level=notice prefix="" info="SELECT count(id) FROM entry WHERE feed_id = AND uri = AND id = [DB Error: mismatch]"] in /home/plnet/www/plnet/bin/create_unique_entry.php on line 30

Whats? Why it doesn't replace the string correctly?
I thought the string for replacement is only "?"
But it's wrong!
There are 3 special string for replacement "?", "!" and "&".

So I wrote a sample to know how it works.
Here it is (removed error handling to read friendly :p)


$sql1 = 'INSERT INTO foo (one, two, three) VALUES (?, ?, ?)';
$sql2 = 'INSERT INTO foo (one, two, three) VALUES (?, !, &)';
$data = array(
"John's text",
"'it''s good'",
'./buz.txt'  //written "Love letter from Canada."
);

$dbh1 = $db->prepare($sql1);
$res1 = $db->execute($dbh1, $data);

$dbh2 = $db->prepare($sql2);
$res2 = $db->execute($dbh2, $data);

This is a result.


mysql> select * from foo;
+----+-------------+--------------+---------------------------+
| id | one         | two          | three                     |
+----+-------------+--------------+---------------------------+
|  1 | John's text | 'it''s good' | ./buz.txt                 |           
|  2 | John's text | it's good    | Love letter from Canada.  |
+----+-------------+--------------+---------------------------+
2 rows in set (0.00 sec)

? = scalar value (i.e. strings, integers). The system will automatically quote and
escape the data.

! = value is inserted 'as is'

& = requires a file name. The file's contents get inserted into the query (i.e. saving binary data in a db)

Actually they are written in PEAR::DB_common.
I should have read first :p.

And I recalled my excoworker told me that "Be careful when you use prepare and execute. You will have a trouble!".
Now I got it.

I rewrote it like this.
SELECT * FROM hoge WHERE id <> ?
It works well.
(weight 81.6ｋｇ　BMI 28%)

Hello again!

2007-01-11T08:06:00.000-08:00

http://mojavi.org has come back.
And it changed the name to Rapid Framework .
It was supporsed to merge with Agavi framework.
Wasn't it ? Will it be?

Any way, I hope it won't be down again.
(weight 79.0ｋｇ　BMI 27%)

What a useful.

2006-12-21T10:05:00.000-08:00

I use del.icio.us as a social bookmark and I like it.
But it's still a little annoying for me to type del.icio.us !!
where should I put dot?!
de.licio.us? delici.o.us ? de.li.cio.us?
Should I bookmark del.icio.us on another social bookmark? No way.

I had been thinking how to solve this problem and I got an answer what I didn't want to get the URL del.icio.us but wanted to get the bookmarks on it.

Here is the solution delimport.
It makes me to search bookmarks on del.icio.us via spotlight.
It's just "Wow". so useful.

Is there any software like it for Windows? I haven't seen any of it.
(weight 78.4ｋｇ　BMI 26%)

Lost the leader

2006-09-27T19:23:00.000-07:00

Pierre Alain Joye ,the leader of PEAR, had left PEAR.
He introduces his leaving on his blog.

He had been as a leader of tons of packages of PEAR.

I have to say "Thank you" for your works, really helped me a lot.
I keep my fingers crossed for your other projects and activities.
(weight 77.6ｋｇ　BMI 24%)

Everyone.

2006-09-19T06:58:00.000-07:00

Everyone has grown.

Everyone has changed.

Everyone has own life.

Sloth has gone...

(weight 78.4ｋｇ　BMI 24%)

Clean up!

2006-08-15T09:50:00.000-07:00

I have not realized, but I actually haven't used Apache and MySQL in my local PC for a long time.
so I decided to uninstall them.

It's sooooooooo comfortable like I'm saying "yahoo" on the top of mountain.
(weight 79.2ｋｇ　BMI 25%)

Speaking on Skype

2006-08-12T08:36:00.000-07:00

I had spoken to my foreign friend on Skype.
the voice was so clear and pretty easy to use.
why does not everybody use it?

I had sopken about 1hour and it was FREE!
so I hope every my friend in foreign country would use it.
(weight 79.6ｋｇ　BMI 25%)

Google Analytics

2006-08-03T09:10:00.000-07:00

I finally got a ticket of Google Analytics.
It's just "WOW".

I could guess that Google Analytics is pretty useful because it is made by Google.
But, this is more exciting and amazing than I expected.

Thank Google for giving us this service for free.
(weight 80.2ｋｇ　BMI 26%)

Gotta Bike!

2006-07-23T04:54:00.000-07:00

I have been trying to lose my weight for a long time, but I have not lose my weight yet!
So I decided to go work by bicycle!
But before starting it, I thought that I should try to go to company by bicycle.
It took almost 1hour to arrive at the company with my old bicycle.
To be honest, it is impossible to go work with my old bicycle.
Finally, I bought a bicycle made by GIANT and is pretty cool.
I didn't know about bicycle well, but my friend kindly had been to there with me to buy it.
He helps me a lot, thank you my friend.

1 week later, I got a phone call which says it takes 2 weeks to get it.
I have to wait until it's on shop.
Anyway, I am really happy getting it. And I must lose my weight!
Thanks.
(weight 79.4ｋｇ　BMI 25%)

Typhoon girls has come

2006-07-23T04:40:00.000-07:00

Two typhoon girls has come.
I could check my English skill again.
But, I realized that the skill is getting worse and worse. Actually one girl said to me .
Anyway I could really enjoyed to be with them and I have been to several places where I had never been to like Meiji Jingu, Omotesando hills.

I wish I can visit typhoon girls next time.
(weight 78.6ｋｇ　BMI 24%)

No moral in Akabane

2006-07-06T08:34:00.000-07:00

It is not possible to endure it any longer.
I saw an old guy who urinated while walking at the station.
I saw the couple playing something in front of Yokado Akabane.

And, finally today

I was on my way home and a foreign woman asked me to let her lick my ...
so scary.

Any way I will move soon.

(weight 79.6ｋｇ　BMI 24%)

As it is

2006-07-04T09:16:00.000-07:00

Thanks、Nakata.
I don't know why but the news that his retirement beat my heart.
I couldn't imagine it is too scary to loose a important person who always be with you.

Today I became a Project leader.
I will do my best. Just Do It.
(weight 80.1ｋｇ　BMI 23%)

I AM CANADIAN

2006-06-12T08:13:00.000-07:00

カナダにいたころはすげーうけた！
今は、あんまり受けない。

俺の英語力がべらぼうに落ちたから？
笑いのツボが変わったから？

あー、カナダもう一回いきてーなー　あまたつー！
(weight 80.2ｋｇ　BMI 24%)

sound good

2006-05-29T04:50:00.000-07:00

ここ結構好きです。

「お前、この歌も好きだろ？！」

ちゅー感じで流れてきます。
なんつっても、テレビねーから音楽聴くでしょ！

(weight 81.6ｋｇ　BMI 26%)

？葉のクローバー　その後

2006-05-16T08:58:00.000-07:00

お前ら、絶対に三つ葉だろ！

ベランダの鉢はもう三つ葉で溢れ返っております。
これって何葉になるかわかんねーんじゃなかったの？

完全に三つ葉ですよね？！　アータ達。

まぁ、とりあえず水はあげてみよう。
(weight 82.2ｋｇ　BMI 27%)

ボールは友達

2006-05-07T00:07:00.000-07:00

すげー！　まじで震えた！
joga tvでリアルキャプテン翼が見れた。
(weight 81.6ｋｇ　BMI 26%)

めでたい！

2006-05-04T02:09:00.000-07:00

友達に子供が生まれました！
友達って言っても、ただの友達じゃなくって、3歳ぐらいからの親友。
小、中、高と同じ学校行って、結婚式ではスピーチまでやっちまいました。

そんなヤツになんと子供が、、、女の子らしいです。
嫁には行かせねーだの、すでに親バカ全開でした。

名前もまだ決まってないらしいけど、とりあえずおめでとう！

そして、生まれてきた子（すまん、こんな言い方で）
あんたはラッキーだよ！だって俺がヤツと友達でラッキーだもん。
(weight 81.2ｋｇ　BMI 26%)

急性難聴

2006-05-02T22:26:00.000-07:00

「耳が聞こえねー！　しかも左耳だけ！」

って思って1週間たったのでさすがに病院行きました。
いろいろ検査をやって、診断結果は

「急性難聴」　だそうです。

ずーっと耳に水が入ったままなのかと思ってた。
で、お薬もらいました。

　アデホスコーワ顆粒
　メチコバール錠500ug
　セルベックスカプセル50mg
　プレドニン錠5mg

で、この中のどれかがステロイドなんだって、、、

つまり、お医者様は
「難聴なんかに負けない強い子になりなさい！」
って言ってるんだね。
(weight 80.4ｋｇ　BMI 23%)

？葉のクローバー

2006-04-03T09:15:00.000-07:00

ちょっと変わったクローバーを育ててます。
何が変わってるかというと、このクローバー

葉っぱが何枚になるかわからない！

ってことです。

今のところ2つ葉かな？
やさしい？同居人が置き土産に、狭くなった入れ物からちゃんとした鉢に植え替えてたので毎日、５００ｃｃの水をあげてます。

俺としては7つ葉がいいなー。

あと、ちょっとした発見。　
クローバーって夜は葉っぱを手を合わせるみたいにして閉じるんだね。
(weight 83.0ｋｇ　BMI 27%)

TGIF

2006-03-31T07:36:00.000-08:00

PHP界隈で期待のZend Framework のsvn up の結果です。

colinux:~/www% svn up ZendFramework
U ZendFramework/documentation/en/module_specs/Zend_Mail.xml
リビジョン 59 に更新しました。

へ？　こんだけ？　

前日は

A ZendFramework/incubator/library/Zend/Search/Lucene/Search/Weight
A ZendFramework/incubator/library/Zend/Search/Lucene/Search/Weight/MultiTerm.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Search/Weight/Phrase.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Search/Weight/Term.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Search/QueryParser.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Search/Query.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Search/QueryToken.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Search/Similarity.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Search/Weight.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Index
A ZendFramework/incubator/library/Zend/Search/Lucene/Index/Writer.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Index/SegmentInfo.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Index/FieldInfo.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Index/SegmentWriter.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Index/TermInfo.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Index/Term.php
A ZendFramework/incubator/library/Zend/Search/Lucene/Field.php
A ZendFramework/incubator/library/Zend/Cache.php
U ZendFramework/demos/Zend/Search/Lucene/feed-search/search-index.php
U ZendFramework/demos/Zend/Search/Lucene/feed-search/create-index.php
D ZendFramework/documentation/en/module_specs/Zend_Search.xml
A ZendFramework/documentation/en/module_specs/Zend_Search-Overview.xml
A ZendFramework/documentation/en/module_specs/Zend_Search-Queries.xml
A ZendFramework/documentation/en/module_specs/Zend_Search-JavaLucene.xml
A ZendFramework/documentation/en/module_specs/Zend_Search-IndexCreation.xml
A ZendFramework/documentation/en/module_specs/Zend_Search-Searching.xml
A ZendFramework/documentation/en/module_specs/Zend_Search-Extending.xml
U ZendFramework/documentation/en/manual.xml
U ZendFramework/documentation/fr/module_specs/Zend_Search.xml
リビジョン 58 に更新しました。

ってな感じ。

おお！そうか今日は金曜日だった。異国の方々は働かない日でしたね。

そして俺は連続出社日数２６日を越えましたとさ。
(weight 82.2ｋｇ　BMI 26%)

健康診断

2006-03-16T08:52:00.000-08:00

今日、会社で健康診断がありました。
そこで気づいた事が。。。

俺は老化していってる！

視力は両方とも0.5ずつ下がった。
身長は1cmぐらい縮んだ。
体重は順調に増えている。

やばいな。ちょっと運動しよう。。。
(weight 81.4ｋｇ　BMI 25%)

旅行三昧

2006-03-05T06:33:00.000-08:00

同居人が実家に帰っちゃうので、思い出作りに旅行に行きまくりです。

3月2日：
23:00 pm
深夜キラキラバスにていざ大阪へ。座席が広い。ぐっすり寝てやりました。

3月3日：
7:00 am　
大阪到着そのままUSJへ。

10:00 am
チケットとブックレットを購入。
このブックレットが非常にパワフル！TDLの優先チケットとはわけが違う。本当にすぐに乗れます。すごい行列の横をスーーーっと通りすぎるのは、ドSの僕らには堪えられませんでした！
そんな、ストレス解消もあってUSJは思ったよりもかなり楽しかったです。

17:00 pm
晩飯を食べに行きました。スペアリブを選択。美味かったです。

3月4日：
10：00 am
起床、楽しみにしていた朝食しに32階へ。運良く窓際が開いていて座らせてもらいました。
USJの周りって工業地帯なんだね。

12：00 pm
大阪は難波へ。NGKへ行きました。立ち見席15：00～しか開いてなくやむなく購入。

15:00 pm
本物の吉本新喜劇を生で見るのは初めてで大興奮でした！やっぱり生は面白いです。
他の出演者（宮川大助花子、大木こだまひびき、桂文珍）なども大爆笑でした。

21：30 pm
いざ東京へカムバック！そーとー遊んだので疲れきってました。バスに乗ると速攻爆睡。

3月5日：
7:00 am
我が家へ到着。そのまま2度寝へ、2度寝最高！

10：00 am
起床、今日はずっと前に同居人が結婚式の引き出物でもらったレストランのチケットで贅沢ディナーの予定。

19：00 pm
ディナー開始。ほんとに贅沢な場所でびっくりした。今までこんなところで食ったことねーよ！
生まれてはじめてのフォアグラ、トリュフなるものを食しました。同居人と「ここ、ゴチとかで使われて
そうだよねー」とか言っていたら、ホントに使われていてこれまたびっくり！とても美味かったです。

21：00 pm
東京タワーへ、すんげーきれいでした。でも高所恐怖症の僕にはドキドキハラハラの1時間でした。

23：00 pm
帰宅、とっても楽しい3日間でした。また遊びに行きたいね。
(weight 83.2ｋｇ　BMI 26%)

フレーズ

2006-02-17T21:17:00.000-08:00

ヨクバリスギ
シアワセスギ
ムサシコスギ

なんてすばらしいフレーズなんだろう。
これ以上武蔵小杉を賛美したフレーズはないと思う。
(weight 82.2ｋｇ　BMI 25%)

DVD鑑賞２

2006-02-12T05:50:00.000-08:00

久しぶりに鑑賞会をしました。

「チャーリーとチョコレート工場」
　すんげー面白かった！ウンパ・ルンパのダンスが楽しい！
(weight 81.6ｋｇ　BMI 26%)

自分のルーツ

2006-02-04T06:22:00.000-08:00

耳垢がカサカサかべちょべちょかで自分のルーツがわかるそうです。

カサカサ：シベリア人タイプ、体臭が強い、日本人は8：2の割合でこちら

べちょべちょ：縄文人タイプ、体臭が弱い、西洋人は8：2の割合でこちら

だそうです。ちなみに美輪明宏さんはカサカサではなくさらさらだそうです。
(weight 80.4ｋｇ　BMI 24%)

Screen grab!

2006-01-29T06:55:00.000-08:00

ドキュメントなんか作るとき画面キャプチャとか取ります。
そんな時かなり便利なのが「Screen grab!」さん。

でも、1.5に入れたらエラーでました。

なので、、、
1.screengrab.jarを解凍。
2.screengrab\locale\screengrab\ja-JP\screengrab.dtdをUTF-8で保存。
3.zipで固めて.jarにリネーム。このとき解凍したscreengrabを固めちゃだめ、screenbrab直下を固めること。
4.screengrab.jarを上書き。

エラー直っちゃった。これでいいのかな？
(weight 81.6ｋｇ　BMI 25%)

ENT_QUOTES

2006-01-29T06:26:00.000-08:00

英語の説明だと
''' (single quote) becomes ''' only when ENT_QUOTES is set.

日本語の説明だと
ENT_NOQUOTES が設定されている場合のみ、 ''' (シングルクオート) は '''になります。

「なんか、このミスが直訳してない手作り感が出ててすごく良いな～！」

とか、思うかよ！ちょっと探したわ！
(weight 81.6ｋｇ　BMI 25%)

サッカー少年

2006-01-09T08:13:00.000-08:00

高校サッカーを久しぶりに真剣に見ました。

　「野洲高校優勝」

大阪朝鮮高校にPK勝ちしたくらいまではラッキーだなって思ってたけど、決勝戦を見てびっくり！むちゃくちゃ上手いんですな、彼らは。。。
九州出身の僕だけど、野洲高校応援してしまいました。
おめでとう野洲高校イレブン！
(weight 82.2ｋｇ　BMI 27%)

DVD鑑賞

2006-01-09T07:49:00.000-08:00

3連休なんで、DVD鑑賞しました。

「The Ring 2」
　すんげーつまらんかった！サマラさん、ぜんぜん怖くねーっす。。。

「TAXI 2」
　すんげー面白かった！黒人のねーちゃんおもろいっす！

「Life is beautiful」
　感動した。こりゃすごいオヤジだ。
(weight 82.2ｋｇ　BMI 27%)

寝正月

2006-01-04T06:48:00.000-08:00

今年は、同居人と「寝正月を決め込む」と誓ったので、
どっこも行きませんでした。
で、DVDを借りて見ました。

「SAW」　
　おもしろかったです。まさかやつが。。。SAW２も早く見たいですな。

「カンフーハッスル」
　なんでジャッキーがすごいのか良くわかりました！
(weight 81.4ｋｇ　BMI 28%)

あけおめことよろ

2006-01-01T17:23:00.000-08:00

あけまして、おめでとうございます。

まずは、初詣。いつもの神社に行っておみくじを引きました。

「末吉」

ちっくっしょー！3年連続大吉をねらっとったのに！

毎年恒例の品川プリンスでのカニ食いに行ってきました。
今年も、ひたすら食ったなぁ。。。
となりのおじさん、カニ飛ばしてごめんなさい。

その後はボーリングへ、同居人はやっぱりヘタクソでした。

最後は、IMAXシアターで「ハリーポッターと炎のゴブレット」見ました。
チョウ・チャンかわいかったっす！

では、年賀状を送らなかった皆さん！　今年も宜しくお願いいたします！
(weight 81.0ｋｇ　BMI 23%)

Friends

2005-12-31T04:45:00.000-08:00

フレンズのファイナルシーズンを鑑賞しました。
最後の終わり方とかすごいよかったですぁ！

さてさて、他にも借りてきたカンフーハッスルとSAWもみまっせ。
体重の増加は年末なので気にしないでおこう。。。
(weight 82.4ｋｇ　BMI 26%)

クルシミマス

2005-12-25T08:03:00.000-08:00

今年の、サンタクロースは苦労した模様である。

だって、サマンサ・タバサなんかよー知らんし！

(weight 81.2ｋｇ　BMI 25%)

3兄弟

2005-12-19T07:57:00.000-08:00

同居人が、またやってくれました。

川平慈英　と　ジョン・カビラ　と　彦麻呂　を3兄弟と思ってました！

「あーこの人、

　『うわ～宝石箱や！！味のIT革命や～！！！！』

っていう人の兄ちゃんやー！」

って、川平慈英を見て言いました。
次の日、、、ジョン・カビラをみてまた、同じことを言ってました。

あんた、立派だよ。
(weight 80.6ｋｇ　BMI 26%)

診断結果

2005-12-12T08:03:00.000-08:00

同居人が今朝、突然股関節が痛いと言い病院へ行きました。

心配だったのですが、診断結果は。。。

「ただの、運動不足！」でした。

｢体をバージョンアップしてください。｣って言われたんだって！

くゎー、ウケルわー！
(weight 80.0ｋｇ　BMI 24%)

CMソング

2005-12-06T08:29:00.000-08:00

中田英寿選手が出演してるCMのバックで流れてる曲がかっこいいなーと思って調べてみました。
「anis」って人が所属する「monora」ってバンドが歌ってるんだって。
タイトルは「VISIONS IN MY HEAD」なんだとか。

いやー、ほんとエエわー！
(weight 79.2ｋｇ　BMI 24%)

二泊三日

2005-12-01T07:25:00.000-08:00

久しぶりに会社に泊まりました。しかも二泊三日です。
眠くて眠くて二日目には武者震いが起きました。

いま、すんげーねむてー。。。

では寝ます。オヤスミナサイ。。。
(weight 79.6ｋｇ　BMI 26%)

サマージャンボ献血

2005-11-26T04:24:00.000-08:00

買いました、サマージャンボ。
ついでに献血しました。前回と同じ流れです。

宝くじ買って、その帰りに人助け！

三億円はもらったようなもんですたい！
(weight 78.4ｋｇ　BMI 26%)

サザエさん in 2005

2005-11-26T04:04:00.000-08:00

サザエさんの髪型って、今でも美容院とかでオーダーできるらしい。。。
頼むときは

「ロールにしてちょうだい！」

って言ってください。
それよりも驚いたのはサザエさん24歳なんだね！もうとっくに年下でした。
(weight 78.4ｋｇ　BMI 26%)

エイトマン

2005-11-25T07:54:00.000-08:00

「ひかるー海、ひかるー大空、ひーかーるー大地」
って、SMAPの歌じゃないんだって。

アニメエイトマン→原辰則応援歌→スマップ

だってさー！
(weight 79.6ｋｇ　BMI 25%)

Google Adsense

2005-11-24T09:14:00.000-08:00

ついに、契約完了しました！
管理機能で見る「本日の総収益額」は、かんなり楽しいですたい！
入金も銀行振り込みとかできてかんなりNICE!

っつてもまだ USD0.00 です。

これから、これから～。
(weight 79.6ｋｇ　BMI 24%)

3丁目の夕日

2005-11-23T06:14:00.000-08:00

久しぶりに映画を見に行ってきました。

「Always 3丁目の夕日」

感想は、ものすごく良かったです！
僕もあんな時代に生まれたかったなーとか思いました。

鈴木則文（堤真一）かっこよかった。。。
(weight 79.6ｋｇ　BMI 28%)

試す！Google

2005-11-20T05:29:00.000-08:00

「Googleデスクトップ」を使ってみました。
インクリメンタル検索なのがとっても乙でした。
サイドバーにすると「タスク管理」や「簡易メモ帳」なんかも使えて便利だね。

「Google AdSense」に申し込んでみました。
Bloggerにしておいて良かった。
テンプレートへの書き込みがBlogger上でできてすごい楽ですたい!
ちゃりんちゃりん生活がたのしみやわー！
(weight 78.6ｋｇ　BMI 27%)

sourceforge.net

2005-11-19T05:49:00.000-08:00

sourceforge.net がデザイン一新してました。
しかも、レスポンスはやくなってます。
(weight 78.5ｋｇ　BMI 25%)

帰ってきたTOEIC

2005-11-18T08:22:00.000-08:00

返ってきました、恐怖の結果が！

僕　　　　： 645点　前年度比 100点DOWN
同居人　： 830点　前年度比 20点UP

立ち直れません。。。
だってあいつぜんぜん勉強してねーし、もこみち好きだし。
(weight 77.5ｋｇ　BMI 26%)

勉強会

2005-11-09T07:24:00.000-08:00

会社で勉強会をやってます。毎週水曜20:00スタート。
みんな、良いネタを毎回用意してくれてとても勉強になります。

僕も一度発表しましたが、そろそろ次の用意をしなきゃね。
(weight 77.5ｋｇ　BMI 25%)

TOIEC

2005-10-27T09:30:00.000-07:00

受験しました。

実力は、、、「はっきりいってそーとー落ちている！」

と実感しました。
はー結果がたのしみやわー。
(weight 78.0ｋｇ　BMI 24%)

才色兼備

2005-10-13T09:16:00.000-07:00

シャロンストーンってIQが高いらしい。

ちなみに僕は、、、

2004年　115
2005年　95

どんどんおバカさんになって行ってます。。。
(weight 79.8ｋｇ　BMI 26%)

バイバイ、みなぞう

2005-10-04T08:39:00.000-07:00

みなぞう君が急死しました。
この間は元気な姿を見せてくれたのに、、、残念。

天国でもみんなのアイドルになっとくれ。

バイバイ　みなぞう君。
(weight 79.4ｋｇ　BMI 23%)

27ってこと

2005-09-30T08:37:00.000-07:00

27歳になりました。
もう、生まれて27年もたったんだね。
そろそろがんばって自立してみます。

いままで、ご迷惑をかけてたみなさん、そして同居人
これからも迷惑かけます。

だっておで末っ子だもん！イェイ！
(weight 79.2ｋｇ　BMI 28%)

ただいまちゃん！

2005-09-27T23:07:00.000-07:00

ただいま帰りました！　とりあえず、、、

「グアム最高！！！」

ってことで非常に楽しい旅行でした。
社会復帰はもうできそうにありません。。。
ではでは、この三日間の内容を残しておきます。

１日目
　1：00~
　　タクシーでホテル（Onward Beach Resort）直行。
　　午前２時ぐらいに到着、就寝。
　　タクシー代： $25ぐらい、ツアーだと他人のホテルも回らなきゃならん。。。
　　　　　　　　　　ツアーじゃなくて良かった！

２日目
　10:00~11:00
　　近所のレストランへ、チャモロ人達がよく来る店なだけあって豪快な朝食。
　　量多すぎ。
　
　12：00~14：00
　　海で泳ぎました。
　　自分の巣を僕から守ろうとする熱帯魚がいっぱいいてかわいかったです。

　14：00~15：30
　　ジェットスキーに乗る。
　　浅瀬で4つのブイの周りを「ぐるぐる、ぐるぐる、ぐるぐる」回った。
　　30分ぐらい回り続けた。
　　途中からなれてグイグイすっ飛ばして気持ちよかった～。
　
　16：00~17：00
　　パラセーリングでぶっ飛ぶ。
　　ライフジャケットを装着してすっ飛んでいくのはとても気持ちよいです！
　
　18：00~19:00
　　同居人の友人の先輩（遠いな）が経営されてる民芸品店へ。
　　なんとここでは「本物の銃が撃てるんですよ！！！」
　　かなり緊張しました。撃ったのは以下の4種類。

　　38口径　　：　連射式。衝撃よわい。薬莢が飛びまくる。　　
　　44口径　　：　6発の弾を詰め込む　衝撃すごい！
　　46口径　　：　6発の弾を詰め込む　衝撃すんごい！
　　　　　　　　　　　なんか冴場涼になった気分。
　　ショットガン：　ものすんごい衝撃！これはおまけ。
　　　　　　　　　　　親戚のおっちゃんはこれでいのしし狩りをやってます。

　結果：186点　かなりへたくそ。僕に人は殺せません。よかったー。

　20：00~21：00
　　ちょっと高級なレストランへ、ステーキを喰らう！　とても、美味かった。
　　窓際の席にしてもらえなかったのはジーンズのせい？！
　　と同居人も気になっていた模様。

3日目
　12：00~
　　ホテルのプールで泳ぎました。

　　流れるプール　：プカーっと浮き輪に乗って流され続けました。
　　　　　　　　　　　　　1周15分ぐらい
　　マンタ　　　　　：超急傾斜滑り台に挑戦！　
　　　　　　　　　　　　　かなりの角度で落ちるって感じでした。
　　　　　　　　　　　　　気持ちよかったです。
　　　　　　　　　　　　　同居人はかなり足がガクガクしてたらしい。くすっ！
　　波のあるプール：波がわりかし高くて面白かった。
　　　　　　　　　　　　　海で溺れるときってあんな感じなのかな？！
　　滑り台　　　　　： A、B、C、D の各種すべり台あり。
　　　　　　　　　　　　　デブなほどすごい勢いで滑れる！
　　　　　　　　　　　　　いやー、このときばかりはデブで良かったと思ったね。

　17：00~
　　近所のレストランへ、2日目とは違う店へ。ここでステーキをたいらげる！
　　やっぱすごい量。。。とても美味かった。ベイビーロブスターがナイス！

　21：00~
　　4日目が朝早いので12時まで寝る予定だったんだけど目が覚めた。
　　近所のスーパーへ行きました。
　　カナダにいたときによく使ってたスーパーっぽくて落ち着きました。

4日目
　1:00~
　　帰宅準備。4時の飛行機なので2時には空港つく予定で出発。
　　タクシー代　：　$15　あれ、行きのタクシー$25じゃねかったか？！　
　　　　　　　　　　　行きのタクシーぼってねーか？！ちくしょー！！　
　　　　　　　　　　　でも、まいっか。

まぁ、なにはともあれ「とても楽しい３泊４日の旅でした。」
また行きたいね、同居人。
(weight 78.6ｋｇ　BMI 26%)

グアム出発

2005-09-25T03:34:00.000-07:00

夏休みがやっと取れました。グアムに行ってきます。
今、成田のヤフーカフェにてブログ更新中！

仕事は完全に忘れて満喫しまっせー！
でも、ちょっとだけ同じ部署の後輩君が心配です。

まぁ、何はともあれ、泳ぎまくって必ず日焼けしてやります。
がんばれよー後輩君！

ドルフェリ～ア

2005-09-23T06:43:00.000-07:00

新江ノ島水族館にいってきました。
イルカのショーを見ました。その名も、、、

「ドルフェリア！！！」

ぱっ、パクリ？！って思ったけど気にしません。
だって、ダンサーのおねーさん達がかわいかったから！

みなぞう君もみました。
ものすごくデカイ！体重２トンらしいです。
目が西川きよし師匠みたいでした。
(weight 78.2ｋｇ　BMI 24%)

逆流食道炎

2005-09-20T07:59:00.000-07:00

同居人の診断結果です。

「逆流食道炎」

刺激物が好きな人がよくかかる病気らしい。
そーいえば、あんた辛口ジャーキーが好きだね。

とりあえず、重病じゃなくてよかったよ。
刺激物は控えなさい。ビールは僕が飲んどきます。
(weight 78.2ｋｇ　BMI 23%)

ストレス性？！

2005-09-18T05:21:00.000-07:00

体調が悪いらしい。。。
胃がムカムカする、ということでヘルシースリム赤羽整体院に行ってきました。
ここの、ＣＯＳＭＯ－ＡＲＤＫってマシンが体の調子をデータとして見せてれるらしい。

結果はA~Dのレベル判定してくれます。
A : excellent
B : good
C : weak and may a concern
D : concern

結果
僕　　　: すこぶる健康
同居人 : 非常に不健康

同居人の結果、ほどんどがD判定。
同居人いわく、「あんたと一緒にいるとストレスで悪化している！」とのこと。

本気で心配になってきたので、病院にいくことにします。
(weight 78.0ｋｇ　BMI 28%)

べるかんぷ

2005-09-14T09:50:00.000-07:00

Dennis Bergkamp選手が引退するそうです。
サッカー選手の中で一番好きな選手でした。

オランダのユニホームが一番似合っていたんじゃないかな？

36歳まで現役だったのは感服ですたい。
僕も、もしかしたら、まだ日本代表に間に合うのかも。。。
(weight 78.2ｋｇ　BMI 26%)

屋形舟

2005-09-10T08:44:00.000-07:00

同居人の会社のレクレーションに参加しました。
なにやら、「屋形舟で飲み会」の予定でしたが、、、

なんとその船は、「タイタニック号」ばりのでかさでした！

レインボーブリッジの下を通過したりして貴重な経験ができたですたい。

そして、、、飲みすぎた同居人は1年半かけて作ったイメージを
今日一日で崩壊していました。
お誕生日おめでとう、今日から新しい君の人生が始まるよ。
(weight 78.0ｋｇ　BMI 29%)

時は来た

2005-09-08T09:31:00.000-07:00

故橋本真也氏が残した名言です。

「時は来た。」

蝶野氏が笑いをこらえていました。
僕はあまりの衝撃に気絶しそうでした。

今でも仕事中に思い出して吹いてしまいます。

夢をありがとう。そしてご冥福をお祈りいたします。
(weight 78.4ｋｇ　BMI 22%)

Putty

2005-09-05T09:48:00.000-07:00

ってずーーーーっと
「プッティー」って読むんだと思ってました。
本名は「パティ」なんだって、、、
まぁ、どっちもかわいいからいいや。
(weight 79.8ｋｇ　BMI 22%)

ビバ！バースデー

2005-09-03T08:19:00.000-07:00

同居人が本日8時30分にて、２x才の誕生日を迎えました。
ビバ！バースデー！　というわけで、お台場行ってきました。

モンスーンカフェでのディナー！タイ海老トーストが超美味かったです。
ジョイポリスで遊びまくりました。　誕生日だとバースデーチケットがもらえるんだね。

で、アトラクションの中の
「着信あり２」、、、チョー怖えぇ！！　あーゆーの嫌い。
「ヴァンヘルシング」、、、ペペがおもろかった。

たくさん遊んできました。
なにはともあれ、お誕生日おめでとさん。
そして、新生同居人よろしくな。
(weight 78.8ｋｇ　BMI 26%)

生誕うんじゅー年

2005-09-02T08:35:00.000-07:00

同居人が明日、生誕２ｘ数年を迎えます。

まぁ、つづきは明日にでも書こうかな、、、？
(weight 78.8ｋｇ　BMI 25%)

末っ子

2005-08-31T10:54:00.000-07:00

会社で朝スピーチなんてものがあります。
今日の話題は「社内コミュニケーションの難しさ」ってなことでした。
そりゃ、300人近くもいれば難しいのは当然だろとか思い。。。

「じゃ、どうやって解決すんの？あんたの考えを聞かせておくれやす。」
って思ったけどそっとしときました。

僕は、誰かに問題提起するときは、必ず自分なりの解決方法もついでに提案するべきじゃね？
なんて思ってやってはみてるのですが、むずかしいですたい。
そして、めんどくせーからどうするべきか、どっちがよいか、なんて考えません。　

だって僕、末っ子だかだ～！
(weight 78.6ｋｇ　BMI 23%)