| Server IP : 134.236.49.22 / Your IP : 216.73.216.114 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/meeting-new/ |
Upload File : |
<?
include("connectdb.php");
$time1 = $_POST["myHour1"].":".$_POST["myMin1"].":00";
$time2 = $_POST["myHour2"].":".$_POST["myMin2"].":00";
if($_POST["myHour1"]=='00' or $_POST["myHour2"]=='00')
{
echo "กรุณาเลือกเวลาด้วยครับ!";
}
else if($_POST["myHour1"]>$_POST["myHour2"])
{
echo "เวลาไม่ถูกต้องครับ!";
}
else
{
$strSQL = "SELECT * FROM meeting_list WHERE ((strdate between '".$_POST["myDate1"]."' and '".$_POST["myDate2"]."') or ";
$strSQL .= " (enddate between '".$_POST["myDate1"]."' and '".$_POST["myDate2"]."')) and ";
$strSQL .= " ((strtime between '".$time1."' and '".$time2."') or ";
$strSQL .= " (endtime between '".$time1."' and '".$time2."')) and room = '".$_POST["myRoom"]."' and mstatus <> 'N' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
if($objResult)
{
echo "ห้องไม่ว่าง มีคนจองแล้ว!";
}
else
{
echo "ห้องว่าง สามารถจองได้ >> <input type='submit' class='button' value='ตกลง'>";
}
}
?>