<?php include"Dbconnect.php"; ?><!DOCTYPE html> <html lang="en"> <head> <!-- title and meta --> <meta http-equiv=Content-Type content="text/html; charset=utf-8"> <link rel="stylesheet" href="css/base.css" /> <link rel="stylesheet" href="css/style.css" /> <title>จัดการข้อมูลไถ่ถอน</title> </head> <body> <table width="960" border="0" align="center" cellpadding="0" cellspacing="0"> <tbody> <tr> <td align="center"><div align="center"><img src="img/banner.png" width="960" height="250"></div></td> </tr> <tr> <td><div align="center"> <? include"menu_top.php";?> </div></td> </tr> <div align="center"> <html> <table width="1162" height="176"align="center"> <tbody> <tr> <form name="form1" method="post" action=""> </form> <td width="70" height="30" align="center" bgcolor="#99CC99">รหัสไถ่ถอนสินค้า</td> <p> </p> <td width="65" align="center" bgcolor="#99CC99"> <div align="center">รหัสสินค้า</div></td> <td width="160" align="center" bgcolor="#99CC99">รูปสินค้า</td> <td width="137" align="center" bgcolor="#99CC99">ชื่อ/รายละเอียดสินค้า</td> <td width="134" align="center" bgcolor="#99CC99">เจ้าของสินค้า</td> <td width="84" align="center" bgcolor="#99CC99">ราคาจำนำ</td> <td width="151" align="center" bgcolor="#99CC99">วันที่จำนำ</td> <td width="137" align="center" bgcolor="#99CC99">วันที่ไถ่ถอน</td> <td width="66" align="center" bgcolor="#99CC99">ดอกเบี้ย%</td> <td width="73" align="center" bgcolor="#99CC99"> </td> </tr> <? //$pagelen =10; //$page = $_REQUEST['page']; //if (empty($page)) { $page=1; } $sql = "Select * from redeem WHERE status_id = '2'"; $result = mysql_query( $sql ); $num_rows = mysql_num_rows($result); $sql1 = "SELECT * FROM redeem inner join product ON redeem.pro_id=product.pro_id "; $resultt = mysql_query( $sql1); $num_rowss = mysql_num_rows($resultt); $sql2 = "SELECT * FROM redeem inner join customer ON redeem.c_id=customer.c_id "; $resulty = mysql_query( $sql2); $num_rowsy = mysql_num_rows($resulty); echo mysql_error(); /*$sql1 = "SELECT * FROM redeem inner join product ON redeem.pro_id=product.pro_id order by redeem_id DESC"; $result1 = mysql_query( $sql1 ); $num_rows1 = mysql_num_rows($result1); $sql2 = "SELECT * FROM redeem inner join pro_type ON redeem.tp_id=pro_type.tp_id order by pro_id DESC"; $result2 = mysql_query( $sql2); $num_rows2 = mysql_num_rows($result2);*/ For ($i=0; $i < $num_rows; $i++) { //if($i%2==0) {$row_color="#FFE8EE";} else {$row_color="#ffffff";} $fetcharr = mysql_fetch_array($result); $fetcharr1 = mysql_fetch_array($resultt); $fetcharr2 = mysql_fetch_array($resulty); //$fetcharr2 = mysql_fetch_array($result2); echo mysql_error(); $redeem_id = $fetcharr['redeem_id']; $c_id = $fetcharr1['c_id']; $pro_id = $fetcharr['pro_id']; $pro_name = $fetcharr1['pro_name']; $date = $fetcharr1['date']; $pro_price = $fetcharr1['pro_price']; $date_redeem = $fetcharr['date_redeem']; $date_interest = $fetcharr['date_interest']; $interest = $fetcharr['interest']; $c_name = $fetcharr2['c_name']; $pro_img = $fetcharr1['pro_img']; $path="img_product"; ?> <tr onmouseover="this.style.backgroundColor='#F0FFF0'" onmouseout="this.style.backgroundColor=''"> <td height="64" align="center" bgcolor="#B9E3AE" ><? echo"$redeem_id"?></td> <td align="center"><? echo"$pro_id";?></td> <td align="center"><span class="txtgray"><img src="<?=$path?>/<?=$pro_img?>" alt="" width="155" height="130" style="border:2px solid #F93" /></span></td> <td align="center"><? echo"$pro_name";?></td> <td align="center"><? echo"$c_name";?></td> <td align="center"><? echo"$pro_price";?></td> <td align="center"><? echo"$date";?></td> <td align="center"> <? echo"$date_redeem";?></td> <td align="center"><? echo"$interest";?></td> <td align="center"><font color="#FF0000">สถานะ<br> ไถ่ถอนแล้ว</font></td> </tr> <? }?> </table> <p> </p><p> </p><p> </p><p> </p>
Quote:SELECT * FROM redeem inner join customer ON redeem.c_id=customer.c_id where customer.c_id = 'xxx'
select * from Customer INNER JOIN Redeem ON Customer.cus_id = Redeem.cus_id INNER JOIN Products ON Redeem.pro_id = Product.pro_id
$sql = "SELECT * FROM product inner join customer ON product.c_id=customer.c_id where product.pro_id ='$pro_id'"; //where product.c_id ='$c_id'"; เชื่อม c_idมา ข้อมูลลูกค้า $sqll = "SELECT * FROM product inner join status_pro ON product.status_id=status_pro.status_id where pro_id='$pro_id' "; $resultt = mysql_query( $sqll); $sql1 = "SELECT * FROM product inner join pro_type ON product.tp_id=pro_type.tp_id where pro_id='$pro_id'" ; $sql2="select * from product inner join redeem on product.redeem_id=redeem.redeem_id"; echo mysql_error (); $sql3="select * from product inner join pawitem on product.pawitem_id=pawitem.pawitem_id"; $result3 = mysql_query( $sql3 ); $result = mysql_query( $sql );
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
Quote:
