 |
|
<?
session_start();
$id=$_POST[id_user];
$name=$_POST[name];
$id_book=$_POST[id_name];
$name_book=$_POST[name_book];
$number=$_POST[number];
$number_date=$_POST[number_date];
$today_date=$_POST[today_date];
$date_send=$_POST[date_send];
$rent1=$_POST[rent1];
$total=$_POST[total];
?><?
$today_date=date("Y-m-d ");
$today_time=date("H:i:s A",strtotime("-1 hours"));
echo "<b>Today is </b> $today_date $today_time";
?><?
$hostname = "127.0.0.1";
$username = "root";
$password = "1234";
$dbname = "db_book";
mysql_connect($hostname,$username,$password) or die("ติดต่อฐานข้อมูลไม่ได้");
mysql_select_db($dbname) or die("ไม่สามารถเลือกฐานข้อมูลได้");
$cs1 = "SET character_set_results=tis620";
mysql_query($cs1) or die('Error query: ' . mysql_error());
$cs2 = "SET character_set_client = tis620";
mysql_query($cs2) or die('Error query: ' . mysql_error());
$cs3 = "SET character_set_connection = tis620";
mysql_query($cs3) or die('Error query: ' . mysql_error());
$sql = "INSERT INTO tb_rent(id_user,name,id_book,name_book,number,number_date,today_date,date_send,rent1,total) values('$id_user','$name','$id_book','$name_book','$number','$number_date','$todt_date','$date_send','$rent1','$total')";
$sqlquery=mysql_db_query($dbname,$sql);
for ($i=0;$i<count($sess_id);$i++) {
$sql3="INSERT INTO tb_rent (id_user,name,id_book,name_book,number,number_date,today_date,date_send,rent1,total) values('$row[0]','$sess_id_user[$i]','$sess_name[$i]','$sess_name_book[$i]','$sess_id_book[$i]','$sess_number[$i]','$sess_number_date[$i]','$sess_today_date[$i]','$sess_date_send[$i]','$sess_rent1[$i]') ";
mysql_db_query($dbname,$sql3);
}
session_unregister("sess_id_user");
session_unregister("sess_name");
session_unregister("sess_name_book");
session_unregister("sess_id_book");
session_unregister("sess_number");
session_unregister("sess_today_date");
session_unregister("sess_number_date");
session_unregister("sess_date_send");
session_unregister("sess_rent1");
?>
<form action="" method="POST" name="rent" id="rent">
<div align="center"><strong>ระบบยืม </strong></div>
</td>
<tr>
<td align="center">
<p align="center">รหัสสมาชิก : <input name="id_user" type="text" id="id_user" size="20" maxlength="10"><br />
<p align="center">ชื่อ-สกุล :<input name="name" type="text" id="name" size="30" maxlength="30">
<br/>
<p align="center">ชื่อหนังสือ :<input name="name_book" type="text" id="name_book" size="30" maxlength="20">
<br/>
<p align="center">รหัสหนังสือ :<input name="id_book" type="text" id="id_book" size="20" maxlength="10"><br/>
<p align="center">จำนวนหนังสือ : <input name="number" type="text" id="number" size="20" maxlength="10"><br/>
<p align="center">
จำนวนวัน :
<input name="number_date" type="text" id="number_date" size="20" maxlength="10" />
<br/>
</p>
<p align="center">ค่าเช่า : <input name="rent1" type="text" id="rent1" size="20" maxlength="10">
<br/>
</p>
<p align="center"><br/>
<input name="submit" type="submit" value="ส่งข้อมูล"from action=" view">
<input name="cancel" type="Reset" value="ลบข้อมูล">
</p>
</form>
<p> </p>
<p> </p></td>
</tr>
<br>
</center>
<table width="924" height="40" border="1" id="view">
<tr>
<th width="89" height="34" scope="col"><div align="center">รหัสสมาชิก</div></th>
<th width="150" scope="col"><div align="center">คุณ</div></th>
<th width="164" scope="col"><div align="center">ชื่อหนังสือ</div></th>
<th width="87" scope="col"><div align="center">รหัสหนังสือ</div></th>
<th width="108" scope="col"><div align="center">จำนวนหนังสือ</div></th>
<th width="75" scope="col"><div align="center">จำนวนวัน</div></th>
<th width="79" scope="col"><div align="center">วันที่ยืม</div></th>
<th width="81" scope="col"><div align="center">กำหนดคืน</div></th>
<th width="63" scope="col"><div align="center">ค่าเช่า</div></th>
<th width="75" scope="col"><div align="center">รวม</div></th>
</tr>
</table>
<?
for ($i=0;$i<count($sess_id_user);$i++) {
$total_unit=$sess_num[$i]*$sess_rent1[$i];
$total=$total+$total_rent1;
echo "
<TR>
<TD><CENTER>$sess_id_user[$i]</CENTER></TD>
<TD><CENTER>$sess_name[$i]</CENTER></TD>
<TD><CENTER>$sess_name_book[$i]</CENTER></TD>
<TD><CENTER>$sess_id_book[$i]</CENTER></TD>
<TD><CENTER>$sess_number[$i]</CENTER></TD>
<TD><CENTER>$sess_number_date[$i]</CENTER></TD>
<TD><CENTER>$sess_today_date[$i]</CENTER></TD>
<TD><CENTER>$sess_date_send[$i]</CENTER></TD>
<TD><CENTER>$sess_rent1[$i]</CENTER></TD>
<TD><CENTER>$total</CENTER></TD>
</TR>";
}
?>
</TABLE>
<? echo "จำนวนเงินทั้งหมด= $total บาท"; ?> <BR>
<p>
<input type="submit" name="Submit" value="บันทึก">
<input type="reset" name="Submit2" value="ออก">
<input type="hidden" NAME="total_order" VALUE="<?=$total?>">
</p>
</form>
</center>
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
4 ต.ค. 2551 00:59:39 |
By :
ัyomoko09 |
View :
1108 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
