How to design a data that was retrieved by Ajax Jquery?

Question

0.00/5 (No votes)

See more:

Hey guys,

I was able to pull this result from ajax in json format and print it on an html

JavaScript

[{"id":"207","Title":"Test","GenreName":"Action","EntryDate":"2014-05-06 19:13:14"}]

Now I cant figure out how to diplay this data in a table, with each columns for Id, Title, GenreName and EntryData. I cant find sample codes from google either. Or at least I cant comprehend what I saw there,.

Also if you'll notice the result have [] on it, on other examples I dont see Json format having that kind of style, I dont know where it came from since my controller only did echo the data from the model.

AJAX

JavaScript

$('form.ajaxForm').on('submit',function() {
                $.ajax({
                        type: 'POST',
                        url: 'http://localhost/AnimeInventory/index.php/maincontroller/testForAjax',
                        data:{ search: $("#searchInput").val(), searchType: $("#searchTypeID").val() },
                        dataType: 'JSON',
                        success: function(smg) {
                        }
                });
        });
        return false;

CodeIgniterController

PHP

public function testForAjax(){
        echo json_encode($this->inventoryModel->search()); 
        }

Thanks,

Posted 9-May-14 20:18pm

KatsuneShinsengumi

Updated 9-May-14 20:38pm

v2

Add a Solution

Comments

DamithSL 10-May-14 2:35am

update the question with how you do the ajax call and where you get this json value

KatsuneShinsengumi 10-May-14 2:38am

I have the code block listed now.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Accepted Answer · 2014-05-09T20:39:00

Solution 1

[] means ARRAY in json, you have array of objects in your json result. But array contains only one item.
few links for display json array in table

http://stackoverflow.com/questions/1051061/convert-json-array-to-an-html-table-in-jquery[^]
http://stackoverflow.com/questions/17066636/jquery-parsing-json-objects-for-html-table[^]

hope this helps you. :)

Posted 9-May-14 20:39pm

DamithSL

Updated 9-May-14 20:43pm

v2

Comments

KatsuneShinsengumi 10-May-14 2:42am

Oh yeah, because in my model I return result_array. So that's why. Thanks,

DamithSL 10-May-14 2:44am

Ok, i have added few links for you. you will find how to display json results in a table.

KatsuneShinsengumi 10-May-14 15:15pm

Hi, I think this is useful if the table is going to be created for the data. I forgot to say that, there's already an existing table with values from database. What I need is to replace table's data.