001.<html>
002.<head>
003.<title>SunZan-Desgin.Com</title>
004.<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>
005.<style>
006..number{ text-align : center; width:100;}
007..number div{
008. background: #91F7A4;
009. color : #ff0000;
010.
011.}
012.#test_report th{ background-color : #21BBD6; color : #ffffff;}
013.#test_report{
014. border-right : 1px solid #eeeeee;
015. border-bottom : 1px solid #eeeeee;
016.}
017.#test_report td,#test_report th{
018. border-top : 1px solid #eeeeee;
019. border-left : 1px solid #eeeeee;
020. padding : 2px;
021.}
022.#txt_year{ width : 70px;}
023..fail{ color : red;}
024.</style>
025.</head>
026.<body>
027.
028.<p>
029. <?php
030.
031.
032.
033.mysql_connect("localhost","bpworld_root","root");
034.mysql_select_db("bpworld_opencart");
035.mysql_query("SET NAMES UTF8");
036.
037.$sizeshow = array();
038.$strSQL = "SELECT ProductName,size ,price FROM `testproduct` WHERE ProductName='2028' ORDER BY size ASC ";
039.$qry = mysql_query($strSQL) or die('ไม่สามารถเชื่อมต่อฐานข้อมูลได้ Error : '. mysql_error());
040.while($row = mysql_fetch_assoc($qry)){
041. $sizeshow[$row['size']] = $row['size'];
042.
043.}
044.
045.$allcolor = array();
046.$strSQL = "SELECT color FROM `testproduct` WHERE ProductName='2028' ORDER BY color ASC ";
047.$qry = mysql_query($strSQL) or die('ไม่สามารถเชื่อมต่อฐานข้อมูลได้ Error : '. mysql_error());
048.while($row = mysql_fetch_assoc($qry)){
049. $allcolor[$row['color']] = $row['color'];
050.}
051.
052.$qtyshow = array();
053.$strSQL = "SELECT qty,size,color FROM `testproduct` ";
054.$strSQL.= "WHERE ProductName='2028' GROUP BY `size` , `color` ";
055.$qry = mysql_query($strSQL) or die('ไม่สามารถเชื่อมต่อฐานข้อมูลได้ Error : '. mysql_error());
056.while($row = mysql_fetch_assoc($qry)){
057.
058.
059.
060.}
061.echo "<table border='0' id='test_report' cellpadding='0' cellspacing='0'>";
062.echo '<tr>';
063.echo '<th>รูปสินค้า</th>';
064.echo '<th>รุ่น</th>';
065.echo '<th>ไซร์</th>';
066.echo '<th>ราคา</th>';
067.
068.
069.foreach($allcolor as $color=>$color){
070. echo '<th width="50" align="center">' . $color . '</th>';
071.}
072.
073.echo "</tr>";
074.
075. echo '<tr>';
076.echo '<td width="150" align="center" rowspan="3"> </td>';
077.foreach($sizeshow as $sizecolor=>$psize){
078.
079. echo '<td width="150" align="center">2028</td>';
080. echo '<td width="150" align="center">'. $psize .'</td>';
081.
082.
083.
084.$allsize = array();
085.$priceshow = array();
086.$strSQL = "SELECT qty,price FROM `testproduct` WHERE ProductName='2028' AND size='".$psize."' GROUP BY size,color ORDER BY color ASC";
087.$qry = mysql_query($strSQL) or die('ไม่สามารถเชื่อมต่อฐานข้อมูลได้ Error : '. mysql_error());
088.while($row = mysql_fetch_assoc($qry)){
089. $allsize[$row['qty']] = $row['qty'];
090. $priceshow[$row['price']] = $row['price'];
091.}
092.
093. foreach($priceshow as $sizeprice=>$pprice){
094. echo '<td width="100" align="center">'. number_format($pprice,0) .'</td>';
095.
096. }
097.
098. foreach($allsize as $color2=>$color2){
099. if($color2==''){$sqty='0';} else {$sqty=$color2;}
100. echo "<td class='number' >", $sqty , "</td>";
101.}
102.
103. echo '</tr>';
104.}
105.echo "</table>";
106.mysql_close();
107.?>
108.</p>
109.<p> </p>
