Problems with timestamps

[smurl]

Right, I don't really have the time to trawl through archives and things so I was wondering if anybody could help me at all please?

I need to make it so that someone is only able to upload something once a week.

So, in my database i have a timestamp (via date()😉 that is in the form of yyyyddmmhhmmss which is updated when the user successfully uploads their soundfile (which goes into the field "soundfile") . The field name for the date is "sound_date".

I need it so that when the User selects the file and presses upload, it checks the current date against the date in the database. If the current date is more than a week after the date in the database, then it allows the upload, otherwise it doesn't.

Does anybody have any idea how to do this?
Would be a real help 🙂
Thanks in advanced.
Carl

[devinemke]

assumptions:
1. you are using mySQL
2. your table is called "table"
3. you have an integer field in "table" called "user_id"
4. the user_id using the form right now is "7"

$result = mysql_query('SELECT UNIX_TIMESTAMP(sound_date) FROM table WHERE user_id = 7');
$timestamp = mysql_result($result, 0);

if (time() - $timestamp < (60 * 60 * 24 * 7)) {echo 'you cannot upload yet!';}
else
{
	// upload code here
}

[smurl]

ill try it out! thanks a lot! 🙂

[smurl]

OK thanks a lot. It works.
Now, I want to also display the date on which they will next be able to upload.

Any idea how to do this also?
Thanks again in advance!

[devinemke]

$result = mysql_query('SELECT UNIX_TIMESTAMP(sound_date) FROM table WHERE user_id = 7');
$timestamp = mysql_result($result, 0);

$diff1 = time() - $timestamp;
$next = $timestamp + (60 * 60 * 24 * 7);
$diff2 = $next - time();

if ($diff1 < (60 * 60 * 24 * 7))
{
	echo 'you cannot upload right now. you will be able to upload at ' . date('Y-m-d H:i:s', $next) . ' which is ' . $diff2 . ' seconds from right now.';
}
else
{
	// upload code here
}

[smurl]

hmmmm it says something about a T_VARIABLE

Parse error: parse error, unexpected T_VARIABLE in /home/kassix/public_html/forum/soundbytes.php on line 109

$result = mysql_query("SELECT UNIX_TIMESTAMP(sound_date) FROM user WHERE username='$username'"); 
$timestamp = mysql_result($result, 0); 

$diff1 = time() - $timestamp; 
$next = $timestamp + (60 * 60 * 24 * 7); 
$diff2 = $next - time(); 

$next_date=date("Y-m-d H:i:s", $next)

$calc="60*60*24*7";

if ($diff1<$calc) { 
    		echo("<b>UPLOAD ERROR!</b> You've already uploaded a soundfile this week!</b><br>You will be able to upload again at <b>$next_date</b> which is <b>$diff2</b> seconds from right now."); 
				} 
else { 

unlink("/home/kassix/public_html/forum/soundbytes/$userinfo[soundfile]");

$copy=copy($file, "/home/kassix/public_html/forum/soundbytes/$file_name"); 
$new_file="$username";
$new_file.="_";
$new_file.="$file_name";
rename("/home/kassix/public_html/forum/soundbytes/$file_name","/home/kassix/public_html/forum/soundbytes/$new_file");
unlink($file); 
}

[smurl]

Nevermind.

$next_date=date("Y-m-d H:i:s", $next) 

I forgot the ; on the end.

$next_date=date("Y-m-d H:i:s", $next);

thanks a lot for aaaall your help!
it works now! 😃