CakePHP Questions

I'm using the Linkable behavior (http://blog.rafaelbandeira3.com/2008/11/16/linkable-behavior-taking-it-easy-in-your-db/) to generate joined queries.

I have the following find operation:

        $episodes =...

Hi. I'm learning CakePHP (using the blog app tutorial) and I want to get rid of that stupid table of SQL queries that shows in my views. So far I only found out that the table isn't passed in $content_for_layout variable, because it appends after...

How can I select a defined list of fields in a findAll() query which runs on a HABTM model. I have the model diagram with HABTM tags. In the tag model I use:

$this->Tag->findAll();

This returns a correct result but the query selects all(!)...

Hey guys i've been trying to increase the user experience of an application of mine by adding AJAX but i can't seem to find a decent tutorial?

Can anyone help me find a good working tutorial that makes use of cakephp + ajax?

Thanks in advance

I'll admit that of the M-V-C pattern's component parts, the View part is my weakest link. Even with elements, helpers and the like, my code ends up being large blobs of hard to read pieces of flotsam and jetsam. One major culprit is...

are there any cakephp way of using find('list', array('fields' = array('User.id', 'Profile.nickname')))); ?

if i do that it'll throw an error.

for the time being i am using a function i wrote to get the list, not flexible function at that.

Your...

Hi, how do I convert this query (with subquery):

SELECT * FROM (SELECT * FROM Logs ORDER BY Logs.created DESC) AS a GROUP BY Logs.id ORDER BY Logs.created DESC

to a CakePHP find condition?

I got app that need to be recoded in CakePHP.

I got following select with subselects:

        SELECT COUNT(*) AS item1,
            (SELECT COUNT(*) FROM portal_members) AS item3, 
            (SELECT COUNT(*) FROM portal_reviews) AS item3, 
     ...

Bonjour,

J'essaye d'utiliser $ajax pour l'envoie de mon formulaire (un livre d'or).

	echo $ajax->submit('Soumettre', array(
	    'url'=> array('controller'=>'messages', 'action'=>'add'), 
	    'condition' => 'valider()',
	    'update' =>...

I am using JQuery and Cakephp 1.2;

the problem is posting the data.

this is how m posting the data iterating over each fields in form.

$('input[type=submit]').click(function(bE) {
				bE.preventDefault();
				id = '#' +...

Hi,

I have an in dex method with a find to select all distinct user id's in my user table;

$userId = $this-Order-find('all', array('fields'=array('DISTINCT(Order.user_id) AS user')));

which sends back the lovely array:

[userId] = Array([0] =...

Cake has default ajax pagination feature, but the output is in html which is not a good idea and huge amount of data transfer.

I want to use JSON to reduce data transfer. Is there any "ready-made" stuff for pagination using json (and jQuery).

Bonjour,

j'ai besoin de faire une seule requête sur plusieurs bases de données. J'ai défini mes associations pour que le LEFT JOIN se fasse correctement sur la table de l'autre base, la requête est correcte.

En revanche, bien que j'aie préfixé mes...

Hi, what would this query look like as per cake?

'SELECT COUNT( * )FROM orders`LEFT JOIN `product_details` AS `ProductDetail` ON ( `orders`.`product_detail_id` = `ProductDetail`.`id` )WHERE `ProductDetail`.`new_or_used` = "New" GROUP BY...

Hi,

I would like to disable multidimensional array returned as result from query.

I would like to have it like simple query result array

Hello, i would like to ask, what is simplest way to use JQuery in cake?

I would like use JQuery in sense, send form data to any contoller and function and put result into DIV on page without page refresh.

Something like:

<script...

Hi,

I'm moving a mysql query from 1.1 to 1.3-RC1

 $conditions = array("OR" => array(
      'Item.expiration'       => 0,
      'Item.expiration >'     => "NOW()"
    )
 );
 $params = array(
   'conditions'    => $conditions
);
 $items =...

Well I read a lot, and now I have too much…

I need clarifying, and I hope I’m not only one.

Cake 1.2.6 standard ajax lib is prototype, and on this lib is based also ajax helper.

In some mailings/blogs I have read that this will be changed in further...

Hi all,

I know MVC speaking it's not kosher to access a database within a helper, but this is the situation I'm in.

I'm creating a parser where people can specify thumbnails for images in the database by inserting a tag like [thumb, id, width,...

Hi all,

I have a table/model Contract with id, price_normal, price_action.

I want to be able to sort on the pseudo column 'price_lowest' which contains the lowest of the fields price_normal and price_action.

I tried to add a MySQL query in the...