| Server IP : 134.236.49.22 / Your IP : 216.73.216.114 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/Menu pusdu/year60/showallmonth/ |
Upload File : |
<?php
$ebits = ini_get('error_reporting');
error_reporting($ebits ^ E_NOTICE);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<title>ÃкºãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10</title>
<style type="text/css">
<!--
.style6 {color: #FF0000}
.style7 {color: #FF3333}
-->
</style>
</head>
<body>
<!-- --------------------------------------------- à´×͹·Õè 1 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center">
ãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10<br>
à´×͹ Á¡ÃÒ¤Á 2560 <br>
<span class="style7">˹èǧҹ âÀª¹Ò¡Òà </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusdu60_canteen");
$strSQL = "SELECT * FROM Month_1 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusdu59157.php?Action=Save">
<table width="731" height="184" border="1" align="center">
<tr>
<th width="59" rowspan="2"> <div align="center">ÅӴѺ·Õè</div></th>
<th width="301" rowspan="2"> <div align="center">ÃÒ¡Òà </div></th>
<th width="76" rowspan="2"> <div align="center">˹èǹѺ </div></th>
<th width="108" rowspan="2"> <div align="center">¨Ó¹Ç¹·Õè<br>
µéͧ¡ÒÃàºÔ¡ </div></th>
<th height="48" colspan="4"> <div align="center" class="style6">ªèͧ¹ÕéÊÓËÃѺ<br>
à¨éÒ˹éÒ·ÕèÈÙ¹Âì¤ÍÁ</div></th>
</tr>
<tr>
<th height="26">͹ØÒµÔãËé<br>
àºÔ¡ä´é</th>
<th>¨èÒ¨ÃÔ§</th>
<th>ÃÒ¤ÒµèÍ<br>
˹èÇÂ</th>
<th>ÃÒ¤ÒÃÇÁ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="center">
<input type="hidden" name="hdnSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
<input type="text" name="txtSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
</div></td>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="50" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="7" align="center">ÃÒ¤ÒÃÇÁ Total price </td>
<td align="right"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_1";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left>
<br>
<br>
</left>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ¨ºà´×͹·Õè 1 ----------------------------------------------------------->
<!-- --------------------------------------------- à´×͹·Õè 2 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center">
ãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10<br>
à´×͹ ¡ØÁÀҾѹ¸ì 2560 <br>
<span class="style7">˹èǧҹ âÀª¹Ò¡Òà </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusdu60_canteen");
$strSQL = "SELECT * FROM Month_2 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusdu59257.php?Action=Save">
<table width="731" height="184" border="1" align="center">
<tr>
<th width="59" rowspan="2"> <div align="center">ÅӴѺ·Õè</div></th>
<th width="301" rowspan="2"> <div align="center">ÃÒ¡Òà </div></th>
<th width="76" rowspan="2"> <div align="center">˹èǹѺ </div></th>
<th width="108" rowspan="2"> <div align="center">¨Ó¹Ç¹·Õè<br>
µéͧ¡ÒÃàºÔ¡ </div></th>
<th height="48" colspan="4"> <div align="center" class="style6">ªèͧ¹ÕéÊÓËÃѺ<br>
à¨éÒ˹éÒ·ÕèÈÙ¹Âì¤ÍÁ</div></th>
</tr>
<tr>
<th height="26">͹ØÒµÔãËé<br>
àºÔ¡ä´é</th>
<th>¨èÒ¨ÃÔ§</th>
<th>ÃÒ¤ÒµèÍ<br>
˹èÇÂ</th>
<th>ÃÒ¤ÒÃÇÁ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="center">
<input type="hidden" name="hdnSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
<input type="text" name="txtSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
</div></td>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="50" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="7" align="center">ÃÒ¤ÒÃÇÁ Total price </td>
<td align="right">
<?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_2";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left>
<br>
<br>
</left>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ¨ºà´×͹·Õè 2 ----------------------------------------------------------->
<!-- --------------------------------------------- à´×͹·Õè 3 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center">
ãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10<br>
à´×͹ ÁÕ¹Ò¤Á 2560 <br>
<span class="style7">˹èǧҹ âÀª¹Ò¡Òà </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusdu60_canteen");
$strSQL = "SELECT * FROM Month_3 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusdu59357.php?Action=Save">
<table width="731" height="184" border="1" align="center">
<tr>
<th width="59" rowspan="2"> <div align="center">ÅӴѺ·Õè</div></th>
<th width="301" rowspan="2"> <div align="center">ÃÒ¡Òà </div></th>
<th width="76" rowspan="2"> <div align="center">˹èǹѺ </div></th>
<th width="108" rowspan="2"> <div align="center">¨Ó¹Ç¹·Õè<br>
µéͧ¡ÒÃàºÔ¡ </div></th>
<th height="48" colspan="4"> <div align="center" class="style6">ªèͧ¹ÕéÊÓËÃѺ<br>
à¨éÒ˹éÒ·ÕèÈÙ¹Âì¤ÍÁ</div></th>
</tr>
<tr>
<th height="26">͹ØÒµÔãËé<br>
àºÔ¡ä´é</th>
<th>¨èÒ¨ÃÔ§</th>
<th>ÃÒ¤ÒµèÍ<br>
˹èÇÂ</th>
<th>ÃÒ¤ÒÃÇÁ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="center">
<input type="hidden" name="hdnSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
<input type="text" name="txtSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
</div></td>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="50" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="7" align="center">ÃÒ¤ÒÃÇÁ Total price </td>
<td align="right"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_3";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left>
<br>
<br>
</left>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ¨ºà´×͹·Õè 3 ----------------------------------------------------------->
<!-- --------------------------------------------- à´×͹·Õè 4 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center">
ãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10<br>
à´×͹ àÁÉÒ¹ 2560 <br>
<span class="style7">˹èǧҹ âÀª¹Ò¡Òà </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusdu60_canteen");
$strSQL = "SELECT * FROM Month_4 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusdu59457.php?Action=Save">
<table width="731" height="184" border="1" align="center">
<tr>
<th width="59" rowspan="2"> <div align="center">ÅӴѺ·Õè</div></th>
<th width="301" rowspan="2"> <div align="center">ÃÒ¡Òà </div></th>
<th width="76" rowspan="2"> <div align="center">˹èǹѺ </div></th>
<th width="108" rowspan="2"> <div align="center">¨Ó¹Ç¹·Õè<br>
µéͧ¡ÒÃàºÔ¡ </div></th>
<th height="48" colspan="4"> <div align="center" class="style6">ªèͧ¹ÕéÊÓËÃѺ<br>
à¨éÒ˹éÒ·ÕèÈÙ¹Âì¤ÍÁ</div></th>
</tr>
<tr>
<th height="26">͹ØÒµÔãËé<br>
àºÔ¡ä´é</th>
<th>¨èÒ¨ÃÔ§</th>
<th>ÃÒ¤ÒµèÍ<br>
˹èÇÂ</th>
<th>ÃÒ¤ÒÃÇÁ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="center">
<input type="hidden" name="hdnSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
<input type="text" name="txtSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
</div></td>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="50" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="7" align="center">ÃÒ¤ÒÃÇÁ Total price </td>
<td align="right">
<?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_4";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left>
<br>
<br>
</left>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ¨ºà´×͹·Õè 4 ----------------------------------------------------------->
<!-- --------------------------------------------- à´×͹·Õè 5 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center">
ãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10<br>
à´×͹ ¾ÄÉÀÒ¤Á 2560 <br>
<span class="style7">˹èǧҹ âÀª¹Ò¡Òà </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusdu60_canteen");
$strSQL = "SELECT * FROM Month_5 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusdu59557.php?Action=Save">
<table width="731" height="184" border="1" align="center">
<tr>
<th width="59" rowspan="2"> <div align="center">ÅӴѺ·Õè</div></th>
<th width="301" rowspan="2"> <div align="center">ÃÒ¡Òà </div></th>
<th width="76" rowspan="2"> <div align="center">˹èǹѺ </div></th>
<th width="108" rowspan="2"> <div align="center">¨Ó¹Ç¹·Õè<br>
µéͧ¡ÒÃàºÔ¡ </div></th>
<th height="48" colspan="4"> <div align="center" class="style6">ªèͧ¹ÕéÊÓËÃѺ<br>
à¨éÒ˹éÒ·ÕèÈÙ¹Âì¤ÍÁ</div></th>
</tr>
<tr>
<th height="26">͹ØÒµÔãËé<br>
àºÔ¡ä´é</th>
<th>¨èÒ¨ÃÔ§</th>
<th>ÃÒ¤ÒµèÍ<br>
˹èÇÂ</th>
<th>ÃÒ¤ÒÃÇÁ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="center">
<input type="hidden" name="hdnSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
<input type="text" name="txtSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
</div></td>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="50" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="7" align="center">ÃÒ¤ÒÃÇÁ Total price </td>
<td align="right">
<?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_5";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left>
<br>
<br>
</left>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ¨ºà´×͹·Õè 5 ----------------------------------------------------------->
<!-- --------------------------------------------- à´×͹·Õè 6 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center">
ãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10<br>
à´×͹ ÁԶعÒ¹ 2560 <br>
<span class="style7">˹èǧҹ âÀª¹Ò¡Òà </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusdu60_canteen");
$strSQL = "SELECT * FROM Month_6 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusdu59657.php?Action=Save">
<table width="731" height="184" border="1" align="center">
<tr>
<th width="59" rowspan="2"> <div align="center">ÅӴѺ·Õè</div></th>
<th width="301" rowspan="2"> <div align="center">ÃÒ¡Òà </div></th>
<th width="76" rowspan="2"> <div align="center">˹èǹѺ </div></th>
<th width="108" rowspan="2"> <div align="center">¨Ó¹Ç¹·Õè<br>
µéͧ¡ÒÃàºÔ¡ </div></th>
<th height="48" colspan="4"> <div align="center" class="style6">ªèͧ¹ÕéÊÓËÃѺ<br>
à¨éÒ˹éÒ·ÕèÈÙ¹Âì¤ÍÁ</div></th>
</tr>
<tr>
<th height="26">͹ØÒµÔãËé<br>
àºÔ¡ä´é</th>
<th>¨èÒ¨ÃÔ§</th>
<th>ÃÒ¤ÒµèÍ<br>
˹èÇÂ</th>
<th>ÃÒ¤ÒÃÇÁ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="center">
<input type="hidden" name="hdnSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
<input type="text" name="txtSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
</div></td>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="50" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="7" align="center">ÃÒ¤ÒÃÇÁ Total price </td>
<td align="right"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_6";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left>
<br>
<br>
</left>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ¨ºà´×͹·Õè 6 ----------------------------------------------------------->
<!-- --------------------------------------------- à´×͹·Õè 7 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center">
ãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10<br>
à´×͹ ¡Ã¡®Ò¤Á 2560 <br>
<span class="style7">˹èǧҹ âÀª¹Ò¡Òà </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusdu60_canteen");
$strSQL = "SELECT * FROM Month_7 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusdu59757.php?Action=Save">
<table width="731" height="184" border="1" align="center">
<tr>
<th width="59" rowspan="2"> <div align="center">ÅӴѺ·Õè</div></th>
<th width="301" rowspan="2"> <div align="center">ÃÒ¡Òà </div></th>
<th width="76" rowspan="2"> <div align="center">˹èǹѺ </div></th>
<th width="108" rowspan="2"> <div align="center">¨Ó¹Ç¹·Õè<br>
µéͧ¡ÒÃàºÔ¡ </div></th>
<th height="48" colspan="4"> <div align="center" class="style6">ªèͧ¹ÕéÊÓËÃѺ<br>
à¨éÒ˹éÒ·ÕèÈÙ¹Âì¤ÍÁ</div></th>
</tr>
<tr>
<th height="26">͹ØÒµÔãËé<br>
àºÔ¡ä´é</th>
<th>¨èÒ¨ÃÔ§</th>
<th>ÃÒ¤ÒµèÍ<br>
˹èÇÂ</th>
<th>ÃÒ¤ÒÃÇÁ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="center">
<input type="hidden" name="hdnSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
<input type="text" name="txtSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
</div></td>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="50" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="7" align="center">ÃÒ¤ÒÃÇÁ Total price </td>
<td align="right">
<?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_7";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left>
<br>
<br>
</left>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ¨ºà´×͹·Õè 7 ----------------------------------------------------------->
<!-- --------------------------------------------- à´×͹·Õè 8 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center">
ãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10<br>
à´×͹ ÊÔ§ËÒ¤Á 2560 <br>
<span class="style7">˹èǧҹ âÀª¹Ò¡Òà </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusdu60_canteen");
$strSQL = "SELECT * FROM Month_8 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusdu59857.php?Action=Save">
<table width="731" height="184" border="1" align="center">
<tr>
<th width="59" rowspan="2"> <div align="center">ÅӴѺ·Õè</div></th>
<th width="301" rowspan="2"> <div align="center">ÃÒ¡Òà </div></th>
<th width="76" rowspan="2"> <div align="center">˹èǹѺ </div></th>
<th width="108" rowspan="2"> <div align="center">¨Ó¹Ç¹·Õè<br>
µéͧ¡ÒÃàºÔ¡ </div></th>
<th height="48" colspan="4"> <div align="center" class="style6">ªèͧ¹ÕéÊÓËÃѺ<br>
à¨éÒ˹éÒ·ÕèÈÙ¹Âì¤ÍÁ</div></th>
</tr>
<tr>
<th height="26">͹ØÒµÔãËé<br>
àºÔ¡ä´é</th>
<th>¨èÒ¨ÃÔ§</th>
<th>ÃÒ¤ÒµèÍ<br>
˹èÇÂ</th>
<th>ÃÒ¤ÒÃÇÁ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="center">
<input type="hidden" name="hdnSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
<input type="text" name="txtSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
</div></td>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="50" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="7" align="center">ÃÒ¤ÒÃÇÁ Total price </td>
<td align="right">
<?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_8";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left>
<br>
<br>
</left>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ¨ºà´×͹·Õè 8 ----------------------------------------------------------->
<!-- --------------------------------------------- à´×͹·Õè 9 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center">
ãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10<br>
à´×͹ ¡Ñ¹ÂÒ¹ 2560 <br>
<span class="style7">˹èǧҹ âÀª¹Ò¡Òà </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusdu60_canteen");
$strSQL = "SELECT * FROM Month_9 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusdu59957.php?Action=Save">
<table width="731" height="184" border="1" align="center">
<tr>
<th width="59" rowspan="2"> <div align="center">ÅӴѺ·Õè</div></th>
<th width="301" rowspan="2"> <div align="center">ÃÒ¡Òà </div></th>
<th width="76" rowspan="2"> <div align="center">˹èǹѺ </div></th>
<th width="108" rowspan="2"> <div align="center">¨Ó¹Ç¹·Õè<br>
µéͧ¡ÒÃàºÔ¡ </div></th>
<th height="48" colspan="4"> <div align="center" class="style6">ªèͧ¹ÕéÊÓËÃѺ<br>
à¨éÒ˹éÒ·ÕèÈÙ¹Âì¤ÍÁ</div></th>
</tr>
<tr>
<th height="26">͹ØÒµÔãËé<br>
àºÔ¡ä´é</th>
<th>¨èÒ¨ÃÔ§</th>
<th>ÃÒ¤ÒµèÍ<br>
˹èÇÂ</th>
<th>ÃÒ¤ÒÃÇÁ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="center">
<input type="hidden" name="hdnSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
<input type="text" name="txtSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
</div></td>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="50" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="7" align="center">ÃÒ¤ÒÃÇÁ Total price </td>
<td align="right">
<?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_9";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left>
<br>
<br>
</left>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ¨ºà´×͹·Õè 9 ----------------------------------------------------------->
<!-- --------------------------------------------- à´×͹·Õè 10 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center">
ãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10<br>
à´×͹ µØÅÒ¤Á 2560 <br>
<span class="style7">˹èǧҹ âÀª¹Ò¡Òà </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusdu60_canteen");
$strSQL = "SELECT * FROM Month_10 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusdu591057.php?Action=Save">
<table width="731" height="184" border="1" align="center">
<tr>
<th width="59" rowspan="2"> <div align="center">ÅӴѺ·Õè</div></th>
<th width="301" rowspan="2"> <div align="center">ÃÒ¡Òà </div></th>
<th width="76" rowspan="2"> <div align="center">˹èǹѺ </div></th>
<th width="108" rowspan="2"> <div align="center">¨Ó¹Ç¹·Õè<br>
µéͧ¡ÒÃàºÔ¡ </div></th>
<th height="48" colspan="4"> <div align="center" class="style6">ªèͧ¹ÕéÊÓËÃѺ<br>
à¨éÒ˹éÒ·ÕèÈÙ¹Âì¤ÍÁ</div></th>
</tr>
<tr>
<th height="26">͹ØÒµÔãËé<br>
àºÔ¡ä´é</th>
<th>¨èÒ¨ÃÔ§</th>
<th>ÃÒ¤ÒµèÍ<br>
˹èÇÂ</th>
<th>ÃÒ¤ÒÃÇÁ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="center">
<input type="hidden" name="hdnSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
<input type="text" name="txtSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
</div></td>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="50" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="7" align="center">ÃÒ¤ÒÃÇÁ Total price </td>
<td align="right">
<?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_10";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left>
<br>
<br>
</left>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ¨ºà´×͹·Õè 10 ----------------------------------------------------------->
<!-- --------------------------------------------- à´×͹·Õè 11 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center">
ãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10<br>
à´×͹ ¾ÄȨԡÒ¹ 2560 <br>
<span class="style7">˹èǧҹ âÀª¹Ò¡Òà </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusdu60_canteen");
$strSQL = "SELECT * FROM Month_11 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusdu591157.php?Action=Save">
<table width="731" height="184" border="1" align="center">
<tr>
<th width="59" rowspan="2"> <div align="center">ÅӴѺ·Õè</div></th>
<th width="301" rowspan="2"> <div align="center">ÃÒ¡Òà </div></th>
<th width="76" rowspan="2"> <div align="center">˹èǹѺ </div></th>
<th width="108" rowspan="2"> <div align="center">¨Ó¹Ç¹·Õè<br>
µéͧ¡ÒÃàºÔ¡ </div></th>
<th height="48" colspan="4"> <div align="center" class="style6">ªèͧ¹ÕéÊÓËÃѺ<br>
à¨éÒ˹éÒ·ÕèÈÙ¹Âì¤ÍÁ</div></th>
</tr>
<tr>
<th height="26">͹ØÒµÔãËé<br>
àºÔ¡ä´é</th>
<th>¨èÒ¨ÃÔ§</th>
<th>ÃÒ¤ÒµèÍ<br>
˹èÇÂ</th>
<th>ÃÒ¤ÒÃÇÁ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="center">
<input type="hidden" name="hdnSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
<input type="text" name="txtSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
</div></td>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="50" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="7" align="center">ÃÒ¤ÒÃÇÁ Total price </td>
<td align="right"><?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_11";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
?></td>
</table>
<left>
<br>
<br>
</left>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ¨ºà´×͹·Õè 11 ----------------------------------------------------------->
<!-- --------------------------------------------- à´×͹·Õè 12 ----------------------------------------------------------->
<div align="center">
<table width="728" border="0">
<tr>
<td width="722" height="83"><p align="center">
ãºàºÔ¡¾ÑÊ´Øâç¾ÂÒºÒÅÊѵËÕº ¡Á.10<br>
à´×͹ ¸Ñ¹ÇÒ¤Á 2560 <br>
<span class="style7">˹èǧҹ âÀª¹Ò¡Òà </span></p>
<p align="left"><br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("pusdu60_canteen");
$strSQL = "SELECT * FROM Month_12 WHERE Req_num > 0 ORDER BY Id_num ASC";
mysql_query("Set names 'tis620'");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p></td>
</tr>
</table>
</div>
<form name="frmMain" method="post" action="..\canteen\pusdu591257.php?Action=Save">
<table width="731" height="184" border="1" align="center">
<tr>
<th width="59" rowspan="2"> <div align="center">ÅӴѺ·Õè</div></th>
<th width="301" rowspan="2"> <div align="center">ÃÒ¡Òà </div></th>
<th width="76" rowspan="2"> <div align="center">˹èǹѺ </div></th>
<th width="108" rowspan="2"> <div align="center">¨Ó¹Ç¹·Õè<br>
µéͧ¡ÒÃàºÔ¡ </div></th>
<th height="48" colspan="4"> <div align="center" class="style6">ªèͧ¹ÕéÊÓËÃѺ<br>
à¨éÒ˹éÒ·ÕèÈÙ¹Âì¤ÍÁ</div></th>
</tr>
<tr>
<th height="26">͹ØÒµÔãËé<br>
àºÔ¡ä´é</th>
<th>¨èÒ¨ÃÔ§</th>
<th>ÃÒ¤ÒµèÍ<br>
˹èÇÂ</th>
<th>ÃÒ¤ÒÃÇÁ</th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
$i = $i + 1;
?>
<tr>
<td><div align="center">
<input type="hidden" name="hdnSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
<input type="text" name="txtSeq<?=$i;?>" size="1" value="<?=$objResult["Seq"];?>">
</div></td>
<td><div align="left">
<input type="text" name="txtItem<?=$i;?>" size="50" value="<?=$objResult["Item"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtUnit<?=$i;?>" size="3" value="<?=$objResult["Unit"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtReq_num<?=$i;?>" size="2" value="<?=$objResult["Req_num"];?>">
</div></td>
<td width="84" align="center"><input type="text" name="txtAllow<?=$i;?>" size="5" value="<?=$objResult["Allow"];?>"></td>
<td><div align="center">
<input type="text" name="txtPay<?=$i;?>" size="5" value="<?=$objResult["Pay"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtOneprice<?=$i;?>" size="5" value="<?=$objResult["Oneprice"];?>">
</div></td>
<td><div align="center">
<input type="text" name="txtTotalprice<?=$i;?>" size="5" value="<?=$objResult["Totalprice"];?>">
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="7" align="center">ÃÒ¤ÒÃÇÁ Total price </td>
<td align="right">
<?php
// Make a MySQL Connection
$query = "SELECT SUM(Totalprice) FROM Month_12";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "". $row['SUM(Totalprice)'];
echo "<br />";
}
</td>
</table>
<left>
<br>
<br>
</left>
</form>
<p>
<?
mysql_close($objConnect);
?>
</p>
<!-- --------------------------------------------- ¨ºà´×͹·Õè 12 ----------------------------------------------------------->
</body>
</html>