Cake PHP useful tips

I come back

2011-03-22T11:47:00.000-07:00

Hi everybody!

I have come back. I look - you read this blog and still have interest to CakePhp. So, I will write more and repost more interest and useful thing ;-)

Behavior in belongsTo request...

2009-05-22T05:26:00.000-07:00

As usual I was not looking for easy ways, and as usual faces challenges not addressed in book.cakephp.org ;-)

Always, the most troublesome part of the project for me is paginate and all that associated with it (sampling, sorting).

And now, I once again stepped on a rake, and the answer to my question - no.

So, what was the challenge:

Model A - hasMany Model B
Model B - belongsTo Model A

Model B - actAs ( 'Image')

Image - a wonderful Yevgenia Tomenko behavior, which is used to link entries in the model with the stored image.

In the case of a request Model B -> ... of any form - behavior of hours worked, and I got me the correct information - in this case, pictures.

However, when the problem began to build a query type

Model B -> Model -> A (in terms of where the sample is on the fields of Model A)

turned out - that the search and pedzhinatsiya work perfectly, but the results of Model B - no trace of the behavior ... I just got a field model, without the right to me «curvature».

No dancing, dancing with Contain, the order request, etc. - No effect. Well the answer is no, and guglegruppe.

And today I found another rake, but with behavior Translate. If you use the instructions and do as they advised - and it works fine, except my favorite pedzhinatsii ...

And it is - sort of fields located in the i18n table - you can not. Not possible. Only those fields that are present in an explicit form. Whew.

Of course, I do not want to say that sorting through the i18n table built to work quickly, or, in principle, be attributable to work. Maybe not. But in this case, if you need some sort of results except for id, created - no chance to use the behavior you do not. It does not work. : (

And if the rake can bypass the second request (first received the list of id Model B, and then to obtain directly from the Model B, all records (this is work behavior). In the second rake, the only way to sort - to dispense with boxed behavior.

But I have the trick ;-)

$results = this->Immovable->Best->find('all',array('conditions' => array('Best.country_id' => $country), 'limit' => 5, 'contain' => array('Immovable' => array('order' => array('Immovable.created' => 'ASC')))));

$result = $this->Immovable->Behaviors->Image->afterFind($this->Immovable, $results, false);

In this case, the results will be applied behavior

Cheers!

double HABTM how to?

2009-01-08T03:56:00.000-08:00

We have:

Post HABTM Tag
Post HABTM Category

We need:

Get all posts where Category.id = M, Tag.id = N
In CakePHP style, of couse ;-)

Scaffolding (just use cake console, nothing strange, all - typical).

Table:

posts: id, title, body
tags: id, title
category: id,title

join tables:

posts_tags: id, post_id, tag_id
categories_tags: id, post_id, category_id

How to?

Easy...

$this->Post->bindModel(array('hasOne' => array('PostsTag','CategoriesPost')));

(add param false if want to make paginate ;-)

And now:

$posts = $this->Post->find('all',array(
'fields' => 'Post.*',
'conditions' => array('PostsTag.tag_id' => 1,'CategoriesPost.category_id' => 4),
));

That's all, folks.

You can add params recursive = 0 (I think it good idea to reduce data in result)
You can use any cake-style 'or', 'and' in conditions query.

And this works well ;-)

Comments

2009-01-05T04:45:00.000-08:00

Dear readers!

Blogspot have too non-usability UI for comment reading and answering.

Yes. I read all your comments, but I remember - I saw some questions in your comments, but after "aprove" I cann't found comments ;-(

If you have question - ask me in twitter: cakephp
http://twitter.com/cakephp

I'll try answer to all your question with my bad english ;-)

CakePHP 1.2 Stable is finally released!

2008-12-26T07:25:00.000-08:00

And now we have release ;-)

Merry Christmas and happy New Year and happy CakePHP! ;-)

ACO\ARO - no problem!

2008-12-05T11:11:00.000-08:00

Recently, I finished my first application using Auth (ACO \ ARO). It turned out it was not scared.

It's simple, easy.

However, there are nuances. First hand accounts add all of these controllers ACO / ARO. Secondly Auth after login does not want to understand the prefix admin, and I get to the admin / posts / main - no way out, only to / posts / main. I had to write an additional line in routes.php

In general - I am happy. Very nice work. Faster and more convenient than dispose of around $ this-> obAuth-> check (...)

;-)

CakePHP vs RoR

2008-11-27T13:42:00.000-08:00

Why you still with CakePHP? Why don't switch onto Ruby on Rails?

Just interesting to know...

ACL ACO Howto...

2008-11-23T12:09:00.001-08:00

Just do it few simple steps, and you haven't any more questions about ACL|ARO...

http://book.cakephp.org/view/641/Simple-Acl-controlled-Application

CakeBook source

2008-11-20T13:22:00.000-08:00

And now You can read and study on CakeBook (book.cakeforge.org) sources code ;-)

http://thechaw.com/cakebook

I'm going for popcorn ;-)

You see? Guys work on CakeBook over 39 years! Starting in 1969... Nice hippy time.. Love drugs and rock'n'roll ;-)

So it's funny, but really - very nice time to start learning how to write code RIGHT

PHP 2008

2008-11-18T03:06:00.000-08:00

Asked to look and move the site, written by one system administrator. The site is written in php without a bare framework.

What do you say friends? At the yard - in 2008, and within - solid global variables.

And type:

INSERT INTO ... ". $ _GET [" Param1 "] - and does, at every turn.

As their site is not hacked so far - do not understand

ACL ACO ARO

2008-11-02T07:00:00.000-08:00

Don't understand....

Terrible things

Automobile project

2008-10-27T12:20:00.000-07:00

Hi, friends!

I was silent a long time, because it was a lot of work. Yes, despite the looming default in our country (I hope I am wrong). Like most of my friends, we work, work, work ...

Now I want you to submit a site devoted to selling cars - prodam-auto.com. The site in Russian, so forgive me, the English-speaking friends (google will help you to understand that where and how).

The site just completed its local run and fixing errors. Now going on alpha testing.

I have already found a couple of points that I missed in the development of the site. Now I think whether it is a mistake, or feature ;-)

Thanks to that tolerate me!

Twitter

2008-10-09T00:33:00.000-07:00

I think the twitter is more useful than short message in blogger.com

So, welcome to my twit: www.twitter.com/cakephp ;-)

Browsers

2008-09-10T01:27:00.000-07:00

I went to see w3school statistics browsers… However, employment trend emerges.

As this is still statistics, that is close to the "Rules on Water" does not look at absolute figures, but on the relative changes…

2004, IE = 76.2%

2005, IE = 68.9% Fx 23.6%

In 2006 IE = 60.6% Fx 29.9%

In 2007 IE = 57% Fx 36.3%

2008, IE = 50.6% Fx 43.7%

Even if there plus minus 5-10% in accuracy. The trend, nevertheless, to the person. And yet here, I think Google Chrome will make serious amendments to the statistics.

According to statistics LiveInternet for September 1-7 at GC 0.6%, for 8-14 September (but today only 9 - e!) - 0.8%

Less percent, is, of course drop in the ocean. But this is not two weeks have passed since the advent of the browser. All the more useful feature such as - creating web application - again, this is NOT FireFox from "unclear whom", and the great Google (! That for companies and offices important), fast (as promised) processing Javascript that in my opinion it is not important, but arhivazhno, Google Chrome opportunity to establish normal user under Windows without resorting to the services administrator (not personally experimented, but overhear in podcasts).

IE as I see it, CMS for the site can be targeted at Google Chrome (almost Safari), a company with more likely to agree to set Chrome (FF on - the refusal of nearly 100% - I do not know why). And fast work with JS - also can not fail to please users jquery / prototype and (especially) extjs.

Honestly admit, I personally Google Chrome has not yet watched. Wait a formal assembly under poppy (Google shame!)

Typical dialogue with the client

2008-09-05T04:03:00.000-07:00

Customer: Hello. I am here for you e-mail sent, with a list of sites which I like. Look.

Me: (I looked). Why do you sent me html? Why could not link?

Customer: What is the difference?

Me: There are. Okay. (Open html-file search for a direct link to the site. Open site)

Customer: I decided that I did not write it like that do not like. I better explain in words. So will be faster.

Me: Do you think that I remember it all?

Customer: Are you inscribe.

Me: 8-O (curtain)

Pipes.Yahoo 503 error

2008-09-04T08:00:00.000-07:00

Recently I met to do a careful study yahoo pipes, as it turned out - something is broken, and pipes.yahoo do not work. Everywhere error 503.

