Databases
StackOverflow2013
Postsdbo
POHow to display data via $.get function using jQuery?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to display data via $.get function using jQuery?
    primarykey
    data
    text
    <p>I am having this issue I have been struggling with for sometime and now I need help: I have the following array </p> <pre><code>array(2) { [0]=&gt; object(stdClass)#4 (4) { ["id"]=&gt; string(1) "1" ["idMake"]=&gt; string(1) "1" ["modelName"]=&gt; string(6) "Legend" ["modelYear"]=&gt; string(4) "1986" } [1]=&gt; object(stdClass)#5 (4) { ["id"]=&gt; string(1) "2" ["idMake"]=&gt; string(1) "1" ["modelName"]=&gt; string(3) "MDX" ["modelYear"]=&gt; string(4) "2000" } } </code></pre> <p>How can I use it the <code>$.get()</code> function via jQuery in order to have something like this: </p> <pre><code>id Model Year 1 Legend 1986 2 MDX 2000 </code></pre> <p>I have already tried the following:</p> <p>a process.php file: </p> <pre><code>&lt;?php require 'DataLayer.class.php'; $dl = new DataLayer(); //get car make models $models = $dl-&gt;getCarModels($id); if(isset($models)){ echo json_encode(json_encode($models)); } else{ echo 'failed'; } ?&gt; </code></pre> <p>the getCarModels function:</p> <pre><code>public function getCarModels($id){ $stmt = $this-&gt;pdo-&gt;prepare("SELECT * FROM model WHERE idMake=? ORDER BY modelName"); $stmt-&gt;execute(array($id)); return $stmt-&gt;fetchAll(PDO::FETCH_OBJ); } </code></pre> <p>Javascript function called upon clicking on some links</p> <pre><code>function getCarModels(id, make){ $.get(process.php, function(data){ var models = $.parseJSON(data); for(var model in models.model.modelName){ // I got stuck here } }); } </code></pre> <p>Hope this makes any sense to someone. Thanks.</p> <p>Just find out some similar issue at this link: <a href="https://stackoverflow.com/questions/7383919/php-multidimensional-array-into-jquery">php multidimensional array into jQuery</a> I am giving a try. </p> <hr> <p>Like I said from the start, my issue is quite similar to the one posted at this link <a href="https://stackoverflow.com/questions/7383919/php-multidimensional-array-into-jquery">php multidimensional array into jQuery</a>. My only question is that I really don't know the reason why they use the json_encode() function twice as all I did to make it work properly is to remove one of the json_encode() functions. </p> <p>Will appreciate some explanation of the reason why I used only jsan_encode() function to get the result I wanted while in most tutorial it has been two time before outputting the data.</p> <p>Thanks again.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USlomse
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to display data via $.get function using jQuery?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIt might help to use firebug to see the contents of `models` as well as the contents of the GET response from the server.
      singulars
      1. POHow to display data via $.get function using jQuery?
      1. USJustin Ethier
    2. COThanks for suggestion: I have the following string: [{"id":"1","idMake":"1","modelName":"Legend","modelYear":"1986"},{"id":"2","idMake":"1","modelName":"MDX","modelYear":"2000"}] not too sure how I can handle this type of string instead of an array
      singulars
      1. POHow to display data via $.get function using jQuery?
      1. USlomse
    3. COoi, oi what's is returned is a json array, you can use Jquey $.each method to loop through it. if you are not sure use firebug debug mode to see what happens as suggested by @justin
      singulars
      1. POHow to display data via $.get function using jQuery?
      1. USblack sensei
 

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