public function Obtain($id_answer)
{
try {
$query = $this->pdo->prepare('SELECT * FROM Respuestas WHERE id_answer = ?');
$query->execute(array($id_answer));
$r = $query->fetch(PDO::FETCH_OBJ);
$answer = new Answer();
$answer->__SET('id_answer', $r->id_answer);
$answer->__SET('id_event', $r->id_event);
$answer->__SET('respuesta', $r->respuesta);
$answer->__SET('correct', $r->correct);
return $answer;
} catch (Exception $e) {
die($e->getMessage());
}
}
$image['name'] = date('ymhis') . $_FILES['image']['name'];
$image['directory'] = '../img_bbdd/';
move_uploaded_file($_FILES['image']['tmp_name'], $image['directory'] . $image['name']);
$directory = 'img_bbdd/' . $image['name'];
} else {
$image = 'img_bbdd/helados.jpg';
$directory = "img_bbdd/helados.jpg";
}
}
switch ($_REQUEST['action']) {
case 'update':
/*echo "<script type=\"text/javascript\">
alert('¡El registro se ha actualizado exitosamente! El directorio de la imagen es: $directory');
//history.go(-2);
</script>";*/
$answer->__SET('id_answer', $_REQUEST['id_answer']);
$answer->__SET('id_event', $_REQUEST['id_event']);
$answer->__SET('respuesta', $_REQUEST['respuesta']);
$answer->__SET('correct', $_REQUEST['correct']);
$answerModel->Update($answer);
echo "<script type=\"text/javascript\">\n alert('¡El registro se ha actualizado exitosamente! El directorio de la imagen es: {$directory}');\n history.go(-2);\n </script>";
break;
case 'insert':
//$answer->__SET('id_answer' , $_REQUEST['id_answer']);
$answer->__SET('id_event', $_REQUEST['id_event']);
$answer->__SET('respuesta', $_REQUEST['respuesta']);
$answer->__SET('correct', $_REQUEST['correct']);
$answerModel->Insert($answer);
echo "<script type=\"text/javascript\">\n alert('Se ha añadido correctamente a la base de datos una respuesta');\n history.go(-2);\n </script>";
break;
case 'edit':
if ($_REQUEST['winner'] == '') {
$_REQUEST['winner'] = 'Sin determinar';
}
if ($_REQUEST['tiposelect'] == 2) {
$contest->__SET('id_event', $_REQUEST['id_event']);
$contest->__SET('id_type', $_REQUEST['tiposelect']);
$contest->__SET('name', $_REQUEST['name']);
$contest->__SET('question', $_REQUEST['question']);
$contest->__SET('initial_date', $_REQUEST['initial_date']);
$contest->__SET('final_date', $_REQUEST['final_date']);
$contest->__SET('winner', $_REQUEST['winner']);
$contest->__SET('active', 1);
$contestModel->Insert($contest);
$lastID = $answerModel->lastID();
//$answer->__SET('id_answer' , $_REQUEST['id_answer']);
$answer->__SET('id_event', $lastID);
$answer->__SET('respuesta', $_REQUEST['first_answer']);
$answer->__SET('correct', $_REQUEST['last_correct']);
$answerModel->InsertA($answer);
echo "<script type=\"text/javascript\">\n alert('Se ha añadido correctamente a la base de datos un nuevo Concurso con sus posibles respuestas');\n history.go(-2);\n </script>";
break;
} else {
$contest->__SET('id_event', $_REQUEST['id_event']);
$contest->__SET('id_type', $_REQUEST['tiposelect']);
$contest->__SET('name', $_REQUEST['name']);
$contest->__SET('question', $_REQUEST['question']);
$contest->__SET('initial_date', $_REQUEST['initial_date']);
$contest->__SET('final_date', $_REQUEST['final_date']);
$contest->__SET('winner', $_REQUEST['winner']);
$contest->__SET('active', 1);
$contestModel->Insert($contest);