Even previously saved to open pipes is not possible. Judging by reports on the forum - a problem with the 7-8 morning.

And I just encountered a problem that String.Translate module converts any field except the field content: encoded. And I just met to find out what the problem is - 503 :(

Well then. Let's wait. Meanwhile, loans something more useful. For example CakePHP :)

dateTime bugs

2008-09-03T10:20:00.000-07:00

Strange error in the helpers who is responsible for form:

echo $ form-> dateTime ( "Showtime", "DMY", 24, null, array ( "minYear" => 2008, "maxYear" => 2012, 'monthNames' => false, "interval" => 15) false);

All right? Everything!

However, in html see the following code:

< name="data[Showtime][Showtime][day]" id="ShowtimeShowtimeDay">
< value="01"> 1
...
< / select> -
< name="data[Showtime][month]" id="ShowtimeMonth">
< value="01"> 01

Why do we have chosen day encoded twice Showtime? Other parameters are coded properly. If only not forget that in order to set the interval mode 24 hours a day, should be a bit sub-source code (ticket already established).

We are talking about CakePHP 1.2 RC2

Multilingual project, i18n, poEdit - in CakePHP

2008-09-03T01:38:00.000-07:00

PoEdit - excellent piece for the "transfer" in the draft texts. Installed - editor works, but there are features.

First, poEdit unwanted collect data from catalogues CakePHP - reported that nothing was found.

Secondly, while maintaining po / mo files - reported error (but not scared, the files still persist).

The first had to deal means CakePHP:

bash cake i18n - ask the location project, and the cake itself forms the pot file for poEdit.

We are talking about poEdit for MacOS.

CakePHP 1.1 is dead now

2008-07-30T02:40:00.000-07:00

If you are new user of CakePHP, forget about CakePHP 1.1 (stable). Learn CakePHP 1.2.

Yes, it's just RC2, but very useful, nice working and stable ;-)

CakePHP going to past... So long, pal...

Zyxel, MacBook & WiFi troubles

2008-07-17T06:46:00.000-07:00

As you know, I'm a happy owner a Apple Macbook. Also, for home mobile development ;-) I get Zyxel 660HTW2EE (ADSL modem + router + WiFi).

But my happy wasn't long ;-(

MacBook drop WiFi connection every 30-60 minutes (when WPA2-PSK). Or drop connect and Zyxel make could restart (!). And I have 3-5 minutes without Internet, without network (terrible! ;-)

When I'm switching into WPA-PSK mode, I get stable connection, Zyxel hasn't restarting. But speed is so slow ;-( max - 110KB/sec (It's 802.11g mode!) Terrible..

After reading a lot of forum/blog and manuals I switch off any WPA, and setup MAC-Filter for my MacBook. Now I have stable connect. STable working of Zyxel, stable Wifi in MacBook.

You may ask me - why you don't by AirPort from Apple?

I have answer ;-)

Because AirPort doesn't have ADSL modem ;-( Yep. In my region we using ADSL internet. still...

So, If you happy from your Zyxel & MacBook - switch off any WPA/WPA2 coding, setup Mac Filter and have fun with WiFi Internet on your notebook...

Great thing : bindModel

2008-07-14T06:24:00.000-07:00

At present moment a have a lot of free time for self improvement and I can learn CakePHP deeper and deeper, as it possible ;-)

In one of my project I have two table with simple relation

Division (id, title) - hasMany Staff

Staff (id, division_id, name, jobtitle..)

So. Now I need to get some info like: I need to get all Staff where birthday today, and get result like:

Array (

[0] => ["Division"] = Array ...

=> ["Staff"] = [0]

[1] ...

But I don't want (or cann't) rewrite model fore staff/division. So, What I must doing?

Of cause I must to use this wonderful thing - bindModel ;-)

Look

$this->Division->bindModel(array("hasMany" => array ("Staff" => array (
"conditions" => array ("MONTH (birthday) = " . $month, "DAY (birthday) = " . $day),
"fields" => array ("Staff.id,Staff.name"),
"order" => array("Staff.name" => "ASC")))));
$staff = $this->Division->find("all");

Also, we can put in field "fields" something like this

"fields" => array ("COUNT (Staff.id) as count")

And we have array with Division and numbers (count of staff with correct birthday)

Simple? yep. And in good cakephp tradition ;-)

MAMP & cake (terminal)

2008-07-10T12:50:00.000-07:00

YESS! I did it! ;-)

1. sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /var/mysql/mysql.sock

2. And 1 hour looking for bug, and found mistake in database.php

After some experiments I put host => 127.0.0.1

And forget about it ;-)

Now all cool -> host -> localhost

And my cake bash baker work fine

I am happy! I am like unixman ;-))))

Hm. Cake 1.2RC2 & baker

2008-07-10T00:20:00.000-07:00

It's very strange, but I cann't use this cake baker under MacOS ;-(

If I starting terminal cake (from pack dmg) I can read only help and resume: Process completed. And could not put any symbol

If I starting terminal, and go to my site directory and run:

bash cake bake

I can create "skeleton" of my web application in directory myapp. Now cake not want to use this subdir and I'm moving files into /cake/console/..

After this I type: bash cake bake

& setup database.php setup. Of couse, I know - this file has not mistakes (Yep, I'm copy database.php into site/app/config/ and read this "Cake is able to connect to database". So - My database setup is nice, and MySQL server work properly.

So. I returning into cake/console, and run bash cake bake - for creating model. But, after I choose database config "default" (yep My database config is really calling default) I get 3 warning about impossible to connect to database throw sockets and get finally message about "database haven't any tables" but this is wrong! I have tables.

And of cause, I'm using MAMP

Where is mistake? I don't know ;-(

Cake...dmg & .htaccess

2008-07-08T22:39:00.000-07:00

After my switching into MacOS I'm start to use cakephp.dmg with latest version of this wonderful framework. But I found some troubles with use this image (dmg).

When MacOS mount cake.dmg you can drag & copy content of framework into your project. Easy? Of cause! But you cann't drag .htaccess from the root of the cakephp.

May be it's a stupid problem, and after setup finder folder view you can move even invisible files, but I don't know how to made this. After all I'm install muCommander and copying this .htaccess file from mu. How to make this copy more easy?

Yes, .htaccess from /app/ & /app/webroot - copying to project without any problem.

Unix hosting

2008-07-08T03:30:00.001-07:00

My pal (pal by ICQ ;-) broken mind about simple problem...

Pre...

On localhost all work nice. Stable and fine. (Windows)

After uploading to unix hosting my pal get some troubles with error "Model not found", "Controller not found" etc...

But, of couse, file posts_controller.php, post.php are present in bot copies of site.

Decision: unix-style hosting known file Post.php and file post.php - it's really different file. Not same.

So, if both copies of your site identical - don't forget to check filename uppercase & lowcase ;-)

4 July

2008-07-03T23:58:00.000-07:00

Independence Day! My congratulations to all citizens of USA ;-)

In this day, please, be careful with UFO! As I know, only 4 july a lot of dangerous aliens attack USA and Earth!

Don't look at sky! Don't speak with unknown aliens! Don't enter in UFO!

;-))))

Textmate vs CakePHP

2008-07-02T23:11:00.000-07:00

Yes, I'm really happy with Textmate ;-)

After reading article "CakePHP for TextMate" I get SVN (universal pack), install SVN, then going and get CakePHP Bundle. And now, I can comfortable use tab triggers with CakePHP ;-)

I don't use TextMate before, and et current time I don't understand, how to made autocomplited with function? I read manual, look at video-tutorial and don't know how ;-)

May be after 1-2 days I found easiest way to use this useful function, and write here.

Netbeans - go to trash, you really monster for me (but good soft, of cause ;-)

Textmate

2008-07-02T13:46:00.001-07:00

I don't know it is my last word about IDE for CakePHP. But at present time I think - TextMate is best choice ;-)

To be continue...

2008-07-01T07:33:00.000-07:00

I had 4 comments at my last post about selecting IDE for CakePHP ;-)

So. I trying:

TextMate

NetBeans

Eclipse

I not unix-man, and I have really problem with installing CakePHP Bundles for TextMate (strange SVN etc... ;)) I think I must start to learn this aspect of IT, for better productivity ;-)

Really, I buy MacBook after 4 month of thinking about ;-) And my choice mac, because it's natural Drag-n-Drop & natural unix shell.... I have no problem with drag-drop, but have really problem with unix part of this beautiful OS.

Thanks a lot, pal! And, I hope, I made right choice ;-)

IDE for CakePHP (OS X)

2008-06-30T23:46:00.000-07:00

