need help with detecting if it's been 24 hours since a user's last data submit..

ShadowIce

Hi all, I'm having a problem.

I need to use this code, to detect whether or not its the next day since a user last submitted data to the website i made..

here's the code:


 <?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);

?>

ANY help is GREATLY appreciated! 🙂

dagon

are you storing the date of each submission?

ShadowIce

um, no, i'd rather use php for that if possible. BUT. if you know of a way i can edit the above code to use a date stamp for the database, AND how to pull it out and check if the 24 hours is up or not, then PLEASE tell me 🙂

dagon

php is not psychic, if you don't store the date how could you possible know 24 hours have past? Add a timestamp to your db

TIMESTAMP DEFAULT CURRENT_TIMESTAMP

ShadowIce

ok, now i need to know how to check that timestamp, and compare a current timestamp w/ the timestamp in the database.

thats what i meant.

dagon

where timesamp >NOW() +INTERVAL 1 DAY

11.6. Date and Time Functions

ShadowIce

So if i were to do this in a table creator, it would look like this?

$sql = "CREATE TABLE $tbl2 
(
id int(255) NOT NULL auto_increment, 
item varchar(255) NOT NULL default TIMESTAMP DEFAULT CURRENT_TIMESTAMP WHERE TIMESTAMP > NOW() + 1 INTERVAL DAY '', 
firstname varchar(255) NOT NULL TIMESTAMP DEFAULT CURRENT_TIMESTAMP WHERE TIMESTAMP > NOW() + 1 INTERVAL DAY default '', 
lastname varchar(255) NOT NULL TIMESTAMP DEFAULT CURRENT_TIMESTAMP WHERE TIMESTAMP > NOW() + 1 INTERVAL DAY default '', 
PRIMARY KEY (id)
)TYPE=MyISAM;";

dagon

no, you create a new table field to hold the timestamp.

ShadowIce

$sql = "CREATE TABLE newtable
(date varchar(255) NOT NULL TIMESTAMP DEFAULT CURRENT_TIMESTAMP WHERE TIMESTAMP > NOW() + 1 INTERVAL DAY default '');";

dagon

You are not going to get far randomly sticking bits of code together and expecting it to work.

Start with a mysql tutorial

ShadowIce

i just need to know how to use the "WHERE TIMESTAMP > NOW() + 1 INTERVAL DAY"
part in an if statement. thats all.

dagon

i could write it all for you, and the next time you have an issue your at the same spot, if you don't want to learn, hire someone.

ShadowIce

thats fine. BUT i dont want u to write it for me. what im looking for is a working example. the way i learn is thru example. im not asking u to take my code and fix it. im asking for an example using the functions u showed me.

dagon

your mixing php with mysql, your mixing the syntax from various mysql function together, this is why you need to follow a basic tutorial. When i gave you example code, you don't know where or how to use it.

ShadowIce

if ur gonna make this tough, ill just ask on another forum.

johanafm

ShadowIce;10927331 wrote:
BUT. if you know of a way i can edit the above code (...), then PLEASE tell me 🙂

ShadowIce wrote:
im not asking u to take my code and fix it. im asking for an example using the functions u showed me.

I'd really love to help, but now I don't know wether I should correct the code you provided or if I should write something from scratch.

ShadowIce

correct the data. so that i can learn w/o u doing it for me.

johanafm

Correct what data? You've shown no data at all about dates of any kind, except for checking what month it is right now.

ShadowIce

if u change the "m" to a "d", it becomes days, not months.