<!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 content="text/html; charset=windows-874" http-equiv=Content-Type> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf8"> > <script> function RestrictSpace() { if (event.keyCode == 32) { event.returnValue = false; return false; } } </script> </head> <body> <? $today = date("Y-m-d"); ?> <h4> Search <h4> <br> <center> <TABLE class="tablemanager"> <form id="form1" name="testform" method="GET" action="query_all.php"> <p> From <input name="dc" size="11" VALUE ="<? $currentDate = date("Ymd"); echo $currentDate.""; ?>" /> <a href="javascript:void(0)" onclick="if(self.gfPop)gfPop.fPopCalendar(document.testform.dc);return false;" ><img class= "PopcalTrigger" align="absmiddle" src="PopCalendarXP/calbtn.gif" width="34" height="22" border="0" alt=""></a> <span class="style15"> To <input name="dc2" size="11" VALUE ="<? $currentDate = date("Ymd"); echo $currentDate.""; ?>" /> <a href="javascript:void(0)" onclick="if(self.gfPop)gfPop.fPopCalendar(document.testform.dc2);return false;" ><img class="PopcalTrigger" align="absmiddle" src="PopCalendarXP/calbtn.gif" width="34" height="22" border="0" alt=""></a> </span><!--<input type="submit" name="Submit" value="Submit">--> </p> <p> </p> <!-- PopCalendar(tag name and id must match) Tags should not be enclosed in tags other than the html body tag. --> <iframe width=174 height=189 name="gToday:normal:agenda.js" id="gToday:normal:agenda.js" src="PopCalendarXP/ipopeng.htm" scrolling="no" frameborder="0" style="visibility:visible; z-index:999; position:absolute; top:-500px; left:-500px;"> </iframe> Insert M Please !!<br /> <center> <input class="textfield1" type="text" onkeypress="return RestrictSpace()" name="M" id="textfield" /> <center> Insert T Please !!<br /> <center> <input class="textfield1" type="text" onkeypress="return RestrictSpace()" name="T" id="textfield" /> <center> <br> <input class="button_gray" type="submit" name="button" id="button" value="Query" /> </form> <br /><br /> <? $M=$_GET[M]; $T=$_GET[T]; $dc=$_GET[dc]; $dc2=$_GET[dc2]; $objConnect = oci_connect("ts_app","ts123","192.168.16.78:1521/log"); if($T=="" and $M=="" and $dc =="" and $dc2 ==""){ echo"<center><h2> Insert DATA !!</h2><br><br><br><center>"; exit(); }else if($T!="" and $M=="") { $strSQL="select * from logs WHERE T = '".$_GET["T"]. " ' "; }else if($TERMINAL=="" and $MERCHANT!="") {$strSQL="select * from logs WHERE M = '".$_GET["M"]."' "; }else if($TERMINAL!="" and $MERCHANT!="" ) {$strSQL="select * from logs where T = '".$_GET["T"]. " and M = '".$_GET["M"]."' "; }else if($dc!="" and $dc2!="") {$strSQL="select * from logs d where to_char(D.DATETIME,'YYYYMMDD') BETWEEN '$_GET[dc]' and '$_GET[dc2]'"; } $objParse = oci_parse($objConnect, $strSQL); oci_execute ($objParse,OCI_DEFAULT); $Num_Rows = oci_fetch_array($objParse, $Result); if ($Num_Rows<=0) { echo"<center> NO DATA</center>"; }else{ echo"<table class=\"tablemanager\">"; echo"<tr class=\"yellow\" > <td>DATETIME </td> <td>T </td> <td>M</td></tr>"; while($Result = oci_fetch_array($objParse,OCI_BOTH)){ $DATETIME=$Result[DATETIME]; $T=$Result[T]; $M=$Result[M]; echo"<tr><td align=center> $DATETIME</td><td> $T</td><td> $M</td><td> $IP</td></tr>"; } { } echo"</table>"; } oci_close($objConnect); ?> </TABLE> <br /><h2> </body> </html>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
ประมานนี้ ครับ
