Hi tim,
you have to use qx.util.Mime.JSON instead of text/plain.
Example:
var r = new qx.io.remote.Request(“test.php”, "GET", qx.util.Mime.JSON);
Tobias
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Wieringa
Timotheus
Gesendet: Dienstag, 5. Februar 2008 15:40
An: qooxdoo-devel@lists.sourceforge.net
Betreff: [qooxdoo-devel] JSON and mysql
Hello i'm just building my first qooxdoo application. I try to get some data
out of a mysql database and display it in a list.
I figured out how to connect to the database and get my data.
But somehow the format of the data that i get back is wrong.
I always get this error:
Error: Could not parse JSON string!
This is my qooxdoo code:
buttonsend.addEventListener("execute", function(e)
{
if (textfield1.getValue() == "") {
alert('Es muss etwas eingegeben werden.');
} else {
var req = new qx.io.remote.Request(
"http://localhost/qooxdoo-0.7.3-skeleton/skeleton/source/db_anfrage.php";,
"GET",
"text/plain");
req.addEventListener("completed", function(e) {
try
{
var content = e.getContent();
alert(content);
if (content.length > 0)
{
var tabledata =
qx.io.Json.parse(content);
tableModel.setData(tabledata);
}
}
catch (ex)
{
alert("Fehler bei Erhalt der
Tabellendaten: " + ex.toString());
}
});
req.send();
}
And this is the php-code:
$sql = "select REPNR, KID, FEHLER, EINH from reparatur WHERE RID='1'";
$result = mysql_query("$sql");
$daten = array();
while ($row = mysql_fetch_assoc($result))
{
$repnr=$row["REPNR"];
$kid=$row["KID"];
$fehler=$row["FEHLER"];
$einh=$row["EINH"];
$daten []= $repnr;
$daten []= $kid;
$daten []= $fehler;
$daten []= $einh;
}
echo json_encode($daten);
The "alert(content)" gives me ["blabla","bla","dved","dwq"] back.
Thanks in advance
Tim
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
qooxdoo-devel mailing list
qooxdoo-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
