Question

象卡纳克民阵如何通过我SQL的问答结果自动 lo,并将之列入你的一份冰图。

这里有一个样本询问:Im使用:

# Inside some model
return $this->query("

  SELECT 
    Profile.id,
    SUM( IF( HOUR(Log.event_one) > 3, 1, 0 ) ) as EventOne

  FROM profiles Profile
  JOIN logs Log ON Log.id = Profile.log_id

  WHERE Profile.id = {$pUserId}
");

CakePHP将返回一个像以下地图:

array
  0
    array
       Profile 
          array
             id  => 23
       0 
          array
             EventOne  => 108
  1
    array
       Profile 
          array
             id  => 23
       0 
          array
             EventOne  => 42
  2
    ...

我想要做的是这样的结果:

array
   Profile 
      array
         id  => 23

   Events 
  #   ^   I want to be able to specify this key
      array
         EventOne  => 108

任何想法?

Answer 1

You can t do that directly

The top level array keys are derived from the table name which mysql says the field relates to - in your case it s a calculated field and therefore (according to mysql) belongs to no table - hence the 0 array key.

Post processing

然而,你可以做的是事后处理结果,这样你想要的是形式:

public function getStuff() {
    // The query call in the question can very easily be a normal find call
    $return = $this->query("don t use query unless you have no choice");

    foreach($return as &$row) {
        $row[ Events ] = $row[0];
        unset($row[0]);
    }

    return $return;
}

You can t do that directly

Post processing

友情链接