converting a number

[Anon]

OK..still having troubles with that timeupdate..I won't fly so I m trying another method.

I have a integer (representing seconds) but now I want to use a fomula to split that integer into hours/minutes and seconds (hours are extra if it can work)

So I want a formula which can set the number...umh..let's say: 1234 into 20 minutes and 34 seconds.

Anyone?

[[deleted]]

Read the first annotation in the manual:

http://www.php.net/manual/en/function.mktime.php

This explains how to do just that.

[Anon]

thx, I find this:

You have 74788 seconds and you want to convert to hh:mm:ss. You can just do date("H:i:s", mktime(0,0,74788)) which returns 20:46:28.

That is exactly what i mean 🙂 but now my next question:

I use the seconds in a table (as an integer) and show it on a phppage with this code

<TD WIDTH=75><font size ="1"><b><? echo $row['Secs']; ?> </b></font></TD>

Now I want to show the converted stuff...but what code now?

Thx again

[Anon]

I have also tried it alot the same thing . But i am also not getting it.

I am still trying If i get it i'll reply to this message again.

If anybody gets it... please mail me at [e-mail]

Chanderjit

[Anon]

I am now working with:

$hours = ($row['Time']/3600);
$restsec = ($row['Time']-($hours3600));
$minut = ($restsec/60);
$sec = ($restsec - ($minut60));

Not quite there yet...have to deal with the rounding stuff...but I am closer now

[[deleted]]

Write a function that takes the seconds as a parameter and returns the human-readable string.

[Anon]

I need a way to round down..I checked the libraries and found floor but that doesn't work...

how do I round to the lowest whole number ( 0.65 should become 0 )

[Anon]

never mind...i got the floor thing to work 🙂

[Anon]

I am working also trying to get the timestamp from database and try to change its time.

If i am getting time 10:00:00 then i am trying to make it 10:15 10:30 10:45 11:00 and soo on....

$year = substr($arr["time_from"],0,4); echo"<BR>";
echo $year;
$month = substr($arr["time_from"],4,2);
echo $month;
$day = substr($arr["time_from"],6,2); echo $day;
$hours = substr($arr["time_from"],8,2); echo"<BR>";
echo"Hours = "; echo $hours;
$minutes = substr($arr["time_from"],10,2); echo"<BR>";
echo"Minutes = "; echo $minutes; echo"<BR>";
$seconds = substr($arr["time_from"],12,2); echo"<BR>";
echo"sec = "; echo $seconds;
echo"<BR>";
echo"<p>";

Here whatever time i get from database i am trying to increase it by 15 minutes and make slots as such..

If anybody can help this it out please reply or send mail at [e-mail]

Thanks

[[deleted]]

If you have a timestamp in a database like mysql, there's usually a function to do this, like date_format for MySQL. That lets you format the date while you retreive it from the database.

Check your documentation!