Guest User

Untitled

a guest
Oct 23rd, 2017
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.94 KB | None | 0 0
  1. ....
  2. <div class="col-md-6">
  3. <div class="form-group label-floating">
  4. <form class="form-inline" action="../folder/action.php" method="post">
  5. <input type="number" class="form-control input-sm" name="days" placeholder="Days" style="width: 70px;" required>
  6. <input type="text" class="form-control input-sm" name="reason" placeholder="Reason" required>
  7. <input type="hidden" name="userid" value="'.$id.'">
  8. <input type="submit" class="btn btn-simple btn-round btn-xs" name="action" value="Do action">
  9. </form>
  10. </div>
  11. </div>
  12. ....
  13.  
  14. <?php
  15. include_once $_SERVER['DOCUMENT_ROOT'].'/configuration/main.php'; // главные настройки, включающие подключение, с ними все ок
  16.  
  17. if ($_SESSION['admin']<3) exit(redirect("../folder/",2)); // проверка сессии, выход при условии
  18.  
  19. $mysqli=connect(); // подключение к бд
  20.  
  21. $id=$mysqli->real_escape_string($_POST['userid']);
  22. $days=$mysqli->real_escape_string($_POST['days']);
  23. $actiontime=time()+(3600*24)*$days;
  24. $reason=$mysqli->real_escape_string($_POST['reason']);
  25. // ^ преобразование информации из folder/user.php
  26.  
  27. if ($id<1||$days<0) exit(redirect("../folder/",2));
  28.  
  29. if ($days>'0')
  30. $mysqli->query("insert into `action`(`userid`,`actionid`,`reason`,`time`) values ('".$id."','".$_SESSION['id']."','".$reason."','".$actiontime."')");
  31. else
  32. $mysqli->query("insert into `action`(`userid`,`actionid`,`reason`,`time`) values ('".$id."','".$_SESSION['id']."','".$reason."','0')");
  33. // запросы шредингера
  34.  
  35. $mysqli->close(); // закрытие подключения к бд
  36. redirect("../folder/user?id=".$id."",2); // возврат к folder/user.php
  37. ?>
  38.  
  39. $connection->autocommit(false);
  40. $query = ""; //sql query here
  41. $result = $connection->query($query);
  42. if (!$result) die($connection->error);
  43. if (!$connection->commit()) exit($connection->error);
Add Comment
Please, Sign In to add comment