Serial Number Database Update

Updating serial Number sequentially

by Soumya Rao

HTML

<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">
<body>
    <form action="update.php" enctype="multipart/form-data" method="POST">
      <fieldset>
        <div class="panel panel-primary">
          <!-- Objectives -->
          <div class="panel-heading">
            <h4>Objectives</h4>
          </div>
          <div class="bs-example">
            <div class="Container">
              <table class="table table-hover small-text" id="tb" border="1px">
                <thead>
                  <tr FONT style="BACKGROUND-COLOR: DarkGrey ">
                    <th colspan="6" style="text-align:Center;">Objectives and Targets </th>
                  </tr>
                  <tr class="tr-header">
                    <th style="text-align:Center;width:6%;">S.No</th>
                    <th>Objectives</th>
                    <th>Measures</th>
                    <th>Targets</th>
                    <th>Time-lines</th>
                    <th style="text-align:Center;width:10%;" rowspan="2">Weightage %</th>
                  </tr>
                </thead>
                <tbody>

                </tbody>
                <tfoot>
                  <th colspan="5">GRAND TOTAL</th>
                  <td>
                    <input type="text" name="GrandTotal" id="table-grand-total" class="table-total form-control" readonly>

JavaScript

function isNumberKey(evt) {
						  var charCode = (evt.which) ? evt.which : event.keyCode
						  if (charCode > 31 && (charCode != 46 && (charCode < 48 || charCode > 57)))
						    return false;
						  return true;
						}
						$(function() {
						  var Corp_Objectives = 0;

						  function studentTemplate(Corp_Objectives) {
						    return '<tr class="Corporate_Objective"><td><input type="text" name="SNo[]" class="form-control" readonly></td><td><b>Corporate Objective</b></td><td colspan="4"><input type="text" name="C_Objectives[]" class="form-control"></td><th><a href="javascript:void(0);" style="font-size:18px;width:33%;" class="add_Corpobjectives"><span class="glyphicon glyphicon-plus"></span></a></th></tr><tr class="Objectives"><td><input type="text" name="SNo1[]" class="form-control" readonly></td><td><input type="text" name="Objectives[]" class="form-control"></td><td><input type="text" name="Measures[]" class="form-control"></td><td><input type="text" name="Achievement[]" class="form-control"></td><td><input type="text" name="Date_Target[]" class="form-control Date_Target"></td><td><input type="number" name="Weightage_Target[]" class="marks student_' + Corp_Objectives + ' form-control" student_ref="student_' + Corp_Objectives + '" onkeypress="return isNumberKey(event)"></td><th><a href="javascript:void(0);" style="font-size:18px;width:33%;" class="add_objectives"><span class="glyphicon glyphicon-plus"></span></a></th></tr><tr class="Sub_Total"><td colspan="5"><b>Sub - Total</b></td><td><input type="text" name="SubTotals[]" class="row-total student_' + Corp_Objectives + ' form-control" readonly></td><td></td></tr>'
						  }

						  function subTemplate(Corp_Objectives) {
						    return '<tr class="Objectives"><td><input type="text" name="SNo1[]" class="form-control" readonly></td><td><input type="text" name="Objectives[]" class="form-control"></td><td><input type="text" name="Measures[]" class="form-control"></td><td><input type="text"...