Форумы портала PHP.SU

CODE (htmlphp):
скопировать код в буфер обмена
<form action="" method="post">
  <table class="table table-bordered table-hover table-striped" style="table-layout: fixed">
      <thead>
 
      <tr>
 
          <th>User Id</th>
          <th>User Name</th>
          <th>User E-mail</th>
          <th>User Pass</th>
          <th>Delete User</th>
      </tr>
      </thead>
 
      <?php
      include("database/db_conection.php");
      $view_users_query="select * from users";//select query for viewing users.
      $run=mysqli_query($dbcon,$view_users_query);//here run the sql query.
 
      while($row=mysqli_fetch_array($run))//while look to fetch the result and store in a array $row.
      {
          $user_id=$row[0];
          $user_name=$row[1];
          $user_pass=$row[2];
          $user_email=$row[3];
      ?>      
      <tr>
 
          <td><input type="text" name="user_id" value="<?php echo $user_id; ?>"></td>
          <td><input type="text" name="user_name" value="<?php echo $user_name; ?>"></td>
          <td><input type="text" name="user_email" value="<?php echo $user_email; ?>"></td>
          <td><input type="text" name="user_pass" value="<?php echo $user_pass; ?>"></td>
          <td><a href="delete.php?del=<?php echo $user_id ?>"><button class="btn btn- danger">Delete</button></a></td> <!--btn btn-danger is a bootstrap button to show danger-->
          <td><button type="submit" name="update" class="btn">Update</button></td>
      </tr>
 
      <?php } ?>
 
  </table>
</form>
 
<?
  if (isset($_POST['update']) {
    $user_id = mysql_real_escape_string($_POST['user_id']);
    $user_name = mysql_real_escape_string($_POST['user_name']);
    $user_email = mysql_real_escape_string($_POST['user_email']);
    $user_pass = mysql_real_escape_string($_POST['user_pass']);
    $update_query = "UPDATE `users` SET     `user_id`='$user_id',`user_name`='$user_name',`user_email`='$user_email'
           ,`user_pass`='$user_pass' WHERE `id`='$user_id'";
     $run=mysqli_query($dbcon,$update_query);
  }
?>