Я тут попытался что то набросать на нем, но тут наверное больше по ооп.
Выкладываю Вам на обсуждение, прошу сильно не бить.
<?php
class Afisha extends Controller {
function index(){
$pageData['title'] = "Gookit Афиша – главная";
$pageData['billboards'] = $this->getAllAfisha();
if ($pageData['billboards'] == false) {
$pageData['errorAfisha'] = "Мероприятия не найдены";
}
$this->load->view('afisha', $pageData);
}
function getAllAfisha(){
$qGetAll = "SELECT `afisha`.`afisha_title`, `afisha`.`afisha_min_discription`
`afisha`.`afisha_organizat_people`, `afisha`.`afisha_partner_people`,
`afisha`.`afisha_sait`
FROM `afisha`";
$res = $this->db->query($qGetAll);
$afishaData = $res->result_array();
if (count($afishaData) == 0) {
return false;
}
return $afishaData;
}
function getAfishaDetails($afisha_id) {
if(!isset($afisha_id) OR !$afisha_id){
return false;
}else{
$qGetAfisha = "SELECT `afisha`.`afisha_title`, `afisha`.`afisha_full_discription`
`afisha`.`afisha_organizat_people`, `afisha`.`afisha_partner_people`,
`afisha`.`afisha_sait`
FROM `afisha` WHERE `afisha`.`afisha_id`=?";
$res = $this->db->query($qGetAfisha, array($afisha_id));
$afishaData = $res->result_array();
if (count($afishaData) == 0) {
return false;
}
return $afishaData[0];
}
}
function addAfisha($afisha_title, $afisha_min_desc, $afisha_full_desc){
$title = $this->input->post('afisha_title');
$min_discript = $this->input->post('afisha_min_discription');
$full_discript = $this->input->post('afisha_full_discription');
$qSetAfisha="INSERT INTO `afisha` (`afisha_title`,`afisha_min_discription`, `afisha_full_discription`) VALUES ($title, $min_discript, $full_discript)";
$res = $this->db->query($qSetAfisha);
}
function modAfisha($afisha_id){
$title = $this->input->post('afisha_title');
$min_discript = $this->input->post('afisha_min_discription');
$full_discript = $this->input->post('afisha_full_discription');
$qSetAfisha="UPDATE `afisha`
SET
`afisha_title` = {$title},
`afisha_min_discription` = {$min_discription},
`afisha_full_discription` = {$full_discription},
`afisha_organizat_people` = {$organizat_people},
`afisha_partner_people` = {$partner_people},
`afisha_sait` = {$sait}
WHERE `afisha`.`afisha_id`={$afisha_id};
";
$res = $this->db->query($qSetAfisha);
}
function delAfisha($afisha_id){
if(!isset($afisha_id) OR !$afisha_id){
return false;
}else{
$qGetAfisha= "SELECT FROM `afisha` WHERE `afisha`.`afisha_id`=? LIMIT 1";
$res = $this->db->query($qGetAfisha, array($afisha_id));
return true;
}
}
}