Disallow upload

[doddsey_65]

Hi, I have an upload image script in place and would like it so that sers can only add one image per hour.

am i right in thinking i need to insert the date and time into the database when they upload an image, and when they go to add anotherone i would need to pull the date of their last one from the database and see if it was atleast an hour before this one?
Soething like

$current= date("H:i:s");
$last=("SELECT last FROM users WHERE username='$_POST['username']");
$res=mysql_query($last);

Then i get stuck with the if and thats what i need help with.

[paulnaj]

Hi doddsey,

First of all, what type of field is 'last' (DATE, TIMESTAMP ...).

TIMESTAMP is easiest for this purpose (you may have other purposes for this date), since then you could just do something like...

<?php
$current = strtotime('now'); // get the current timestamp
$sql = '
SELECT `last` 
FROM `users` 
WHERE `username`= "'.mysql_real_escape_string($_POST['username']).'"
;'; 
$res = mysql_query($sql);
$row = mysql_fetch_row($res);
$last_updated = $row[0];

if($current - $last_updated >= 3600){ // 3600 = num seconds in a hour
	echo 'Can do updates ...';
} else {
	echo 'Have to wait ...';
}
?>

P.