zend db model statistics - PHP Snipplr Social Repository

Revision: 47844

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

Choose a language for easy browsing: