<script>

$(document).ready(function()

{

//$("tr:even").css("background-color","green");

////$("input:even").css("background-color","green");

////$("td:even").css("background-color","green");

//$("tr:odd").css("background-color","red");

$("#save").click(function ()

{

var i=1;

while(i<=29)

{

var val_s=$("#slno_"+i);

var val_a=$("#album_name_"+i);

var val_p=$("#paper_used_"+i);

var val_f=$("#finishing_"+i);

var val_pr=$("#price_"+i);

var val_v=$("#vat_"+i);

var val_t=$("#total_amt_"+i);

var data=val_s;

$("#result").append(data);

$("#result1").append(val_a);

i++;

}

});

});

</script>

<?php

require_once("config.php");

$query_for_result=mysqli_query($con,"SELECT * FROM mytable ORDER BY id ASC");

$num=mysqli_num_rows($query_for_result);

mysqli_close($con);

?>

<table >

<tr>

<td>Sl.No..</td>

    <td  >Item</td>

    <td  >Paper</td>

    <td  >Finish</td>

    <td  >Price</td>

    <td  >Vat</td>

    <td  >Total Amount</td>

   

  </tr>

<?php

$i=0;

while($row = mysqli_fetch_assoc($query_for_result)) 

{

$f1=$row['id'];

$f2=$row['album_name'];

$f3=$row['paper_used'];

$f4=$row['finishing'];

$f5=$row['price'];

$f6=$row['vat'];

$f7=$row['total_amt'];

 

$id=$i+1;

//echo $id;

?>

   <tr>

   <td><input id="<?php echo "slno_".$f1; ?>" name="slno" type="text" value="<?php echo $f1; ?>" style="width:20px;"/></td>

   <td><input id="<?php echo "album_name_".$f1; ?>" name="album_name" value="<?php echo $f2; ?>" type="text" style="width:150px;"/></td>

   <td><input id="<?php echo "paper_used_".$f1; ?>" name="paper_used" type="text" value="<?php echo $f3; ?>" style="width:85px;"/></td>

   <td><input id="<?php echo "finishing_".$f1; ?>" name="finishing"  value="<?php echo $f4; ?>" type="text" style="width:90px;"/></td>

   <td><input id="<?php echo "price_".$f1; ?>"  value="<?php echo $f5; ?>" name="price" type="text" style="width:25px;"/></td>

   <td><input id="<?php echo "vat_".$f1; ?>"  value="<?php echo $f6; ?>" name="vat" type="text" style="width:35px;"/></td>

   <td><input id="<?php echo "total_amt_".$f1; ?>" name="total_amt"  value="<?php echo $f7; ?>" type="text" style="width:50px;"/></td>

       

  </tr>

  <?php

$i++;

}

?>