public function viewAction() { $table = new Model_DbTable_Users(); $select = $table->select()->where('username = ?', $this->_getParam('username')); $user = $table->fetchRow($select); $this->view->headTitle($user->realname); $this->view->user = $user; }
public function ajaxdavaaresultAction() { $davaa_num = $this->_request->getParam('davaa_num'); $fantasy_id = $this->_request->getParam('fantasy_id'); $galuud = new Model_DbTable_Gal(); $gal = $galuud->fetchAll($galuud->select()); $galname = array(); $galezenid = array(); foreach ($gal as $key => $value) { $galname[$value['id']] = $value['name']; $galezenid[$value['id']] = $value['ezen_id']; } $users = new Model_DbTable_Users(); $user = $users->fetchAll($users->select()); $usr = array(); foreach ($user as $key => $value) { $usr[$value['id']] = $value['lastname'] . ' ' . $value['firstname']; } $davaas = new Model_DbTable_Davaagal(); $davaa = $davaas->fetchAll($davaas->select()->where('fantasy_id = ' . $fantasy_id . ' AND davaa_num = ' . $davaa_num)->order('score DESC')); $galid = 0; $cnt = 5; $ret = array(); foreach ($davaa as $key => $val) { $ret[] = array('galname' => $galname[$val['gal_id']], 'score' => $val['score'], 'username' => $usr[$galezenid[$val['gal_id']]], 'galid' => $val['gal_id'], 'davaa' => $davaa_num); } echo Zend_Json::encode($ret); }