Searching an EXACT date

**revray** · 02-24-2008, 03:47 AM

Evening,

I am trying to create a simple query that will take the date that the users enters and compares it to dates entered into the database. It is looking for an exact match on DATE information inside the database and the table. I cannot get this to work, I search for dates that I know are in the database and it returns that it does not find the record. I am using the = in my query, is this the wrong command for date information?

The form is validated for users to enter the date in the right format yyyy-mm-dd, and the I know that it is entered right in the database. Can anyone guide me to the right query to make this work?

Thanks so much in advance! Find the script I am using below.

$usertable = "booking_dates"; // This is the table you made.
$dbName = "turnerbooking"; // This is the main database you connect to.
MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
?>
<?
$query = mysql_query("SELECT * FROM $usertable WHERE $_POST[date_search] = '%$search%' ");
while ($row = mysql_fetch_array($query))
{
$variable1=$row["date"];
//$variable2=$row["row_name2"];
//$variable3=$row["row_name3"];
print ("$variable1");
}

**Nile** · 02-24-2008, 03:56 AM

Try this:

PHP Code:



$usertable = "booking_dates"; // This is the table you made.
$dbName = "turnerbooking"; // This is the main database you connect to.
mysql_connect($hostname, $username, $password) OR DIE("Unable to connect to database");
mysql_select_db( "$dbName") or die( "Unable to select database");

$query = mysql_query("SELECT * FROM $usertable WHERE {$_POST['date_search']} = '%$search%' ");
while ($row = mysql_fetch_array($query))
{
$variable1=$row["date"];
//$variable2=$row["row_name2"];
//$variable3=$row["row_name3"];
print ("$variable1");
}

**revray** · 02-24-2008, 04:24 AM

Nile,

Thanks so much for your help, it did not work however, and I am sure that I am doing something wrong. Here is the whole script, with the changes you suggested, any chance you could guide me further?

$usertable = "booking_dates"; // This is the table you made.
$dbName = "turnerbooking"; // This is the main database you connect to.
MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
?>
<?
$query = mysql_query("SELECT * FROM $usertable WHERE {$_POST['date_search']} = '%$search%' ");
while ($row = mysql_fetch_array($query))
{
$variable1=$row["date"];

print ("$variable1");
}

//below this is the function for no record!!
if (!$variable1)
{
echo "<p> Great news! Jeff is available. Please fill out the form below to contact Jeff about booking your date. Please note, your date IS NOT booked yet, it simply is available. Make sure to fill out this form so Jeff can get back to you.</p>"

;

}
//end
?>

**Nile** · 02-24-2008, 04:27 AM

Try this:

PHP Code:



$usertable = "booking_dates"; // This is the table you made.
$dbName = "turnerbooking"; // This is the main database you connect to.
mysql_connect($hostname, $username, $password) OR DIE("Unable to connect to database");
mysql_select_db( "$dbName") or die( "Unable to select database");
$query = mysql_query("SELECT * FROM $usertable WHERE {$_POST['date_search']} = '$search' ");
while ($row = mysql_fetch_array($query))
{
$variable1=$row["date"];

print ("$variable1");
}

//below this is the function for no record!!
if (!$variable1)
{
echo "<p> Great news! Jeff is available. Please fill out the form below to contact Jeff about booking your date. Please note, your date IS NOT booked yet, it simply is available. Make sure to fill out this form so Jeff can get back to you.</p>"

;


}
//end
?>

**revray** · 02-24-2008, 05:03 AM

I cannot figure out what I am doing wrong!

If i use LIKE, then it lists all the dates that are entered into the database, if I use the = then it says record not found. Where am I messing up?

**Nile** · 02-24-2008, 05:05 AM

Well are you sure the value from {$_POST['date_search']} is an entry?

**revray** · 02-24-2008, 05:30 AM

Code:

<!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 http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>testing</title>
<link href="bookingformat.css" rel="stylesheet" type="text/css" />
<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
</head>

<body>
<div id="content">
<p>To see if Jeff is available for your special day, please use this form to input your wedding date.</p>


<form method="post" action="result.php">
<p>Enter your wedding date below to see if Jeff is available</p>
<p>  Please note, you must enter your date in the following format yyyy-mm-dd. </p>  
 <p> <span id="sprytextfield1">
  <label>Wedding Date:
  <input type="text" name="date_search" id="date_search" />
  </label>
  <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span>

&nbsp;&nbsp;
<input type="submit" value="Check Your Date"></p>
</form> 
</div>
<script type="text/javascript">
<!--
var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1", "date", {format:"yyyy-mm-dd", hint:"yyyy-mm-dd"});
//-->
</script>
</body>
</html>

This is the form I am using.

**revray** · 02-24-2008, 05:40 AM

WHERE {$_POST['date_search']}

Should the date_search be the name of the field in the search form, or the row in my database or something else?

Thanks again for your time!

Thread: Searching an EXACT date

Thread Tools

Search Thread

Searching an EXACT date

Bookmarks

Bookmarks

Posting Permissions