001.
<?php
002.
003.
include
'../connect/connect.php'
;
004.
$params
=
array
();
005.
$options
=
array
(
"Scrollable"
=> SQLSRV_CURSOR_KEYSET );
006.
?>
007.
<form name=
"frmSearch"
method=
"post"
action=
"<?php echo $_SERVER['SCRIPT_NAME'];?>"
>
008.
<table width=
"428"
border=
"0"
align=
"left"
>
009.
<tr>
010.
<th width=
"422"
height=
"117"
>
011.
Month - Year <input name=
"txtKeyword"
type=
"text"
id=
"txtKeyword"
value=
"<?php error_reporting(0);echo $_POST["
txtKeyword
"]?>"
>
012.
<input name=
"Submit"
type=
"submit"
value=
"Search"
>
013.
</th>
014.
</tr>
015.
</table>
016.
</form>
017.
<form method=
"post"
action=
"guest_info.php"
>
018.
<table width=
"1222"
border=
"1"
cellspacing=
"0"
bordercolor=
"#003300"
>
019.
<tr>
020.
<td bordercolor=
"rgb(0,142,0)"
width=
"66"
rowspan=
"2"
align=
"center"
valign=
"center"
bgcolor=
"#EAF1DD"
><h4><font size =
"2"
color=
"#008000"
>No</font></h4></td>
021.
<td bordercolor=
"rgb(0,142,0)"
width=
"89"
rowspan=
"2"
align=
"center"
valign=
"center"
bgcolor=
"#EAF1DD"
><h4><font size=
"2"
color=
"#008000"
>
Date
</font></h4></td>
022.
<td bordercolor=
"rgb(0,142,0)"
colspan=
"2"
align=
"center"
bgcolor=
"#EAF1DD"
><h4><font size=
"2"
color=
"#008000"
>Time</font></h4></td>
023.
<td bordercolor=
"rgb(0,142,0)"
width=
"72"
rowspan=
"2"
align=
"center"
valign=
"center"
bgcolor=
"#EAF1DD"
><h4><font size=
"2"
color=
"#008000"
>Fac</font></h4></td>
024.
<td bordercolor=
"rgb(0,142,0)"
width=
"85"
rowspan=
"2"
align=
"center"
valign=
"center"
bgcolor=
"#EAF1DD"
><h4><font size=
"2"
color=
"#008000"
>Room</font></h4></td>
025.
<td bordercolor=
"rgb(0,142,0)"
width=
"159"
rowspan=
"2"
align=
"center"
valign=
"center"
bgcolor=
"#EAF1DD"
><h4><font size=
"2"
color=
"#008000"
>Company Name</font></h4></td>
026.
<td bordercolor=
"rgb(0,142,0)"
width=
"66"
rowspan=
"2"
align=
"center"
valign=
"center"
bgcolor=
"#EAF1DD"
><h4><font size=
"2"
color=
"#008000"
>Number</font></h4></td>
027.
<td bordercolor=
"rgb(0,142,0)"
width=
"84"
rowspan=
"2"
align=
"center"
valign=
"center"
bgcolor=
"#EAF1DD"
><h4><font size=
"2"
color=
"#008000"
>PIC</font></h4></td>
028.
<td bordercolor=
"rgb(0,142,0)"
width=
"88"
rowspan=
"2"
align=
"center"
valign=
"center"
bgcolor=
"#EAF1DD"
><h4><font size=
"2"
color=
"#008000"
>VIP</font></h4></td>
029.
<td bordercolor=
"rgb(0,142,0)"
width=
"154"
rowspan=
"2"
align=
"center"
valign=
"center"
bgcolor=
"#EAF1DD"
><h4><font size=
"2"
color=
"#008000"
>Remark</font></h4></td>
030.
<td bordercolor=
"rgb(0,142,0)"
width=
"98"
rowspan=
"2"
align=
"center"
valign=
"center"
bgcolor=
"#EAF1DD"
><h4><font size=
"2"
color=
"#008000"
>Route</font></h4></td>
031.
</tr>
032.
<tr>
033.
<td bordercolor=
"rgb(0,142,0)"
width=
"60"
align=
"center"
valign=
"center"
bgcolor=
"#EAF1DD"
><h4><font size=
"2"
color=
"#008000"
>Start</font></h4></td>
034.
<td bordercolor=
"rgb(0,142,0)"
width=
"85"
align=
"center"
valign=
"center"
bgcolor=
"#EAF1DD"
><h4><font size=
"2"
color=
"#008000"
>Finish</font></h4></td>
035.
</tr>
036.
<?php
037.
$span
=0;
038.
$filt
=
$_POST
[
"txtKeyword"
];
039.
if
(
$filt
==NULL)
040.
{
041.
$strSQL
=
"SELECT * FROM guest ORDER BY guest_id DESC"
;
042.
$query
= sqlsrv_query(
$conn
,
$strSQL
);
043.
while
(
$result
= sqlsrv_fetch_array(
$query
))
044.
{
045.
?>
046.
<tr>
047.
<?php
048.
if
(
$span
==0)
049.
{
050.
$sqlspan
=
"select * from guest where GUEST_ID="
.
$result
[
'GUEST_ID'
].
""
;
051.
052.
$queryspan
=sqlsrv_query(
$conn
,
$sqlspan
,
$params
,
$options
);
053.
$num_rows_span
=sqlsrv_num_rows(
$queryspan
);
054.
?>
055.
<td bordercolor=
"rgb(0,142,0)"
rowspan=
"<?php echo $num_rows_span; ?>"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"GUEST_ID"
];?></div></font></td>
056.
<?php
057.
}
058.
?>
059.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
date_format(
$result
[
"STDATE"
],
'd-m-Y'
);?></div></font></td>
060.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"STTIME"
];?></div></td>
061.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"FNTIME"
];?></div></td>
062.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"FAC"
];?></div></font></td>
063.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"ROOM"
];?></div></font></td>
064.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"COMPANY"
];?></div></font></td>
065.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"NUMBER"
];?></div></font></td>
066.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"PIC"
];?></div></font></td>
067.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"VIP"
];?></div></font></td>
068.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"REMARK"
];?></div></font></td>
069.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><a href=
"../announce/PDF/<?php echo $result["
ROUT
"]."
.pdf
";?>"
><?php
echo
$result
[
"ROUT"
];?></div></font></a></td>
070.
</tr>
071.
<?php
072.
$span
=
$span
+1;
073.
if
(
$span
==
$num_rows_span
)
074.
$span
=0;
075.
}
076.
}
077.
else
078.
{
079.
if
(
$filt
[2]==
"/"
)
080.
{
081.
$month
=
strstr
(
$filt
,
'/'
, true);
082.
$year
=
substr
(
strstr
(
$filt
,
'/'
, false),1);
083.
}
084.
else
if
(
$filt
[2]==
"-"
)
085.
{
086.
$month
=
strstr
(
$filt
,
'-'
, true);
087.
$year
=
substr
(
strstr
(
$filt
,
'-'
, false),1);
088.
}
089.
else
if
(
$filt
[4]==
"/"
)
090.
{
091.
$year
=
strstr
(
$filt
,
'/'
, true);
092.
$month
=
substr
(
strstr
(
$filt
,
'/'
, false),1);
093.
}
094.
else
if
(
$filt
[4]==
"-"
)
095.
{
096.
$year
=
strstr
(
$filt
,
'-'
, true);
097.
$month
=
substr
(
strstr
(
$filt
,
'-'
, false),1);
098.
}
099.
$search
=
$year
.
"-"
.
$month
;
100.
for
(
$i
=1;
$i
<=31;
$i
++)
101.
{
102.
$strKeyword
=
$search
.
"-"
.
$i
;
103.
104.
$strSQL
=
"SELECT * FROM guest where STDATE = '"
.
$strKeyword
.
"' ORDER BY guest_id DESC"
;
105.
106.
107.
$query
= sqlsrv_query(
$conn
,
$strSQL
,
$params
,
$options
);
108.
$num_row
=sqlsrv_num_rows(
$query
);
109.
if
(
$num_row
>0)
110.
{
111.
while
(
$result
= sqlsrv_fetch_array(
$query
))
112.
{
113.
?>
114.
<tr>
115.
<?php
116.
if
(
$span
==0)
117.
{
118.
$sqlspan
=
"select * from guest where GUEST_ID="
.
$result
[
'GUEST_ID'
].
""
;
119.
$queryspan
=sqlsrv_query(
$conn
,
$sqlspan
,
$params
,
$options
);
120.
$num_rows_span
=sqlsrv_num_rows(
$queryspan
);
121.
?>
122.
<td bordercolor=
"rgb(0,142,0)"
rowspan=
"<?php echo $num_rows_span; ?>"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"GUEST_ID"
];?></div></font></td>
123.
<?php
124.
}
125.
?>
126.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
date_format(
$result
[
"STDATE"
],
'd-m-Y'
);?></div></td>
127.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"STTIME"
];?></div></td>
128.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
date_format(
$result
[
"FNDATE"
],
'd-m-Y'
).
" "
.
$result
[
"FNTIME"
];?></div></td>
129.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"FAC"
];?></div></font></td>
130.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"ROOM"
];?></div></font></td>
131.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"COMPANY"
];?></div></font></td>
132.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"NUMBER"
];?></div></font></td>
133.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"PIC"
];?></div></font></td>
134.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"VIP"
];?></div></font></td>
135.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><font size=
"2"
><?php
echo
$result
[
"REMARK"
];?></div></font></td>
136.
<td bordercolor=
"rgb(0,142,0)"
><div align=
"center"
><a href=
"../PDF/<?php echo $result["
ROUT
"]."
.pdf
";?><font size="
2
"><?php echo $result["
ROUT"];?></div></font></a></td>
137.
</tr>
138.
<?php
139.
$span
=
$span
+1;
140.
if
(
$span
==
$num_rows_span
)
141.
$span
=0;
142.
}
143.
}
144.
}
145.
}
146.
147.
148.
149.
150.
?>
151.
</table>
152.
</form>
153.
<table width=
"1158"
border=
"0"
>
154.
<tr>
155.
<td align=
"right"
><a href=
"admin_manage.php"
> <img src=
"img/Guestbook.jpg"
width=
"51"
height=
"36"
></a></td>
156.
</tr>
157.
</table>
158.
<br>
159.
<br><br><br><br><br><br><br><br>
160.
<br><br><br><br><br><br><br>
161.
</head>
162.
</table>