|
 |
| |
เรื่องเวลาในเวปประมูล อยากทราบว่าจะทำอย่างไร อย่างเช่นยหน้าฟอมนี้คะ จะมีเวลาให้เลิอกว่าจะตั้งประมูลกี่วัน |
| |
 |
|
|
 |
 |
|
อยากทราบว่าจะทำอย่างไร อย่างเช่นยหน้าฟอมนี้คะ
จะมีเวลาให้เลิอกว่าจะตั้งประมูลกี่วัน โดยกำหนดวันตั้งเป็นวันแรก
อยากทราบวิธีเขียนให้ปิดประมูลตามวันที่ตั้งคะ หน้าฟอร์มตั้งประมูล
--------->>>tungpramool.php
<?php session_start?>
<?php require_once('Connections/projectcon.php'); ?>
<?php mysql_select_db($database_projectcon, $projectcon);
$query_Recordset1 = "SELECT * FROM auctiondetail WHERE auctionid='$auctionid'";
$Recordset1 = mysql_query($query_Recordset1, $projectcon) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_projectcon, $projectcon);
$query_Recordset2 = "SELECT m.*,p.* FROM member m,product p WHERE m.memberid=p.memberid and p.auctionid='$auctionid' ";
$Recordset2 = mysql_query($query_Recordset2, $projectcon) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
session_start();?>
<!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=windows-874">
<title>Untitled Document</title>
<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>
<style type="text/css">
<!--
.style1 {
font-size: 24px;
font-style: italic;
color: #0033CC;
}
body {
background-color: #6699FF;
background-image: url(picture/bg_main.jpg);
}
.style2 {font-size: 24px; font-style: italic; color: #FF0000; }
.style3 {font-size: 14px}
-->
</style>
</head>
<body>
<div id="Layer1" style="position:absolute; left:38px; top:22px; width:738px; height:1239px; z-index:1">
<div align="center">
<p> </p>
<p class="style2">
ตั้งประมูลพระใหม</p>
<p class="style2"><?php echo $row_Recordset1['name']; ?></p>
<p class="style2"> </p>
<form action="postpamool.php?memberid=<?php echo $member1; ?>&proid=<?php echo $row_Recordset2['proid'] ?>&auctionid=<?php echo $row_Recordset2['auctionid']?>" method="post"name="form1">
<table width="594" height="830" border="1">
<tr>
<td width="130" height="27" bgcolor="#33CC66"><div align="right">ชื่อสมาชิก<span class="style2">
<label></label>
</span>
<input name="auctionid" type="hidden" id="auctionid" value="<?php echo $auctionid; ?>">
<input name="proid" type="hidden" id="proid" value="<?php echo $proid;?>">
<span class="style2">
<input name="memberid" type="hidden" id="memberid" value="<?php echo $member1;?>">
</span></div></td>
<td width="434" bgcolor="#66CC99"><div align="left">
<label></label>
<label></label>
<label>
<input name="proname" type="text" id="proname" value="<?php echo $member; ?>">
</label>
</div></td>
</tr>
<tr>
<td height="33" bgcolor="#33CC66"><div align="center">ชื่อพระเครื่อง</div></td>
<td bgcolor="#66CC99"><div align="left">
<input name="ctitle" type="text" id="ctitle" size="50">
*</div></td>
</tr>
<tr><?php $today = date("Y-m-d G:i:s"); ?>
<td height="35" bgcolor="#33CC66"><div align="right">ราคาขั้นต่ำที่ต้องการขาย</div></td>
<td bgcolor="#66CC99">
<div align="left">
<input name="priceup" type="text" id="priceup">
บาท </div>
<label></label> </td></tr>
<tr>
<td height="30" bgcolor="#33CC66">ราคาที่ต้องประมูลแต่ละครั้ง</td>
<td bgcolor="#66CC99">
<div align="left">
<input name="pricebit" type="text" id="pricebit">
บาท</div></td>
</tr>
<tr>
<td height="30" bgcolor="#33CC66"><div align="right">จำนวนวันที่ลงประมูล</div></td>
<td bgcolor="#66CC99"><div align="left">
<label>
<select name="stopn" id="stopn">
<option value="1" selected>1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</label>
</div></td>
</tr>
<tr>
<td bgcolor="#33CC66"><div align="right">รายละเอียด</div></td>
<td bgcolor="#66CC99"><div align="left">
<textarea name="detail" cols="40" id="detail"></textarea>
</div></td>
</tr>
<tr>
<td height="46" bgcolor="#33CC66"><div align="right">วันที่เริ่มตั้งประมูล</div></td>
<td bgcolor="#66CC99"><div align="left">
<input name="datestart" type="text" id="datestart" value="<?php echo $today;?>">
<label></label>
</div></td>
</tr>
<tr>
<td height="33" bgcolor="#33CC66"><div align="right">ชื่อบัญชีธนาคาร</div></td>
<td bgcolor="#66CC99"><table width="240" border="0">
<tr>
<td width="55"><span class="style3">ชื่อบัญชี</span></td>
<td width="175"><label>
</label>
<label>
<input name="account" type="text" id="account">
</label></td>
</tr>
<tr>
<td><span class="style3">ธนาคาร</span></td>
<td height="24"><label>
<input name="bank" type="text" id="bank"> </label> </td>
</tr>
<tr>
<td height="38"><span class="style3">สาขา</span></td>
<td><label>
<input name="banch" type="text" id="banch"> </label> </td>
</tr>
<tr>
<td height="35"><span class="style3">เลขที่บัญชี</span></td>
<td><label>
<label>
<input name="idaccount" type="text" id="idaccount">
</label> </label> </td>
</tr>
<tr>
<td><span class="style3">ประเภท</span></td>
<td height="55"><label>
<input name="textfield5" type="text">
</label> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="67" bgcolor="#33CC66"><p align="right">รูปถาพพระที่นำมาลงประมูล</p>
<p align="right">ภาพขนาดไม่เกิน 100 K </p></td>
<td bgcolor="#66CC99"><p align="left"> </p>
<p align="left">
<input name="picture" type="file" id="picture">
</p>
<p align="left">
<input name="picture1" type="file" id="picture1">
</p>
<p align="left">
<input name="picture2" type="file" id="picture2">
</p>
<p align="left">
<label></label>
</p>
<p align="left"> </p>
<p align="center">
<input type="submit" name="Submit" value="ตกลง">
<input type="submit" name="Submit" value="ยกเลิก">
</p></td>
</tr>
</table>
<p> </p>
</form>
<p class="style2"> </p>
<p class="style1"> </p>
<p class="style1"> </p>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
----->>>pagepamool.php
<?php session_start();?>
<?php require_once('Connections/projectcon.php'); ?>
<?php require_once('Connections/projectcon.php'); ?>
<?php
mysql_select_db($database_projectcon, $projectcon);
$query_Recordset1 = "SELECT * FROM auctiondetail WHERE auctionid='$auctionid'";
$Recordset1 = mysql_query($query_Recordset1, $projectcon) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_projectcon, $projectcon);
$query_Recordset3 = "SELECT * FROM product WHERE proid='$proid'";
$Recordset3 = mysql_query($query_Recordset3, $projectcon) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);
mysql_select_db($database_projectcon, $projectcon);
$query_Recordset2 = "select * from member where memberid='$memberid'";
$Recordset2 = mysql_query($query_Recordset2, $projectcon) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
mysql_select_db($database_projectcon, $projectcon);
$query_Recordset4 = "SELECT * FROM promool WHERE proid='$proid'";
$Recordset4 = mysql_query($query_Recordset4, $projectcon) or die(mysql_error());
$row_Recordset4 = mysql_fetch_assoc($Recordset4);
$totalRows_Recordset4 = mysql_num_rows($Recordset4);
mysql_select_db($database_projectcon, $projectcon);
$query_Recordset5 = "SELECT count(name) FROM promool WHERE proid='$proid'";
$Recordset5 = mysql_query($query_Recordset5, $projectcon) or die(mysql_error());
$row_Recordset5 = mysql_fetch_assoc($Recordset5);
$totalRows_Recordset5 = mysql_num_rows($Recordset5);
session_start();?><!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=windows-874">
<title>Untitled Document</title>
<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>
<style type="text/css">
<!--
body {
background-color: #33CCFF;
}
.style31 {color: #000000; }
.style32 {color: #FF0000}
#Layer7 {
position:absolute;
left:350px;
top:1398px;
width:186px;
height:30px;
z-index:7;
}
#Layer8 {
position:absolute;
left:349px;
top:1113px;
width:249px;
height:32px;
z-index:7;
}
#Layer9 {
position:absolute;
left:121px;
top:356px;
width:154px;
height:1361px;
z-index:7;
background-color: #FFFFFF;
}
#Layer1 {
position:absolute;
left:406px;
top:1080px;
width:179px;
height:49px;
z-index:7;
}
.style42 {font-size: 24px}
.style43 {font-size: 14px}
.style44 {font-size: 12px}
.style45 {font-size: 16px}
-->
</style>
</head>
<body>
<div id="Layer2" style="position:absolute; left:135px; top:12px; width:710px; height:24px; z-index:2; background-color: #FF9933; layer-background-color: #FF9933; border: 1px none #000000;">
<div align="center" class="style42"><?php echo $row_Recordset1['name']; ?></div>
</div>
<div id="Layer3" style="position:absolute; left:271px; top:326px; width:327px; height:129px; z-index:3">
<p> </p>
<p> </p>
<p> </p>
<p align="center"> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p>
</p>
</div>
<div id="Layer4" style="position:absolute; left:217px; top:1170px; width:582px; height:510px; z-index:4">
<table width="573" border="1">
<tr>
<td width="116" bgcolor="#999999"><div align="center" class="style31">ชื่อพระเครื่อง</div></td>
<td width="441" bgcolor="#CCCCCC"><?php echo $row_Recordset3['name']; ?></td>
</tr>
<tr>
<td height="26" bgcolor="#999999"><div align="center" class="style31">รายละเอียดพระเครื่อง</div></td>
<td bgcolor="#CCCCCC"><label><?php echo $row_Recordset3['prodetail']; ?></label></td>
</tr>
<tr>
<td bgcolor="#999999"><div align="center" class="style31">ราคาปัจจุบัน</div></td>
<td bgcolor="#CCCCCC"><?php echo $row_Recordset3['propriceupper']; ?></td>
</tr>
<tr>
<td bgcolor="#999999"><div align="center"><span class="style31">เพิ่มขึ้นครั้งละ</span></div></td>
<td bgcolor="#CCCCCC"><?php echo $row_Recordset3['propricelower']; ?></td>
</tr>
<tr>
<td bgcolor="#999999"><div align="center" class="style31">วันเปิดประมูล</div></td>
<td bgcolor="#CCCCCC"><?php echo $row_Recordset3['datestart']; ?></td>
</tr>
<tr>
<td bgcolor="#999999"><div align="center" class="style31">วันปิดประมูล</div></td>
<td bgcolor="#CCCCCC"><span class="style32"><?php echo $row_Recordset3['datestop']; ?></span></td>
</tr>
<tr>
<td bgcolor="#999999"><span class="style31">ผู้ตั้งประมูล</span></td>
<td bgcolor="#CCCCCC"><?php echo $row_Recordset3['proname']; ?></td>
</tr>
<tr>
<td height="33" bgcolor="#999999">หมายเลขบัญชี</td>
<td bgcolor="#CCCCCC"><table width="281" border="0">
<tr>
<td width="62"><span class="style43">ชื่อบัญชี</span></td>
<td width="209"><div align="left"><?php echo $row_Recordset3['account']; ?></div></td>
</tr>
<tr>
<td><span class="style43">ธนาคาร</span></td>
<td><div align="left"><?php echo $row_Recordset3['bank']; ?></div></td>
</tr>
<tr>
<td><span class="style43">สาขา</span></td>
<td><div align="left"><?php echo $row_Recordset3['banch']; ?></div></td>
</tr>
<tr>
<td><span class="style43">หมายเลขบัญชี</span></td>
<td><div align="left"><?php echo $row_Recordset3['idaccount']; ?></div></td>
</tr>
<tr>
<td><span class="style43">สาขา</span></td>
<td><div align="left"><?php echo $row_Recordset3['type']; ?></div></td>
</tr>
</table>
<p class="style45"> </p></td>
</tr>
</table>
</div>
<div id="Layer5" style="position:absolute; left:252px; top:1687px; width:434px; height:88px; z-index:5">
<table width="484" border="1">
<tr bgcolor="#66CC99"><?php
$con = mysql_connect("localhost","","")
or die ("Connect Error".mysql_error());
mysql_select_db("project");
$sql = "select max(price) max from promool where proid='$proid' ";
$result = mysql_query($sql)
or die ("error");
while($rs = mysql_fetch_array($result))
{
$max=$rs['max'];
?>
<td width="83"><div align="right" class="style44">
<div align="center">ราคาปัจจุบัน: </div>
<label></label>
</div> </td>
<td width="385"><?php echo $max;} ?></td>
</tr>
<tr bgcolor="#66CC99">
<td><div align="center"><span class="style44">ราคาถ้ากดประมูล</span></div></td>
<td><form name="form3" method="post" action="">
<input name="price" type="text" id="price" value="<?php echo $row_Recordset3['propriceupper']; ?>">
</form></td>
</tr>
<tr bgcolor="#66CC99">
<td><div align="right" class="style44">
<div align="center">เพิ่มขึ้นครั้งละ:</div>
</div></td>
<td><?php echo $row_Recordset3['propricelower']; ?>
<form name="form4" method="post" action="">
<input name="proid" type="hidden" id="proid" value="<?php echo $proid;?>">
<label></label>
</form> </td>
</tr>
<tr bgcolor="#66CC99">
<td height="69"><div align="right" class="style44">
<div align="center">ต้องการเสนอราคา</div>
</div></td>
<td><form name="form1" method="post" action="codepramool.php?memberid=<?php echo $member1; ?>&proid=<?php echo $row_Recordset3['proid'] ?>&auctionid=<?php echo $row_Recordset3['auctionid']?>"">
<label></label>
<div align="center">
<input type="submit" name="Submit" value="ส่งราคาประมูล">
</div>
</form></td>
</tr>
</table>
</div>
<div id="Layer6" style="position:absolute; left:245px; top:1913px; width:470px; height:82px; z-index:6">
<table width="466" border="1">
<tr bgcolor="#339933">
<td width="190"><span class="style43">ผู้เสนอราคา</span></td>
<td width="95"><span class="style43">ราคา</span></td>
<td width="159"><span class="style43">เวลา</span></td>
</tr>
<?php do { ?>
<tr bgcolor="#66CC66">
<td><span class="style44"><?php echo $row_Recordset4['name']; ?></span></td>
<td><span class="style44"><?php echo $row_Recordset4['price']; ?></span></td>
<td><span class="style44"> <?php echo $row_Recordset4['date']; ?></span></td>
</tr>
<?php } while ($row_Recordset4 = mysql_fetch_assoc($Recordset4)); ?>
</table>
คนประมูลทั้งหมด <?php echo $row_Recordset5['count(name)']; ?> คน
<table width="200" border="1">
<tr><?php
$con = mysql_connect("localhost","","")
or die ("Connect Error".mysql_error());
mysql_select_db("project");
$sql = "select max(price) max from promool where proid='$proid' ";
$result = mysql_query($sql)
or die ("error");
while($rs = mysql_fetch_array($result))
{
$max=$rs['max'];
?>
<td> ราคาปิดประมูล <?php echo $max;} ?></td>
</tr>
</table>
</div>
<div id="Layer1">
<form name="form2" method="post" action="">
<div align="center">
<p><a title="แจ้งตรวจสอบพระ" href="emailauction.php"><img src="picture/examrequest.jpg" width="155" height="33" border="0"></a> </p>
<p> </p>
</div>
</form>
</div>
<p> </p>
<p align="center">
<?php
$con = mysql_connect("localhost","","")
or die ("cannot connect".mysql_error());
mysql_select_db("project");
$sql = "select * from product where proid = '$proid'";
$result = mysql_query($sql)
or die("select error".mysql_error());
$rs = mysql_fetch_array($result);
?>
<?
if ($rs["pic1"] !="")
echo " <p align=center><img src= $rs[pic1] width=400 height=300 /></p>";
if ($rs["pic2"] !="")
echo " <p align=center><img src= $rs[pic2] width=400 height=300/></p>";
if ($rs["pic3"] !="")
echo " <p align=center><img src= $rs[pic3] width=400 height=300/></p>";
?> <a title="แจ้งตรวจสอบพระ" href="emailauction.php"></a></p>
</body>
</html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset3);
mysql_free_result($Recordset2);
mysql_free_result($Recordset4);
mysql_free_result($Recordset5);
?>
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
5 มี.ค. 2551 15:25:12 |
By :
nininan |
View :
1496 |
Reply :
0 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
|
| |
|
 Load balance : Server 05
|
