how do you detect after a user has submitted data, if it's the next day?

[DarkShadowWing]

Hi all. I need to know how after a person submits some data, that it will return an error message until the next day?

 

Example:

 

I submit my data. it returns an error message until the next day. then it lets me submit again.

 

<?php
$conn = "localhost";
$user = "myuser";
$pass = "mypass";
$dbname = "metaldetect02";
$tbl2 = "users0002";
$con = mysql_connect($conn,$user,$pass);
if (!$con)
  {
  die('Could not connect to database: "' . $dbname . '" because ' . mysql_error());
  }

mysql_select_db($dbname, $con);

$sql="INSERT INTO $tbl2 (item, firstname, lastname)
VALUES
('".$_POST[requireditem]."','".$_POST['requiredfirstname']."','".$_POST['requiredlastname']."')";

echo "Thanks for submitting your item, ".$_POST['requiredfirstname'].", ".$_POST['requiredlastname']."!<br>";
echo "Returning you to the previous page...";

echo "<script>setTimeout('document.location = \"./\";', 2000);</script>";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

mysql_close($con);

?>

[sKunKbad]

Use a cookie or session

[micmania1]

Please checkout this topic.

http://www.phpfreaks.com/forums/index.php/topic,268419.0.html

 

I think we came to the conclusion that it was best to store the submitted time in a database.

[DarkShadowWing]

i cant store it in a database because technically nobody has submitted data yet. what i need to do is use php to detect if after submission, it's the next day, if not then return error, if so, then allow for another submission.

 

can someone please show me a working example?

[DarkShadowWing]

Ok, using this code, can someone at least help me modify it to detect whether or not its 24 hours later since the 1st submit?

 

<?php $thismonth = date("m"); if ($thismonth=="01") // list January's dates       {       echo "<ul id=\"dateslist\">";
echo "<li>Wed, 7th January</li>";
echo "<li>Wed, 14th January</li>";
echo "<li>Wed, 21st January</li>";
echo "<li>Wed, 28th January</li>";
echo "</ul>";
} elseif ($thismonth=="02") // list February's dates             {
echo "<ul id=\"dateslist\">";
echo "<li>Wed, 4th February</li>";
echo "<li>Wed, 11th February</li>";
echo "<li>Wed, 18th February</li>";
echo "<li>Wed, 25th February</li>";
echo "</ul>";
}  
?>

<?php
$conn = "localhost";
$user = "myuser";
$pass = "mypass";
$dbname = "metaldetect02";
$tbl2 = "users0002";
$con = mysql_connect($conn,$user,$pass);
if (!$con)
  {
  die('Could not connect to database: "' . $dbname . '" because ' . mysql_error());
  }

mysql_select_db($dbname, $con);

$sql="INSERT INTO $tbl2 (item, firstname, lastname)
VALUES
('".$_POST[requireditem]."','".$_POST['requiredfirstname']."','".$_POST['requiredlastname']."')";

echo "Thanks for submitting your item, ".$_POST['requiredfirstname'].", ".$_POST['requiredlastname']."!<br>";
echo "Returning you to the previous page...";

echo "<script>setTimeout('document.location = \"./\";', 2000);</script>";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

mysql_close($con);

?>

[DavidAM]

Can you define "24 hours later since the 1st submit" ?  Is it the first (or do you mean last) time submitted from this computer-user, or submitted with the exact same data, or submitted by the user logged into your site (I don't see a user login but maybe it's there).

 

Give more detail on what you are trying to restrict and we might be able to give you some suggestions.