Revision: 47844
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at June 17, 2011 05:04 by yigit
Initial Code
public function getStats() { $result = $this->fetchAll( $this->select() ->from(array('r' => 'samsung_sii.record')) ->columns(array('DAY(RecordDateTime) AS RecordDateTime')) ->group('DAY(RecordDateTime)') ); // print_r($result); exit(); $data = array(); foreach ($result as $row) { $data['xAxis'][] = "'" . $row->RecordDateTime . "'"; $result2 = $this->fetchRow( $this->select() ->from(array('r' => 'samsung_sii.record')) ->columns(array('COUNT(RecordID) AS RecordCount')) ->where('DAY(RecordDateTime) = ?', $row->RecordDateTime) ); $data['yAxis'][] = $result2->RecordCount; } $data['xAxis'] = implode(', ', $data['xAxis']); $data['yAxis'] = implode(', ', $data['yAxis']); return $data; }
Initial URL
Initial Description
Initial Title
zend db model statistics
Initial Tags
Initial Language
PHP