Android connecting to MySQL json_encode

Question

I am trying to get data from MySQL database but in the php file I get this error:

Fatal error: Call to undefined function: json_encode() in /homez.100/pizzapar/www/clic/marwa/test/base.php on line 13

Here is my php file:

<?php     
echo"welcom <br>"; 
$conn =  mysql_connect('xxx.xxx.xxx.xxx','xxx','xxx');

if ($conn) {

    mysql_select_db('zak', $conn);


    $sql=mysql_query("select * from zak_user");
  while($row=mysql_fetch_assoc($sql))
  $output[]=$row;
  print(json_encode($output));
  mysql_close();

    }
else 
{
echo"erreur connexion";
}

Can some one help?

Pekka · Accepted Answer · 2011-12-24 11:20:34Z

2

According to the manual, json_encode() is available in PHP >= 5.2.0 only. You are probably running an older version.

answered Dec 24, 2011 at 11:20

Pekka

451k150 gold badges990 silver badges1.1k bronze badges

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

2 Comments

Pekka Over a year ago

@manita no problem. If at all possible, upgrading to PHP 5.2 would be the best way to go

manita marwa Over a year ago

i did thanks and it works but in the emulator it show me an error JSONObject must begin with '{' or my result in the php is an array [{..},... {..}] any help about that?

Derk Arts · Accepted Answer · 2011-12-24 11:26:44Z

1

See here: http://www.boutell.com/scripts/jsonwrapper.html

This is a replacement for JSON in earlier PHP versions.

Usage:

require 'jsonwrapper.php';

At the top of your code and you're ready to go. Of course, jsonwrapper.php must be in the same folder. If not, adjust the require command.

json_encode example

Just to give you a sense of the possibilities:

$data = array(
array('name' => 'Jane', 'age' => 35),
array('name' => 'Steve', 'age' => 37)
);
<script>
var data = <?php echo json_encode($data) ?>;
</script>

And this is the direct download: http://www.boutell.com/scripts/jsonwrapper.tar.gz

answered Dec 24, 2011 at 11:26

Derk Arts

3,4702 gold badges21 silver badges36 bronze badges

Comments

RageZ · Accepted Answer · 2011-12-24 11:21:43Z

0

json_encode used to be not part of PHP, you might have to compile an extension to enable this function.

It's been awhile that json_encode is shipped with PHP(since 5.2), I advise you to upgrade.

answered Dec 24, 2011 at 11:21

RageZ

27.3k12 gold badges72 silver badges76 bronze badges

Collectives™ on Stack Overflow

Android connecting to MySQL json_encode

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related