[Solved] How to make a member list with database?

by


NOTE: Your question is not clear. You have not included any code or query snippet. I will try my best to answer your question.

As per my knowledge I think your users are nothing but the members. Just write a query to pull all the users from the users table and display.

NOTE : I will use mysqli_* function without any escaping please help yourself.

<?php

include_once 'db_connect.php'; /Line to include the database connection file, which had $link as resource */

$membersQuery = mysqli_query($link, "SELECT * FROM users");
$members = array();
if(mysqli_num_rows($membersQuery) > 0){
    while($row = mysqli_fetch_assoc($membersQuery)){
        $members[] = $row; //Get all the members row by row and store in $members array
    }
}
?>

<table>
    <thead>
        <tr>
            <th>Firstname</th>
        </tr>
    </thead>
    <tbody>
        <?
        if(count($members) > 0){
            foreach($members as $member){
            <tr>
                <td><?php echo $member['firstname']; ?></td>
            </tr>
            <?php
            }
        }
        ?>
    </tbody>
</table>

Even while looping in table you can use the following command

<tbody>
    <?
    if(mysqli_num_rows($membersQuery) > 0){
        while($member = mysqli_fetch_assoc($membersQuery)){
        <tr>
            <td><?php echo $member['firstname']; ?></td>
        </tr>
        <?php
        }
    }
    ?>
</tbody>

solved How to make a member list with database?