When Fetching Data from Database Returning Empty Array

Question

My Question Is About Fetching Data From Database But Displaying Empty Array. I Connected DB by PDO and else you can see in code. Suggestions In Code it will great Help.

try{
  $tododb = new PDO('mysql:host = localhost;dbname = mytodo;charset=utf8','root','');  //Connect to the db
  $statement = $tododb->prepare('select * from todos');
  $statement->execute();
  var_dump($statement->fetchAll(PDO::FETCH_OBJ));
}
catch(PDOException $e){
  echo 'Exception -> ';
  var_dump($e->getMessage());
  die();
}

As told there is nothing wrong with your code, but the table is empty. — halojoy, Dec 22 '17 at 10:25
Can you verify that your table actually contains data? The code seems fine to me. — MechMK1, Dec 22 '17 at 10:53

score 1 · Answer 1 · answered Dec 22 '17 at 10:31

1

Not sure what else may be failing, but in your connect, you need to remove the spaces around the '='

  $tododb = new PDO('mysql:host=localhost;dbname=mytodo;charset=utf8','root','');  //Connect to the db

answered Dec 22 '17 at 10:31

Nigel Ren

56,122
11
43
55

Your Common Sense · Accepted Answer · 2017-12-22T10:35:27.880

0

In general, PDOStatement:fetchAll() returns an empty array in case your query returned no data.

It means that todos table is empty.

However, in your case it's both your inaccuracy with PDO credentials and insufficient error reporting. You didn't tell PDO to throw an exception in case of a database error.

As of parameters, you should never ever "decorate" them adding spaces or other unnecessary stuff.

And as of error reporting, always put PDO in Exceptuion mode so it could give you a clue.

$options = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,
    PDO::ATTR_EMULATE_PREPARES   => false,
];

$tododb = new PDO('mysql:host=localhost;dbname=mytodo;charset=utf8','root','', $options);
$statement = $tododb->prepare('select * from todos');
$statement->execute();
var_dump($statement->fetchAll());

edited Dec 22 '17 at 10:35

answered Dec 22 '17 at 10:22

Your Common Sense

156,878
40
214
345

todos table is not empty :/ – Munaf Hajir Dec 22 '17 at 10:28
Thanks Bro It Work – Munaf Hajir Dec 22 '17 at 10:40
If I read [this question](https://stackoverflow.com/q/47989346/4932070) right, which you closed as duplicate, it is asking about inserting into database, not fetching. The question you linked to is about fetching. – A J Dec 27 '17 at 10:16

When Fetching Data from Database Returning Empty Array

2 Answers2