001.
<?
002.
@session_start();
003.
ob_start();
004.
$usermem
=
$_SESSION
[
"usermem"
];
005.
require_once
"include/connectdb.php"
;
006.
require_once
"include/connect.php"
;
007.
require_once
"include/tdate.php"
;
008.
if
(
empty
(
$usermem
))
009.
{
010.
$showmember
= "
011.
<table width=100% border=0 align=center cellpadding=1 cellspacing=1>
012.
<form method=post action=SignIn.php><tr>
013.
<td width=32% align=right><font size=2 color=#ffffff>ชื่อสมาชิก :</font></td>
014.
<td width=68%><input name=usermem type=text size=15></td>
015.
</tr>
016.
<tr>
017.
<td align=right><font size=2 color=#ffffff>รหัสผ่าน :</font></td>
018.
<td><input name=passmem type=password size=15></td>
019.
</tr>
020.
<tr>
021.
<td> </td>
022.
<td><input name=submit type=submit
class
=submit value=เข้าสู่ระบบ!></td>
023.
</tr>
024.
<tr>
025.
<td> </td>
026.
<td><font size=2 color=#ffff00>!</font> <a href=ForgetPass.php><font size=2 color=#ffffff>ลืมรหัสผ่าน</font></a></td>
027.
</tr></form>
028.
</table>
029.
";
030.
}
else
{
031.
$sql
=
"select * from member where usermem='$usermem'"
;
032.
$db_query
=mysql_db_query(
$db
,
$sql
);
033.
$result
=mysql_fetch_array(
$db_query
);
034.
$idxx
=
$result
[id];
035.
$usename
=
$result
[name];
036.
$user_mem
=
$result
[usermem];
037.
$pass_mem
=
$result
[passmem];
038.
$showmember
= "
039.
<div align=center><font size=2 color=#ffffff><img src=images/user.gif width=25 height=15>ยินดีต้อนรับ : <font color=#FFFF00>
$usename
</font>
040.
<br><font size=2 color=#ffffff>[</font> <a href=CheckMyOrder.php><font size=2 color=#ffffff>ประวัติสั่งซื้อสินค้า</font></a> <font size=2 color=#ffffff>]
041.
<br><font size=2 color=#ffffff>[</font> <a href=ChangePass.php><font size=2 color=#ffffff>เปลี่ยนรหัสผ่าน</font></a> <font size=2 color=#ffffff>]
042.
<br><font size=2 color=#ffffff>[</font> <a href=Profiles.php><font size=2 color=#ffffff>ข้อมูลส่วนตัว</font></a> <font size=2 color=#ffffff>]
043.
<br>[</font><a href=Logout.php><font size=2 color=#ffffff>ออกจากระบบ</font></a><font size=2 color=#ffffff>]</font>
044.
</div>
045.
";
046.
$myorder
=
"<a href=CheckMyOrder.php><img src=images/myorder.gif border=0><a>"
;
047.
}
048.
$address_new
=
"$_POST[address] ถนน $_POST[road] ตำบล/แขวง : $_POST[district] อำเภอ/แขวง : $_POST[city] จ.$_POST[province] $_POST[zipcode] ประเทศ : $_POST[country]"
;
049.
$randnum
= rand(111111,999999);
050.
051.
052.
$sql_numcode
=
"select * from tb_order"
;
053.
$db_queryr
=mysql_db_query(
$db
,
$sql_numcode
);
054.
$result_numcode
=mysql_fetch_array(
$db_queryr
);
055.
$num_rows_code
=mysql_num_rows(
$db_queryr
);
056.
$run_number
=
$num_rows_code
+1;
057.
$rand_num
=sprintf(
"%05d"
,
$run_number
);
058.
059.
$userCus
=
$_GET
[user];
060.
$passCus
=
$_GET
[pass];
061.
$sent_rate
=
$_GET
[sr];
062.
$today
=
date
(
"d-m-Y"
);
063.
$sql
=
"select * from member where usermem='$usermem' "
;
064.
$result
=mysql_db_query(
$db
,
$sql
);
065.
$rs
=mysql_fetch_array(
$result
);
066.
067.
$dateorder
=
date
(
"$e_date"
);
068.
069.
$dateime1
=
$dateorder
;
070.
$date
=
explode
(
'/'
,
$dateime1
);
071.
$newdate
= implode(
'-'
,
array
(
$date
[2],
$date
[1],
$date
[0]));
072.
073.
for
(
$n
=0;
$n
<
count
(
$sess_idproduct
);
$n
++) {
074.
$sql1
= insert(
"pId,refid,pNum,pPrice,date,id_cus"
,
" '$sess_idproduct[$n]','$randnum','$sess_num[$n]','$sess_price[$n]','$newdate','$usermem' "
,
"tb_order"
);
075.
mysql_db_query(
$db
,
$sql1
);
076.
077.
$sql_data
=
"update products set amount = amount-$sess_num[$n] where productscode = '$sess_idproduct[$n]'"
;
078.
mysql_query(
$sql_data
);
079.
080.
$sql_update_address
=
"update tb_order set address2 = '$address_new' where refid = '$randnum'"
;
081.
mysql_query(
$sql_update_address
);
082.
083.
$sql_stats
=
"update products set stats = stats+1 where productscode = '$sess_idproduct[$n]'"
;
084.
mysql_query(
$sql_stats
);
085.
}
086.
?>
087.
<html>
088.
<head>
089.
<title>:: <?
echo
"$headtxt_web"
; ?> ::</title>
090.
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=tis-620"
>
091.
<link href=
"css/instyle.css"
rel=
"stylesheet"
type=
"text/css"
>
092.
<link href=
"css/style1.css"
rel=
"stylesheet"
type=
"text/css"
>
093.
<link href=
"css/style.css"
rel=
"stylesheet"
type=
"text/css"
>
094.
<link rel=
"stylesheet"
href=
"css/lightbox.css"
type=
"text/css"
media=
"screen"
/>
095.
096.
<script src=
"css/jquery-latest.pack.js"
type=
"text/javascript"
></script>
097.
<script src=
"css/jquery.lightbox.js"
type=
"text/javascript"
></script>
098.
<script>
099.
$(document).ready(
function
(){
100.
$(
".lightbox"
).lightbox();
101.
});
102.
103.
</script>
104.
<LINK href=
"css/contentslider2.css"
type=text/css rel=stylesheet>
105.
<STYLE type=text/css>BODY {
106.
MARGIN-TOP: 0px; MARGIN-LEFT: 0px
107.
}
108.
</STYLE>
109.
110.
<SCRIPT src=
"js/contentslider.js"
type=text/javascript>
111.
112.
113.
</SCRIPT>
114.
<script language=
"JavaScript"
type=
"text/JavaScript"
>
115.
<!--
116.
function
MM_swapImgRestore() {
117.
var
i,x,a=document.MM_sr;
for
(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
118.
}
119.
120.
function
MM_preloadImages() {
121.
var
d=document;
if
(d.images){
if
(!d.MM_p) d.MM_p=
new
Array();
122.
var
i,j=d.MM_p.length,a=MM_preloadImages.arguments;
for
(i=0; i<a.length; i++)
123.
if
(a[i].indexOf(
"#"
)!=0){ d.MM_p[j]=
new
Image; d.MM_p[j++].src=a[i];}}
124.
}
125.
126.
function
MM_findObj(n, d) {
127.
var
p,i,x;
if
(!d) d=document;
if
((p=n.indexOf(
"?"
))>0&&parent.frames.length) {
128.
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
129.
if
(!(x=d[n])&&d.all) x=d.all[n];
for
(i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
130.
for
(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
131.
if
(!x && d.getElementById) x=d.getElementById(n);
return
x;
132.
}
133.
134.
function
MM_swapImage() {
135.
var
i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=
new
Array;
for
(i=0;i<(a.length-2);i+=3)
136.
if
((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x;
if
(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
137.
}
138.
139.
</script>
140.
<style>
141.
.jc{
142.
position:relative;
143.
}
144.
</style>
145.
146.
<script language=
"JavaScript1.2"
>
147.
var
ns6=document.getElementById&&!document.all
148.
var
ie=document.all
149.
150.
var
customcollect=
new
Array()
151.
var
i=0
152.
153.
function
jiggleit(num){
154.
if
((!document.all&&!document.getElementById))
return
;
155.
customcollect[num].style.left=(parseInt(customcollect[num].style.left)==-1)? customcollect[num].style.left=1 : customcollect[num].style.left=-1
156.
}
157.
158.
function
init(){
159.
if
(ie){
160.
while
(
eval
(
"document.all.jiggle"
+i)!=null){
161.
customcollect[i]=
eval
(
"document.all.jiggle"
+i)
162.
i++
163.
}
164.
}
165.
else
if
(ns6){
166.
while
(document.getElementById(
"jiggle"
+i)!=null){
167.
customcollect[i]= document.getElementById(
"jiggle"
+i)
168.
i++
169.
}
170.
}
171.
172.
if
(customcollect.length==1)
173.
setInterval(
"jiggleit(0)"
,80)
174.
else
if
(customcollect.length>1)
175.
for
(y=0;y<customcollect.length;y++){
176.
var
tempvariable=
'setInterval("jiggleit('
+y+
')",'
+
'100)'
177.
eval
(tempvariable)
178.
}
179.
}
180.
window.onload=init
181.
</script>
182.
</head>
183.
<body bgcolor=
"#ffffff"
background=
"images/bg.gif"
>
184.
<table width=
"1000"
border=
"0"
align=
"center"
cellpadding=
"0"
cellspacing=
"0"
>
185.
<!-- fwtable fwsrc=
"Untitled"
fwbase=
"home.jpg"
fwstyle=
"Dreamweaver"
fwdocid =
"742308039"
fwnested=
"0"
-->
186.
<tr>
187.
<td><img src=
"images/spacer.gif"
width=
"423"
height=
"1"
border=
"0"
alt=
""
></td>
188.
<td><img src=
"images/spacer.gif"
width=
"16"
height=
"1"
border=
"0"
alt=
""
></td>
189.
<td><img src=
"images/spacer.gif"
width=
"225"
height=
"1"
border=
"0"
alt=
""
></td>
190.
<td><img src=
"images/spacer.gif"
width=
"315"
height=
"1"
border=
"0"
alt=
""
></td>
191.
<td><img src=
"images/spacer.gif"
width=
"21"
height=
"1"
border=
"0"
alt=
""
></td>
192.
<td><img src=
"images/spacer.gif"
width=
"1"
height=
"1"
border=
"0"
alt=
""
></td>
193.
</tr>
194.
195.
<tr>
196.
<td colspan=
"5"
><img name=
"home_r1_c1"
src=
"images/home_r1_c1.jpg"
width=
"1000"
height=
"20"
border=
"0"
alt=
""
></td>
197.
<td><img src=
"images/spacer.gif"
width=
"1"
height=
"20"
border=
"0"
alt=
""
></td>
198.
</tr>
199.
<tr>
200.
<td><img name=
"home_r2_c1"
src=
"images/home_r2_c1.jpg"
width=
"423"
height=
"133"
border=
"0"
alt=
""
></td>
201.
<td colspan=
"2"
><img name=
"home_r2_c2"
src=
"images/home_r2_c2.jpg"
width=
"241"
height=
"133"
border=
"0"
alt=
""
></td>
202.
<td background=
"images/home_r2_c4.jpg"
><div align=
"center"
> <?
echo
"$showmember"
; ?></div></td>
203.
<td><img name=
"home_r2_c5"
src=
"images/home_r2_c5.jpg"
width=
"21"
height=
"133"
border=
"0"
alt=
""
></td>
204.
<td><img src=
"images/spacer.gif"
width=
"1"
height=
"133"
border=
"0"
alt=
""
></td>
205.
</tr>
206.
<tr>
207.
<td colspan=
"2"
><img src=
"images/home_r3_c1.jpg"
alt=
""
name=
"home_r3_c1"
width=
"439"
height=
"62"
border=
"0"
usemap=
"#home_r3_c1Map"
></td>
208.
<td colspan=
"3"
><img src=
"images/home_r3_c3.jpg"
alt=
""
name=
"home_r3_c3"
width=
"561"
height=
"62"
border=
"0"
usemap=
"#home_r3_c3Map"
></td>
209.
<td><img src=
"images/spacer.gif"
width=
"1"
height=
"62"
border=
"0"
alt=
""
></td>
210.
</tr>
211.
<tr>
212.
<td colspan=
"5"
bgcolor=
"#FFFFFF"
><div align=
"center"
>
213.
<table width=
"100%"
border=
"0"
cellspacing=
"0"
cellpadding=
"0"
>
214.
<tr valign=
"top"
>
215.
<td width=
"190"
><table width=
"100%"
border=
"0"
cellspacing=
"1"
cellpadding=
"1"
>
216.
<tr>
217.
<td><img src=
"images/h_prdtype.jpg"
width=
"187"
height=
"32"
></td>
218.
</tr>
219.
<tr>
220.
<td>
221.
<?
222.
$page
=
$_GET
[
'page'
];
223.
$select_type
=
"select * from productstype order by id asc"
;
224.
$query_select
=mysql_query(
$select_type
);
225.
$num_rows
=mysql_num_rows(
$query_select
);
226.
227.
if
(
$num_rows
<1){
228.
echo
"<br><br><center><font color=#666666 face=tahoma size=2><b>ยังไม่มีการเพิ่มข้อมูลค่ะ</b></font></center>"
;
229.
}
else
{
230.
$select
=
"select * from productstype order by id asc"
;
231.
$q_ry
= mysql_query(
$select
);
232.
$num_rows
=mysql_num_rows(
$q_ry
);
233.
$pagesize
=20;
234.
$rt
=
$num_rows
%
$pagesize
;
235.
if
(
$rt
!=0)
236.
{
237.
$totalpage
=
floor
(
$num_rows
/
$pagesize
)+1;
238.
}
239.
else
240.
{
241.
$totalpage
=
floor
(
$num_rows
/
$pagesize
);
242.
$toppic_id
=1;
243.
}
244.
if
(
empty
(
$page
))
245.
{
246.
$page
=1;
247.
}
248.
mysql_free_result(
$q_ry
);
249.
$goto
=(
$page
-1)*
$pagesize
;
250.
$sql_select_mem
=
"Select * From productstype order by id asc limit $goto,$pagesize"
;
251.
$fect
=mysql_query(
$sql_select_mem
);
252.
if
(!
$fect
)
253.
{
254.
(
"ติดต่อฐานข้อมูลไม่ได้"
.mysql_error());
255.
exit
;
256.
}
257.
258.
$bgcount
=0;
259.
while
(
$rows
=mysql_fetch_array(
$fect
))
260.
{
261.
$idx
=
$rows
[
'id'
];
262.
$productstypecode
=
$rows
[
'productstypecode'
];
263.
$productstypename
=
$rows
[
'productstypename'
];
264.
$bgcount
=
$bgcount
+1;
265.
$bgmod
=
$bgcount
%2;
266.
if
(
$bgmod
==0){
267.
$bgcolor
=
"#E9E9E8"
;
268.
}
else
{
269.
$bgcolor
=
"#FFFFFF"
;
270.
}
271.
272.
$s_num
=
"select * from products where productstypecode = '$productstypecode'"
;
273.
$query_select_num
=mysql_query(
$s_num
);
274.
$snum
=mysql_num_rows(
$query_select_num
);
275.
?>
276.
<table width=
"100%"
border=
"0"
cellspacing=
"1"
cellpadding=
"1"
>
277.
<tr>
278.
<td height=
"23"
> <div align=
"left"
></div>
279.
<div align=
"left"
></div>
280.
<div align=
"center"
> </div>
281.
<div align=
"left"
><img src=
"images/opened.gif"
width=
"17"
height=
"17"
><font color=
"#993300"
size=
"2"
>
282.
<?
echo
"<a href=ProductList.php?PRD=$productstypecode>$productstypename</a> ($snum)"
; ?></font></div></td>
283.
</tr>
284.
<tr>
285.
<td height=
"5"
><img src=
"images/inline.jpg"
width=
"184"
height=
"3"
></td>
286.
</tr>
287.
</table>
288.
<?
289.
}
290.
}
291.
?>
292.
</td>
293.
</tr>
294.
<tr>
295.
<td> </td>
296.
</tr>
297.
</table></td>
298.
<td><table width=
"100%"
border=
"0"
cellspacing=
"1"
cellpadding=
"1"
>
299.
<tr>
300.
<td><img src=
"images/step3.jpg"
width=
"796"
height=
"64"
></td>
301.
</tr>
302.
<tr>
303.
<td><table width=
"100%"
border=
"0"
cellspacing=
"1"
cellpadding=
"1"
>
304.
<tr>
305.
<td><table width=
"38%"
border=
"0"
cellspacing=
"1"
cellpadding=
"1"
>
306.
<tr>
307.
<td bgcolor=
"#ECE7D6"
><strong><font size=
"2"
>ผลการสั่งซื้อ</font></strong></td>
308.
</tr>
309.
</table></td>
310.
</tr>
311.
<tr>
312.
<td><br> <img src=
"images/loading.gif"
width=
"32"
height=
"32"
>
313.
<font size=
"2"
>ข้อมูลการสั่งซื้อได้ส่งไปเรียบร้อยแล้ว</font>
314.
</td>
315.
</tr>
316.
<tr>
317.
<td><br> <br> <font size=
"2"
><strong>การสั่งซื้อมีรายละเอียดดังนี้
318.
</strong></font></td>
319.
</tr>
320.
<tr>
321.
<td><img src=
"images/lineorder.jpg"
width=
"800"
height=
"3"
></td>
322.
</tr>
323.
<tr>
324.
<td><br> <table width=
"38%"
border=
"0"
cellspacing=
"1"
cellpadding=
"1"
>
325.
<tr>
326.
<td bgcolor=
"#ECE7D6"
><strong><font size=
"2"
>หมายเลขการสั่งซื้อ</font></strong></td>
327.
</tr>
328.
</table></td>
329.
</tr>
330.
<tr>
331.
<td><font size=
"2"
>Order No : <font color=
"#FF0000"
><?
echo
"$randnum"
; ?></font></font></td>
332.
</tr>
333.
<tr>
334.
<td><font size=
"2"
>สถานะการสั่งซื้อ : <font color=
"#FF0000"
>รอการชำระเงิน</font></font></td>
335.
</tr>
336.
<tr>
337.
<td><font size=
"2"
>วันที่สั่งซื้อ : <font color=
"#FF0000"
><?
echo
"$e_date $etime"
; ?></font></font></td>
338.
</tr>
339.
<tr>
340.
<td> </td>
341.
</tr>
342.
<tr>
343.
<td><table width=
"38%"
border=
"0"
cellspacing=
"1"
cellpadding=
"1"
>
344.
<tr>
345.
<td bgcolor=
"#ECE7D6"
><strong><font size=
"2"
>รายการสินค้าที่สั่งซื้อ</font></strong></td>
346.
</tr>
347.
</table></td>
348.
</tr>
349.
<tr>
350.
<td><TABLE WIDTH=
"100%"
BORDER=
"0"
align=
"center"
cellpadding=
"1"
cellspacing=
"1"
bgcolor=
"#CCCCCC"
>
351.
<TR BGCOLOR=
"#f4f4f4"
>
352.
<TD WIDTH=
"15%"
height=
"34"
> <CENTER>
353.
<font size=
"3"
><B>รหัสสินค้า</B> </font></CENTER></TD>
354.
<TD WIDTH=
"50%"
> <CENTER>
355.
<font size=
"3"
><b>รายการสินค้าที่ได้สั่งซื้อ</b>
356.
</font></CENTER></TD>
357.
<TD WIDTH=
"12%"
> <CENTER>
358.
<font size=
"3"
><B>จำนวน</B></font></CENTER></TD>
359.
<TD WIDTH=
"10%"
> <CENTER>
360.
<font size=
"3"
><B>ราคา</B></font></CENTER></TD>
361.
<TD WIDTH=
"13%"
> <CENTER>
362.
<font size=
"3"
><B>รวม</B></font></CENTER></TD>
363.
</TR>
364.
<?
365.
for
(
$i
=0;
$i
<
count
(
$sess_idproduct
);
$i
++) {
366.
$total_unit
=
$sess_num
[
$i
]*
$sess_price
[
$i
];
367.
$total
=
$total
+
$total_unit
;
368.
$prd_code
=sprintf(
"%05d"
,
$sess_idproduct
[
$i
]);
369.
$a
=
$sess_num
[
$i
] *150 ;
370.
$c
=number_format(
$total_unit
,2,
'.'
,
','
) ;
371.
$total_all
=
$total
;
372.
373.
echo
"
374.
375.
<TR bgcolor=
'#FFFFFF'
height=
'22'
>
376.
<TD><center><font size=2>
$sess_idproduct
[
$i
]</font></center></TD>
377.
<TD><font size=2>
$sess_name_prd
[
$i
]</font></TD>
378.
<TD><CENTER><font size=2>
$sess_num
[
$i
]</font></CENTER></TD>
379.
<TD><CENTER><font size=2>
$sess_price
[
$i
]</font></CENTER></TD>
380.
<TD><div align=center><font size=2>
$c
</font></div></TD>
381.
382.
</TR>";
383.
}
384.
?>
385.
</TABLE>
386.
<table width=
"100%"
border=
"0"
align=
"center"
cellspacing=
"0"
>
387.
<tr>
388.
<td width=
"473"
height=
"25"
><div align=
"right"
></div></td>
389.
<td width=
"118"
><div align=
"center"
> <font size=
"2"
>
390.
</font></div></td>
391.
</tr>
392.
</table>
393.
<font size=
"2"
><br>
394.
</font> <table width=
"83%"
border=
"0"
align=
"center"
cellpadding=
"0"
cellspacing=
"0"
>
395.
<tr>
396.
<td width=
"418"
> <div align=
"right"
><font size=
"3"
><strong>รวมเป็นเงินทั้งหมดที่คุณต้องชำระ</strong></font></div></td>
397.
<td width=
"118"
> <font size=
"3"
><u>
398.
<?
399.
$a
=number_format(
$total_all
,2,
'.'
,
','
) ;
400.
echo
"<center><b>$a</b></center>"
;
401.
?>
402.
</u></font></td>
403.
<td width=
"66"
><font size=
"3"
><strong>บาท</strong></font></td>
404.
</tr>
405.
<tr>
406.
<td colspan=
"3"
><div align=
"center"
></div></td>
407.
</tr>
408.
</table></td>
409.
</tr>
410.
<tr>
411.
<td><br> <img src=
"images/lineorder.jpg"
width=
"800"
height=
"3"
><br>
412.
</td>
413.
</tr>
414.
<tr>
415.
<td><table width=
"38%"
border=
"0"
cellspacing=
"1"
cellpadding=
"1"
>
416.
<tr>
417.
<td bgcolor=
"#ECE7D6"
><strong><font size=
"2"
>วิธีการชำระเงิน</font></strong></td>
418.
</tr>
419.
</table></td>
420.
</tr>
421.
<tr>
422.
<td><font size=
"2"
><br>
423.
<strong> ชำระผ่านธนาคารโดยการโอนเงิน</strong><br>
424.
ชำระเงินเข้าบัญชี </font></td>
425.
</tr>
426.
<tr>
427.
<td bgcolor=
"#ECE7D6"
> <table width=
"800"
border=
"0"
cellspacing=
"1"
cellpadding=
"1"
>
428.
<tr>
429.
<td width=
"116"
><font size=
"2"
><strong>ธนาคาร</strong></font></td>
430.
<td width=
"171"
><font size=
"2"
><strong>ชื่อบัญชี</strong></font></td>
431.
<td width=
"156"
><font size=
"2"
><strong>ประเภทบัญชี</strong></font></td>
432.
<td width=
"161"
><font size=
"2"
><strong>สาขา</strong></font></td>
433.
<td width=
"180"
><font size=
"2"
><strong>เลขที่บัญชี</strong></font></td>
434.
</tr>
435.
</table></td>
436.
</tr>
437.
<tr>
438.
<td>
439.
<?
440.
$page
=
$_GET
[
'page'
];
441.
442.
$select_type
=
"select * from bank order by id asc"
;
443.
$query_select
=mysql_query(
$select_type
);
444.
$num_rows
=mysql_num_rows(
$query_select
);
445.
446.
if
(
$num_rows
<1){
447.
echo
"<br><br><center><font color=#666666 face=tahoma size=2><b>ยังไม่มีการเพิ่มข้อมูลค่ะ</b></font></center>"
;
448.
}
else
{
449.
$select
=
"select * from bank order by id asc"
;
450.
$q_ry
= mysql_query(
$select
);
451.
$num_rows
=mysql_num_rows(
$q_ry
);
452.
$pagesize
=20;
453.
$rt
=
$num_rows
%
$pagesize
;
454.
if
(
$rt
!=0)
455.
{
456.
$totalpage
=
floor
(
$num_rows
/
$pagesize
)+1;
457.
}
458.
else
459.
{
460.
$totalpage
=
floor
(
$num_rows
/
$pagesize
);
461.
$toppic_id
=1;
462.
}
463.
if
(
empty
(
$page
))
464.
{
465.
$page
=1;
466.
}
467.
mysql_free_result(
$q_ry
);
468.
$goto
=(
$page
-1)*
$pagesize
;
469.
$sql_select_mem
=
"Select * From bank order by id asc limit $goto,$pagesize"
;
470.
$fect
=mysql_query(
$sql_select_mem
);
471.
if
(!
$fect
)
472.
{
473.
(
"ติดต่อฐานข้อมูลไม่ได้"
.mysql_error());
474.
exit
;
475.
}
476.
477.
$bgcount
=0;
478.
while
(
$rows
=mysql_fetch_array(
$fect
))
479.
{
480.
$idx
=
$rows
[
'id'
];
481.
$accname
=
$rows
[
'accname'
];
482.
$bankname
=
$rows
[
'bankname'
];
483.
$accno
=
$rows
[
'accno'
];
484.
$branch
=
$rows
[
'branch'
];
485.
$acctype
=
$rows
[
'acctype'
];
486.
$bgcount
=
$bgcount
+1;
487.
$bgmod
=
$bgcount
%2;
488.
if
(
$bgmod
==0){
489.
$bgcolor
=
"#E9E9E8"
;
490.
}
else
{
491.
$bgcolor
=
"#FFFFFF"
;
492.
}
493.
?>
494.
<table width=
"800"
border=
"0"
cellspacing=
"1"
cellpadding=
"1"
>
495.
<tr>
496.
<td width=
"116"
><?
echo
"<font size=2 color=#000000>$bankname</font>"
; ?></td>
497.
<td width=
"171"
><?
echo
"<font size=2 color=#000000>$accname</font>"
; ?></td>
498.
<td width=
"156"
><?
echo
"<font size=2 color=#000000>$acctype</font>"
; ?></td>
499.
<td width=
"161"
><?
echo
"<font size=2 color=#000000>$branch</font>"
; ?></td>
500.
<td width=
"180"
><?
echo
"<font size=2 color=#000000>$accno</font>"
; ?></td>
501.
</tr>
502.
</table>
503.
<?
504.
}
505.
}
506.
?>
507.
</td>
508.
</tr>
509.
<tr>
510.
<td><br> <img src=
"images/lineorder.jpg"
width=
"800"
height=
"3"
><br>
511.
<br> <table width=
"38%"
border=
"0"
cellspacing=
"1"
cellpadding=
"1"
>
512.
<tr>
513.
<td bgcolor=
"#ECE7D6"
><strong><font size=
"2"
>ข้อมูลผู้สั่งซื้อ</font></strong></td>
514.
</tr>
515.
</table></td>
516.
</tr>
517.
<tr>
518.
<td><font size=
"2"
>
519.
<?
520.
$sql
=
"select * from member where usermem='$usermem' "
;
521.
$result
=mysql_db_query(
$db
,
$sql
);
522.
$rs
=mysql_fetch_array(
$result
);
523.
?>
524.
</font> <table width=
"99%"
border=
"0"
align=
"center"
cellpadding=
"2"
cellspacing=
"2"
>
525.
<tr>
526.
<td width=
"96"
valign=
"top"
><div align=
"left"
><font size=
"2"
>ชื่อ</font></div></td>
527.
<td width=
"8"
valign=
"top"
><font size=
"2"
>:</font></td>
528.
<td width=
"668"
valign=
"top"
><font size=
"2"
><?
echo
"$rs[name]"
; ?></font></td>
529.
</tr>
530.
<tr>
531.
<td valign=
"top"
><div align=
"left"
><font size=
"2"
>อีเมล์</font></div></td>
532.
<td valign=
"top"
><font size=
"2"
>:</font></td>
533.
<td valign=
"top"
><font size=
"2"
>
534.
<label><?
echo
"$rs[email]"
; ?></label>
535.
</font></td>
536.
</tr>
537.
</table></td>
538.
</tr>
539.
<tr>
540.
<td><br> <table width=
"38%"
border=
"0"
cellspacing=
"1"
cellpadding=
"1"
>
541.
<tr>
542.
<td bgcolor=
"#ECE7D6"
><strong><font size=
"2"
>สถานที่ในการจัดส่ง</font></strong></td>
543.
</tr>
544.
</table></td>
545.
</tr>
546.
<tr>
547.
<td><table width=
"99%"
border=
"0"
align=
"center"
cellpadding=
"2"
cellspacing=
"2"
>
548.
<tr>
549.
<td width=
"96"
valign=
"top"
><div align=
"left"
><font size=
"2"
>ชื่อ</font></div></td>
550.
<td width=
"8"
valign=
"top"
><font size=
"2"
>:</font></td>
551.
<td width=
"668"
valign=
"top"
><font size=
"2"
><?
echo
"$rs[name]"
; ?></font></td>
552.
</tr>
553.
<tr>
554.
<td valign=
"top"
><div align=
"left"
><font size=
"2"
>ที่อยู่</font></div></td>
555.
<td valign=
"top"
><font size=
"2"
>:</font></td>
556.
<td valign=
"top"
><font size=
"2"
>
557.
<label>
558.
<?
559.
echo
"$address_new"
;
560.
?>
561.
</label>
562.
</font></td>
563.
</tr>
564.
<tr>
565.
<td valign=
"top"
><div align=
"left"
><font size=
"2"
>เบอร์โทรศัพท์</font></div></td>
566.
<td valign=
"top"
><font size=
"2"
>:</font></td>
567.
<td valign=
"top"
><font size=
"2"
>
568.
<label><?
echo
"$rs[phone]"
; ?></label>
569.
</font></td>
570.
</tr>
571.
<tr>
572.
<td valign=
"top"
><div align=
"left"
><font size=
"2"
>อีเมล์</font></div></td>
573.
<td valign=
"top"
><font size=
"2"
>:</font></td>
574.
<td valign=
"top"
><font size=
"2"
>
575.
<label><?
echo
"$rs[email]"
; ?></label>
576.
</font></td>
577.
</tr>
578.
</table>
579.
<div align=
"center"
><br>
580.
<br>
581.
<br>
582.
</div></td>
583.
</tr>
584.
</table></td>
585.
</tr>
586.
</table></td>
587.
</tr>
588.
</table>
589.
</div></td>
590.
<td><img src=
"images/spacer.gif"
width=
"1"
height=
"25"
border=
"0"
alt=
""
></td>
591.
</tr>
592.
<tr>
593.
<td colspan=
"2"
><img src=
"images/home_r5_c1.jpg"
alt=
""
name=
"home_r5_c1"
width=
"439"
height=
"39"
border=
"0"
usemap=
"#home_r5_c1Map"
></td>
594.
<td colspan=
"3"
><img src=
"images/home_r5_c3.jpg"
alt=
""
name=
"home_r5_c3"
width=
"561"
height=
"39"
border=
"0"
usemap=
"#home_r5_c3Map"
></td>
595.
<td><img src=
"images/spacer.gif"
width=
"1"
height=
"39"
border=
"0"
alt=
""
></td>
596.
</tr>
597.
<tr>
598.
<td><img name=
"home_r6_c1"
src=
"images/home_r6_c1.jpg"
width=
"423"
height=
"71"
border=
"0"
alt=
""
></td>
599.
<td colspan=
"4"
background=
"images/home_r6_c2.jpg"
><font color=
"#FFFFFF"
size=
"2"
><?
echo
"$buttomtxt_web"
; ?></font></td>
600.
<td><img src=
"images/spacer.gif"
width=
"1"
height=
"71"
border=
"0"
alt=
""
></td>
601.
</tr>
602.
</table>
603.
<map name=
"home_r3_c1Map"
>
604.
<area shape=
"rect"
coords=
"13,20,79,50"
href=
"index.php"
>
605.
<area shape=
"rect"
coords=
"99,20,193,52"
href=
"Member.php"
>
606.
<area shape=
"rect"
coords=
"204,19,301,51"
href=
"Products.php"
>
607.
<area shape=
"rect"
coords=
"326,17,425,51"
href=
"Cart.php"
>
608.
</map>
609.
<map name=
"home_r3_c3Map"
>
610.
<area shape=
"rect"
coords=
"15,16,109,52"
href=
"Payment.php"
>
611.
<area shape=
"rect"
coords=
"125,16,237,53"
href=
"ConfirmPayment.php"
>
612.
<area shape=
"rect"
coords=
"257,16,373,53"
href=
"CheckRef.php"
>
613.
<area shape=
"rect"
coords=
"383,14,458,55"
href=
"Webboard.php"
>
614.
<area shape=
"rect"
coords=
"472,13,547,51"
href=
"Contact.php"
>
615.
</map>
616.
<map name=
"home_r5_c1Map"
>
617.
<area shape=
"rect"
coords=
"10,5,84,33"
href=
"index.php"
>
618.
<area shape=
"rect"
coords=
"98,2,189,49"
href=
"Member.php"
>
619.
<area shape=
"rect"
coords=
"208,2,303,42"
href=
"Products.php"
>
620.
<area shape=
"rect"
coords=
"324,2,423,44"
href=
"Cart.php"
>
621.
</map>
622.
<map name=
"home_r5_c3Map"
>
623.
<area shape=
"rect"
coords=
"12,-2,100,36"
href=
"Payment.php"
>
624.
<area shape=
"rect"
coords=
"127,-6,235,36"
href=
"ConfirmPayment.php"
>
625.
<area shape=
"rect"
coords=
"383,-1,453,37"
href=
"Webboard.php"
>
626.
<area shape=
"rect"
coords=
"477,-12,546,37"
href=
"Contact.php"
>
627.
<area shape=
"rect"
coords=
"256,1,365,57"
href=
"CheckRef.php"
>
628.
</map>
629.
</body>
630.
</html>