PHP SCRIPT RETURNING JSON NOT WORKING

Pravesh Singh

Total Post:101

Points:709
Posted by  Pravesh Singh
PHP 
PHP
 1409  View(s)
Ratings:
Rate this:
Hi Guys

The below returns "\nQuery was empty" as I run it simply from my server with the URL in the Browser.

This is the PHP code:

    <?

$databasehost = "server";
$databasename = "xxxx";
$databaseusername ="xxxx";
$databasepassword = "xxxx";
$query = "SELECT * FROM  `Tailor`LIMIT 0 , 30";
$con = mysql_connect($databasehost,$databaseusername,$databasepassword) or die(mysql_error());
mysql_select_db($databasename) or die(mysql_error());
$query = file_get_contents("php://input"); 
$sth = mysql_query($query);

if (mysql_errno()) { 
    header("HTTP/1.1 500 Internal Server Error");
    echo $query.'\n';
    echo mysql_error(); 
}
else
{
    $rows = array();
    while($r = mysql_fetch_assoc($sth)) {
        $rows[] = $r;
    }
    print json_encode($rows);
}

?>

Thanks 
  1. AVADHESH PATEL

    Post:604

    Points:4228
    Re: PHP script returning JSON not working

    Hi Pravesh!

    There is no need to use file_get_content and you have to put one white space after table name.

    <?php

    $databasehost = "server";
    $databasename = "xxxx";
    $databaseusername ="xxxx";
    $databasepassword = "xxxx";
    $query = "SELECT * FROM  `Tailor` LIMIT 0 , 30";
    $con = mysql_connect($databasehost,$databaseusername,$databasepassword) or die(mysql_error());
     mysql_select_db($databasename) or die(mysql_error());

    $sth = mysql_query($query);

    if (mysql_errno()) {
    header("HTTP/1.1 500 Internal Server Error");
    echo $query.'\n';
    echo mysql_error();
    }
    else
    {
    $rows = array();
    while($r = mysql_fetch_assoc($sth)) {
        $rows[] = $r;
    }
    print json_encode($rows);
    }
    ?>

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!