A few Extremely Simple Questions

[Branman]

Hello everyone,

 

My name is Brandon and I'm fairly new to php. I just had some questions...

 

In the database I am using the premium subscription END date is stored as a unix time stamp. however when I go to see it I get a date back from 1969..:

 

its a simple date convert script

[obsidian]

Any code? My guess is that if you're not using a DATETIME in your database, you may be calling strtotime() or another date function on a value that is invalid.

[craygo]

you can do it 2 ways, using mysql or using php to convert the timestamp

 

mysql

$sql = "SELECT FROM_UNIXTIME(`fieldname`,'%Y %D %M %h:%i:%s %x') AS newdate FROM tablename";

 

Now newdate will be your formatted date

 

php

<?php
$sql = "SELECT * FROM tablename";
$res = mysql_query($sql) or die(mysql_error());
while($r = mysql_fetch_array($res)){
$newdate = date("Y-m-d G:i:s", $r['timestamp']);
} 
?>

 

Ray

[Branman]

Well, as you can tell I am extremely nooblety at this. Here is what I have:

Current Code:

[code=php:0]$sql = mysql_query("SELECT * FROM ibf_subscription_trans WHERE id=". $_COOKIE['member_id']);
while ($r = mysql_fetch_array($sql))
{
$newdate = date("Y-m-d G:i:s", $r['subtrans_end_date']);
echo "$newdate";
} 

 

Timestamp information:

 

Table Name: ibf_subscription_trans

Field Name: subtrans_end_date

 

All I want to display is - the end date =/ The code above did not work.

[obsidian]

What data type is the column subtrans_end_date? I'm guessing DATE by the name, and if so, you simply need to translate your result to a timestamp to parse:

<?php
$newdate = date('Y-m-d G:i:s', strtotime($r['subtrans_end_date']));
echo $newdate;
?>

[Branman]

Still comes out to 1969 =/

[revraz]

Post the actual timestamp value that you are using.

[Branman]

1202336734 <- That's one of them.

[revraz]

This works fine for me

 

<?php 
$newdate = date("Y-m-d G:i:s", 1202336734);
echo "$newdate";
?>

 

echo $r['subtrans_end_date'];

 

and make sure its the same number.

 

[obsidian]

1202336734 <- That's one of them.

 

If you are storing them in that format (UNIX timestamp), you can just remove the strtotime() call within the date function. I was assuming by your column name that you were using the MySQL DATETIME data type rather than storing it as an integer.