PDO FetchAll from mysql echo data in table

Question

Working on a Highscore system in PHP. To get data from MySQL database I use this code.

<?php
$sql_query = "SELECT id,name, exp FROM user ORDER by exp DESC";
try {
    $conn = new PDO('mysql:host=localhost;dbname=game', 'root', 'pass');
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $rst = $conn->query($sql_query);
    $users= $rst->fetchAll(PDO::FETCH_OBJ);
    echo '' . json_encode($users) . '';
}
catch(PDOException $e) {
    echo '{"error":{"text":'. $e->getMessage() .'}}';
}
?>

Output from that code looks like:

[{"id":"1","name":"Player","exp":"22060"}

I need to echo that data in tags separately. For example.

<td><?php echo $users->name ?></td>
<td><?php echo $users->exp ?></td>

side-note: I'm under the impression you guys picked the wrong "original" question in the duplicate vote ;-) — VolkerK, Jul 17 '15 at 17:29
@Volkerk Looking again at their code, your comment makes a good point :) I just retracted my vote — Hanky Panky, Jul 17 '15 at 17:36

score 0 · Answer 1 · answered Jul 17 '15 at 17:26

0

This should do the trick:

<?php
$sql_query = "SELECT id,name, exp FROM user ORDER by exp DESC";
try {
    $conn = new PDO('mysql:host=localhost;dbname=game', 'root', 'pass');
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $rst = $conn->query($sql_query);
    $users= $rst->fetchAll(PDO::FETCH_OBJ);

    foreach($users as $user) {
        echo "<td>{$user->name}</td>";
        echo "<td>{$user->exp}</td>";
    }
}
catch(PDOException $e) {
    echo '{"error":{"text":'. $e->getMessage() .'}}';
}
?>

answered Jul 17 '15 at 17:26

Jim Wright

5,905
1
15
34

1

Why does putting the loop in the `try` make this work? – Jay Blanchard Jul 17 '15 at 17:42
Works like a charm. Thank you. – Martin Bariak Jul 17 '15 at 18:02
@JayBlanchard It doesn't make it work, it just lets you catch the exception before php stops running! Check this link out: http://www.w3schools.com/php/php_exception.asp – Jim Wright Jul 20 '15 at 08:16
You can actually catch the exceptions and handle them gracefully without putting your display code in the `try`. – Jay Blanchard Jul 20 '15 at 11:23

PDO FetchAll from mysql echo data in table

1 Answers1