Hi to all!

Can you help me to make choice between: TextMate & NetBeans?

As I saw, it's tow nice IDE for developing in PHP (for Mac). But TextMate cost some money, and NB - weight like 91 Mb...

What better? Help me to select ;-)

How about autocomplite? Help (for class-function, and browsing through lib?)

jQuery ft Prototype

2008-06-29T11:10:00.000-07:00

It's really hard to choice. Easy (to me ;) in developing and understanding jQuery as AJAX/javascript framework. Or hard (as for me) but native Prototype.

When I wrote my own function in AJAX/JS I use jQuery (of course). But when you'll start using AJAX with standart pagination (for example) - easy to use - prototype with ajax.helper....

Now I seat and thinking about: may be start to study Prototype? Or start to write jquery.helper? ;-)

Cake 1.2 RC2

2008-06-28T01:04:00.000-07:00

My congratulations to all community! ;-)

I very glad to use CakePHP ;) And I hope, that RC2 haven't bugs, and work faster than RC1 ;-)

Empty & old Cake

2008-06-25T22:40:00.000-07:00

Hi, pals!

I have one old project with cake 1.1. And, suddenly, I start to get a lot of "empty" message.

So, it's look like this:

site.com/ads/add

Model have (all field) -> VALID_NOT_EMPTY

In controller, before $this->Ad->save() I made this:

trim(...)
strip_tags(...)
And, even, I wrote:

if ($this->data['Field'] == '') die;

But... But after one-two day I can found in DB records with empty fields. ;(

Of couse, I trying to add record with empty fields an cann't do it. Cake work fine, and return me to /ads/add with error "Field cannot be empty"

But fields empty. I don't know, how spammers do it, but he do it fine ;-(

After week of a lot attempts to fight with this I start use function afterSave ;-)

So

afterSave

$id = $this->Model->GetId();
$data = $this->Model->read(null,$id);
if ($data['Field'] == '') -> $this->Model->del($id)

After this I got only useful record in database.

