How To Fetch And Update Query In MySQL - PHP
Tags: php, update, fetch
Published: 2020-11-25 04:47:44

we learn to update query in MySQL. many time need to  Fetch and update the data from the MySQL database in PHP. This example demonstrates to you how you can easily fetch data and update query in SQL server, the data from the MySQL database in PHP.

Here, we will show you a simple and easy way on how to fetch and update query in MySQL database in PHP.

**[How To Fetch And Update Query In MySQL - PHP](https://www.phpcodingstuff.com/blog/how-to-fetch-and-update-query-in-mysql-php.html "How To Fetch And Update Query In MySQL - PHP")**

```
<!DOCTYPE html>
<html lang="en">
   <head>
      <meta charset="utf-8">
      <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
      <title>PHP code to retrieve and update data from MySQL database - phpcodingstuff.com</title>
      <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto|Varela+Round|Open+Sans">
      <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">
      <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
      <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
      <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
      <style type="text/css">
         .bs-example{
         margin: 20px;
         }
      </style>
      <script type="text/javascript">
         $(document).ready(function(){
         $('[data-toggle="tooltip"]').tooltip();   
         });
      </script>
   </head>
   <body>
      <div class="bs-example">
         <div class="container">
          <div class="row">PHP code to retrieve and update data from MySQL database - phpcodingstuff.com</div>
            <div class="row">
               <div class="col-md-12">
                  <div class="page-header clearfix">
                     <h2 class="pull-left">Users List</h2>
                  </div>
                  <?php
                     include_once 'db.php';
                     $result = mysqli_query($conn,"SELECT * FROM users");
                     ?>
                  <?php
                     if (mysqli_num_rows($result) > 0) {
                     ?>
                  <table class='table table-bordered table-striped'>
                     <tr>
                        <td>Name</td>
                        <td>Email id</td>
                        <td>Mobile</td>
                        <td>Action</td>
                     </tr>
                     <?php
                        $i=0;
                        while($row = mysqli_fetch_array($result)) {
                        ?>
                     <tr>
                        <td><?php echo $row["name"]; ?></td>
                        <td><?php echo $row["email"]; ?></td>
                        <td><?php echo $row["mobile"]; ?></td>
                        <td><a href="update-action.php?userid=<?php echo $row["id"]; ?>">Update</a></td>
                     </tr>
                     <?php
                        $i++;
                        }
                        ?>
                  </table>
                  <?php
                     }
                     else{
                     echo "No result found";
                     }
                     ?>
               </div>
            </div>
         </div>
      </div>
   </body>
</html>
```


Read More: [https://www.phpcodingstuff.com/blog/how-to-fetch-and-update-query-in-mysql-php.html](https://www.phpcodingstuff.com/blog/how-to-fetch-and-update-query-in-mysql-php.html "https://www.phpcodingstuff.com/blog/how-to-fetch-and-update-query-in-mysql-php.html")