PHP List Users from SQL Database in Table

Question

Hi so im trying to put all of the useres in a database, table into a html table this is what i have:

<table class="table table-striped">
    <thead>
        <tr>
            <th>UUID</th>
            <th>Full Name</th>
            <th>Email</th>
            <th>Access Key</th>
            <th>Phone Number</th>
            <th>Activated</th>
            <th>Role</th>
        </tr>
    </thead>
    <tbody>

        <?php
        include_once('inc/conf/databaseConnect.php');
        $query = mysql_query("SELECT * FROM list_users ORDER by id");
        while($row = mysql_fetch_array($query)){
            echo "<tr>";
            echo "<td>".$row['uuid']."</td>";
            echo "<td>".$row['firstname'].$rowtwo['lastname']."</td>";
            echo "<td>".$row['email']."</td>";
            echo "<td>".$row['security_key']."</td>";
            echo "<td>".$row['phone_no']."</td>";
            echo "<td>".$row['activated']."</td>";
            echo "<td>".$row['role']."</td>";
            echo "</tr>";
        }
        ?>

    </tbody>
</table>

This dosnt return anything, or any errors. It connects to the database correctly ive checked that its just not retrieving the users.

Image of database structure

databaseConnect.php:

    <?php

//Create Connnection
$sqlLink = mysqli_connect('localhost', 'root', 'classified', 'user_details');

//If Error Connecting
if(!$sqlLink) {
    die('<center><br><h3>Error connecting to servers Database.');
}

?>

You don't actually check for errors. That may be why you don't see them. — John Conde
– John Conde, Commented Oct 25, 2015 at 15:29
Does that query work on the db directly? Maybe the order by is incorrect and it should be order by uuid? — chris85
– chris85, Commented Oct 25, 2015 at 15:31
databaseConnect.php is what we'd like to know is in there. mysql_? mysqli_? PDO? — Funk Forty Niner
– Funk Forty Niner, Commented Oct 25, 2015 at 15:35
Wow @Fred-ii- nice detecting. Josh, you need to use mysqli functions with a mysqli connection. mysql_ functions are for a different, outdated/insecure, driver. — chris85
– chris85, Commented Oct 25, 2015 at 15:42

Community · Accepted Answer · 2017-05-23 11:44:33Z

2

After seeing your edit because you did not originally show us which connection method you were using; the almighty answer here (least the most important one) is that you can't mix different MySQL APIs.

Can I mix MySQL APIs in PHP?

You need to use the same one from connection to query.

Plus that $rowtwo should be $row as I stated in comments along with my asking about what was inside your databaseConnect.php file.

Get to work with prepared statements also to help protect against an SQL injection.

https://en.wikipedia.org/wiki/Prepared_statement

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Oct 25, 2015 at 15:45

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Funk Forty Niner · Accepted Answer · 2015-10-25 15:51:19Z

1

Thanks. I have fixed the issue i updated to using mysqli's methods

<?php
include_once('inc/conf/databaseConnect.php');
$query = $sqlLink->query("SELECT * FROM list_users ORDER by id");
while($row = $query->fetch_array()){
    echo "<tr>";
    echo "<td>".$row['uuid']."</td>";
    echo "<td>".$row['firstname'].$row['lastname']."</td>";
    echo "<td>".$row['email']."</td>";
    echo "<td>".$row['security_key']."</td>";
    echo "<td>".$row['phone_no']."</td>";
    echo "<td>".$row['activated']."</td>";
    echo "<td>".$row['role']."</td>";
    echo "</tr>";
}
?>

edited Oct 25, 2015 at 15:51

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Oct 25, 2015 at 15:47

Joosh

1361 gold badge1 silver badge9 bronze badges

Comments

Alex · Accepted Answer · 2015-10-25 15:35:19Z

0

At least check for errors:

if ($query = mysql_query("SELECT * FROM list_users ORDER by id");) {
  ...
} else {
  echo '<b>MySQL error:</b><br>' . mysql_error() . '<br />';
}

answered Oct 25, 2015 at 15:35

Alex

17.3k1 gold badge31 silver badges52 bronze badges

1 Comment

Joosh Over a year ago

Its not using the databaseConnect.php file because access denied.

chris85 · Accepted Answer · 2015-10-25 15:45:48Z

0

You must use mysql_fetch_assoc() instead of mysql_fetch_array or fetch like this mysql_fetch_array($result, MYSQL_ASSOC).

edited Oct 25, 2015 at 15:45

chris85

23.9k7 gold badges37 silver badges51 bronze badges

answered Oct 25, 2015 at 15:37

Nuriddin Rashidov

9647 silver badges26 bronze badges

2 Comments

chris85 Over a year ago

Why can't OP use mysql_fetch_array? This mysql_fetch_array($query) seems valid to me although gives back named and numerical references.

Nuriddin Rashidov Over a year ago

yeah off course it's return both type but, sometime it's changed pointer in array.

Collectives™ on Stack Overflow

PHP List Users from SQL Database in Table

4 Answers 4

Comments

Comments

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related