PHP Json no consistent

Question

I'm using a PHP page to get some data in my MySQL Database, I was using an xml structure to do that, but since I found JSON a little faster I decided to migrate all my webserver to that.

I use exactly the same code to retrieve data from the database, but the generated JSON can't get all the data; some fields like Description, and others like Nome, sometimes come as a null object. In the database everything is okay, and the XML script is also still running okay.

Here's the PHP script I'm using:

 <?php
    header('Content-type: application/json');

    $banco = "*******";
    $usuario = "*******";
    $senha = "*******";
    $hostname = "localhost";

    $conn = mysql_connect($hostname,$usuario,$senha); mysql_select_db($banco) or die( "Cant Connect MySQL");

    $result = mysql_query("SELECT * FROM users");
    $arrayOfChildren = Array(); 
    $i = 0;
    while($row = mysql_fetch_array($result))
    {
        $Balada = array(
             'Id'=>($row['Id']),
             'Nome'=>($row['Nome']),
             'Endereco'=> ($row['Endereco']),
             'Telefone'=>($row['Telefone']),
             'Description'=>($row['Descricao']),
             'Genero' => ($row['Genero']),
             'Pagamento' => ($row['FormasPagamento']),
             'NomeLista' => ($row['NomeLista'])
        );      
        $arrayOfChildren[] = $Balada;     
        $i++;
    }
    $myJSON = json_encode($arrayOfChildren);
    echo($myJSON);
    ?>

The generated JSON: Link

The XML for comparsion: Link

are you using the portuguese descrição con tilde?

Elzo Valugi
– Elzo Valugi

2012-11-13 14:11:40 +00:00
Commented Nov 13, 2012 at 14:11 — Elzo Valugi
– Elzo Valugi, Commented Nov 13, 2012 at 14:11
No, its a column in my database

darkman
– darkman

2012-11-13 15:04:13 +00:00
Commented Nov 13, 2012 at 15:04 — darkman
– darkman, Commented Nov 13, 2012 at 15:04

Community · Accepted Answer · 2017-05-23 12:04:35Z

1

Translation in the while loop is unnecessary, you can only make mistakes here. Just use mysql_fetch_object($result) in staid of mysql_fetch_array($result) and put the $row in the array.

$arrayOfChildren = Array(); 
while($row = mysql_fetch_object($result)) $arrayOfChildren[] = $row ;
echo json_encode($arrayOfChildren);

Or even better you could use PDO or MSQLi. Here is a MSQLi example:

$mysqli = new mysqli($hostname,$usuario,$senha, $banco);
$result = $mysqli->query("SELECT * FROM users");
$rows = Array(); 
while ($row = $result->fetch_object()) $rows[] = $row;
echo json_encode($rows);

Special chars can be a hassle too.. I think this question can be useful

edited May 23, 2017 at 12:04

CommunityBot

11 silver badge

answered Nov 13, 2012 at 14:07

VDP

6,4104 gold badges33 silver badges54 bronze badges

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

Comments

Elzo Valugi · Accepted Answer · 2012-11-13 14:13:50Z

1

If you using the portuguese "descrição" con tilde and cedille, probably you need to UTF8 encode the name of the key or the results, and probably have a mismatch key error between the column name and the key name. Check the results before exporting them to JSON to see if they include the description or not.

answered Nov 13, 2012 at 14:13

Elzo Valugi

28.1k17 gold badges97 silver badges115 bronze badges

3 Comments

darkman Over a year ago

It's correct, i checked them, and in the xml query i use almost the same code

Elzo Valugi Over a year ago

json_encode will not nullify a column arbitrarily. Does your arrayOfChildren has the description before the json_encode command?

Elzo Valugi Over a year ago

can you var_export the arrayOfChildren?

Collectives™ on Stack Overflow

PHP Json no consistent

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