View Full Code Snippet

<?php session_start(); ?>
<?php
   include ("dbcon.php");
?>
<!DOCTYPE html>
<html>
 <head>
  <title></title>
  <link rel="stylesheet" type="text/css" href="css/dsgncnv.css">
  <script type="text/javascript">
    $(document).ready(function() {
	
		$("select[name='ratelist']").change(function() {
			var cost = $("option:selected", this).data('cost');
			var currentRow = $(this).parents('tr'); // get the <tr> that contains the changed <select>
			$("input[name='i-cost']", currentRow).val(cost); // set the value of 'i-cost' in the currentRow only
		});
	
       $('.btnupdt a').click(function(e){
          e.preventDefault(); // prevent the A target from being followed
          var data = new Array(); // prepare some data storage
          $('table#display tr').each(function() {
             var id =  $("td:nth-child(1)", this).text(); 
             var qty = $("select[name='ratelist']", this).val(); 
             var price = $("select[name='ratelist'] :selected", this).data("cost"); 
             data[data.length] = {id: id, qty: qty, price: price}
          });
          $.ajax({
            type: 'POST',
            url: 'data.php',
            data: { records: data }
          })
          .done( function(data) {
            console.log(data);
          })
          .fail( function(jqXHR, textStatus, errorThrown) {
            console.log(textStatus);
          });
       });
    });
  </script>
  </head>
  <body>
   <div class="btns">
     <div class="btnupdt">	<!-- Update all records back to database -->
       <a href="#"><input type="image" src="images/btnupdtcart.jpg" alt="Submit" class="shw_updtbtn" /></a>
     </div>				
   </div>
   <div class="disp_recs">
    <?php
      $var = 'rahul@xys.com';
      $query = "SELECT user_id FROM user_dtls where u_emailid = '{$var}'";
      $retrv = mysqli_query($connection, $query);
      $retrvarr = mysqli_fetch_array($retrv);
      if (!$retrvarr)
      { die("Database Query failed." . mysqli_error($connection)); }
      else {$getid = $retrvarr[0];}

     //get details based on id
     $pickrecs = "SELECT t_ordid, tord_dt FROM utmp_orders where user_id = '{$getid}'";
     $result = mysqli_query($connection, $pickrecs); 
	?>
    <table id='display'>
       <thead>
           <tr>
              <th>Creation&nbsp;Date</th>
              <th>Labels</th>
              <th>Total&nbsp;Price (&nbsp;&pound;&nbsp;)</th>
           </tr>
	   </thead>
        <?php while($resultarr = mysqli_fetch_assoc($result)){ ?>
            <tbody>
              <tr>
                <td style="display:none;"><?php echo $resultarr["t_ordid"] ?></td>
                <td><?php echo $resultarr["t_ordid"] ?></td>
                <td><?php
                  $pickrecs = "SELECT rt_qty, rt_cost FROM rate_mast order by rt_qty";
                  $rtlist = mysqli_query($connection, $pickrecs); 
                  echo "<select name='ratelist' value='' class='rdd'>";
                  while($rtlistarr = mysqli_fetch_assoc($rtlist)){ 
                    echo "<option value = $rtlistarr[rt_qty] data-cost='" . $rtlistarr[rt_cost] . "'>$rtlistarr[rt_qty]</option>";
                  }
                  echo "</select>";
                ?></td>
                <td><input type="text" name="i-cost" value="5.95" readonly class="icost"></td>
                <td><a href="#" class="delete" style="color:#FF0000;"><img src="images\cartidel.jpg" alt="" style="width:24px; height:24px"</a></td>					
			  </tr>
			</tbody>
		<?php } ?>
	</table>
	<?php 
		mysqli_free_result($retrv);
		mysqli_free_result($result);
	?>
   </div>
  </body>
</html>
<?php
	mysqli_close($connection);
?>