CakePHP query array

Question

I am running this query using CakePHP:

$total = $this->Lapse->query("select sum(unix_timestamp(stop) - unix_timestamp(start)) from lapses where id = ".$lastId."");

And i get back this array structure:

Array
(
    [0] => Array
        (
            [0] => Array
                (
                    [sum(unix_timestamp(stop) - unix_timestamp(start))] => 1
                )

        )

)

So my variable holds this: $updateVal = $total[0][0][0];

Which isn't the prettiest, is there a way i can simplify this OTT array?

elitalon · Accepted Answer · 2011-11-28 07:11:29Z

3

Have you tried the find() method passing a custom fields option?:

$this->Lapse->find('all', array(
  'fields' => array('sum(unix_timestamp(stop) - unix_timestamp(start)) as elapsed_time'),
  'conditions' => array('Lapse.id' => $lastId),
));

The returned array is prettier than the one you're getting, although it's not prettier than elapsed_time being an actual model property.

Another solution would be to set elapsed_time as a virtual field within the model:

class Lapse extends AppModel {
  ...

  public $virtualFields = array(
    'elapsed_time' => 'sum(unix_timestamp(Lapse.stop) - unix_timestamp(Lapse.start)',
  );

  ...
}

Then elapsed_time acts as a model property and would be returned as $updateVal['Lapse']['elapsed_time'] in every find() call.

edited Nov 28, 2011 at 7:11

answered Nov 26, 2011 at 16:12

elitalon

9,46710 gold badges53 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

CakePHP query array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related