But, of couse, this decision is not so beauty ;-(

If you know HOW this spammers do it - I'll be very happy if you tell me

(Yes, I look apache logs and don't found anything strange)

Bug in posts_tags table

2008-06-05T03:32:00.000-07:00

If you read my previous article about strange bugs in posts_tag table, you must to know, I found "error", and now all work stable.

In Mysql table posts_tag, you must add column id (BIGINT, unique, autoincrease)
So, at least you had:

id BIGINT +
post_id
tag_id

And, if you editing any posts (clearing tag, for example) - other posts don't clear in this table.

Alliluja! ;-)

Paginator and multi language

2008-05-23T01:19:00.000-07:00

Guys! I have real trouble with multi-languages site and

echo $paginator->next(...)

I made Routes like:

/:lang/:controller/:action/*

Nice? Nice!

But paginator don't want made url like this ;-(
Even in latest trunk version, when I made

array ('url' => array ('lang' => 'uk'))...

in parameters, I got:

/controller/action/uk/...

How I can get url like this:

/uk/controller/action/... ??

UPDATE: I found a lot useless Routes in my routes.php. Now all work nice ;-)

Tags cloud

2008-05-12T23:57:00.000-07:00

I suddenly had problem with my posts_tag table.

I don't know why, but yesterday I found this talbe empty. Not so empty, but table must have around 400-500 record. She has 27.

Yep I recover this table from field Post['tags']

But why this table was empty? I don't understand ;-(

You have any idea?

Tags, Tags cloud, behaviors etc...b

2008-03-28T02:47:00.000-07:00

I am based my compilation of this useful stuff on This Article.

But, DW aka "dooltaz" made some mistakes in his code.

First of all you need to created model post.php:


VALID_NOT_EMPTY,
              'email' => VALID_EMAIL,
              'body' => VALID_NOT_EMPTY,
      );
   
      var $actsAs = array('Tag'=>array('table_label'=>'tags', 'tags_label'=>'tag', 'separator'=>','));


      var $hasAndBelongsToMany = array('Tag' =>
                             array('className'    => 'Tag',
                                   'joinTable'    => 'posts_tags',
                                   'foreignKey'   => 'post_id',
                                   'associationForeignKey'=> 'tag_id',
                                   'conditions'   => '',
                                   'order'        => '',
                                   'limit'        => '',
                                   'unique'       => true,
                                   'finderQuery'  => '',
                                   'deleteQuery'  => '',
                             )
                             );

}
?>

nest make posts_tag.php

And the last tag.php

array('className' => 'Post',
'joinTable' => 'posts_tags',
'foreignKey' => 'tag_id',
'associationForeignKey' => 'post_id',
'unique' => true,
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
)
);

}
?>

don't forget to create table in your MySQL database ;-)

Model Post: posts must have fields:

id (bigint)
tags (text) - it's field need to HABTM working properly ;-))

Model Tag: tags

id (bigint)
tag (text, or varchar 255)

Join model posts_tags:

post_id (bigint)
tag_id (bigint)

Ok? Ok!

Now, if you use CakePHP 1.2.0.6311-beta, you'll need to make some things with /lib/model.php

Look at track - ticket.

Ok? Ok! In next post I told you how to make view cloud ;-)

CakePHP 1.2: paginator and custom query

2008-03-12T14:51:00.000-07:00

Hello everybody!

;-)

Today I'm broken my brain for making custom query in paginator ;-)

So. Let's begining!

I have two models (don't ask why ;-)

Post: id, body, ...
Answer: id, post_id, body ...

What I need? I want to search for %query% in Answer.body and in Post.body.

But!

I want to get list only like this: site.com/posts/view/id

Other words: if I found %query% in both body (Answer.body and Post.body) I don't need to get 2 url. Only one.

How to get it with SQL (MySQL)? It's so easy if you use DISTINCT in your query.

But, after 2 hours with cofee and brainstorming... I made this code:

$datas = $this->Post->findAll($query,"id");
foreach ($datas as $key => $value) {
$dat .= $value['Post']['id'] . " ";
}
$dat = explode (" ",$dat);
$dat = array_unique ($dat);
array_pop($dat);
$dat = implode(",",$dat);
$this->Post->recursive = -2;
$this->paginate = array ('limit' => '10','conditions' => 'Post.id IN ('. $dat .')', 'order' => 'Post.created DESC');

Yes, it's not so good idea, but it's simple, it's work. And I think - Keep It Simple St... ;-)

If you have better idea, I very glad to see your code!

Visualize your models

2008-02-01T00:11:00.000-08:00

The article by Cakeexplorer on a script to build an image of your db schema. I had been meaning to write such a script for some time, it was great to have it already ticked off the to-do list.

More information here.

Baking plugin (cakephp 1.2)

2008-02-01T00:09:00.000-08:00

Since CakePHP 1.2beta the bake script supports the generation of plug-ins. This feature is a bit hidden in the current version, as it is not mentioned when you call the help of the bake script:

cake bake help

Really interesting feature! ;-) You can find more useful information here.

jQuery and cakephp startup

2008-01-24T22:56:00.000-08:00

After a long work (from 16 sep) we need to wait some day to get new release of UI jQuery (as I read at jquery/blog) Waiting! Be patient! ;-)

And you know who - start new cakephp startup - PostTask (forget about your time leak!)

But at current moment site is not work ;( Yesterday I use them, but now...

Waiting and look at this interesting project

Nicedit & jQuery

2008-01-17T12:37:00.000-08:00

I found some trouble when using Nicedit & jQuery together.

< ? if ($obAuth->lock(array(2)) != 1) : ? >

$(document).ready(function() {
$("div.ppp a").not("[@href*=flomaster]").attr({ target : "_blank"});
});

< ? endif; ? >
< ? if ($obAuth->lock(array(2)) == 1) : ? >

bkLib.onDomLoaded(function() {
new nicEditor().panelInstance('PostBody');
});

< ? endif;? >

It's too late. But now it's work in my admin area. Only one be live (Highlander ;-)

Nicedit - Nice editor

2008-01-16T10:28:00.000-08:00

After some days, I trying to change in my own (personal) project - FCKEditor to small and fast Nicedit.

And, I must told you... It's very nice editor.

I like it. And I love them after 1 day of using ;-)

Yep, some features I really need in this editor:

Table editor (insert, edit)
Image Browser (upload, insert, delete)

I think, that I could adoptate ibrowse (tinymce) to this editor. But question with table editor - is open...

Yes, I understand... XXI century... Div... CSS... But my clients love and using table.
What I can do? ;-)

New jQuery 1.2.2: 300% speedup!

2008-01-15T02:02:00.000-08:00

From jQuery Blog:

On the 2nd anniversary of jQuery’s release we’re proud to bring you a brand new release of jQuery. This is primarily a bug fix release for jQuery 1.2. You can view the full list of what was fixed on the bug tracker.

Downloading

jQuery 1.2.2:

As I see, now we have 28kb of js code... One year ago we had 16kb... And this fact was a great argument to choice this library for development. Now, after getting a lot of funs, jquery grows up ;-)

Also, I didn't see a big problem in size. Year ago I had 512kb/128kb ADSL, now I have 1M/512kb in same price. Other guys (I think so) have speedup them Internet connection to. So, Long Live jQuery! ;-)

First CakePHP official gathering

2008-01-11T12:35:00.000-08:00

First CakePHP official gathering

February 6-8, 2008.

The Planned Festivities

February 06, 2008

Listen to One
Hear some fantastic presentations
Eat food, be merry

February 07, 2008

Listen to Another One
Hear some fantastic presentations
Eat more food, be merry

February 08, 2008

Listen to the Final One
Hear some fantastic presentations
Eat food, be jolly

Who is coming?

WYSIWYG Editors. Again

2008-01-10T22:39:00.000-08:00

I'm so sorry for one more post about WYSIWYG's, but I found a power link with tonns of wysiwyg's ;-)

For all projects, with any licenses. For everyone ;-)

Look here.

;-) Have a nice choice!

Server-side AJAX answer generator

2008-01-09T04:59:00.000-08:00

At russian news-site habrahabr.ru, I found interesting jQueryPHP library, which help you generate correct AJAX-answers.

Try and use. Link.

Don't worry, all information at that pages in english ;-)

WYSIWYG editor

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

Yes, I know. WYSIWYG - must die, and textpattern, textile - rules forever ;-)

But how I can explain it to my clients? I have no idea ;-(

Secretary, blondes doesn't understand style "**bold**". But drag-n-play - is rules for them.

So, it's small catalog of WYSIWYG editor, which we can use in our project.

TinyMCE

FCKEditor

SPAW editor

Xihna

My choice - FCKEDitor. It's large editor, but good license, Image/File browser - present.
TinyMCE - non browser inluded. MCFileManager - 50 euro. But, TinyMCE good choice, if you want Copy-Paste table from MS Word. No bugs, no error.

SPAW Editor - I don't like license and price. And, as I remember - Image/File browser absent.

Xihna - Image browser present, but I don't see preview in Image browser dialog.

Do you know some separated Image/File browser (free) who can be easy connecting with TinyMCE, or normal Word Copy-Paste plugin for FCKEditor?

CakePHP Beta: 1.2.0.6311 changelog

2008-01-07T14:18:00.000-08:00

Small addon to my pervious note - changelog CakePHP Beta 1.2.0.6311:

Look here <-

Happy New Cake! ;-)

And don't forget, it's BETA!

CakePHP: no more pre-beta. Now we are BETA!

2008-01-07T06:21:00.000-08:00

It's very nice New Years gift: now, cakephp change status from pre-beta to beta:
Beta 1.2.0.6311-beta

Of course, if you made your project, don't change pervious version to new. Make backup ;-)
Don't forget about it!

Happy new year! I hope, I'll write more in 2008, and more useful issues ;-)

Happy New Year! ;-)

Multiple rules of validation per field in CakePHP 1.2

2007-12-04T23:03:00.000-08:00

Custom Validation and Multiple rules of validation per field in CakePHP 1.2

It's really very useful information! A lot of time I thinking about: how to check size of field, NOT_EMPTY or something else.

And now, at Bakery, I found articles: How to made custom validations ;-)

Look here and use this great tip! Link

Session. Sessions... A lot of sessions

2007-11-09T10:39:00.000-08:00

When I start "dressing" my engine into new design. I had a problem with session.
Every load of any page giving a lot of session. 2-3-10-20... A lot of...

I found two way, why It's happening:

1. Don't forgot about favicon.ico (/app/webroot/favicon.ico)
If this file absent, you have a troubles with session multiplying

2. Check all path to your design images. Into your ctp, and (SIC!) into style css file. Like url (image/background.jpg)...

I trying to teach my designer, but have fiasco with him ;-) Easy way - remake design code, then trying to teach designer ;-)

Have a nice time ;-)

Cake 1.2.5875 pre-beta some bug with saveField

2007-10-27T08:33:00.000-07:00

I have some trouble with Model->saveField('title',$title);

when I switch project to Cake 1.2.5875 pre-beta, suddenly cake set to 0,null,'' all other fields in my table ;-(

But daphonz say, how to fight with this bug:

$saveData = array('Category'=>array('id'=>$category['ParentCategory']['id'],'options'=>serialize($options)));

$this->Image->Category->save($saveData,false,array('Category.options'));

Not so beauty, but it's work fine.

Good luck, pals!

CakePHP 1.2 pre beta

2007-10-22T22:13:00.000-07:00

Hey-ya!

Now, we all can made dance of fun, and go to cakeforge.org to get latest version of Cake:

CakePHP 1.2.0.5875pre-beta
CakePHP 1.1.18.5850

yep! I', already download my favorite CakePHP 1.2! (Erh, I don't understand why you still using 1.1.* versions?)

I hope, in new october version of 1.2 cake, I haven't problems with saving unique/non unique fields in MySQL...

List, JQuery & CakePHP

2007-10-15T11:29:00.000-07:00

In my work I will need a online change droplist.

So. I have list of countries, and of course, every country have a lot of cities. And we don't need to put ALL tons of cities in our html code. What we must do?

I don't work with prototype, I love jquery, and I wrote small code in jquery & cakephp.

First, user select country, then script AJAX-working upload list of cities, and user can select needing city.

How? Look my add.thtml (ctp):

For country select:

selectTag('Realty/country_id', $country_list,null,null,null,true)?>

And city select:

selectTag('Realty/city_id', $city_list,null,null,null,true)?>

Ok?

In top of add.thtml I wrote:

$(document).ready(function() {
$("#attention").hide();
$("#RealtyCountryId").change( function () {
$("#sel_city").html("Please wait...");
$.get("/realties/sel_city", {id: $("#RealtyCountryId").val()}, function (data) { $("#sel_city").html(data)} );
$("#sel_city").show();
});

});

And, of course, in realties_controller I have sel_city function:

function sel_city()
{
$this->layout = null;
$id = intval($this->params['url']['id']);
if (! $id) exit;
$this->City->unbindModel(array('hasMany' => array('Realty'), 'belongsTo' => array('Country')));
$city_list = $this->City->generateList('country_id = ' . $id,'name ASC');
$this->set('city_list',$city_list);
$this->render();
}

Yep! ;-) Any questions? ;-)

Documentation for CakePHP 1.2

2007-10-08T13:45:00.000-07:00

Yep! I got a link! ;-)

Try this rapidshare-link for getting first version of CakePHP 1.2 documentation.

Like 60-70% of complete, but you can find here a lot of useful things ;-) I already read it manual, and hope, you too found this documentation useful. Have a nace baking ;-)

First steps from Wordpress to CakePHP

2007-09-25T02:43:00.000-07:00

Felix Geisendörfer (aka the_undefined) in his own blog wrote about first step for migration from platform Wordpress to CakePHP.

Of course, CakePHP engine doesn't exist right now, but, as I say, it's just first step in this direction.

Planning about DB structure tables, and some migrations tools for cake console (1.2, of course! :)

Oh. Forget give to you link to this wonderful article ;-)

Here.

FrameWork mania

2007-09-06T11:13:00.000-07:00

It's strange, but, when I trying to write code on PHP without my favorite CakePHP, I got my own Waterloo...

I forget about _SESSION, how to work with him, how to cache, how to make simple SQL code...

Wow...

It's terrible!

But... After 20 minutes of reminding I install N-th copy of CakePHP, and in 2 minutes wrote all needing code ;-)

CakePHP is my FrameWork. (& jQuery, of couse ;)

MySQL warning and CakePHP 1.2 error?

2007-09-04T11:19:00.000-07:00

I wrote some code about adding users to MySQL Table.

In my table present two unique fields: username & email. Ok?

Ok!

It's code for adding user:

if($this->User->save($this->data)) {
$this->flash('All good','/login');
$this->redirect(array('action'=>'index'), null, true);
} else {
$this->data['User']['password'] = null;
$this->Session->setFlash('All bad');
}
(of couse it's fragment!)

So. When debug = 1. And I add user with already present in table username or email, I get

1: SQL Error about key who must be unique
2. I see message: All bad
3. No new records in table.

Now, switch debug level = 0

1. We don't see SQL Error (fine!)
2. We see message "All good"
3. We have new record in table with NON unique email (or username)

Who is wrong???

Password Reminder

2007-09-03T14:04:00.000-07:00

I have some idea about "How To Remind Password".

Firsd idea in: I don't want to store password in database. Only md5('pass').
Second idea: I haven't time to programming scheme like: Forgot password? -> Get e-mail with shortlifetime links -> Go To url -> Get new password in your mailbox Or Type in special fields.

So. For my small, fast forum engine I use remindpassword from CheeseCake (PhotoBlog) ;-)
for my user password. And. Yes, I bad boy ;), I had store user's password in DB ;-( Anyway admin password only in md5 ;-)

It's not commercial site, project, and not so secure forum, so, next time, I promise, I'll write more secure password remind code ;-)

But, I think, If cheesecake store admin pass in open-view i DB, why I cann't? ;-)))

DBDesigner & CakePHP

2007-08-31T00:47:00.000-07:00

Cool man Dérico Filho (respect!)

Wrote some usefule tips for DBDesigner 2 CakePHP

http://www.cirello.org/dbdesigner2cake/download.html

and

http://cakeforge.org/frs/?group_id=162

I'm open DBDesginer 2 weeks ago, and found this tool very useful for design relation in my DB.

DBDesigner is free, so. If you don't see this tools - go and try it ;-)

Google help you to find dbdesign, yes, I lose link ;-)

Fields: created, modified in CakePHP 1.2

2007-08-30T11:12:00.000-07:00

I had a troubles with automatic omplete this fields, when my script made $this->Model->save

After 2 hours of brain storm, I come back to group.google.com/cake-php and found answer on my question - Ticket #2595 ;-)

But we can solve this problem ;-)

All we need to do is convert default in MySQL:

0000-00-00 00:00 - is wrong! And doesn't working!!!

But

Null - default. It's working fine!

I'm change my table defaults parameters of this fields, and ->save method working fine ;-)

Wow! ;-)

Some interesting features in CakePHP 1.2

2007-08-30T05:45:00.000-07:00

After changing 1.1 up to 1.2 version. A have a lot of question. Some answer I can find, some - no.

Let's go...

1. If you want to make validation in 1.2, You must write this:

if ($this->YourModel->create($this->data) && $this->YourModel->validates()) {
validation ok
} else {
validation not ok
}

2. If you want to change default paginator in 1.2, you must define variable in your controller, like this:

var $paginate = array('limit' => 10, 'page' => 1, 'conditions' => 'User.id >= 2');

3. If you have 0000-00-00 00:00 in your default-named fields: created/modifiead...

I... I don't know what you must do ;-( Someone can help with this trouble?

Vacation

2007-08-27T02:59:00.000-07:00

I had a vacation ;-) 3 days at sea (Black Sea). Zatoka, near Odessa.
We use one Ford Connect for 5 (one way) and 4 (other way). So. That's cost 10 USD for 2 man and 1200 km ;-)

Weather is nice, sea is warm. Vacation is short ;-)))

I'm find my own bug. Again

2007-08-16T01:34:00.000-07:00

Yep. CakePHP 1.2 has not this error...
When I made Posts/Rubrics (M-V-C) and change routes to my post/index...
No more blank page. All work done. Hmm...

May be I need more time for dreaming? ;-)

CakePHP 1.2 & debug 0

2007-08-15T07:04:00.000-07:00

Hmm... I got a real problem, and don't see decision.

PHP4, MySQL, all directory is writeable.

1.1 CakePHP (empty, only framework). Set debug 0 - no problem. I see normal "Hello page of CakePHP"

1.2 CakePHP (empty, only framework). Set debug 0 - and get blank page... No data. No one byte.
In choise debug 1 - I see "Hellopage", when switch to debug 0 - blank.

Where is error? I don't understand... No one string of code... Where is bug???

CakePHP 1.2 & Auth

2007-08-14T10:39:00.000-07:00

I trying to change my experience in CakePHP 1.1 into 1.2, and even find this useful article:

Setting Up User Groups With ACL/Auth in CakePHP 1.2

But.... I still don't understand how to I must work with all of this. I think I will use ob_auth (some modify for 1.2 version made by myself).

Also I found some bug (?) in cake.bat (console).

When I trying to: cake acl create aro ROOT ROOT

I get: Unknown type aro

But, If I use php 5, I have no error... So. May be My installation of PHP 4 is not so good for cake console? I don't know.

ACL: user & Groups in CakePHP 1.2 - it's easy

2007-08-13T01:08:00.000-07:00

After a long searching in web, I found this page.
All steps about user/group ACL/ACO in CakePHP. From creating table to use this.
Yes, You must know something about CakePHP, other way you can find this manual to hard for understanding.

So, have a nice reading the article Setting Up User Groups With ACL/Auth in CakePHP 1.2
And I'll learn it too. After, may be add some comments to this manual.

I Find The Own Bug in Code

2007-07-13T07:29:00.000-07:00

It's very strange, but it's still don't solve this problem.

So. I have 3 copy of sites in my hosting (equal code, equal MySQL, etc).

But present small difference...

In two copies of code function $this->{$Model}->SetId($id); working properly...

in one copy - doesn't.

Why? I don't know. Version of CakePHP 1.15.... May be some bug in code? Unnecessary space, comma? I don't know.

Full week I hunting for this bug ;-) And only I'm add "//" before SetId construction, I get normal working.

(I mean bug was: empty records was adding to table, without any system or any conforming.

Now code work (without SetId). Yep. Only one week ;-))

Tools For CakePHP

2007-07-11T02:11:00.000-07:00

It's a small post about my tools, what I use for development my site in CakePHP style.

So. First of all about mu workplace: it's standart PC (born in 2004 year ;-) with Windows 2000 on board (yes, yes, I understand, but it's corporative style & I cann't change anything ;(

Editor: I use notepad++. He is small, useful, freeware. Yep. He hasn't a lot of feature. but if you write code on CakePHP framework, you must know - it's not necessary ;-)) Notepad++ is really useful tool in my comp.

Development: I use Denver. It's small self-install package with PHP, MySQL & apache. (doesn't work at Vista!). just 4-5 Mb, one-two clicks and I have useful local websites for coding, testing etc. Don't forget about proxy! ;-) If you made local site with same name like your real site, you will less a lot time, why understand: "I made change in code... Why it's not working???" like me ;-) Don't forget about it.

And last. I use FAR manager for uploading/downloading. Yep it's not so beauty like standard windows application, but small & useful. And free for people living in exUSSR ;-)

Well.

Ops! Yep, I am using chm version of CakePHP manual, PHP manual. But now CakePHP manual is too old for coding (but very nice for newbie and understanding "how it's works???").

That's all! Have a nice coding & sorry again about my poor english

News of CakePHP!

2007-07-10T03:19:00.000-07:00

Hi to everyone!

I'm so sorry for long time without any posts. But, I hope, from this time I will write pften ;-)

So. If you don't visit Official Site of CakePHP - do it now. And you can get fresh version of CakePHP ;-)

I'm already get fresh 1.2 alpha, and reading in changes about next 1.2 will be BETA.

I think - it's good time to start learning 1.2 version, because is too many differences between 1.1 & 1.2 version, and when (I think about september/october) 1.2 version will have status: release, we had a lot knowledges about 1.2 and use them in full power.

Well, I think next my posting will be oriented for newbie in Cake and newbie in 1.2 (like me ;-)))

My last works in CakePHP use standard features, standard function. I understand, all around is Web 2.0, Web 3.0 etc. But my clients always say: "We want some new, difference from other" but, when our small web-company finishing project, they say "All good, but it's so unusual... Please make it like at site .... " ;-)

Well, that's all, folks! I'm going to learn 1.2

Did AJAX At Work Now?

2007-06-28T23:55:00.000-07:00

Original >>

I think it's very simple and useful short script. Jquery + CakePHP or any PHP page.

It's a AJAX Global Activity code:

$(function() {
var $headline = $('h1:first');
$(document).ajaxSend(function() {
$headline
.removeClass('activity')
.addClass('activity');
});
$(document).ajaxStop(function() {
$headline.removeClass('activity')
});
});

So. When ANY AJAX activity - your 'activity'-class will be work;-) Easy ;-)

Ajax/jquery

2007-06-24T02:00:00.000-07:00

So, I want to ask you about one thing:

Did you interesting about: How To Use JQuery into your CakePHP project?

I wrote some articles (in russian), but if you have interest, I can translate it into english.

Please write in comments, if it's interesting for you.

Yep!

2007-03-23T02:24:00.000-07:00

Really nice day!

I start new project - Easy-Ajax. You could find there a lot of useful links about Ajax, programming, and, I hope, useful info around cake PHP + ajax ;-)

Have a nice programming! ;-)

New Feature: bindModel/unbindModel

2006-09-25T23:35:00.000-07:00

This feature allows you to bind or turn off associations on the fly, and will be available in the next release (RC6?) of CakePHP.

Let us start with an unbindModel example. We have three models: User, Project and Supportrequest. A user has many projects and many support requests. If we do

debug($this->User->findAll());

the output would be something like:

Array
(
    [0] => Array
        (
            [User] => Array
                (
                    [id] => 1
                    [firstname] => Daniel
                    [lastname] => Hofstetter
                )
           [Project] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [name] => project A
                        )
                )
            [Supportrequest] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [comment] => a support request
                        )
                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 1
                            [comment] => another support request
                        )
                )
        )
)

Ok, but what if we are only interested in the users and the projects? Well, we could simply ignore the support requests. Or we could turn off the association to the support requests with unbindModel:

$this->User->unbindModel(array('hasMany' => array('Supportrequest')));
debug($this->User->findAll());

That gives us the following output:

Array
(
    [0] => Array
        (
            [User] => Array
                (
                    [id] => 1
                    [firstname] => Daniel
                    [lastname] => Hofstetter
                )
           [Project] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [name] => project A
                        )
                )
)

Notice: The associations are reset after each call to a find function.

Ok, that was the unbindModel example. Let us go to the bindModel example. That example will be a little bit artificial as I do not see a real use case for bindModel at the moment. Maybe you know one? Ok, we have two Models: User and Supportrequest. The model do not have any associations. If we do

debug($this->User->findAll());

we get the following output:

Array
(
    [0] => Array
        (
            [User] => Array
                (
                    [id] => 1
                    [firstname] => Daniel
                    [lastname] => Hofstetter
                )
        )
)

For some reason we want to have a temporary “hasMany” association between user and support request. We define it in the following way using the usual association syntax:

$this->User->bindModel(array('hasMany' => array('Supportrequest' =>
                             array('foreignKey' => 'user_id'))));
debug($this->User->findAll());

And that is the output:

Array
(
    [0] => Array
        (
            [User] => Array
                (
                    [id] => 1
                    [firstname] => Daniel
                    [lastname] => Hofstetter
                )
            [Supportrequest] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [comment] => a support request
                        )
                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 1
                            [comment] => another support request
                        )
                )
        )
)

That’s it :) (original)

21 Things You Must Know About CakePHP

2006-09-18T14:09:00.000-07:00

Original >>

Easily creating static pages

I needed to create several pages that didn't use any models and contained static data inside the default layout. My first thought was to create a controller for these pages and define an action for each static page I needed. However, this solution seemed tedious and would make it difficult to quickly add new pages. Enter the pages controller - simply create a view inside the views/pages/ folder and it'll automatically be rendered in /pages. For example, if I created /views/pages/matt.thtml it would be accessible via http://www.example.com/pages/matt

Static pages - Adjusting the page title

If you're using the pages controller and you need to change the page title, add the following to your view:
<? $this->pageTitle = 'Title of your page.'; ?>

Static pages - Adjusting other data sent to the layout

If you need to send data to the layout (such as a variable indicating what section to highlight on the nav bar), add this to your view:

<? $this->_viewVars['somedata'] = array('some','data'); ?>

That array should then be accessible as $somedata inside your layout.

Creating a simple admin center

If you need to create an administrative back-end for your CakePHP site and would like all the actions with administrative capabilities to exist under a specific folder, open up config/core.php and uncomment:
define('CAKE_ADMIN', 'admin');
This will then make all actions that are prefixed with "admin_" to be accessible via:
/admin/yourcontroller/youraction. For instance, if I created an action in my posts controller called "admin_add," I would access this via: www.example.com/admin/posts/add
From there I could simply password the admin folder to prohibit unwanted users from adding posts.

Viewing the SQL queries that are running behind the scenes

You can easily see the SQL queries that CakePHP is running by adjusting the DEBUG constant in config/core.php. 0 is production, 1 is development, 2 is full debug with SQL, and 3 is full debug with SQL and dump of the current object. I typically have debug set at 2, which renders a table at the bottom of the page that contains SQL debug information.
If rendering a table at the bottom of your site is constantly breaking your layout during development (especially if you're making AJAX calls and you're getting SQL inside your pages, not just the bottom), you can easily style this table to be hidden by adding this to your CSS:
.cakeSqlLog { display: none; }
This will allow you to view debug information in the HTML source code without your layout getting mangled, just don't forget to set debug back to 0 when your site goes live.

Multiple sources of documentation

Don't just rely on the manual. The wiki and the API are invaluable sources of information. The tutorials in the wiki are especially useful, and the API may be daunting at first, but you'll quickly find the information in there is crucial to building a site with CakePHP.

Using bake.php

Bake is a command line PHP script that will automagically generate a model, controller, and views based on the design of your database. I highly recommend using scaffolding to get a prototype going of a table that may change a lot in the beginning. If you're fairly certain the data is not subject to any drastic change, I recommend using bake instead. With bake all the files are generated and written to disk and you can make modifications from there. It saves a lot of time doing the repetitive tasks such as creating associations, views, and the basic CRUD controller operations.
Using bake is really easy. Once you have a table(s) in your database created, change directories to the /cake/scripts/ folder and run:
php bake.php
If you choose to bake interactively it'll walk you through the steps required to create your model, controller, and views. Once everything has been baked I usually go through all the generated code and make custom modifications as needed.

Mind permissions when moving cake around

When I changed from the development server to the live server I tarred up my entire cake directory and scp'd it to the new server. Immediately I started having an issue where any time the debug level was set to 0 (production mode), data would not be returned for certain database calls. This was a bit of a catch 22 since I needed to view debug information to troubleshoot the problem.
Someone in #cakephp kindly pointed out that permissions on the /app/tmp folder need to be writeable by apache. I changed the permissions to 777 and the issue went away.

Complex model validation

I needed to validate beyond just checking to make sure a field wasn't empty or it matched a regular expression. In particular, I needed a way to verify that the email address users registered with was unique. In the wiki I found this gem: this advanced validation tutorial, which covers some advanced methods of validation that were very useful.

Logging errors

$this->log('Something broke');
This will log your error to /tmp/logs/ (I initially made the mistake of thinking it would log it to the apache error log)

Creating a controller that uses other models

Suppose you have a controller that needs data from a bunch of different models, simply add this to the top of your controller:
class yourController extends AppController { var $uses = array('Post','User'); }
This controller would then have access to both the Post and the User model.

Creating a model for a table that doesn't actually exist in the database

I needed a way to create a model and controller without actually having an associated table in the database. I particularly wanted to make use of the $validate array so I could easily validate my fields and keep the validation logic in the model. CakePHP will throw an error if you create a model for a table that doesn't exist. Adding this to the model fixed the problem:
var $useTable = false;
You can use this to change tables names as well.
var $useTable = 'some_table';

Call exit() after redirecting

This should be no surprise to anyone who has done any serious web development in the past, but make sure you call exit() after running $this->redirect() if there's code afterward that you don't want to run. I've always done this in the past, but I made the assumption that $this->redirect() would make an exit call for me (which it didn't).

Advanced model functions

Unless you delve in to the API, there are some very useful model functions at your disposal you might not know exist. I highly recommend reading over the Model Class Reference at least once. Here's a few key functions I wasn't aware of that I found to be very useful:

generateList() - I use this function primarily to populate select boxes with data from associated tables
findBySql() - Sometimes you just need to write your own SQL
findCount() - Returns number of rows matching given SQL condition
hasAny() - Returns true if a record that meets the given conditions exists.

Again, I highly recommend reading over the entire model class reference, you'll be surprised at what you learn.

Inserting multiple rows in succession

I had a situation where I needed to iterate through a list of items and insert new rows for each. I quickly discovered that if you insert an item and then immediately insert another, the item that is inserted next doesn't insert at all. Instead the previously inserted row was being updated. For example:
$items = array('Item 1','Item 2','Item 3'); foreach ($items as $item) { $this->Post->save(array('Post' => array('title' => $item))); }
This code will result in a single entry in the posts table: "item 3." CakePHP inserted "item 1", but then updates it to become "item 2," then "item 3" because $this->Post->id gets the value of the last inserted ID. Normally this functionality is very useful, but in this particular instance it was not. I found was to setting $this->Post->id = false after each insert solved the problem.

Inserting logic before or after controller functions

Suppose you needed an array of colors to be available to every view rendered by your controller but you don't want to have to define this data in every action. Using the beforeRender() callback will allow you to do this:
function beforeRender() { $this->set('colors',array('red','blue','green'); }
This would make $colors accessible in every view rendered by that controller. beforeRender() is called after the controller logic and just before a view is rendered.
There's also beforeFilter() and afterFilter(), which are called before and after every controller action. For more information, read up on callbacks in the models section of the manual.

Adding a WYSIWYG editor to CakePHP

I found this great tutorial on getting TinyMCE set up with CakePHP. Basically you just link the tiny_mce .js file to your page and then add a small bit of init code to every page that you want textareas to be converted into TinyMCE editors.

Writing your own SQL for HABTM relationships

I had an issue with trying to create a HABTM (has-and-belongs-to-many) relationship where I needed to specify my own SQL statement. According to the docs (at the time of this writing) you should set finderSql in your model, but according to the cakePHP source you should set finderQuery instead. It's just a foul-up in the docs, but I figured it'd be worth noting to save others from having to figure it out for themselves. Trac ticket here: https://trac.cakephp.org/ticket/1217

Sending email

I found two tutorials in the wiki: Sending email and Sending email with PHPMailer
I highly recommend the latter of the two, sending emails with PHPMailer is more secure and there's less of a headache because you don't have to deal with constructing the mail headers yourself.

Customizing HTML generated by the Helper

I needed to change the default <option> generated when I called $html->selectTag() to say something like "Please Select" rather than an empty space (default). I also wanted radio buttons to have labels so the user doesn't have to click exactly on the radio button itself but can instead click anywhere on the text associated with it.
Create the file /app/config/tags.ini.php and add the following:
; Tag template for a input type='radio' tag. radio = "<input type="radio" name="data[%s][%s]" id="%s" %s /><label for="%3$s">%s</label>" ; Tag template for an empty select option tag. selectempty = "<option value="" %s>-- Please Select --</option>"
You can get a full list of available tags in /cake/config/tags.ini.php. I wouldn't recommend modifying that file, however, because you could lose your changes when you upgrade CakePHP.

Creating a custom 404 error page

If you need to change the page that users see when a document is not found, create:
/app/views/errors/error404.thtml

Fixed Security Exploit

2006-09-17T14:49:00.000-07:00

Larry E. Masters aka PhpNut:

There was an security exploit brought to my attention today. I have fixed this exploit in the trunk and branched versions. Please replace the app/webroot/js/vendors.php with this file.

https://trac.cakephp.org/browser/trunk/cake/1.x.x.x/app/webroot/js/ve...

This exploit is important to correct since it would allow reading files outside of the vendors/javascript directory when magic_quotes_gpc = Off.

And I put this file here:

<?php
/* SVN FILE: $Id$ */
/**
* Short description for file.
*
* This file includes js vendor-files from /vendor/ directory if they need to
* be accessible to the public.
*
* PHP versions 4 and 5
*
* CakePHP : Rapid Development Framework <http://www.cakephp.org/>
* Copyright (c) 2006, Cake Software Foundation, Inc.
* 1785 E. Sahara Avenue, Suite 490-204
* Las Vegas, Nevada 89104
*
* Licensed under The MIT License
* Redistributions of files must retain the above copyright notice.
*
* @filesource
* @copyright Copyright (c) 2006, Cake Software Foundation, Inc.
* @link http://www.cakefoundation.org/projects/info/cakephp CakePHP Project
* @package cake
* @subpackage cake.app.webroot.js
* @since CakePHP v 0.2.9
* @version $Revision$
* @modifiedby $LastChangedBy$
* @lastmodified $Date$
* @license http://www.opensource.org/licenses/mit-license.php The MIT License
*/
/**
* Enter description here...
*/
$file = $_GET['file'];
$pos = strpos($file, '..');
if ($pos === false) {
if(is_file('../../vendors/javascript/'.$file) && (preg_match('/(\/.+)\\.js/', $file)))
{
readfile('../../vendors/javascript/'.$file);
}
} else {
header('HTTP/1.1 404 Not Found');
}
?>

Easy Way To Upload Files Up To Your Server

2006-09-16T03:54:00.000-07:00

The easyest answer to question: "How to I can upload files to server?" Is - File Handler Component, written by Chris Partridge.

(You can find fresh version of this component at Code Snippet)

Just one moment! Do not use

$html->file ('UserFile');

Because construction

$_FILES['data[User][File]'] doesn't work (PHP 4.1.* at least).

So use standart html code:

Then

$this->filehandler->upload('userfile','dir');

Remember, You must creating directory at your webroot ;-)

