jQuery UI provides many fancy user interfaces for web developers. You can follow the steps below in order to use jQuery UI in CakePHP.
1. Download the jQuery UI library at jqueryui.com
2. Unzip the downloaded archive and copy the css folder and two .js files to <CAKEPHP_PROJECT>/app/webroot Continue reading Integrate CakePHP and jQuery UI
Update @ 2012-09-25: This approach could not handle the DST zones. Thanks for the comment made by Lucas. =)
You can make use the TimeHelper to offset the time by user specified time zone. What u need is adding a new time_zone column in the users table just like the following example.
--MySQL CREATE TABLE IF NOT EXISTS users ( user_id INT NOT NULL auto_increment, name VARCHAR(45) NOT NULL, password VARCHAR(45) NOT NULL, time_zone DECIMAL(5,1) NOT NULL, created DATETIME DEFAULT NULL, PRIMARY KEY (user_id) ) ENGINE = InnoDB;
Recently i have started another CakePHP project. i found that the example in Ajax implementation on CakePHP @ 2 should be changed as follow.
ajax_controller.php
<?php
Class AjaxController extends AppController {
var $name = 'Ajax';
var $helpers = array('Form','Html','Javascript', 'Ajax');
var $components = array('RequestHandler');
function afterAjaxAction () {
// get the $this->data to collect the form information
// save the object to database
// render the after_ajax_call.ctp
$this->render('/elements/layout/after_ajax_call');
}
}
The view file in CakePHP is with .ctp extension. By default, Eclipse does not know which editor should be used to open this kind of file. If you associate it with PHP Editor in Preference -> General -> File Association, you will find there is no syntax highlight in the editor.
Here comes to the solution.
Continue reading Opening .ctp file with Syntax Highlight in Eclipse
About a half year ago, i posted an article about exporting data to an .xls file in CakePHP.
CakePHP – Export data to a .xls file
It is found that the exported .xls cannot be opened in OpenOffice. Today, Stebu finds the solution. Here is the modified helper class.
Continue reading CakePHP – Open an xml Formatted .xls in OpenOffice
We have talked about how to read data from an excel file in previous articles.
CakePHP – php-excel-reader
CakePHP – Read data from an excel file into an array
Continue reading CakePHP – Export data to a .xls file
In the last article – CakePHP – php-excel-reader, we have implement the php-excel-reader. Now i would like to read the excel content for processing instead of just displaying it in the view.
Continue reading CakePHP – Read data from an excel file into an array
The next enhancement on the BHJS Alumni website is adding an import function such that a bench of graduates could be created in the Database without adding new member one by one. Importing the records from an excel file would probably the most common and straight forward way.
Continue reading CakePHP – php-excel-reader
After working for about one year, the BHJS Alumni website phase 2 is completed. But after it is deployed in production server, i found that some email addresses are regarded as invalid email address. The email validation rule which i used is provided by CakePHP. Only email addresses ended with .com, .org etc… could pass the validation rule.
So i ask the Google teacher and luckily i am not the only one to come across this problem.
Continue reading CakePHP – Email Validation
Some times if you wanna show more than one chart in the view. You can make use of the render function such that different charts are shown in different div by providing the div id.
Continue reading FlashChartHelper @ 3
Eureka! 