Multidimensional Array to table using jQuery

Question

I have a multidimensional array generated using PHP as below:

$result = array(
        array(
            'bookID' => '1',
            'bookName' => 'Book1',
            'bookAuthor' => 'Author1',
            'bookISBN' => 'ISBN1',
            'bookStatus' => 'Available'
        ),
        array(
            'bookID' => '2',
            'bookName' => 'Book2',
            'bookAuthor' => 'Author2',
            'bookISBN' => 'ISBN2',
            'bookStatus' => 'On Loan'
        ),
        array(
            'bookID' => '3',
            'bookName' => 'Book3',
            'bookAuthor' => 'Author3',
            'bookISBN' => 'ISBN3',
            'bookStatus' => 'On Loan'
        ),
        array(
            'bookID' => '4',
            'bookName' => 'Book4',
            'bookAuthor' => 'Author4',
            'bookISBN' => 'ISBN4',
            'bookStatus' => 'Available'
        ),
    );
echo json_encode($result);

And I have a HTML file that is using $.getJSON to get that array. What I am now trying to do is create a table using that array, such that it looks something like this:

+---+-------+---------+-------+-----------+
| 1 | Book1 | Author1 | ISBN1 | Available |
+---+-------+---------+-------+-----------+
| 2 | Book2 | Author2 | ISBN2 | On Loan   |
+---+-------+---------+-------+-----------+
| 3 | Book3 | Author3 | ISBN3 | On Loan   |
+---+-------+---------+-------+-----------+
| 4 | Book4 | Author4 | ISBN4 | Available |
+---+-------+---------+-------+-----------+

I have tried using $.each() and foreach() including suggestions from other SO questions but I cannot seem to get it to work at all. Can anyone help?

My jQuery code at the moment:

$(document).ready(function() {
        // var query = $('#query').val();
        $.getJSON('[url of PHP file above]', function(data){
            // Do something to create table
        });
    });

Show us your jQuery code.

MD Sayem Ahmed
– MD Sayem Ahmed

2013-08-19 04:54:21 +00:00
Commented Aug 19, 2013 at 4:54 — MD Sayem Ahmed
– MD Sayem Ahmed, Commented Aug 19, 2013 at 4:54

Salman Arshad · Accepted Answer · 2013-08-19 08:28:47Z

2

First suppose that your array is stored in $books variable.

$books = json_enconde($books);

Then we have received correctly that array.

$.ajax({
 ...
 success: function(data){
    var $table = $('<table />');
    $.each(data, function(i, item){
        var $tr = $('<tr />');
        $tr.appendTo($table);
        $.each(a, function(subitem) {
            $tr.append('<td>'+ subitem + '</td>');
        });
    }
 }
});

Hope it helps!

edited Aug 19, 2013 at 8:28

Salman Arshad

274k85 gold badges450 silver badges540 bronze badges

answered Aug 19, 2013 at 5:00

Jepser Bernardino

1,3701 gold badge12 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multidimensional Array to table using jQuery

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related