Code: Select all
<?php
session_start();
include("config.php");
$msg = "";
if (isset($_POST['Submit']))
{
$event_date = $_POST['event_date'];
$result = mysql_query("Select * From events where event_date='$event_date'",$con);
if(mysql_num_rows($result)>0)
{
$row = mysql_fetch_array($result, MYSQL_BOTH);
if($event_date == $row["event_date"])
{
$msg = "This date is unavailable";
}
else
{
$msg = "This date is available";
}
}
}
?>Code: Select all
<html>
<head>
<title>Search</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>Code: Select all
<?php include "panel.htm"; ?>Code: Select all
<form name="form1" method="post" action="">
<br /><br /><br />
<table class="table" width="35%" border="0" align="center" cellpadding="1" cellspacing="1" bordercolor="#000000">
<tr>
<td colspan="2"><div align="center"><font color="#669966" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>search</strong></font></div></td>
</tr>
<tr>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Date: </font></div></td>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="event_date" id="event_date" width="200">
</font></td>
</tr>
<tr>
<td>
<input type="submit" name="Submit" value="Submit">
</td>
</tr>
</table>
</form>
</body>
</html>Code: Select all