<div id="main-panel"><!--  Start of Main Panel -->



    <div class="ae-widget">
      <table  ><!--  Start of Table -->
          <thead>
          <tr>
          <th><input type="checkbox" name="allbox" /></th>
          <th>Номер</th>
          <th>Код</th>
          <th>Сумма</th>
          <th>Дата заказа</th>
          <th>Проверка</th>
          </tr>
          </thead>
          
      
      
      
<?
$ct = 0;
$tsql = "select id, CONVERT(char(10), buffer.Datetime, 103) + ' ' + CONVERT(char(10), buffer.Datetime, 108) as Datetime, Number, cid, Code, Amount, Checked from buffer";
$stmt = sqlsrv_query($conn, $tsql) or die(DisplayErrors());
//echo $tsql;
while($row = sqlsrv_fetch_array($stmt)){
?>

								<tr>
			<td><input name="checkbox[]" type="checkbox"  value="<? echo $rows['id']; ?>"></td>
			<td style="text-align: center"><?echo iconv('cp1251', 'utf-8', $row['Number']);?></td>
			<td style="text-align: center"><?echo iconv('cp1251', 'utf-8', $row['Code']);?></td>
		    <td style="text-align: center"><?echo iconv('cp1251', 'utf-8', $row['Amount']);?></td>
			<td class="td_date"><?echo str_replace('/', '.', $row['Datetime']);?></td>
			<td style="text-align: center"><?echo iconv('cp1251', 'utf-8', $row['Checked']);?></td>
                                </tr>
<?
$ct++;
}
?>	
		<tbody>
          </tbody>
      </table><!--  End of Table -->
      <input type="submit" name="submit" value="Обновить" class="ui-state-default ui-corner-all button" />

</div>

if (isset($_POST['submit']))
	{
	$tsql .= "UPDATE [buffer] SET [Checked] = '1' WHERE id = '9'";
	sqlsrv_query($conn, $tsql) or die(DisplayErrors());
	}

if (isset($_POST['submit']))
	{
for($i=0;$i<count($_POST["checkbox"]);$i++)  
{  
	$tsql = "UPDATE [buffer] SET [Checked] = '1' WHERE id = '".$_POST["checkbox"][$i]."' ";;
	sqlsrv_query($conn, $tsql) or die(DisplayErrors());
}
}

<form name="frmactive" method="post" action="">
      <table id="pagetable" ><!--  Start of Table -->
	 
          <thead>
          <tr>
          <th><input type="checkbox" name="allbox" /></th>
          <th>Абонент</th>
          <th>Код</th>
          <th>Сумма</th>
          <th>Дата заказа</th>
          <th>Проверка</th>
          </tr>
          </thead>
          
      
      
      
<?
$ct = 0;
$tsql = "select id, CONVERT(char(10), buffer.Datetime, 103) + ' ' + CONVERT(char(10), buffer.Datetime, 108) as Datetime, Number, cid, Code, Amount, Checked from buffer";
$stmt = sqlsrv_query($conn, $tsql) or die(DisplayErrors());
//echo $tsql;
while($row = sqlsrv_fetch_array($stmt)){
?>

								<tr>
			<td><input name="checkbox[]" type="checkbox" value="<? echo $rows['id']; ?>"></td>
			<td style="text-align: center"><?echo iconv('cp1251', 'utf-8', $row['id']);?></td>
			<td style="text-align: center"><?echo iconv('cp1251', 'utf-8', $row['Code']);?></td>
		    <td style="text-align: center"><?echo iconv('cp1251', 'utf-8', $row['Amount']);?></td>
			<td class="td_date"><?echo str_replace('/', '.', $row['Datetime']);?></td>
			<td style="text-align: center"><?echo iconv('cp1251', 'utf-8', $row['Checked']);?></td>
                                </tr>
<?
$ct++;
}
?>	
		<tbody>
          </tbody>
      </table><!--  End of Table -->
      <!--<input type="submit" name="submit" value="Обновить" class="ui-state-default ui-corner-all button" />-->
	  <input name="submit" type="submit" id="submit" value="Delete" class="ui-state-default ui-corner-all button"/>
</form>