query-data-from mysql and php

68

query-data-from mysql and php -

<?php 
                            $sql = "SELECT * FROM `users`";
                            $result = mysqli_query($conn, $sql);
                            // fetch all users
                            $users = mysqli_fetch_all($result, MYSQLI_ASSOC);
                            ?>
                            <!-- A single user -->
                            <?php foreach ($users as $user): ?>
                                <tr>
                                    <td><?php echo $user['id'] ?></td>
                                    <td><?php echo $user['Name'] ?></td>
                                    <td><?php echo $user['Email'] ?></td>
                                    <td> <span id="user_current_status"></span></td>
                                </tr>
                            <?php endforeach; ?>
                            <!-- A single user -->

Comments

Submit
0 Comments