<script type="text/javascript">
function sum(){
var total = 0;
for(var i = 1; i<=10; i++){
eval("if(!isNaN(parseInt(document.system.price"+i+".value))){total = total + parseInt(document.system.price"+i+".value)}");
}
document.system.total = total;
}
</script>
<font face="Times New Roman, Times, serif"><?php require_once('Connections/combuddy.php'); ?>
<?php require_once('Connections/combuddy.php'); ?>
<?php require_once('Connections/combuddy.php'); ?>
<?php
mysql_select_db($database_combuddy, $combuddy);
$query_rsCdrom = "SELECT * FROM cdrom ORDER BY CdRom ASC";
$rsCdrom = mysql_query($query_rsCdrom, $combuddy) or die(mysql_error());
$row_rsCdrom = mysql_fetch_assoc($rsCdrom);
$totalRows_rsCdrom = mysql_num_rows($rsCdrom);
mysql_select_db($database_combuddy, $combuddy);
$query_rsCpu = "SELECT * FROM cpu ORDER BY CPU ASC";
$rsCpu = mysql_query($query_rsCpu, $combuddy) or die(mysql_error());
$row_rsCpu = mysql_fetch_assoc($rsCpu);
$totalRows_rsCpu = mysql_num_rows($rsCpu);
mysql_select_db($database_combuddy, $combuddy);
$query_rsHarddisk = "SELECT * FROM harddisk ORDER BY HardDisk ASC";
$rsHarddisk = mysql_query($query_rsHarddisk, $combuddy) or die(mysql_error());
$row_rsHarddisk = mysql_fetch_assoc($rsHarddisk);
$totalRows_rsHarddisk = mysql_num_rows($rsHarddisk);
mysql_select_db($database_combuddy, $combuddy);
$query_rsMainboard = "SELECT * FROM mainboard ORDER BY MainBoard ASC";
$rsMainboard = mysql_query($query_rsMainboard, $combuddy) or die(mysql_error());
$row_rsMainboard = mysql_fetch_assoc($rsMainboard);
$totalRows_rsMainboard = mysql_num_rows($rsMainboard);
mysql_select_db($database_combuddy, $combuddy);
$query_rsMonitor = "SELECT * FROM monitor ORDER BY Monitor ASC";
$rsMonitor = mysql_query($query_rsMonitor, $combuddy) or die(mysql_error());
$row_rsMonitor = mysql_fetch_assoc($rsMonitor);
$totalRows_rsMonitor = mysql_num_rows($rsMonitor);
mysql_select_db($database_combuddy, $combuddy);
$query_rsNetworkcard = "SELECT * FROM networkcard ORDER BY NetWorkCard ASC";
$rsNetworkcard = mysql_query($query_rsNetworkcard, $combuddy) or die(mysql_error());
$row_rsNetworkcard = mysql_fetch_assoc($rsNetworkcard);
$totalRows_rsNetworkcard = mysql_num_rows($rsNetworkcard);
mysql_select_db($database_combuddy, $combuddy);
$query_rsRam = "SELECT * FROM ram ORDER BY Ram ASC";
$rsRam = mysql_query($query_rsRam, $combuddy) or die(mysql_error());
$row_rsRam = mysql_fetch_assoc($rsRam);
$totalRows_rsRam = mysql_num_rows($rsRam);
mysql_select_db($database_combuddy, $combuddy);
$query_rsSoundcard = "SELECT * FROM soundcard ORDER BY SoundCard ASC";
$rsSoundcard = mysql_query($query_rsSoundcard, $combuddy) or die(mysql_error());
$row_rsSoundcard = mysql_fetch_assoc($rsSoundcard);
$totalRows_rsSoundcard = mysql_num_rows($rsSoundcard);
mysql_select_db($database_combuddy, $combuddy);
$query_rsSpeaker = "SELECT * FROM speaker ORDER BY Speaker ASC";
$rsSpeaker = mysql_query($query_rsSpeaker, $combuddy) or die(mysql_error());
$row_rsSpeaker = mysql_fetch_assoc($rsSpeaker);
$totalRows_rsSpeaker = mysql_num_rows($rsSpeaker);
mysql_select_db($database_combuddy, $combuddy);
$query_rsVga = "SELECT * FROM vga";
$rsVga = mysql_query($query_rsVga, $combuddy) or die(mysql_error());
$row_rsVga = mysql_fetch_assoc($rsVga);
$totalRows_rsVga = mysql_num_rows($rsVga);
?>
<?php require_once('Connections/customer.php'); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title>Untitled Document</title>
<style type="text/css">
<!--
#Layer3 {position:absolute;
left:0px;
top:0px;
width:1023px;
height:151px;
z-index:1;
background-color: #ECE9D8;
}
.style6 {
font-size: 36px;
font-family: "Times New Roman", Times, serif;
color: #FF0000;
}
#Layer1 {position:absolute;
left:45px;
top:13px;
width:116px;
height:115px;
z-index:2;
overflow: visible;
visibility: visible;
}
.style35 {font-family: "Times New Roman", Times, serif;
color: #6633CC;
font-weight: bold;
}
#Layer5 {position:absolute;
left:40px;
top:128px;
width:128px;
height:21px;
z-index:4;
}
.style7 {font-size: 16px}
#Layer7 {position:absolute;
left:382px;
top:16px;
width:116px;
height:115px;
z-index:6;
}
#Layer9 {position:absolute;
left:371px;
top:130px;
width:138px;
height:21px;
z-index:8;
}
#Layer6 {position:absolute;
left:724px;
top:14px;
width:116px;
height:115px;
z-index:5;
}
#Layer10 {position:absolute;
left:714px;
top:129px;
width:137px;
height:21px;
z-index:9;
}
#Layer8 {position:absolute;
left:1066px;
top:14px;
width:116px;
height:115px;
z-index:7;
}
#Layer11 {position:absolute;
left:1057px;
top:129px;
width:137px;
height:21;
z-index:10;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.style44 {font-family: "Times New Roman", Times, serif; color: #FF0000; }
.style45 {
font-family: "Times New Roman", Times, serif;
color: #0000FF;
}
-->
</style>
</head>
<body>
<div id="Layer3"><img src="Header.gif" alt="ds" width="1258" height="151" /></div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div id="Layer7"><a href="system.php"><img src="My-computer-icon.gif" width="116" height="115" border="0" /></a></div>
<div class="style35" id="Layer9">
<div align="center"><a href="system.php">ระบบจัดการสินค้า</a></div>
</div>
<div id="Layer6"><a href="search.php"><img src="search_user.gif" width="117" height="117" border="0" /></a></div>
<div class="style35" id="Layer10">
<div align="center"><a href="search.php">ระบบค้นหาข้อมูล</a></div>
</div>
<div id="Layer8"><img src="report.gif" width="116" height="115" /></div>
<div class="style35" id="Layer11">
<div align="center">รายงานสินค้า</div>
</div>
<p> </p>
<div id="Layer1"><a href="select.php"><img src="member.gif" width="115" height="115" border="0" /></a></div>
<div class="style35" id="Layer5">
<div align="center"><a href="select.php" class="style7">ระบบข้อมูลลูกค้า</a></div>
</div>
<p align="center" class="style6">ระบบจัดการสินค้า</p>
<form id="system" name="system" method="post" action="">
<div align="center">
<table width="45%" border="1">
<tr>
<th width="22%" bgcolor="#00FF66" scope="col"><span class="style45">ชนิดสินค้า</span></th>
<th colspan="2" bgcolor="#00FF66" scope="col"><span class="style45">รายละเอียดสินค้า</span></th>
<th width="19%" bgcolor="#00FF66" scope="col"><span class="style45">ราคาสินค้า</span></th>
</tr>
<tr>
<th bgcolor="#00FFFF" scope="row"><span class="style44">CD-ROM</span></th>
<td colspan="2" bgcolor="#FFCCFF"><label for="select"></label>
<div align="left">
<select name="cdromid" id="cdromid" onchange ="this.form.price1.value = this.value;sum();">
<option value="0">--โปรดเลือกรายการ--</option>
<?php
do {
?>
<option value="<?php echo $row_rsCdrom['Price']?>"><?php echo $row_rsCdrom['CdRom']?></option>
<?php
} while ($row_rsCdrom = mysql_fetch_assoc($rsCdrom));
$rows = mysql_num_rows($rsCdrom);
if($rows > 0) {
mysql_data_seek($rsCdrom, 0);
$row_rsCdrom = mysql_fetch_assoc($rsCdrom);
}
?>
</select>
</div></td>
<td bgcolor="#FFFF00"><label for="textfield"></label> <p align="center">
<input name="price1" type="text" id="price1" size="13" />
</p></td>
</tr>
<tr>
<th bgcolor="#00FFFF" scope="row"><span class="style44">CPU</span></th>
<td colspan="2" bgcolor="#FFCCFF"><label for="select"></label>
<div align="left">
<select name="cpuid" id="cpuid" OnChange="this.form.price2.value = this.value;sum();" >
<option value="0">--โปรดเลือกรายการ--</option><?php
do {
?><option value="<?php echo $row_rsCpu['Price']?>"><?php echo $row_rsCpu['CPU']?></option>
<?php
} while ($row_rsCpu = mysql_fetch_assoc($rsCpu));
$rows = mysql_num_rows($rsCpu);
if($rows > 0) {
mysql_data_seek($rsCpu, 0);
$row_rsCpu = mysql_fetch_assoc($rsCpu);
}
?>
</select>
</div></td>
<td bgcolor="#FFFF00"> <p align="center">
<input name="price2" type="text" id="price2" size="13" />
</p></td>
</tr>
<tr>
<th bgcolor="#00FFFF" scope="row"><span class="style44">Harddisk</span></th>
<td colspan="2" bgcolor="#FFCCFF"><label for="select"></label>
<div align="left">
<select name="harddiskid" id="harddiskid" OnChange="this.form.price3.value = this.value;sum();">
<option value="0">--โปรดเลือกรายการ--</option>
<?php
do {
?><option value="<?php echo $row_rsHarddisk['Price']?>"><?php echo $row_rsHarddisk['HardDisk']?></option>
<?php
} while ($row_rsHarddisk = mysql_fetch_assoc($rsHarddisk));
$rows = mysql_num_rows($rsHarddisk);
if($rows > 0) {
mysql_data_seek($rsHarddisk, 0);
$row_rsHarddisk = mysql_fetch_assoc($rsHarddisk);
}
?>
</select>
</div></td>
<td bgcolor="#FFFF00"> <p align="center">
<input name="price3" type="text" id="price3" size="13" />
</p></td>
</tr>
<tr>
<th bgcolor="#00FFFF" scope="row"><span class="style44">Mainboard</span></th>
<td colspan="2" bgcolor="#FFCCFF"><label for="select"></label>
<div align="left">
<select name="mainboardid" id="mainboardid" OnChange="this.form.price4.value = this.value;sum();">
<option value="0">--โปรดเลือกรายการ--</option>
<?php
do {
?><option value="<?php echo $row_rsMainboard['Price']?>"><?php echo $row_rsMainboard['MainBoard']?></option>
<?php
} while ($row_rsMainboard = mysql_fetch_assoc($rsMainboard));
$rows = mysql_num_rows($rsMainboard);
if($rows > 0) {
mysql_data_seek($rsMainboard, 0);
$row_rsMainboard = mysql_fetch_assoc($rsMainboard);
}
?>
</select>
</div></td>
<td bgcolor="#FFFF00"> <p align="center">
<input name="price4" type="text" id="price4" size="13" />
</p></td>
</tr>
<tr>
<th bgcolor="#00FFFF" scope="row"><span class="style44">Monitor</span></th>
<td colspan="2" bgcolor="#FFCCFF"><label for="select"></label>
<div align="left">
<select name="monitorid" id="monitorid" OnChange="this.form.price5.value = this.value;sum();">
<option value="0">--โปรดเลือกรายการ--</option>
<?php
do {
?><option value="<?php echo $row_rsMonitor['Price']?>"><?php echo $row_rsMonitor['Monitor']?></option>
<?php
} while ($row_rsMonitor = mysql_fetch_assoc($rsMonitor));
$rows = mysql_num_rows($rsMonitor);
if($rows > 0) {
mysql_data_seek($rsMonitor, 0);
$row_rsMonitor = mysql_fetch_assoc($rsMonitor);
}
?>
</select>
</div></td>
<td bgcolor="#FFFF00"> <p align="center">
<input name="price5" type="text" id="price5" size="13" />
</p></td>
</tr>
<tr>
<th bgcolor="#00FFFF" scope="row"><span class="style44">NetworkCard</span></th>
<td colspan="2" bgcolor="#FFCCFF"><label for="select"></label>
<div align="left">
<select name="networdcardid" id="networdcardid" OnChange="this.form.price6.value = this.value;sum();">
<option value="0">--โปรดเลือกรายการ--</option>
<?php
do {
?><option value="<?php echo $row_rsNetworkcard['Price']?>"><?php echo $row_rsNetworkcard['NetWorkCard']?></option>
<?php
} while ($row_rsNetworkcard = mysql_fetch_assoc($rsNetworkcard));
$rows = mysql_num_rows($rsNetworkcard);
if($rows > 0) {
mysql_data_seek($rsNetworkcard, 0);
$row_rsNetworkcard = mysql_fetch_assoc($rsNetworkcard);
}
?>
</select>
</div></td>
<td bgcolor="#FFFF00"> <p align="center">
<input name="price6" type="text" id="price6" size="13" />
</p></td>
</tr>
<tr>
<th bgcolor="#00FFFF" scope="row"><span class="style44">RAM</span></th>
<td colspan="2" bgcolor="#FFCCFF"><label for="select"></label>
<div align="left">
<select name="ramid" id="ramid" OnChange="this.form.price7.value = this.value;sum();">
<option value="0">--โปรดเลือกรายการ--</option>
<?php
do {
?><option value="<?php echo $row_rsRam['Price']?>"><?php echo $row_rsRam['Ram']?></option>
<?php
} while ($row_rsRam = mysql_fetch_assoc($rsRam));
$rows = mysql_num_rows($rsRam);
if($rows > 0) {
mysql_data_seek($rsRam, 0);
$row_rsRam = mysql_fetch_assoc($rsRam);
}
?>
</select>
</div></td>
<td bgcolor="#FFFF00"> <p align="center">
<input name="price7" type="text" id="price7" size="13" />
</p></td>
</tr>
<tr>
<th bgcolor="#00FFFF" scope="row"><span class="style44">SoundCard</span></th>
<td colspan="2" bgcolor="#FFCCFF"><label for="select"></label>
<div align="left">
<select name="soundcardid" id="soundcardid" OnChange="this.form.price8.value = this.value;sum();">
<option value="0">--โปรดเลือกรายการ--</option>
<?php
do {
?><option value="<?php echo $row_rsSoundcard['Price']?>"><?php echo $row_rsSoundcard['SoundCard']?></option>
<?php
} while ($row_rsSoundcard = mysql_fetch_assoc($rsSoundcard));
$rows = mysql_num_rows($rsSoundcard);
if($rows > 0) {
mysql_data_seek($rsSoundcard, 0);
$row_rsSoundcard = mysql_fetch_assoc($rsSoundcard);
}
?>
</select>
</div></td>
<td bgcolor="#FFFF00"> <p align="center">
<input name="price8" type="text" id="price8" size="13" />
</p></td>
</tr>
<tr>
<th bgcolor="#00FFFF" scope="row"><span class="style44">Speaker</span></th>
<td colspan="2" bgcolor="#FFCCFF"><label for="select"></label>
<div align="left">
<select name="speakerid" id="speakerid" OnChange="this.form.price9.value = this.value;sum();">
<option value="0">--โปรดเลือกรายการ--</option>
<?php
do {
?><option value="<?php echo $row_rsSpeaker['Price']?>"><?php echo $row_rsSpeaker['Speaker']?></option>
<?php
} while ($row_rsSpeaker = mysql_fetch_assoc($rsSpeaker));
$rows = mysql_num_rows($rsSpeaker);
if($rows > 0) {
mysql_data_seek($rsSpeaker, 0);
$row_rsSpeaker = mysql_fetch_assoc($rsSpeaker);
}
?>
</select>
</div></td>
<td bgcolor="#FFFF00"> <p align="center">
<input name="price9" type="text" id="price9" size="13" />
</p></td>
</tr>
<tr>
<th bgcolor="#00FFFF" scope="row"><span class="style44">VGA</span></th>
<td colspan="2" bgcolor="#FFCCFF"><label for="select"></label>
<div align="left">
<label for="select"></label>
<select name="vgaid" id="vgaid" OnChange="this.form.price10.value = this.value;sum();">
<option value="0">--โปรดเลือกรายการ--</option>
<?php
do {
?><option value="<?php echo $row_rsVga['Price']?>"><?php echo $row_rsVga['DisplayCard']?></option>
<?php
} while ($row_rsVga = mysql_fetch_assoc($rsVga));
$rows = mysql_num_rows($rsVga);
if($rows > 0) {
mysql_data_seek($rsVga, 0);
$row_rsVga = mysql_fetch_assoc($rsVga);
}
?>
</select>
</div></td>
<td bgcolor="#FFFF00"><label for="label"></label> <p align="center">
<input name="price10" type="text" id="label" size="13" />
</p></td>
</tr>
<tr>
<th colspan="2" bgcolor="#CC9900" scope="row"><span class="style45">รวมราคาสินค้าที่เลือกทั้งหมด
<label for="Submit"></label>
</span></th>
<th width="11%" bgcolor="#CC9900" scope="row"><label for="Submit"></label>
<input type="button" name="Button" value="รวมราคา" id="Submit" /></th>
<td bgcolor="#99FFFF"><label for="label2"></label>
<div align="center">
<input name="total" type="text" id="label2" size="13" />
</div></td>
</tr>
</table>
</div>
</form>
<p align="center" class="style6"> </p>
</body>
</html>
<?php
mysql_free_result($rsCdrom);
mysql_free_result($rsCpu);
mysql_free_result($rsHarddisk);
mysql_free_result($rsMainboard);
mysql_free_result($rsMonitor);
mysql_free_result($rsNetworkcard);
mysql_free_result($rsRam);
mysql_free_result($rsSoundcard);
mysql_free_result($rsSpeaker);
mysql_free_result($rsVga);
?>
</font>
Quote:
