001.<?php
002. $date = date("d-m-y");
003. $time = date("H:i");
004.?>
005.<?php
006. $con=mysql_connect("localhost","root","12345678");
007.
008. mysql_select_db("db_wasunchai2");
009. mysql_query("SET NAMES utf8");
010. $sql="SELECT * FROM product_sell ";
011.
012. $data=mysql_query($sql,$con);
013.
014.?>
015.
018.<head>
019.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
020.<title>เพิ่มสินค้า</title>
021.<style type="text/css">
022.#form1 table {
023. text-align: left;
024.}
025.#form1 center h3 {
026. text-align: left;
027.}
028..d {
029. font-size: 12px;
030.}
031..btn.btn-success {
032. text-align: right;
033.}
034.</style>
035.</head>
036.
037.
038.<body>
039.<center>
040.
041.<table width="947" bgcolor="#CCCCCC" border="1" >
042. <tr>
043. <td width="937" height="201"><img src="images/logo.png" width="941" height="197" /></td>
044. </tr>
045.
046.</center>
047.<tr>
048.
049. <td><center><br /><br /><img src="picfile/atcom.png" width="210" height="120" /><br />
050. <p> ร้านแอทคอมพิวเตอร์ อาคารเลขที่ ข/102-103 ถนนไชยพันธ์ ตำบลท่าช้าง อำเภอเมือง จังหวัดนครนายก 26000 <p></center>
051. <hr>
052.
053. <p><h3> รายการขายสินค้า</h3></p>
054. <span class="btn">
055. <button type="button" class="btn btn-success"><i class="icon-calendar"></i>
056. วันที่ :<?php echo $date;?>;   เวลา : <?php echo $time;?></strong></button><br /></span>
057.
058. <br />
059.
060. <table width="941" border="1" cellpadding="0" cellspacing="0">
061.
062. <tr>
063.
064. <td width="90" bgcolor="#CCFF00">วันที่/เวลา</td>
065. <td width="90" bgcolor="#CCFF00">รหัสสินค้า</td>
066. <td width="220" bgcolor="#CCFF00">ชื่อสินค้า</td>
067. <td width="180" bgcolor="#CCFF00">ประเภท</td>
068. <td width="60" bgcolor="#CCFF00">จำนวน</td>
069. <td width="60" bgcolor="#CCFF00">ราคา</td>
070. <td width="80" bgcolor="#CCFF00">รวม(บาท)</td>
071. <td width="80" bgcolor="#CCFF00">ผู้บันทึก</td>
072. <td width="80" bgcolor="#CCFF00">รูป</td>
073. <td width="30" bgcolor="#CCFF00">แก้ไข</td>
074. <td width="30" bgcolor="#CCFF00">ยกเลิก</td>
075.
076.
077. </tr>
078.<?php
079. while($row=mysql_fetch_array($data)){
080. ?>
081. <tr class="d">
082. <td bgcolor="#CCFFCC"><? echo $row["date_re"] ?></td>
083. <td bgcolor="#CCFFCC"><? echo $row["product_id"] ?></td>
084. <td bgcolor="#CCFFCC"><? echo $row["product_name"] ?></td>
085. <td bgcolor="#CCFFCC"><? echo $row["type_name"] ?></td>
086. <td bgcolor="#CCFFCC"><? echo $row["product_amount"] ?></td>
087. <td bgcolor="#CCFFCC"><? echo $row["product_price"] ?></td>
088. <td bgcolor="#CCFFCC"><? echo $row["product_total"] ?> </td>
089.
090. <td bgcolor="#CCFFCC"><? echo $row["username"] ?></td>
091. <td bgcolor="#CCFFCC"><img src="images/<?php echo $row["picture"]?>" width="80px" height="80px"/> </td>
092.
093. <td bgcolor="#CCFFCC"><a href="editsell.php?id=<?php echo $row["product_id"] ?>"><img src="icon/edit-icon.png" width="25" height="25" /></a></td>
094. <td bgcolor="#CCFFCC"><a href="deletesell.php?id=<?php echo $row["product_id"] ?>"><img src="icon/delete.ico" width="25" height="25"/></a></td>
095. </tr>
096. <?php
097. }
098. mysql_close($con);
099. ?>
100. </table>
101.
102. </body>
103. </html>