With 777 access ;-)

<?php

/***************************
* File Handler Component
***************************
* Author: Chris Partridge
* License: MIT
* Release Date: 09/03/2006
* Version: 1.0
* Revision: 2
*
* Description: This class is designed to be extended for
* a specific purpouse. However, it can act
* as a file repository component "out of the box".
***************************/
class FileHandlerComponent extends Object
{
/*
Probably the most important variable, this determines how the
file is handled within the component.
There are two options, db and array.
db:
This will use the dbModel and dbFields variables to save the
file data to the database. When getLastUploadInfo() is requested,
it will return the id aswell as all the other information.
A specific table and model need to be created for this to work.
When saved, it will be placed in $dir/$file_id/$filename
(e.g 'files/25/some_file.zip')
array:
This will take the uploaded file and store it. When getLastUploadInfo()
is run, it will return all information related to the file.
The information will be returned in the format of the dbFields array.
The unique directory name will be appended to the dir variable.
When saved, it will be placed in $dir/$unique_id/$filename
(e.g 'files/a438sdu4s/some_file.zip')
If you wish to save information about array uploads, you must
do so manually with the return data from getLastUploadInfo()
*/
var $handlerType = 'array';
/*
You can specify a different model to store the file
upload information. You need to create the correct model
file and database table for this to work correctly.
*/
var $dbModel = 'FileUpload';
/*
You can modify the array key values below, if you
want/have to change the field names in your database.
*/
var $dbFields = array( 'dir' => 'dir', // The directory the file was uploaded to
'file_name' => 'file_name', // The file name it was saved with
'mime_type' => 'mime_type', // The mime type of the file
'file_size' => 'file_size', // The size of the file
);
/*
This array stores all allowed mime types, a mime type
determines the type of file.
The specified mime types below should be safe for uploads,
however the compressed formats could be a touch unsafe.
*/
var $allowedMime = array( 'image/jpeg', // images
'image/pjpeg',
'image/png',
'image/gif',
'image/tiff',
'image/x-tiff',
'application/pdf', // pdf
'application/x-pdf',
'application/acrobat',
'text/pdf',
'text/x-pdf',
'text/plain', // text
'application/msword', // word
'application/mspowerpoint', // powerpoint
'application/powerpoint',
'application/vnd.ms-powerpoint',
'application/x-mspowerpoint',
'application/x-msexcel', // excel
'application/excel',
'application/x-excel',
'application/x-compressed', // compressed files
'application/x-zip-compressed',
'application/zip',
'multipart/x-zip',
'application/x-tar',
'application/x-compressed',
'application/x-gzip',
'application/x-gzip',
'multipart/x-gzip'
);
/*
This variable stores the maximum allowed file
size(in kilobytes) for uploaded files.
Please note that this can also be limited on the form
and by php itself. Default is 3584(3.5 MB).
*/
var $maxFileSize = 3584;
/*
These variables are used to store information about
errors or/information that needs to be stored while
using this component.
Do not modify these.
*/
var $errorMessage = null;
var $isError = false;
var $lastUploadData;
/*
__construct
Initiates the database model
and runs the parent constructor.
*/
function __construct()
{
if(!in_array($this->handlerType, array('db','array')))
{
$this->setError('The specified handler type is invalid.');
}
if($this->handlerType == 'db')
{
if(!class_exists($this->dbModel))
{
$this->setError('The specified database model does not exist.');
}
$this->{$this->dbModel} = &new $this->dbModel;
if(!is_subclass_of($this->{$this->dbModel}, 'AppModel'))
{
unset($this->{$this->dbModel});
$this->setError('The specified database model is not a cake database model.');
}
}
parent::__construct();
}

/*
getLastFileId
Returns the id of the last
uploaded file if using db
handler type.
*/
function getLastUploadInfo()
{
if(!is_array($this->lastUploadData))
{
$this->setError('No upload detected.');
}
else
{
return $this->lastUploadData;
}
}
function getMime($file)
{
if (!function_exists('mime_content_type'))
{
return system(trim('file -bi ' . escapeshellarg ($file)));
}
else
{
return mime_content_type($file);
}
}

/*
upload
Passed a form field and dir,
the class will check and attempt
to upload the file.
If uploaded, the details are stored
and the id is returned.
*/
function upload($field, $dir)
{
// Check that the two method variables are set
if(empty($field) || empty($dir))
{
$this->setError('You must supply a file field name and a directory on the server.');
return false;
}
// Check that the upload file field exists
if(!isset($_FILES[$field]))
{
$this->setError('No file supplied.');
return false;
}
// Check that the file upload was not errornous
if($_FILES[$field]['error'] != 0)
{
switch($_FILES[$field]['error'])
{
case 1:
$this->setError('The file is too large (server).');
break;
case 2:
$this->setError('The file is too large (form).');
break;
case 3:
$this->setError('The file was only partially uploaded.');
break;
case 4:
$this->setError('No file was uploaded.');
break;
case 5:
$this->setError('The servers temporary folder is missing.');
break;
case 6:
$this->setError('Failed to write to the temporary folder.');
break;
}
return false;
}
// Check that the supplied dir ends with a DS
if($dir[(strlen($dir)-1)] != DS)
{
$dir .= DS;
}

// Check that the given dir is writable
if(!is_dir($dir) || !is_writable($dir))
{
$this->setError('The supplied upload directory does not exist or is not writable.');
return false;
}
// Check that the file is of a legal mime type
if(!in_array($_FILES[$field]['type'], $this->allowedMime))
{
$this->setError('The file upload is of an illegal mime type.');
return false;
}
// Check that the file is smaller than the maximum filesize.
if((filesize($_FILES[$field]['tmp_name'])/1024) > $this->maxFileSize)
{
$this->setError('The file is too large (application).');
return false;
}
// Get the mime type for the file
$mime_type = $_FILES[$field]['type'];

// Update the database is using db
if($this->handlerType == 'db')
{
// Create database update array
$file_details = array($this->dbModel => array( $this->dbFields['dir'] => $dir,
$this->dbFields['file_name'] => basename($_FILES[$field]['name']),
$this->dbFields['mime_type'] => $file_type,
$this->dbFields['file_size'] => (filesize($_FILES[$field]['tmp_name'])/1024)
)
);
// Update database, set error on failure
if(!$this->{$this->dbModel}->save($file_details))
{
$this->setError('There was a database error');
return false;
}
// Get the database id
$file_id = $this->{$this->dbModel}->getLastInsertId();
$dir = $dir . $file_id . DS;
}
// Generate dir name if using handler type of array
if($this->handlerType == 'array')

{
$dir = $dir . uniqid('') . DS;
}
// Create a folder for the file, on failure delete db record and set error
if(!mkdir($dir))
{
// Remove db record if using db
if($this->handlerType == 'db')
{
$this->{$this->dbModel}->del($file_id);
}
// Set the error and return false
$this->setError('The folder for the file upload could not be created.');
return false;
}
// Move the uploaded file to the new directory
if(!move_uploaded_file($_FILES[$field]['tmp_name'], $dir . basename($_FILES[$field]['name'])))
{
// Remove db record if using db
if($this->handlerType == 'db')
{
$this->{$this->dbModel}->del($file_id);
}
// Set the error and return false
$this->setError('The uploaded file could not be moved to the created directory');
return false;
}
// Set the data for the lastUploadData variable
$this->lastUploadData = array( 'dir' => $dir,
'file_name' => basename($_FILES[$field]['name']),
'mime_type' => $mime_type,
'file_size' => (filesize($_FILES[$field]['tmp_name'])/1024)
);
// Add the id if using db
if($this->handlerType == 'db')
{
$this->_lastUploadData['id'] = $file_id;
}
// Return true
return true;
}
/*
setError
Set the errorMessage and isError
variables.
*/
function setError($error)
{
$this->isError = true;
$this->errorMessage = $error;
}
}
?>

