Error reading Json from PHP into C#

Question

I'm receiving this error when trying to read a JObject in C# from PHP, it is the result of a basic query "SELECT * FROM items"...

Unexpected character encountered while parsing value: S. Path '', line 0, position 0.

PHP

$query = ($_POST["test"]);

if ($result = $mysqli->query($query)
{
    $jsonResult = json_encode($result);
}   

echo $jsonResult;

C#

public JObject GetThat()
{
    HttpWebResponse WebResp = (HttpWebResponse)WebReq.GetResponse();

    Stream Answer = WebResp.GetResponseStream();

    string phpResponse = Answer.ToString();
    JObject myResult = JObject.Parse(phpResponse);

    return myResult;
}

What am I doing wrong? Thanks.

You should probably see the output phpResponse yourself by adding a breakpoint to see if it is really valid JSON — Alvin Wong
– Alvin Wong, Commented Jul 13, 2012 at 14:03
this is the same database, same query topofsteel.com/PHP/test-database.php — topofsteel
– topofsteel, Commented Jul 13, 2012 at 14:08

Karl-Johan Sjögren · Accepted Answer · 2012-07-13 14:07:29Z

2

The problem is that Answer.ToString() won't return the stream contents as a string. Try something like this.

public JObject GetThat()
{
    HttpWebResponse WebResp = (HttpWebResponse)WebReq.GetResponse();

    string phpResponse = string.Empty;
    using(StreamReader rdr = new StreamReader(WebResp.GetResponseStream()))
        phpResponse = rdr.ReadToEnd();
    }

    JObject myResult = JObject.Parse(phpResponse);

    return myResult;
}

answered Jul 13, 2012 at 14:07

Karl-Johan Sjögren

17.8k7 gold badges66 silver badges75 bronze badges

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

Comments

topofsteel · Accepted Answer · 2012-07-15 18:00:50Z

0

It turns out the problem was the array type.

$row = $result->fetch_array(MYSQLI_NUM);

does not work, but

$row = $result->fetch_array(MYSQLI_BOTH);

and

$row = $result->fetch_array(MYSQLI_ASSOC);

do. Does anyone have any idea why? Thanks.

answered Jul 15, 2012 at 18:00

topofsteel

1,2676 gold badges16 silver badges25 bronze badges

Collectives™ on Stack Overflow

Error reading Json from PHP into C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related