Help (mktime)

Barrucadu · 08-20-2006, 03:02 PM

PHP Code:

  $timeout = 15;

$t_stamp = mktime(date('H'),date('i')-$timeout,date('s'));

die($t_stamp);

That should return the time (in mysql format) 15 minutes ago, but it dosnt. It dosnt return anything.
????: NamePros.com http://www.namepros.com/programming/229806-help-mktime.html

Whats wrong?

Noobie · 08-20-2006, 03:31 PM

echo $t_stamp;
die();

why?
die() does not print integers
die("$t_stamp");
works too

Barrucadu · 08-20-2006, 03:58 PM

It dosnt print integers?

*feels stupid now*

lol

--edit--

Now I have a different problem:

PHP Code:

      function Update_Stats($timeout,$stats){

        $t_stamp = mktime(date('H'),date('i')-$timeout,date('s'),0,0,0);

????: NamePros.com http://www.namepros.com/showthread.php?t=229806
        

        $this->Database_Query('delete from ' .$stats . ' where visited < '.$t_stamp);

    }

the field visited is a mysql time.
It should delete all entries where visited is more than 15 mins ago, but it deletes everything.

Noobie · 08-20-2006, 04:09 PM

i'm not sure why, but you can use int for timestamps

TwistMyArm · 08-20-2006, 08:01 PM

PHP timestamps and MySQL datetimes are not the same thing... it all depends on your column types.

There is a MySQL function called something like UNIXTIMESTAMP that will return a MySQL date as a timestamp and I know there's one for converting from UNIX to MySQL, but I don't know it off the top of my head. However, do some digging for UNIXTIMESTAMP and you're bound to find the 'reverse' function name.

08-20-2006, 03:02 PM	THREAD STARTER #1 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	Help (mktime) PHP Code: `$timeout = 15; $t_stamp = mktime(date('H'),date('i')-$timeout,date('s')); die($t_stamp);` That should return the time (in mysql format) 15 minutes ago, but it dosnt. It dosnt return anything. ????: NamePros.com http://www.namepros.com/programming/229806-help-mktime.html Whats wrong? __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

08-20-2006, 03:31 PM	#2 (permalink)
Noobie NamePros Regular Join Date: Feb 2006 Location: Montreal, Quebec, Canada Posts: 324	echo $t_stamp; die(); why? die() does not print integers die("$t_stamp"); works too __________________ Goldkey.com is a scam What's your BMI? \| Timestamp Generator

08-20-2006, 03:58 PM	THREAD STARTER #3 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	It dosnt print integers? feels stupid now lol --edit-- Now I have a different problem: PHP Code: `function Update_Stats($timeout,$stats){ $t_stamp = mktime(date('H'),date('i')-$timeout,date('s'),0,0,0); ????: NamePros.com http://www.namepros.com/showthread.php?t=229806 $this->Database_Query('delete from ' .$stats . ' where visited < '.$t_stamp); }` the field visited is a mysql time. It should delete all entries where visited is more than 15 mins ago, but it deletes everything. __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385 Last edited by Mikor; 08-20-2006 at 04:07 PM.

08-20-2006, 04:09 PM	#4 (permalink)
Noobie NamePros Regular Join Date: Feb 2006 Location: Montreal, Quebec, Canada Posts: 324	i'm not sure why, but you can use int for timestamps __________________ Goldkey.com is a scam What's your BMI? \| Timestamp Generator

08-20-2006, 08:01 PM	#5 (permalink)
TwistMyArm NamePros Member Join Date: May 2006 Posts: 160	PHP timestamps and MySQL datetimes are not the same thing... it all depends on your column types. There is a MySQL function called something like UNIXTIMESTAMP that will return a MySQL date as a timestamp and I know there's one for converting from UNIX to MySQL, but I don't know it off the top of my head. However, do some digging for UNIXTIMESTAMP and you're bound to find the 'reverse' function name. __________________ Free Fuel Efficiency Calculator \| Buy CMS Templates

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)