 |
ช่วยดูทีว่าผิดอะไรครับ session_start(); $id=$_POST[id]; $name=$_POST[name]; $id_book=$_POST |
| |
 |
|
|
 |
 |
|
<?
session_start();
$id=$_POST[id];
$name=$_POST[name];
$id_book=$_POST[id_name];
$name_book=$_POST[name_book];
$number=$_POST[number];
$number_date=$_POST[number_date];
$today_date=$_POST[date_rent];
$date_send=$_POST[date_send];
$rent1=$_POST[rent1];
$total=$_POST[total];
//$date_rent=date("Y-m-d");
$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,date_rent,date_send,rent1,total) values('$id_user','$name','$id_book','$name_book','$number','$number_date','$date_rent','$date_send','$rent1','$total')";
$sqlquery=mysql_db_query($dbname,$sql);
$sql1="select number from tb_book where id_book='$id_book'";
$sqlquery=mysql_db_query($dbname,$sql1);
$i=0;
while($i<$num_rows)
{
$result=mysql_fetch_array($dbquery);
$num_book=$result[number];
$rents=$result[rent1];
}
$num_book=$num_book-$number;
$sql_up="update tb_book set number='$number_book' where id_book='$id_book'";
$sqlquery=mysql_db_query($dbname,$sql_up);
for ($i=0;$i<count($sess_id);$i++) {
$sql3="INSERT INTO tb_rent values('$row[0]','$sess_idUser[$i]','$sess_name[$i]','$sess_name_book[$i]','$sess_id_book[$i]','$sess_number[$i]','$sess_number_date[$i]','$sess_date_rent[$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_date_rent");
session_unregister("sess_number_date");
session_unregister("sess_date_send");
session_unregister("sess_rent1");
session_unregister("sess_total");
*/
$sql="select * from tb_rent where id_user='$id_user' ";
$result=mysql_db_query($dbname,$sql);
$rs=mysql_fetch_array($result);
$sess_id[]=$rs[id_user];
$sess_name[]=$rs[name];
$sess_name_book[]=$rs[name_book];
$sess_id_book[]=$rs[id_book];
$sess_number[]=$rs[number];
$sess_date_rent[]=$rs[date_rent];
$sess_number_date[]=$rs[number_date];
$sess_date_send[]=$rs[date_send];
$sess_rent1[]=$rs[rent1];
$sess_total[]=$rs[total];
?>
<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>
<?
$sql = "SELECT * FROM `tb_rent`";
$total = 0;
$db_query = mysql_query($sql);
while($result = mysql_fetch_array($db_query)){
echo "
<tr>
<td> $result[id_user]</td>
<td> $result[name]</td>
<td> $result[id_book]</td>
<td> $result[name_book]</td>
<td> $result[number]</td>
<td> $result[number_date]</td>
<td> $result[date_rent]</td>
<td> $result[date_set]</td>
<td> $result[rent1]</td>
<td> </td>
</tr>";
if($result[rent1] >0){
$total += $result[rent1];
}
}
echo "<tr><td colspan = 9 align = right> total : $total</td></tr>";
?>
</table>
<br></br>
<? echo "จำนวนเงินทั้งหมด $total บาท"; ?> </P>
><BR>
<CENTER>
<input type="hidden" name="total" value="<?=$total?>">
<input name="calculate" type="submit" id="calculate" value="คำนวณใหม่">
<input type="submit" name="Submit2" value="บันทึก">
</P>
</FORM></CENTER>
<?
mysql_close();
?>
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
12 ต.ค. 2551 22:50:15 |
By :
terngjar |
View :
1449 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
อ่า แล้วมที่มันรันไมได้ มันขึ้น error ว่าอะไรอ่ะครับ
|
| |
|
|
| |
| Date :
13 ต.ค. 2551 14:19:42 |
By :
aprodise |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ini_set('display_errors','1');
error_reporting(E_ALL);
เอาไปใส่ด้านบนครับ
ถึงยังแก้ไมได้ แต่อย่างน้อยก็ได้รู้ว่า error อะไรครับ
ใช่ เติ้ง rmutt มั้ยหว่า
|
| |
|
|
| |
| Date :
14 ต.ค. 2551 08:32:37 |
By :
aprodise |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