How To Integrate WYSIWYG Editor into CakePHP?

2006-09-15T05:45:00.000-07:00

Easy way to integrate Xihna into CakePHP.

Easy way to integrate TinyMCE into CakePHP.

And, of couse, it's SO EASY to integrate FCKEditor into CakePHP ;-)

But if you asked me about WYSIWYG Editor, I say to you: "I don't like WYSIWYG! And use MarkDown PHP.

So, about MarkDown "non-visual editor" next time. Ok? ;)

Security Component

2006-09-15T00:51:00.000-07:00

Some tricks for extra security in cake.

If you call http://example.com/users/render/delete (you’ve an UsersController) you will get rendered the delete.thtml view.
Try it at home with any controller.
The render() method from Controller gets called. I’m not sure if something dangerous can be done, but some other functions can be called like redirect. For forbidding all the methods from Controller base class, use this component.

<?php
/**
* MySecurity.php
* Some security things for Cake
*
* Features:
* - The public functions from controller & object now can’t be called from url
* -
*
* @author RosSoft
* @version 0.1
* @license MIT
*
* @package components
*/

class MySecurityComponent extends Object
{
var $components=array(’Security’);

    /**
    * Extra forbidden actions
    *
    * @var array $forbidden_actions
    */
    var $forbidden_actions=array();

