Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. <?php
  2. session_start();
  3. $conn = mysqli_connect( 'localhost', 'root', '', 'register_bd') or die("Невозможно установить соединение: ".mysqli_error());
  4. $sql = "SELECT *FROM users";
  5. $q = mysqli_query($conn, $sql);
  6. $n = mysqli_num_rows($q);
  7.  
  8. for ($i=0; $i <= $n; $i++) {
  9. $save_serring[$i] = (int)$user['id'];
  10. }
  11.  
  12. if(isset($_POST["send"])){
  13. $save_serring = "Настройки сохранены";
  14. //$sql = "UPDATE users SET status = '0' WHERE id != '1'";
  15. $result = mysqli_query($conn, $sql);
  16. }
  17.  
  18.  
  19.  
  20. mysqli_close($conn);
  21. ?>
  22.  
  23. // Тут происходит вывод
  24. <form action="" method="post">
  25. <center><h2><?=$save_serring?></h2></center><br>
  26. <?php
  27.  
  28. echo "<table border=1>";
  29. echo "<tr><th colspan=6 align=center>Содержимое таблицы Users";
  30. echo "<tr><th align=center>№ <th align=center> Логин <th align=center> Имя <th align=center> Email
  31. <th align=center> Пароль <th align=center> Status<br>(0-обыч.поль. <br>1-адм. по инф.<br>2-гл. адм.)";
  32.  
  33. while($row = mysqli_fetch_assoc($q))
  34. {
  35. echo "<tr> <td>" . $row['id'];
  36. echo "<td>" . $row['login'];
  37. echo "<td>" . $row['name'];
  38. echo "<td>" . $row['email'];
  39. echo "<td>" . $row['pass'];
  40. echo "<td>";
  41. ?>
  42.  
  43. <input type="number"min="0" max="2" id="status" name="status" placeholder="0" value="<?=$row['status'] ?>" />
  44. <?php
  45. }
  46. echo "</table>";
  47. ?>
  48.  
  49. <input type="submit" id="send" name="send" value="Сохранить">
  50. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement