hey, what's php equivalent of mysql's date() ? I tried time(), but it's totally different.

    The php function

    date()

    is still want you want... Depending on your situation, there are a few things to do. What format is your datetime variable in? If its a timestamp, then you can just use date() directly. If its user input or something, you'll need to call mktime to convert the common date representation to a timestimp, and then use date(). If you're yanking dates from a data base, you can call MySQL's TIMESTAMP function on your date field, and then pass those results back to PHP's date() function.

    Look here for specifics on how to get the date returned the correct way.

    If you need some more advice about this, give some more specifics and we'll help you out.

    Erestar

      I just have a timestamp in the mysql data field, but when i try to use date() by itself, it gives me: Warning: Wrong parameter count for date()

        did you bother reading the date() documentation page i posted earlier? i think it's pretty clear on the exact arguments date() expects.

          Right... Because you're not passing in how the date should be formatted.

          The date() function is for formatting any timestamp any way that you want, so you need to tell it that you only want the date, month, and year, and how you want those represented.

          The first parameter is the format string, and the second is the UNIX timestamp, which is just an integer measuring the number for seconds since 1970 or something.

          Here are some examples from the date() function docs on php.net.

          // Assuming today is: March 10th, 2001, 5:16:18 pm

$today = date("F j, Y, g:i a");                // March 10, 2001, 5:16 pm
$today = date("m.d.y");                        // 03.10.01
$today = date("j, n, Y");                      // 10, 3, 2001
$today = date("Ymd");                          // 20010310
$today = date('h-i-s, j-m-y, it is w Day z ');  // 05-16-17, 10-03-01, 1631 1618 6 Fripm01
$today = date('\i\t \i\s \t\h\e jS \d\a\y.');  // It is the 10th day.
$today = date("D M j G:i:s T Y");              // Sat Mar 10 15:16:08 MST 2001
$today = date('H:m:s \m \i\s\ \m\o\n\t\h');    // 17:03:17 m is month
$today = date("H:i:s");                        // 17:16:17
?>

          Just remember that when you call date(), instead of just passing it the format (like they do in the example) you'll also want to pass your timestamp variable, eg

          date("j, n, Y", $myTimestampVariable);

            You'll also find that its always better to read the docs before posting... That way you'll have a better understanding of it yourself and won't piss anyone off on the boards :p

              Write a Reply...