Просмотр файла _X_admin_X_/pages/1.php

Конкурс дизайнеров на 15000 рублей
Автопокупка рекламы
Размер файла: 3.16Kb 
  1. <?php
  2. $pp=@$_GET['pp'];
  3. $pp=valid_number($pp);
  4. $res=mysql_query("SELECT * 
  5. FROM `category`");
  6. echo '<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  7. <html><head><title>Админ панель-&gt;Управление категориями</title>
  8. '.$css.'
  9. </head>';
  10. if (!mysql_num_rows($res))
  11. {echo '<div class="rekl">Нет ни одной категории!</div>';}
  12. echo '<div class="zag" align="center"><form method="post" action="'.htmlspecialchars($_SERVER['REQUEST_URI']).'">
  13. Название<br/>
  14. <input type="text" name="cat_name">
  15. <input type="hidden" name="from" value="'.$pp.'"><br/>
  16. <input type="submit" value="Создать">
  17. </form></div>';
  18. if (!empty($_POST))
  19. {
  20. 	$n=trim($_POST['cat_name']);
  21. 	$from=$_POST['from'];
  22. 	$time=time();
  23. 	mysql_query("INSERT INTO `category` 
  24. 	(`id`, `name`, `from`, `one_time`, `update`,`count`) 
  25. 	VALUES ('', '$n', '$from', '$time', '$time', '0')");
  26. }
  27. ///----------------------------------Удаление-----------------------------------------///
  28. if (isset($_GET['dell']))
  29. {$dellete=$_GET['dell'];
  30. mysql_query("DELETE FROM `category` WHERE `id` = '$dellete' LIMIT 1");}
  31. ///-----------------------------------------------------------------------------------///
  32. echo '<div class="c">';
  33. ///------------------------------Переименование---------------------------------------///
  34. if (isset($_GET['rename']))
  35. {
  36. $rename=$_GET['rename'];
  37. 	if (isset($_POST['new_name']))
  38. 	{
  39. 	$new_name=$_POST['new_name'];
  40. 	mysql_query("UPDATE `category` SET 
  41. 	`name` = '$new_name'
  42. 	WHERE `id` = '$rename' 
  43. 	LIMIT 1");
  44. 	}
  45. $ren=mysql_query("SELECT * FROM `category` WHERE `id`='$rename' LIMIT 1");
  46. $arr_ren = mysql_fetch_assoc($ren);
  47.  
  48. echo '<a href="?p=1&amp;password='.$_GET['password'].'&amp;pp='.$pp.'">Отмена</a><form method="post" action="'.htmlspecialchars($_SERVER['REQUEST_URI']).'">
  49. <input type="text" name="new_name" value="'.htmlspecialchars($arr_ren['name']).'">
  50. <input type="submit" value="Ок">
  51. </form>';
  52. }
  53. ///------------------------------------------------------------------------------------///
  54.  
  55. ///--------------------------------------------Очистка---------------------------------///
  56. if (isset($_GET['clear']))
  57. {
  58. $clear=$_GET['clear'];
  59. mysql_query("UPDATE `category` SET 
  60. `array` = '', 
  61. `count` = '0' 
  62. WHERE `id` = '$clear' 
  63. LIMIT 1");
  64. echo 'Выполнено!<br/><br/>';
  65. }
  66. ///------------------------------------------------------------------------------------///
  67.  
  68.  
  69.  
  70.  
  71.  
  72. $res=mysql_query("SELECT * 
  73. FROM `category`
  74. WHERE `from`='$pp'");
  75.  
  76. while ($arr = mysql_fetch_assoc($res))
  77. {
  78. echo '&#187;<a href="?p=1&amp;password='.$_GET['password'].'&amp;pp='.$arr['id'].'">'.$arr['name'].'</a>(<a href="?p=1&amp;password='.$_GET['password'].'&amp;pp='.$pp.'&amp;clear='.$arr['id'].'">Clear</a>|<a href="?p=1&amp;password='.$_GET['password'].'&amp;pp='.$pp.'&amp;rename='.$arr['id'].'">Rename</a>|<a href="?p=1&amp;password='.$_GET['password'].'&amp;pp='.$pp.'&amp;dell='.$arr['id'].'">Del</a>)('.$arr['count'].')<br/>
  79. ';
  80. }
  81. echo '</div>';
  82. echo '<div class="kon" align="center"><a href="?p=0&amp;password='.$_GET['password'].'">В админ панель</a></div>
  83. </html>';
  84. ?>