Help (mktime)

Barrucadu · 08-20-2006, 02: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.

Whats wrong?

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

echo $t_stamp;
die();

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

Barrucadu · 08-20-2006, 02: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);

        

        $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, 03:09 PM

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

TwistMyArm · 08-20-2006, 07: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, 02:02 PM	#1 (permalink)
Barrucadu Barru. Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,731 78.50 NP$ (Donate)	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. Whats wrong? __________________ Website \| Blog \| Uzbl (my branch) 9thSeptember2009.com

08-20-2006, 02:31 PM	#2 (permalink)
Noobie NamePros Regular Join Date: Feb 2006 Location: Montreal, Quebec, Canada Posts: 324 66.75 NP$ (Donate)	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, 02:58 PM	#3 (permalink)
Barrucadu Barru. Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,731 78.50 NP$ (Donate)	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); $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 \| Uzbl (my branch) 9thSeptember2009.com Last edited by Mikor; 08-20-2006 at 03:07 PM.

08-20-2006, 03:09 PM	#4 (permalink)
Noobie NamePros Regular Join Date: Feb 2006 Location: Montreal, Quebec, Canada Posts: 324 66.75 NP$ (Donate)	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, 07:01 PM	#5 (permalink)
TwistMyArm NamePros Member Join Date: May 2006 Posts: 160 81.00 NP$ (Donate)	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 \| CMS Book Store

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