    function startup(&$controller)
    {
        $this->forbidden_actions=am($this->forbidden_actions, get_class_methods(’Controller’));

        $this->Security->startup($controller);
        if (in_array($controller->action,$this->forbidden_actions))
        {
            $this->Security->blackHoleCallback=null;
            $this->Security->blackHole($this);
        }
    }
}
?>

Original at RosSoft.

Need Different Title For Page? It's simple!

2006-09-14T03:29:00.000-07:00

Just add this code in <head> your views:

<h2><?php echo $this->pageTitle="Page title goes here"?></h2>

But remember, in cakephp 1.2.xx you can achieve this by

$this->set(‘title’, ‘Foo bar’);

Of couse, you must setup this variable (pageTitle) in your controller ;-)

Navigation Helper The Best of!

2006-09-14T03:26:00.000-07:00

If you want get code like this:

<ul id="main_nav"> <li><a href="/users/account' class="active">My account</a></li> <li><a href="/items/browse'>Browse</a></li> <li><a href="/items/add' class="active">Create item</a></li> <li><a href="/users/add' class="active">Create User</a></li> </ul>

You can use useful ;) helper - Navigation Helper!

Code like this:

<?$navigation->link('My account',"/users/account/",array('activeAction'=>'account'))?>
<?$navigation->link('Browse',"/items/browse/",array('activeAction'=>'browse'))?>
<?$navigation->link('Create Item',"/items/add/",array('activeAction'=>'add','activeController'=>'items'))?>
<?$navigation->link('Create Item',"/users/add/",array('activeAction'=>'add','activeController'=>'users'))?>

