PHP display all rows from a table in a table only displays Array ( )

Asked Sep 19 '16 at 19:32

Active Sep 19 '16 at 19:32

Viewed 34 times

<?php

    $user = 'mgs_user';
    $password = 'pa55word';
    $db = new PDO('mysql:host=localhost;dbname=portfolio', $user, $password);
    $statement = $db->prepare("SELECT * FROM Player_Team");
    $statement->execute();
    $result = $statement->fetchAll();
    print_r($result);
?>

I am not sure what I am doing wrong here. I only get a result of Array ( )

Any advice will be appreciated.

asked Sep 19 '16 at 19:32

Cindi Liebenberg

3

Your query found no records, so it returned an empty result set. Check `$statement->rowCount()`. it'll probably be `0`. – Marc B Sep 19 '16 at 19:34
run this directly `"SELECT * FROM Player_Team"` on your db table and check anything coming or not? – Alive to die - Anant Sep 19 '16 at 19:35
I ran the "SELECT * FROM Player_Team" and It returned all 8 results. – Cindi Liebenberg Sep 19 '16 at 19:39
setAttribute(PDO::ATTR_EMULATE_PREPARES,false); $statement = $db->prepare("SELECT * FROM Player_Team"); if (!$stmt) { echo "\nPDO::errorInfo():\n"; print_r($dbh->errorInfo()); } $statement->execute(); $result = $statement->fetchAll(); print_r($result); ?> – Alive to die - Anant Sep 19 '16 at 19:43
http://stackoverflow.com/questions/8776344/how-to-view-query-error-in-pdo-php – Alive to die - Anant Sep 19 '16 at 19:44
I made a idiot rookie mistake, must be tired. I never imported the .sql file into myphpadmin. Thanks guys! – Cindi Liebenberg Sep 20 '16 at 17:09

PHP display all rows from a table in a table only displays Array ( )

0 Answers0