send json data from php [closed]

Question

I am totally new to Php and i am trying to send json data from php to android.I have the following code in php to read value from data base:

<?php
$con=mysql_connect("localhost","root","");

if(! $con)
{
        die('Connection Failed'.mysql_error());
}

mysql_select_db("registration",$con);
$name="Adam";//$_POST["name"];
$password="charles";//$_POST["password"];
$sql="SELECT * FROM users WHERE name='$name'and password='$password'"; 

$result=mysql_query($sql, $con);
while($row = mysqli_fetch_array($result))     
{
    $details= array(
        'name' => $row['name'],
        'password' => $row['password'],

    );
    array_push($json, $bus);
}

$jsonstring = json_encode($json);
echo $jsonstring;
mysql_close();
?>

I am expecting the output to be something like this:

[{"name":"Adam","age":"25","surname":"charles"}]

If i am not wrong the JSON data. But this gives me error :

mysqli_fetch_array() expects parameter 1 to be mysqli_result, resource given in...

and also

Undefined variable: json in...

can somebody pleease tell me what might be the possible error

Answer 1

Try as this

$result=mysql_query($sql, $con);
$json = array();
while($row = mysql_fetch_array($result))     
 {
    $json[]= array(
       'name' => $row['name'],
     'password' => $row['password']
    );
}

$jsonstring = json_encode($json);
 echo $jsonstring;

And mysql is deprecated, when you can use mysqli or PDO

Answer 2

In addition to the changes suggested by sam and pitchinnate, also consider adding php header to set the content type to json

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

That is if you are using android to request the json information remotely

Answer 3

You are using mysql_query with mysqli_fetch_array. You need to use mysql_fetch_array.

However mysql_* functions shouldn't be used anymore.

Also another error:

array_push($json, $bus); // i believe $bus should be replaced with $details