Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ....
- <div class="col-md-6">
- <div class="form-group label-floating">
- <form class="form-inline" action="../folder/action.php" method="post">
- <input type="number" class="form-control input-sm" name="days" placeholder="Days" style="width: 70px;" required>
- <input type="text" class="form-control input-sm" name="reason" placeholder="Reason" required>
- <input type="hidden" name="userid" value="'.$id.'">
- <input type="submit" class="btn btn-simple btn-round btn-xs" name="action" value="Do action">
- </form>
- </div>
- </div>
- ....
- <?php
- include_once $_SERVER['DOCUMENT_ROOT'].'/configuration/main.php'; // главные настройки, включающие подключение, с ними все ок
- if ($_SESSION['admin']<3) exit(redirect("../folder/",2)); // проверка сессии, выход при условии
- $mysqli=connect(); // подключение к бд
- $id=$mysqli->real_escape_string($_POST['userid']);
- $days=$mysqli->real_escape_string($_POST['days']);
- $actiontime=time()+(3600*24)*$days;
- $reason=$mysqli->real_escape_string($_POST['reason']);
- // ^ преобразование информации из folder/user.php
- if ($id<1||$days<0) exit(redirect("../folder/",2));
- if ($days>'0')
- $mysqli->query("insert into `action`(`userid`,`actionid`,`reason`,`time`) values ('".$id."','".$_SESSION['id']."','".$reason."','".$actiontime."')");
- else
- $mysqli->query("insert into `action`(`userid`,`actionid`,`reason`,`time`) values ('".$id."','".$_SESSION['id']."','".$reason."','0')");
- // запросы шредингера
- $mysqli->close(); // закрытие подключения к бд
- redirect("../folder/user?id=".$id."",2); // возврат к folder/user.php
- ?>
- $connection->autocommit(false);
- $query = ""; //sql query here
- $result = $connection->query($query);
- if (!$result) die($connection->error);
- if (!$connection->commit()) exit($connection->error);
Add Comment
Please, Sign In to add comment