PHP mysql time

[Pain]

Hi guys.

 

I want to make two records.

 

1)Current time and date.

2)Time and date after 20 seconds.

 

Now i have this piece of code:

<?php
$hr  = 0;
$min = 0;
$sec = 11;

echo $date = date("Y-m-d H:i:s");echo "\n";
echo $modified = time() + (0 * 0 * 0 * 20);

?>

 

I think there is something wrong with this line:

<?php
echo $modified = time() + (0 * 0 * 0 * 20);1
?>

I get something like this: 1324668576.

 

You can check this http://kingstonuni.atspace.co.uk/RPG/muziejus.php link to get a better view.

 

Any help would be appreciated. Thank you.

 

 

 

 

[Pain]

Sorry, please ignore this peace of code.

<?php
...
$hr  = 0;
$min = 0;
$sec = 11;
...
?>

[Maq]

time - "Returns the current time measured in the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)."

 

The integer you're getting is actually correct in seconds.  If you're trying to store this in MySQL then why not use NOW() when inserting into the DB?

[Pikachu2000]

Any value multiplied by zero results in zero, so your ( 0 * 0 * 0 * 20 ) is cratering the addition.

 

$now = time();
$time_in_20_seconds = $now + 20;

[Pain]

Looks like that works, but the output is still in this format 1324670946.

I need it to be like this: 2011-12-23 20:08:46.

[Pikachu2000]

Use date to format it. If it's going into a database record, read Maq's post above.

[Maq]

Looks like that works, but the output is still in this format 1324670946.

I need it to be like this: 2011-12-23 20:08:46.

I think you're performing too many steps, something like this should suffice:

echo date('Y-m-d h:i:s', strtotime("+20 seconds"));

[Pain]

Yes i want to put two records into the database.

 

Not sure how to do this. Sorry im really bad at this date and time thing.

[Pain]

Looks like that works, but the output is still in this format 1324670946.

I need it to be like this: 2011-12-23 20:08:46.

I think you're performing too many steps, something like this should suffice:

echo date('Y-m-d h:i:s', strtotime("+20 seconds"));

This is what i was searching for! Thank you!

[Maq]

If you're storing dates in a DB then you probably want to store it as a TIMESTAMP.  That way you can operate on it if need be (get a certain range, add, subtract etc.).

[Pain]

Yes i have stored them as timestamps, but now im having some difficulties trying to display them. I guess it's not the same as retrieving INT or VARCHAR?

[Pain]

how can i retrieve timestamp from the db?:/

[Pikachu2000]

Don't bump threads.

 

What problems are you having, specifically. Post the code that's causing the current problems as well.

[Maq]

how can i retrieve timestamp from the db?:/

As Pikachu said, show us the code you're trying to use along with errors.  If you don't have code I would suggest Googling it, making an attempt, and coming back to specific help.  There are a multitude of good examples.