CODEWITHSUNDEEP
jquery
Bidyut
Bidyut

Reputation: 541

Get the table cells value row by row with jquery

I have a table like this

<table class="wp-list-table widefat fixed posts">
        <tbody id="c_b">
    <tr>
        <td><b>Title</b></td>
        <td><b>Upcharge</b></td>
        <td><b>Profit Percentage</b></td>
        <td><b>Short Description</b></td>
    </tr>
    <tr>
        <td colspan="4"><input type="checkbox" id="selectall"> Bulk <u>Check/Uncheck</u></td>
    </tr>
    <tr>
        <td id="title_1"><input type="checkbox" id="product_1" value="123123_1" class="case"> 123123<br></td>
        <td id="upcharge_1">24</td>
        <td id="percentage_1">15</td>
        <td id="sdescription_1">This is a short</td>
    </tr>
    <tr>
        <td id="title_2"><input type="checkbox" id="product_2" value="A33232_2" class="case"> A33232<br></td>
        <td id="upcharge_2">24</td>
        <td id="percentage_2">15</td>
        <td id="sdescription_2">This is a short</td>
    </tr>
    <tr>
        <td id="title_22"><input type="checkbox" id="product_3" value="BEY-049_22" class="case"> Plane Shirt<br></td>
        <td id="upcharge_22">24</td>
        <td id="percentage_22">15</td>
        <td id="sdescription_22">SD for Plane shirt</td>
    </tr>
    <tr>
        <td id="title_23"><input type="checkbox" id="product_4" value="IRCTC_23" class="case"> Rail Neer<br></td>
        <td id="upcharge_23">24</td>
        <td id="percentage_23">15</td>
        <td id="sdescription_23">Rail neer short description</td>
    </tr>
    <input type="hidden" value="47474" id="licence_no" name="licence_no"><input type="hidden" value="47474" id="licence_no" name="licence_no">
    <input type="hidden" value="47474" id="licence_no" name="licence_no"><input type="hidden" value="47474" id="licence_no" name="licence_no">      
    </tbody>
    </table>

I want to get the cells value row by row as an array, for this I write the code like below

$("tbody>tr").each(function(){
        var rowvalue = [];
        $("tbody>tr>td").each(function(){
            //alert($(this).text());
            rowvalue.push($(this).text());
        });
        alert(rowvalue);

    });

Here I am geting the all values at a time and it is alerting n times (n= number of row), but I want n number of array with that rows value. How can I get those value.

Upvotes: 6

Views: 14019

Answers (3)

SaminatorM
SaminatorM

Reputation: 630

You can use this,

var rowvalues = [];
            $("tbody > tr").each(function () {
                var rowvalue = [];
                $(this).children().each(function () {
                    //alert($(this).text());
                    rowvalue.push($(this).text());
                });
                rowvalues.push(rowvalue);
            });

here rowvalues array will contain row wise values

Upvotes: 4

iambriansreed
iambriansreed

Reputation: 22241

Demo: http://jsfiddle.net/iambriansreed/2Pgey/

var table_data = [];

$('tr').each(function(){

    var row_data = [];    

    $('td', this).each(function(){

        row_data.push($(this).text());   

    });    

    table_data.push(row_data);

});

console.log(table_data);

Upvotes: 2

Ram
Ram

Reputation: 144659

You should initialize the array outside of scope of each function. In each iteration you are clearing data of previous iterations. You can use map method.

var rowvalue = [];
$("tbody > tr").each(function(i, v) {
    rowvalue[i] = $('td', this).map(function() {
        return $(this).text()
    }).get()
});

console.log(rowvalue);

http://jsfiddle.net/ydZBN/

Upvotes: 1

Related Questions