Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If I have a file test.php with your content like</p> <pre><code> &lt;?php $data = array('items'=&gt;array('serverip'=&gt;'localhost', 'game'=&gt;'cs','protocol'=&gt;'48')); echo $data; ?&gt; </code></pre> <p>then</p> <pre><code>$ php -f test.php </code></pre> <p>produces the output:</p> <pre><code>Array </code></pre> <p>I think instead you want to deliver JSON encoded data.</p> <pre><code>&lt;?php $data = array('items'=&gt;array('serverip'=&gt;'localhost', 'game'=&gt;'cs','protocol'=&gt;'48')); echo json_encode($data); ?&gt; </code></pre> <p>The use of json_encode delivers the output:</p> <pre><code>{"items":{"serverip":"localhost","game":"cs","protocol":"48"}} </code></pre> <hr> <p>Your javascript tries to pass an object to jQueries .html function, when you need to make a string out of it first. An easy way to achive this is by using code like</p> <pre><code>&lt;script type='text/javascript'&gt; $(document).ready(function(){ var pprint = function (data){ var print = "{"; $.each(data, function(key, element){ if($.isPlainObject(element)) element = pprint(element); print = print + '&lt;br/&gt;' + key + ': ' + element; }); return print + "}"; }; console.log("test"); $.getJSON("test.php",{}, function(data){ console.log(data); $("#foo").html(pprint(data)); console.log("done."); }); }); &lt;/script&gt; </code></pre> <p>where the pprint function does some simple conversion of plain objects to strings. I got the idea to use $.each from <a href="https://stackoverflow.com/questions/4079274/how-to-get-an-objects-properties-in-javascript-jquery">this Answer</a>, but there are also more advanced approaches like <a href="https://j11y.io/javascript/prettyprint-for-javascript/" rel="nofollow noreferrer">https://j11y.io/javascript/prettyprint-for-javascript/</a>.</p> <hr> <p>To check on problems of $.getJSON you can use $.ajax:</p> <pre><code>$.ajax({ url: "test.php", dataType: 'json', data: {}, success: function(data){ console.log(data); $("#foo").html(pprint(data)); console.log("done."); }), error: function(jqXHR, textStatus, errorThrown){ console.log(textStatus); console.log(errorThrown); } }); </code></pre> <p>which you can find documented at <a href="https://api.jquery.com/jQuery.ajax/" rel="nofollow noreferrer">https://api.jquery.com/jQuery.ajax/</a>. Hopefully this can tell more about the problems you're experiencing.</p>
    singulars
    1. This table or related slice is empty.
    1. POjQuery JSON Response
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJakob Runge
    1. USJakob Runge
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POjQuery JSON Response
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI also get that output, but the JSON GET doesn't post the result $('#result').html(data);
      singulars
      1. PO
      1. USKristjan
    2. COThe problem appears to be that data is an object and that the jQuery .html() reacts to this the same way as to .html(""). You can see a different reaction if you use .html("" + data) which would give you '[object Object]'. You need some way to encode your object into a string if you want to display it.
      singulars
      1. PO
      1. USJakob Runge
    3. COMy console shows "test", not even data & "done"... I've been trying all day to fix this, very frustrating :/
      singulars
      1. PO
      1. USKristjan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload