Getting Null value with JSON from MySQL, how to retrive data from MySQL to JSON correctly?

Question

I'm using following code but cannot return data from MySQL.

This is the output:

<script type="text/javascript"> 
    var somethings= [null,null,null]; 
</script>

It does have three post, but I couldn't get the title(message) output.

EDIT: this is the code I'm using:

<?php

    $session = mysql_connect('localhost','name','pass');     
    mysql_select_db('dbname', $session);    

    $result= mysql_query('SELECT * FROM posts', $session); 
    $somethings= array(); 
    while ($row= mysql_fetch_assoc($result)) { 
        $somethings[]= $row['something']; 
    } 
?> 

<script type="text/javascript"> 
    var somethings= <?php echo json_encode($somethings); ?>; 
</script>

This is the table:

message

Try iPhone post!

Welcome to Yo~ :)

好快！

Sergey Kuznetsov · Accepted Answer · 2010-04-19 17:13:13Z

3

Why did you use $row['something'] in the loop body? You don't need this.

Try such code:

$somethings = array(); 
while ($row = mysql_fetch_assoc($result)) { 
    $somethings[] = $row;
}

answered Apr 19, 2010 at 17:13

Sergey Kuznetsov

8,7214 gold badges27 silver badges22 bronze badges

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

2 Comments

sky Over a year ago

yep, it works out fine, thanks, just one more question, how i get the result as : var somethings= {"Welcome to Yo~ :)"},{"Try iPhone post!"},{"message":"????"}; instead of var somethings= [{"message":"Welcome to Yo~ :)"},{"message":"Try iPhone post!"},{"message":"????"}]; with chinese character support?

Sergey Kuznetsov Over a year ago

json_encode() works with UTF-8 encoded data. Maybe you have problems with MySQL connection, which doesn't work in the UTF-8? Try to put additional query before the "SELECT" query: mysql_query("SET NAMES 'utf8'");

Collectives™ on Stack Overflow

Getting Null value with JSON from MySQL, how to retrive data from MySQL to JSON correctly?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related