How to retrieve JSON Array Data in Android site via JSONencoded string pushed by PHP Script?

Question

I have written a PHP script below try to Post the JSON encoded string to Android device as below:

<?php
 // Create HostConnection
 $host = $_SERVER['HTTP_HOST'];  
 if ($host)
 {
    $data = array('HTTP_HOST' => $host);    
 }
 else
 {
    $data = array('HTTP_HOST' => "Not Available");
 }

 // Create Connection
 $link = mysql_connect('127.0.0.1:3306', 'root', 'xxxxxx');
 if ( $link != false )
 {
    //echo "mysql_connect success !";
    // Set Use UTF-8 String
    if (mysql_set_charset('utf8', $link)  && $db_selected = mysql_select_db("gw"))
    {
       // echo "mysql_set_charset() success<br />";       
       array_push($data, "SQL_DB", "gw");           
    } 
 }
 else
 {
   array_push($data, "SQL_DB", "Not Available");
 }       

 print_r(urldecode(json_encode($data)));
?>

Before post to Android device, I run this PHP script on the localhost(127.0.0.1) and got the result shown on the screen as:

{"HTTP_HOST":"127.0.0.1","0":"SQL_DB","1":"gw"}

Why there are 3 sets of data ? what I really want is 2 sets of data shown and prepare send to Android device on nest step. Where I was wrong ? If yes, what's the correct procedures to retrieve the encoded JSON array string on Android side ?

Pekka · Accepted Answer · 2012-03-12 08:56:05Z

2

You are not pushing arrays to the array, but single elements. You can't add an associative array value using the method you show.

Use

 $data["SQL_DB"] = "gw";

instead.

answered Mar 12, 2012 at 8:56

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

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

1 Comment

cmh Over a year ago

Great, Follows Pekka's instruction to modify the PHP script, It's work and meet my expection !

Collectives™ on Stack Overflow

How to retrieve JSON Array Data in Android site via JSONencoded string pushed by PHP Script?

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