[SOLVED] TIMESTAMP HOW!?

[Snooble]

When I create a user in my database I want to record the date and time the record was made.

 

Using PHPMYADMIN what type would the field be? and using php what would i put in the "INSERT" sql statement?

 

Thanks

 

Snooble

[PravinS]

Use DATETIME data type for date field. You can INSERT date and time by using NOW() function in sql statement.

[redarrow]

Well years ago i was told to use the int for the database field and the time() php statement.

 

 

database field int not null

 

 

<?php

$date=time();

$sql="insert into what_ever(date)values('$date')";

?>

 

That will create a timestamp in unix..

 

format a time stamp use the date function

 

from a while loop

 

example

 

$date=date("h:i:s", data['date']);

 

now the time stamp only shows the time in hours min seconds

 

 

[Mchl]

Use TIMESTAMP type and define default as CURRENT_TIMESTAMP

[Yesideez]

I use INT(10) UNSIGNED for the database entry containing a timestamp and PHP's time() to populate it.

mysql_query("INSERT INTO `table` (`dt`) VALUES ('".time()."')");

 

When you get the date/time from the database you can display it using PHP's date() function:

echo date('d-M-Y H:i:s',$row['dt']);

 

See here for formatting the date and time:

http://uk3.php.net/date

 

The big thing I like about time() is sorting records can be done soooo easily and adding dates/times also as easy.

 

For example, to add 1 hour use this:

echo time()+(60*60);

Since time() is measured in seconds 60*60 is seconds*minutes which gives 3,600 - one hour.

 

btw, you use UNSIGNED for the MySQL database because time() is never negative and gives you the full range.

[redarrow]

 

1 year i think

echo time()+(60*60*24*365);

[Mchl]

1 year i think

echo time()+(60*60*24*365);

 

Why not

 

echo strtotime("+1 year")

 

(wonder if it takes leap years into account)

[redarrow]

 

I am sure this is correct when dealing with leap years not sure theo.

<?php

echo date("d/m/y",time()+(60*60*24*365));

?>

[Snooble]

so i've a 10 int field. And it's saving time(). How can i output it. Format needs to be

24:00 DD/MM/YYYY

 

Thanks

[Yesideez]

Check the link I gave you to format the time - if you get stuck come back and we'll prod you in the right direction.

 

ALL the formatting codes are listed on that page.

[Mchl]

Why not check then?

 

<?php
echo date("d-m-Y",strtotime("+4 years"));  //8-12-2008
echo "<br/>\n";
echo date("d-m-Y",time() + 4 * 365 * 24 * 3600);  //7-12-2008
?>

 

 

strtotime wins again

 

[edit]

 

I really don't understand, why you're saving dates as INT

 

[Snooble]

I have looked... but it doesn't completey tell me... cause in my database i have:

 

1228745009

 

What can i do with that?

 

can you give me a wonderful prod please!?

 

Snoobs

[Yesideez]

Mchl, check my previous post as to why...

[redarrow]

 

agree strtotime wins

<?php

$year = date('Y');

function isleapyear($year) {

   $year = (int) $year;
   if ($year % 4 == 0) {
      if ($year % 100 == 0) {
         return ($year % 400 == 0);
      } else {
         return true;
      }
   } else {
      return false;
   }
}
echo isleapyear($year);
?>

[Mchl]

Still I see no reason to do it

There are dedicated data types for time, and these should be used.

[Yesideez]

I find INT and time() so much more versatile than using the MySQL methods.

 

Even the forums use the INT time() method.

[Maq]

I have looked... but it doesn't completey tell me... cause in my database i have:

 

1228745009

 

What can i do with that?

 

can you give me a wonderful prod please!?

 

Snoobs

 

Sorry Snoobs, as these guys have steered into their own thread.  The number you have is a timestamp.  You have to use the date function like so...

 

$your_date = 1228745009;
echo date("d-m-Y", $your_date));

 

Check out the manual - date() for more date formats.

 

Hope this is what you're looking for because I don't know what this means:

 

can you give me a wonderful prod please!?

[redarrow]

now u need to format ur time how u want it.

 

http://uk3.php.net/date

 

<?php echo date("d-m-Y h:i:s", 1228745009); ?>
[code]

[Snooble]

thanks so much maq. I'll work out the formatting! I understand now.

 

Thanks!!!!

 

Snoobs

[Yesideez]

Didn't I just post all that?

[Maq]

Didn't I just post all that?

 

:P

[Mchl]

I find INT and time() so much more versatile than using the MySQL methods.

 

Even the forums use the INT time() method.

 

A matter of habit probably...

Just wanted our OP to know, there are other options

I can't imagine anything more convenient than TIMESTAMP DEFAULT CURRENT_TIMESTAMP

 

[Yesideez]

That's why I posted this...

I use INT(10) UNSIGNED for the database entry containing a timestamp

[redarrow]

Got to admit Theo mysql has got some really nice time formatting Theo very powerful

 

We have teached you the best ways to get a timestamp in your database, and shown you

how to format the timestamp.

 

Any think else relating to the post mate....