Vfrdtyky

How can I insert some value from table 2 to table 1. if clicked a Add button I want to get all value of the row that I selected. should i get rowindex from the current row that i selected and get $prod value by rowindex?

<table id="table1">

    <tr>

        <th>Product ID</th>

        <th>Product Name</th>

        <th>Price</th>

        <th>Stock</th>

        <th>Action</th>

    </tr>

    <?php foreach($prod->getAll() as $name):?>

    <tr>

        <td><?php echo $name['prod_id'];?></td>

        <td><?php echo $name['name'];?></td>

        <td><?php echo $name['price'];?></td>

        <td><?php echo $name['stock'];?></td>

        <td><button class="addbtn">Add</button></td>

    </tr>

    <?php endforeach;?>

</table>



<table id="table2">

<tr>

    <th>No</th>

    <th>Product Name</th>

    <th>Price</th>

    <th>Qty</th>

    <th>Total</th>

</tr>

<tr>

    <td>1</td>

    <td>Some Product Name From Table 1</td>

    <td>Some Product Price From Table 1</td>

    <td>Qty is generated from table 1</td>

    <td>Qty * Price</td>

</tr>

</table>





 <?php



 class Product extends DB_Connect

 {



    public function __construct()

    {

     parent::__construct();

    }



function getAll(){

    try

    {

        $sql = "SELECT * FROM product Order By prod_id asc";

        $result = $this->db->query($sql);

        $results = $result->fetchAll(PDO::FETCH_ASSOC);

        return $results;

    }

    catch ( Exception $e )

    {

        die ( $e->getMessage() );

    }

}

}



?>

If you're using jQuery you can use the closest() function:

$('.addbtn').click(function(){

    var row = $(this).closest('tr'),

        cells = row.find('td'),

        prodId = cells.eq(0).html(),

        name = cells.eq(1).html(),

        price = cells.eq(2).html(),

        stock = cells.eq(3).html();

});

Fiddle: http://jsfiddle.net/Afk8a/1/