ช่วยดุ code ให้หน่อยคับ
ผมอยาให้มัน ค้นหาตามที่เราต้องการ ออกมาทุกตัวที่เราเลื่อกทำยังไงดีคับแนะนำหน่อยผมใช้ดรีมทำ
หน้านี้ เป็นการค้นหาอยากให้ค้นจากทุกอันเช่น ค้นหา แรม 256 สินค้าก็จะออกมาแต่แรม 256 แต่มันต้องเลือกยี่ห้อ เลือกหน้าจอ เลือกซีพียู ให้มันออกมาตามที่เราค้นหาคับผม
<?php require_once('../Connections/tv.php'); ?> <?php mysql_select_db($database_tv, $tv); $query_Recordset1 = "SELECT * FROM notebook"; $Recordset1 = mysql_query($query_Recordset1, $tv) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Untitled Document</title> </head>
<body> <form name="form1" method="post" action="show.php"> <p> <select name="selectsearch" id="selectsearch"> <option>ยี่ห้อที่ต้องการ</option> <option value="Acer">Acer</option> <option value="Asus">Asus</option> <option value="HP">HP</option> <option value="Compaq">Compaq</option> </select> </p> <p> <select name="selectsearch1" id="selectsearch1"> <option>ขนาดหน้าจอ</option> <option value="14 inch">14 inch</option> <option value="15 inch">15 inch</option> </select> </p> <p> <select name="selectsearch2" id="selectsearch2"> <option>ขนาดแรมที่ต้องการ</option> <option value="128 MB DDR">128 MB DDR</option> <option value="256 MB DDR">256 MB DDR</option> <option value="512 MB DDR">512 MB DDR</option> <option value="1 GB DDR">1 GB DDR</option> <option value="128 MB DDR2">128 MB DDR2</option> <option value="256 MB DDR2">256 MB DDR2</option> <option value="512 MB DDR2">512 MB DDR2</option> <option value="1 GB DDR2">1 GB DDR2</option> </select> </p> <p> <select name="selectsearch3" id="selectsearch3"> <option>ซีพียูที่ต้องการ</option> <option value="Intel Celeron">Intel Celeron</option> <option value="Intel Celeron M">Intel Celeron M</option> <option value="AMD">AMD</option> </select> </p> <p> <input type="submit" name="Submit" value="Submit"> </p> </form> <p> </p> </body> </html> <?php mysql_free_result($Recordset1); ?>
หน้านี้เป็นหน้า โชว์สินค้าคับ
<?php require_once('../Connections/tv.php'); ?> <?php $maxRows_Recordset1 = 1; $pageNum_Recordset1 = 0; if (isset($_GET['pageNum_Recordset1'])) { $pageNum_Recordset1 = $_GET['pageNum_Recordset1']; } $startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
$colname_Recordset1 = "-1"; if (isset($_POST['selectsearch'])) { $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_POST['selectsearch'] : addslashes($_POST['selectsearch']); } mysql_select_db($database_tv, $tv); $query_Recordset1 = sprintf("SELECT * FROM notebook WHERE brand = '%s'", $colname_Recordset1); $query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1); $Recordset1 = mysql_query($query_limit_Recordset1, $tv) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) { $totalRows_Recordset1 = $_GET['totalRows_Recordset1']; } else { $all_Recordset1 = mysql_query($query_Recordset1); $totalRows_Recordset1 = mysql_num_rows($all_Recordset1); } $totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1; ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Untitled Document</title> <style type="text/css"> <!-- .style9 {font-family: AngsanaUPC; font-size: 20px; } .style10 {font-size: 14px} --> </style> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> </head>
<body> <div id="Layer1" style="position:absolute; left:97px; top:34px; width:196px; height:197px; z-index:1"> <table width="195" height="197" border="0"> <tr> <td><div align="center"> <p><span class="style9"> <? $dir ='photo/'; $myPic =$dir.$row_Recordset1['pic']; $getSize = getimagesize($myPic); $shape = ($getSize[1] > $getSize[0]) ? "h=120" : "w=120"; echo $$getSize[1]; $showPic = "image.php?img=".$dir.$row_Recordset1['pic']."&".$shape; ?> </span><img src="<?=$showPic?>" width="97" height="101" /></p> <p><?php echo $row_Recordset1['prite']; ?><span class="style10"> บาท</span></p> </div></td> </tr> </table> </div> <form name="form1" method="post" action=""> <table width="300" height="150" border="0" align="center"> <?php do { ?> <tr> </tr> <tr> <td>ยี่ห้อ</td> <td><?php echo $row_Recordset1['brand']; ?></td> </tr> <tr> <td>รุ่น</td> <td><?php echo $row_Recordset1['generation']; ?></td> </tr> <tr> <td>CPU</td> <td><?php echo $row_Recordset1['cpu']; ?></td> </tr> <tr> <td>Chipeset</td> <td><?php echo $row_Recordset1['chipeset']; ?></td> </tr> <tr> <td>RAM</td> <td><?php echo $row_Recordset1['ram']; ?></td> </tr> <tr> <td>Harddisk</td> <td><?php echo $row_Recordset1['harddisk']; ?></td> </tr> <tr> <td>Monitor</td> <td><?php echo $row_Recordset1['monitor']; ?></td> </tr> <tr> <td>Drive</td> <td><?php echo $row_Recordset1['drive']; ?></td> </tr> <tr> <td>น้ำหนัก</td> <td><?php echo $row_Recordset1['weight']; ?></td> </tr> <tr> <td>การ์ดจอ</td> <td><?php echo $row_Recordset1['card']; ?></td> </tr> <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> </table> <p> </p> <p> </p> <div align="center"></div> </form> <span class="style9"></span> </body> </html> <?php mysql_free_result($Recordset1); ?>
ช่วยทีคับ ขอบคุณคับ
|