PHP json_encode displaying null

Question

I am running an SQL Query in PHP and putting the values into a JS variable:

<?php
$return_arr = array();
$sql="SELECT * from customer_billing group by productname ";
$rs=mysql_query($sql,$conn) or die(mysql_error());
while($result=mysql_fetch_array($rs)) {
    $return_arr[] =  $result["productname"];
}
echo json_encode($return_arr);
?>
<script type="text/javascript">
$(function() {
    var availableTags = <?php echo json_encode($return_arr); ?>
    //autocomplete
    $(".auto").autocomplete({
        source: availableTags
    });             
});
</script>

I have 3 rows with the column productname equal to:

Integra Fibre Unlimited
Integra Fibre Unlimited (RRP: £59.95)
Integra Professional Web Hosting

and when i use echo json_encode($return_arr);, it displays like:

"Integra Fibre Unlimited",null,"Integra Professional Web Hosting"

it just doesn't like displaying the second one

I think you mean ["Integra Fibre Unlimited",null,"Integra Professional Web Hosting"]. — Halcyon
– Halcyon, Commented Apr 24, 2014 at 22:50
SELECT * FROM customer_billing WHERE productname IS NOT NULL GROUP BY productname;? — Sam
– Sam, Commented Apr 24, 2014 at 22:51
@SharikovVladislav it shows - "Integra Fibre Unlimited" [91]=> string(37) "Integra Fibre Unlimited (RRP: £59.95)" [92]=> string(32) "Integra Professional Web Hosting" — user3179854
– user3179854, Commented Apr 24, 2014 at 22:52

Sharikov Vladislav · Accepted Answer · 2014-04-24 22:56:38Z

1

Try:

// some code
while($result=mysql_fetch_array($rs)) {
    $return_arr[] =  utf8_encode($result["productname"]);
}
echo utf8_decode(json_encode($response));

answered Apr 24, 2014 at 22:56

Sharikov Vladislav

7,2999 gold badges53 silver badges92 bronze badges

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

1 Comment

Sharikov Vladislav Over a year ago

Wow. Rly? :D Need explanation?

Collectives™ on Stack Overflow

PHP json_encode displaying null

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related