So... When user travel into your site and change /items/add -> users/add - the different menu be displayed (class = "active" I mean).

Just add code like this

<?php echo $navigation->render(null,array('id'=>'main_nav'))?>

In your views! ;-)

Easy Way? Yes! Easy!

You can find more detail information here. And download navigation helper (sorry it's not direct link, because this file present in other blog).

How To Make Model Without a Table? Easy Decision!

2006-09-14T03:05:00.000-07:00

The answer is simple:

class ModelWithoutTable extends AppModel
{
    var $useTable = false;
}

How To Make Controller Without a Model?

class MyController extends AppController
{
    // var $uses = null; works too
    var $uses = array();

    function index()
    {
    }
}

If you omit the “var $uses = array();” you will get a “missing model” error.

Thank's to CakeBaker!

Useful Site for CakePHP Developer

2006-09-13T06:00:00.000-07:00

Here you can monitore a lot of useful cakephp-oriented site (but without this ;)

Just reload this page every 2-3 hours and you can read all news, all discovery, all new hints.

CakePHP - is fastest developing framework in the world. Just try it!

How To Validate data Without Saving?

2006-09-13T05:35:00.000-07:00

You know, CakePHP check data only when you saving:

$this -> User -> save ($this->data)

But if you do not needing to save data?

In this case, you can use this "hint":

if ( $this -> User -> validates ( $this -> data ) )
{
// OK, good to go
}
else
{
$this->set( 'data', $this->params['data'] );
$this->validateErrors( $this->User );
$this->render();
}

This code snippet made by Devo.

Hi!

2006-09-13T05:18:00.000-07:00

The goal of this blog - concentrate useful tips, hints and original metod of programming... All about Cakephp - one of the best framework in the world ;-)