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
– halojoy, Commented Dec 22, 2017 at 10:25
Can you verify that your table actually contains data? The code seems fine to me. — MechMK1
– MechMK1, Commented Dec 22, 2017 at 10:53

Nigel Ren · Accepted Answer · 2017-12-22 10:31:05Z

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, 2017 at 10:31

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

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

Comments

Your Common Sense · Accepted Answer · 2017-12-22 10:35:27Z

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, 2017 at 10:35

answered Dec 22, 2017 at 10:22

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

3 Comments

Munaf Hajir Over a year ago

todos table is not empty :/

Munaf Hajir Over a year ago

Thanks Bro It Work

A J Over a year ago

If I read this question right, which you closed as duplicate, it is asking about inserting into database, not fetching. The question you linked to is about fetching.

Collectives™ on Stack Overflow

When Fetching Data from Database Returning Empty Array

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related