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");
}
}
