Advertisement
Hello_PHP

Untitled

Dec 16th, 2019
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.55 KB | None | 0 0
  1. <?php
  2. session_start();
  3. require_once 'vendor/connect.php';
  4. if(isset($_POST['delete'])){
  5.     Mysqli_query($connect, "DELETE  FROM `users` WHERE `users`.`id` = ".$_POST['id']);
  6. }
  7. ?>
  8. <!DOCTYPE html>
  9. <html>
  10. <head>
  11.     <title>Admin</title>
  12.     <link rel="stylesheet" type="text/css" href="assets/css/main.css">
  13. </head>
  14. <body>
  15. <?php if($_SESSION['user']['email'] == $adm_email) :?>
  16. <div class="form">
  17.     <form action="" method="post">
  18.     <input type="text" name="id" placeholder="Введите ID">
  19.     <input type="submit" name="delete" value="Удалить!">
  20.     </form>
  21. <?php else: ?>
  22.     <div class="message">
  23.         Такой страницы не существует!
  24.     </div>
  25. <?php endif ?>
  26. </body>
  27. </html>
  28.  
  29. <?
  30.     //if ( !$_SESSION['admin'] ) header('location: /');
  31.     if ( $_GET['fnc'] == 'add_art' ) {?>
  32.     <h1>Добавление статьи</h1>
  33.         <form action="/admin.php?fnc=add_art" method="post">
  34. <?
  35.     if ( $_POST['add_art'] ) {
  36.         mysqli_query($connect, "INSERT INTO `articles` (`author`, `title`, `text`, `date`) VALUES ('$_POST[author]', '$_POST[title]', '$_POST[text]', NOW())");
  37.     //  header('location: /');
  38.     }
  39. ?>
  40.             <p><input type="text" class="input" name="author" placeholder="Автор" value="<?=$_SESSION['login']?>"></p>
  41.             <p><input type="text" class="input" name="title" placeholder="Заголовок"></p>
  42.             <p><textarea name="text" style="max-width: 100%;font-size: 18px;" cols="30" rows="10" placeholder="Текст статьи"></textarea></p>
  43.             <p><input type="submit" name="add_art" class="button"></input></p>
  44.         </form>
  45.     <?}
  46.     else if ( $_GET['fnc'] == 're_art' AND !$_GET['id'] ) {
  47.         $query = mysqli_query($connect, "SELECT * FROM `article` ORDER BY `id` DESC");
  48.         $row = mysqli_num_rows($query);
  49.         if ( !$row ) echo 'статьей не найдено';
  50.         else {
  51.             while ( $art = mysqli_fetch_assoc($query) ) {?>
  52.                 <hr><article>
  53.                     <p>Автор: <?=$art['author']?></p>
  54.                     <span style="float: right;"><a style="color: #000;border-bottom: 1px solid #000;" href="/admin.php?fnc=re_art&id=<?=$art['id']?>">Редактировать</a></span>
  55.                     <p>Заголовок: <?=$art['title']?></p>
  56.                     <p>Текст: <?=$art['text']?></p>
  57.                     <p>Дата опубликования: <?=$art['date']?></p>
  58.                 </article>
  59.             <?}
  60.         }
  61.     }
  62.     else if ( $_GET['fnc'] == 're_art' AND $_GET['id'] ) {?>
  63.     <h1>Редактирование статьи</h1>
  64.         <form action="/admin.php?fnc=re_art&id=<?=$_GET['id']?>" method="post">
  65. <?
  66.     $art = mysqli_fetch_assoc($connect, "SELECT * FROM `articles` WHERE `id` = $_GET[id]");
  67.  
  68.     if ( $_POST['re_art'] ) {
  69.         $art = mysqli_fetch_assoc(mysqli_query($connect, "SELECT * FROM `articles` WHERE  `id` = $_GET[id]"));
  70.         if ( $_POST['remove_art'] ) {
  71.             mysqli_query($connect, "DELETE FROM `articles` WHERE `id` = $_GET[id]");
  72.         }else {
  73. mysqli_query($connect, "UPDATE  `articles` SET  `author` =  '$_POST[author]',`title` =  '$_POST[title]',`text` =  '$_POST[text]' WHERE `id` = $art[id]");
  74.         }//header('location: /');
  75.     }
  76. ?>
  77.             <p><input type="text" class="input" name="author" placeholder="Автор" value="<?=$art['author']?>"></p>
  78.             <p><input type="text" class="input" value="<?=$art['title']?>" name="title" placeholder="Заголовок"></p>
  79.             <p><textarea name="text" style="max-width: 100%;font-size: 18px;" cols="30" rows="10" placeholder="Текст статьи">
  80.                 <?=$art['text']?>
  81.             </textarea></p>
  82.             <p><input type="submit" name="re_art" class="button"></input>
  83.             <span><input name="remove_art" value="remove" type="checkbox">Удалить статью</span></p>
  84.         </form>
  85.     <?}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement