Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- $conn = mysqli_connect( 'localhost', 'root', '', 'register_bd') or die("Невозможно установить соединение: ".mysqli_error());
- $sql = "SELECT *FROM users";
- $q = mysqli_query($conn, $sql);
- $n = mysqli_num_rows($q);
- for ($i=0; $i <= $n; $i++) {
- $save_serring[$i] = (int)$user['id'];
- }
- if(isset($_POST["send"])){
- $save_serring = "Настройки сохранены";
- //$sql = "UPDATE users SET status = '0' WHERE id != '1'";
- $result = mysqli_query($conn, $sql);
- }
- mysqli_close($conn);
- ?>
- // Тут происходит вывод
- <form action="" method="post">
- <center><h2><?=$save_serring?></h2></center><br>
- <?php
- echo "<table border=1>";
- echo "<tr><th colspan=6 align=center>Содержимое таблицы Users";
- echo "<tr><th align=center>№ <th align=center> Логин <th align=center> Имя <th align=center> Email
- <th align=center> Пароль <th align=center> Status<br>(0-обыч.поль. <br>1-адм. по инф.<br>2-гл. адм.)";
- while($row = mysqli_fetch_assoc($q))
- {
- echo "<tr> <td>" . $row['id'];
- echo "<td>" . $row['login'];
- echo "<td>" . $row['name'];
- echo "<td>" . $row['email'];
- echo "<td>" . $row['pass'];
- echo "<td>";
- ?>
- <input type="number"min="0" max="2" id="status" name="status" placeholder="0" value="<?=$row['status'] ?>" />
- <?php
- }
- echo "</table>";
- ?>
- <input type="submit" id="send" name="send" value="Сохранить">
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement