php - json_encode not working inside while loop -

-

i have json_encode in php script seems fail jquery side of things if json_encode called inside while loop.

when view result in browser window other page need result in can see work.

for example:

while ($row = mysql_fetch_array($result)) {          $id = $row['id'];     $title = $row['title'];     $content = $row['content'];      $data = array("id" => $id,     "title" => $title,     "success" => true     ); echo json_encode($data); // inside while loop  }

and output in browser is:

{"id":"15","title":"advanced booking examples","success":true} {"id":"14","title":"advanced booking fields","success":true} {"id":"11","title":"add new driver","success":true} {"id":"10","title":"registering driver \/ add new vehicle","success":true} {"id":"8","title":"dispatch controls","success":true} {"id":"7","title":"troubleshooting driver device checklist","success":true} {"id":"6","title":"requirements checklist","success":true}

in jquery response blank if leave echo json_encode($data); outside while loop jquery picks response, 1 record - being last record in loop.

i need jquery pick results loop.

here's js

$.ajax({ // send off prcessing         type: "post",         datatype: 'json',         url: "includes/auto_suggest.php",         data: {             q: inputstring         },         success: function (result) {             if (result.success) {                              var id = result.id;                 var title = result.title;                                     $('#auto_id').append("<input type='text' class='hideid' id='hideid_" + id + "' value='" + id + "'/>");                       $('#auto_title').prepend("<p>" + title + "</p>");             }         }     });

any ideas?

thanks in advance

json needs on 1 array or object. need append each row array, json_encode that.

$data = array(); while ($row = mysql_fetch_array($result)) {          $id = $row['id'];     $title = $row['title'];     $content = $row['content'];      $data[] = array(       "id" => $id,       "title" => $title,       "success" => true     ); } echo json_encode($data);

then in javascript, have array of objects, can loop through.

$.ajax({ // send off prcessing     type: "post",     datatype: 'json',     url: "includes/auto_suggest.php",     data: {         q: inputstring     },     success: function (result) {         $.each(result, function(){           if (this.success) {             var id = this.id;             var title = this.title;             $('#auto_id').append("<input type='text' class='hideid' id='hideid_" + id + "' value='" + id + "'/>");             $('#auto_title').prepend("<p>" + title + "</p>");          }         });     } });

Comments

Post a Comment

Popular posts from this blog

django - How can I change user group without delete record -

-
on website user have 1 group. , user can change group. it's made user.groups.clear() and user.groups.add(new_group) but it's not efficient, because there 2 sql query: delete, insert. how can change group update query? user , group related each other using manytomanyfield . means intersection table exists relating both entities, , if don't specify model map (using through attribute) django creates 1 you. looking @ sources django.contrib.auth.models see that's case. fortunatly, can access intermediary model using through attribute of manager (in case, user.groups.through ). can use regular model. example: >>> alice = user.objects.create_user('alice', 'alice@example.com', 'alicepw') >>> employee = group.objects.create(name='employee') >>> manager = group.objects.create(name='manager') >>> alice.groups.add(employee) >>> alice.groups.all() [<group: employee...
Read more

java - Need to add SOAP security token -

-
i need set custom soap header attribute on jax-ws generated webservice client. case webservice calls must go through proxy server requiring specific token (recieved web request header) present in soap request header. e.g.: 1 carserviceservice service = null; 2 service = new carserviceservice(new url(url), new qname(qname); 3 carserviceendpoint port = service.getcarserviceport(); it seems in line 3 wsdl retrieved , call fails due missing security token. 1 point direction on how done? a detailed example has been mentioned here: creating , deploying jax-ws web service on tomcat 6 this article shows how create , use security token .
Read more

java - EclipseLink JPA Object is not a known entity type -

-
i have strange problem eclipselink , object want persist. have 1 object (keypointlistimpl) stores object keypointimpl in list. persisting keypointimpl objects works great if try persist keypointlistimpl object java.lang.illegalargumentexception says object keypointimpl isn't known entity type. here keypointimpl code: @entity @table(name="keypoints") public class keypointimpl implements keypoint { @id @generatedvalue(strategy = generationtype.identity) private int id; @enumerated(enumtype.string) private detectortype keypointtype; private float x; private float y; private float size; private float angle; private float response; private int octave; private int classid; ... } here keypointlistimpl code: @entity @table(name="keypointlists") public class keypointlistimpl implements keypointlist { @id @generatedvalue(strategy = generationtype.identity) private int id; @onetoone(cascade={ca...
Read more