function __construct() { db_connect(); $selected_group = (int) @$_REQUEST['selected_group']; $add_new = @$_REQUEST['selected_group'] == 'new'; if (isset($_GET['delete'])) { $id = (int) $_GET['delete']; $query = "DELETE FROM `groups` WHERE id={$id}"; if (!($result = mysql_query($query))) { die(mysql_error()); } unlink("../costumes/groups/{$id}.jpg"); header('Location: grupy'); } if (count($_POST)) { $group = mysql_escape_string($_POST['group']); $sort = (int) $_POST['sort']; if ($add_new == true) { $query = "INSERT INTO `groups` (`id`, `group`, `sort`) VALUES (0, '{$group}', {$sort})"; if (!($result = mysql_query($query))) { die(mysql_error()); } $selected_group = mysql_insert_id(); } else { $query = "UPDATE `groups` SET `group`='{$group}', `sort`={$sort} WHERE `id`={$selected_group}"; if (!($result = mysql_query($query))) { die(mysql_error()); } } if (@$_FILES['cover']['tmp_name']) { Obrazek::zmniejsziwytnij($_FILES['cover']['tmp_name'], "../costumes/groups/{$selected_group}.jpg", 120, 180); } header('Location: grupy#group-' . $selected_group); } if ($selected_group == 0 && $add_new == false) { $this->groups = array(); $query = "SELECT * FROM `groups` ORDER BY sort ASC"; $result = mysql_query($query); while ($row = mysql_fetch_array($result)) { $this->groups[] = $row; } } else { $this->template = "grupa"; if ($add_new) { $this->group = array('id' => 'new', 'group' => '', 'sort' => ''); } else { $query = "SELECT * FROM `groups` WHERE id={$selected_group}"; $result = mysql_query($query); $row = mysql_fetch_array($result); $this->group = $row; } $this->show(); exit; } }
function __construct() { db_connect(); // wyrbane zdjecie $selected_photo = (int) @$_REQUEST['selected_photo']; //czy jest to opcja dodawania $add_new = @$_REQUEST['selected_photo'] == 'new'; // kasowanie elementu if (isset($_GET['delete'])) { $id = (int) $_GET['delete']; //wyrzucamy wpis z bazy $query = "DELETE FROM `photos` WHERE id={$id}"; if (!($result = mysql_query($query))) { die(mysql_error()); } //kasujemy pliki unlink("../costumes/large/{$id}.jpg"); unlink("../costumes/thumb/{$id}.jpg"); //przekierowujemy z powrotem na liste header('Location: kostiumy'); } // jeżeli został wysłany formularz to edytujemy/zmieniamy if (count($_POST)) { // pobieramy wysłane wartosci $id_group = (int) $_POST['id_group']; $name = mysql_escape_string($_POST['name']); $stars = (int) $_POST['stars']; // jezeli dodajemy if ($add_new == true) { $query = "INSERT INTO photos (id, id_group, name, stars) VALUES (0, {$id_group}, '{$name}', {$stars})"; if (!($result = mysql_query($query))) { die(mysql_error()); } $selected_photo = mysql_insert_id(); } else { $query = "UPDATE photos SET id_group={$id_group}, name='{$name}', stars={$stars} WHERE id={$selected_photo}"; if (!($result = mysql_query($query))) { die(mysql_error()); } } // jezeli został wrzucony plik if (@$_FILES['photo']['tmp_name']) { // to robimy miniaturkę i prevke Obrazek::zmniejsz($_FILES['photo']['tmp_name'], "../costumes/large/{$selected_photo}.jpg", 800, 600); Obrazek::zmniejsziwytnij($_FILES['photo']['tmp_name'], "../costumes/thumb/{$selected_photo}.jpg", 120, 180); } // przekierowywujemy na liste kostiumów w odpowienie miejsce // wpis po # odnosi automatcyznie do elementu o takim id na stronie header('Location: kostiumy#costume-' . $selected_photo); } // jezeli nie ma wybranego zdjecia to wyrzucamy listę if ($selected_photo == 0 && $add_new == false) { $selected_group = 1; $this->photos = array(); $query = "SELECT * FROM `photos` ORDER BY id_group ASC, stars DESC"; $result = mysql_query($query); while ($row = mysql_fetch_array($result)) { $this->photos[] = $row; } } else { $this->template = "kostium"; // jezeli nowy to zwracamy tablicę z pustymi wartosciami if ($add_new) { $this->photo = array('id' => 'new', 'name' => '', 'id_group' => 0, 'stars' => ''); } else { $query = "SELECT * FROM `photos` WHERE id={$selected_photo}"; $result = mysql_query($query); $row = mysql_fetch_array($result); $this->photo = $row; } // pobieramy grupy żeby wyświetlić selectboxa z wyborem $this->groups = array(); $query = "SELECT * FROM `groups` ORDER BY sort ASC"; $result = mysql_query($query); while ($row = mysql_fetch_array($result)) { $this->groups[] = $row; } // wypisujemy ( tak jak w indexie tylko że bez headera i footera ) $this->show(); // i kończymy dalsze wykonywanie exit; } }