public function index() { $id = I('get.movie_id'); $model = new \Home\Model\MovieModel(); $result = $model->selectOne('movie', 'movie_id=' . $id); $join = [' join movie on movie.movie_id=schedule.movie_id ', ' join hall on schedule.hall_id=hall.hall_id ']; $where = ' schedule.movie_id=' . $id . ' '; $dom = $model->select('schedule', $where, '', $join); foreach ($dom as &$movie) { $movie['cinema'] = $model->selectOne('cinema', ' cinema_id=' . $movie['cinema_id']); $movie['cinema'] = $movie['cinema'][0]; } // var_dump($dom); // $ticketUrl = ; $join = ['join hall on hall.hall_id=schedule.hall_id', 'join cinema on hall.cinema_id=cinema.cinema_id']; $allSchedule = $model->select('schedule', 'movie_id=' . $id, '', $join); $allComments = $model->select('comment', 'movie_id=' . $id, '', ' user on user.user_id=comment.user_id'); $allMovie = $model->select('movie'); //var_dump($allSchedule); $this->assign('allSchedule', $allSchedule); $this->assign('movieurl', U('Movie/index')); $this->assign('dom', $dom); $this->assign('ticketUrl', U('ticket/index')); $this->assign('movie', $result[0]); $this->assign('allmovie', $allMovie); $this->assign('allComments', $allComments); $this->assign('searchurl', U('Search/index')); // var_dump($allComments ); //$this->assign('allmovie',$allMovie); $this->display(); }
public function index() { $id = I('get.cinema_id'); $model = new \Home\Model\MovieModel(); $result = $model->selectOne('cinema', 'cinema_id=' . $id); //var_dump($result); $this->assign('searchurl', U('Search/index')); $allMovie = $model->select('movie', '', '0,9'); $this->assign('cinema', $result[0]); $this->assign('allmovie', $allMovie); $this->assign('movieurl', U('Movie/index')); $this->display(); }
public function check() { //var_dump($_GET); $model = new \Home\Model\MovieModel(); $result = $model->selectOne('user', " email='" . I('get.email') . "' "); $result = $result[0]; if ($result) { if ($result['password'] == I('get.password')) { $this->setToken($result); $this->redirect('Home/Index/index', array('cate_id' => 2), 1, '<script>alert("success")</script>'); } else { $this->redirect('Home/Sign/index', array('cate_id' => 2), 1, '<script>alert("password error")</script>'); } } else { $data = ['email' => I('get.email'), 'password' => I('get.password'), 'phone' => '-', 'nickname' => md5(date('Y-m-d h-i-s')), 'headurl' => 'headicon.jpg']; $user = M('user'); $user->add($data); $data['user_id'] = $user->getLastInsID(); $this->setToken($data); $this->redirect('Home/Index/index', array('cate_id' => 2), 1, '<script>alert("register success")</script>'); } }