Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php // cats.php
- include('header.php'); // header einbinden
- //------------------------------------------------------------------------------
- // Kategorie Bearbeiten
- //------------------------------------------------------------------------------
- if($_GET['action'] == 'edit'){
- if(isset($_POST['submit']) && !empty($_POST['cat'])){ // Sofern speichern gedrueckt
- // DB Updaten
- $update = mysql_query("UPDATE news SET cat = '".clean_it($_POST['cat'])."' WHERE cat = '".clean_it($_GET['cat'])."' ");
- if($update){
- header("Location: cats.php"); // Weiterleitung
- }
- } // close submit
- ?>
- <form action="" method="post" id="bbcode">
- <fieldset>
- <legend>Kategorie bearbeiten</legend>
- <input type="text" name="cat" value="<?php echo clean_it($_GET['cat']); ?>" />
- <input type="submit" value="Speichern" name="submit" class="button"/>
- </fieldset>
- </form>
- <?php
- //------------------------------------------------------------------------------
- // Kategorie loeschen
- //------------------------------------------------------------------------------
- }else if($_GET['action'] == 'delete'){
- // DB Updaten
- $update = mysql_query("UPDATE news SET cat = '' WHERE cat = '".clean_it($_GET['cat'])."' ");
- if($update){
- header("Location: cats.php"); // Weiterleitung
- }
- //------------------------------------------------------------------------------
- // Kategorien auflisten
- //------------------------------------------------------------------------------
- }else{
- echo "<h2>Kategorien</h2>\n";
- // DB Abfrage
- $abfrage = mysql_query("SELECT DISTINCT cat FROM news WHERE cat != ''");
- $total = mysql_num_rows($abfrage); // Anzahl aller Zeilen in DB ermitteln
- if($total < 1){ // Pruefen ob Eintraege vorhanden
- echo "<p>Zur Zeit existieren keine Kategorien ...</p>";
- }else{
- echo "<ul class=\"list\">";
- // Kategorien ausgeben ausgeben
- while($row = mysql_fetch_object($abfrage)){
- echo "<li>";
- echo "<div class=\"right\">\n";
- echo "<a href=\"cats.php?action=edit&cat=".urlencode($row->cat)."\">Bearbeiten</a> \n";
- echo "<a href=\"cats.php?action=delete&cat=".urlencode($row->cat)."\">[x]</a>\n";
- echo "</div>\n ";
- echo "<p>".$row->cat."</p></li>\n";
- } // close while
- echo "</ul>\n<br />";
- } // close Eintrage vorhanden
- }// close $action
- include('footer.php'); // footer einbinden
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement