function doGet() { global $smarty; global $db; require_once "./config.php"; $db = connectToDatabase(); smartysetup(); $mvname = $_GET['mvn']; $query = 'movie = ?'; $mvm = new Moviemains(); $infos = $mvm->Find($query, $mvname); /**single movie*/ $mcomms = array(); $mpics = array(); $querys = 'fk_movie = ?'; $mvs = new Moviesupps(); $supinfos = array(); $supinfos = $mvs->Find($querys, $infos[0]->id); foreach ($supinfos as $supin) { $mcomms[] = $supin->photocomment; $mpics[] = $supin->photo; } $snums = count($mpics) - 1; $smarty->assign('num', $snums); $smarty->assign('name', $mvname); $smarty->assign('cat', $infos[0]->mgroup); $smarty->assign('info', $infos[0]->info); $smarty->assign('comms', $mcomms); $smarty->assign('pics', $mpics); $smarty->display('SearchResult.tpl'); }
function doPost() { global $smarty; global $db; require_once "./config.php"; smartysetup(); $db = connectToDatabase(); if (isset($_POST['mvname']) && isset($_POST['mvcategory']) && isset($_POST['sum']) && isset($_POST['pics']) && isset($_POST['comms'])) { $mvname = filter_input(INPUT_POST, 'mvname', FILTER_SANITIZE_STRING); $cat = filter_input(INPUT_POST, 'mvcategory', FILTER_SANITIZE_STRING); $sum = filter_input(INPUT_POST, 'sum', FILTER_SANITIZE_STRING); //$pics = filter_input_array(INPUT_POST, 'pics', FILTER_SANITIZE_STRING); $pics = $_POST['pics']; //$comms = filter_input_array(INPUT_POST, 'comms', FILTER_SANITIZE_STRING); $comms = $_POST['comms']; $moviem = new Moviemains(); $moviem->movie = $mvname; $moviem->mgroup = $cat; $moviem->info = $sum; if ($moviem->save() == false) { die("Database record save failure"); } $id = $moviem->id; for ($i = 0; $i < count($pics); $i++) { $movies = new Moviesupps(); $movies->fk_movie = $id; $movies->photo = $pics[$i]; $movies->photocomment = $comms[$i]; if ($movies->save() == false) { die("sumplement datas record save failure"); } } $smarty->assign("headt", "Movie records"); $smarty->assign('mname', $mvname); $smarty->assign('mnum', $id); $smarty->assign('picnum', count($pics)); $smarty->display('AddReport.tpl'); } else { $errorMsg = "please input all the things first"; $smarty->assign('error', $errorMsg); $smarty->display("error.tpl"); } }
function doPost() { global $smarty; global $db; require_once "./config.php"; $db = connectToDatabase(); smartysetup(); $movies = array(); $namelinks = array(); if (isset($_POST['mvcategory'])) { $cat = filter_input(INPUT_POST, 'mvcategory', FILTER_SANITIZE_STRING); $mvm = new Moviemains(); $query = "mgroup = ?"; $movies = $mvm->Find($query, $cat); foreach ($movies as $tm) { $namelinks[] = $tm->movie; } $smarty->assign('mvks', $namelinks); $smarty->assign('cat', $cat); $smarty->display('SearchReport.tpl'); } }