Databases
StackOverflow2013
Postsdbo
POsending JSON as AJAX reponse. json_encode just not working?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POsending JSON as AJAX reponse. json_encode just not working?
    primarykey
    data
    text
    <p>Ive done some work before with encoding arrays into json objects and sending them, however this I just cannot get json-encode to work...</p> <p>My script for sending out for the ajax response is as follows...</p> <pre><code> function loadCalls(sid) { var xmlhttp; if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 &amp;&amp; xmlhttp.status==200) { innerText = xmlhttp.responseText; aCall = document.createElement('div'); aCall.innerHTML = innerText; document.getElementById("calls").appendChild(aCall); } } xmlhttp.open("POST","loadCalls.php",true); xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded"); xmlhttp.send("fname=&lt;? echo $fname; ?&gt;&amp;lname=&lt;? echo $lname; ?&gt;&amp;email=&lt;? echo $email; ?&gt;&amp;sid=" + sid); } </code></pre> <p>And my php form code is as follows... What it simply does is build an array try to encode it to JSON, and then send it back to my loadCalls function above.</p> <p>//Lets grab the uber long variable...</p> <pre><code>$fname = $_POST['fname']; $lname = $_POST['lname']; $email = $_POST['email']; $sid = $_POST['sid']; //Array for all the tokens to go into... $ourCalls = array(); //Our counter $i = 0; //Build the query $querytokens = "SELECT * FROM lime_tokens_".$sid." WHERE firstname='".$fname."' AND lastname ='".$lname."'"; //execute query $resulttokens = mysql_query($querytokens) or die ("Error in query: $querytokens. ".mysql_error()); // see what rows were returned while($rowtokens = mysql_fetch_row($resulttokens)) { $ourCalls[$i] = $rowtokens[5]; $i++; } echo json_encode($ourCalls); // free result set memory mysql_free_result($resulttokens); // close connection mysql_close($connection); </code></pre> <p>If i just echo our the print_r $ourCalls, i get that text displayed, and my line of thought is that even if i left the code in part one the way i wanted, it would still show on my screen as the string. But i get nothing.</p> <p>Please help :)</p> <p>EDIT</p> <p>The output of the print_r is :</p> <pre><code>Array ( [0] =&gt; b8r5x6w53d6cahw [1] =&gt; p5ugbeg68b4qixy ) 1 Array ( [0] =&gt; 4c85zznh955gjsc [1] =&gt; 2atggeb2hyg9mbj ) 1 Array ( [0] =&gt; z4kihguxfu2npx9 ) 1 </code></pre> <p>What does the 1 at the end mean?</p> <p>EDIT - dropped the echo, 1's are now gone.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGraeme Leighfield
    1. USGraeme Leighfield
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhat is the output of print_r($ourCalls)? Have you checked your php error log? Have you used something like Firebug or Chrome's console to check the precise response from the server?
      singulars
      1. POsending JSON as AJAX reponse. json_encode just not working?
      1. USmegaflop
    2. COprint_r returns the php array and all its contents, perfectly, I can see this as the response in firebug also. However when I change to json_encode... i get nothing. no response at all.
      singulars
      1. POsending JSON as AJAX reponse. json_encode just not working?
      1. USGraeme Leighfield
    3. COAnything in the error log? it would seem then that there's an issue with your array that's preventing it from being encoded as json. Please can you post the *precise* output of `print_r($ourCalls)`?
      singulars
      1. POsending JSON as AJAX reponse. json_encode just not working?
      1. USmegaflop
 

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