Database consult doesn´t show "int"

Hosting Support
1

I´m doing a consult from database but numbers aren´t displayed. Other types like “varchar” are correctly displayed but “int” or “tinyInt”. Do somebody know why?
while ($row = $resultado->fetch_assoc()) {
echo $row[‘id’] . “
”;
echo $row[‘name’] . “
”;
echo $row[‘surname’] . “
”;
echo $row[‘age’];
}

2

So… what does the above code output and what should it output?

3

The code doesn´t show any error. Just the name and surname, but it doesn´t show the id and the age.
Example:

John
Smith

4

I´m running this same example in xampp and works correctly but here there are some issue that doen´t allow the numbers be showed.
Maybe is the way to insert the type in database. Any advice?
Thanks!

5

@rickra said:
The code doesn´t show any error. Just the name and surname, but it doesn´t show the id and the age.
Example:

John
Smith

What happens if instead of echo $row['id'] you do echo "".$row['id']? Or var_dump($row)? It might just be an unexpected type casting issue with PHP, not database output being suppressed.

6

When I do echo “”.$row[‘id’] the result is the same. It doesn´t show nothing.
But if I try var_dump($row) the result is:
array(2) { [“name”]=> string(4) “John” [“surname”]=> string(5) “Smith” }
So the id and the age aren´t displayed also in this array. But they really exist in database.
Any idea of what is happening?
Thanks again.

7

Oh, I saw the error. It´s totally mine. My consult doesn´t include the id and age and that´s why they didn´t be displayed.
$sql=“SELECT name, surname FROM tabletest”;
Sorry for the inconveniences. It works correctly non