CODEWITHSUNDEEP
phpmysqlsqlcodeigniter
mtpultz
mtpultz

Reputation: 18248

Displaying queried date field issue using PHP, CodeIgniter, and MySQL?

I altered a table in MySQL to be a timestamp so I could see when a user was created:

ALTER TABLE  `users` CHANGE  `created_date`  `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ;

Using CodeIgniter I queried the database and got my row results for all users:

$this->db->get('users');

In my view I'm trying to display the results using PHP date():

<?php echo date("d-m-Y", $row->created_date); ?>

and I'm getting this error message, which I don't understand:

Severity: Notice
Message: A non well formed numeric value encountered
Filename: users/view_all_users.php
Line Number: 19

where by itself:

<?php echo $row->created_date ?>

produces:

01-01-1970 0000-00-00 00:00:00

Any ideas what I've done wrong?

Upvotes: 0

Views: 875

Answers (2)

F&#233;lix Adriyel Gagnon-Grenier
F&#233;lix Adriyel Gagnon-Grenier

Reputation: 8885

the second argument for date() must be a valid time stamp. 01-01-1970 0000-00-00 00:00:00 is not a valid timestamp. 

$arr = explode(' ',$row->created_date);
$date = $arr[1] . ' ' . $arr[2];
echo date("d-m-Y", strtotime($date));

note that this string: 01-01-1970 0000-00-00 00:00:00 probably denotes that the value in your field is wrong, but this string: 1970-01-01 00:00:00 is valid for use with strtotime()

edit I have an eerie feeling though, are you sure that the full string is outputed by the second echo, or are your two echos taking place, hence mimicking an invalid string? in which case this:

echo date("d-m-Y", strtotime($row->created_date));

will work right away!

Upvotes: 3

Jerry
Jerry

Reputation: 3586

MySQL returns that cumbersome string when you use the TIMESTAMP data type. You can either convert it to the Unix value you are expecting in your query:

SELECT UNIX_TIMESTAMP(`created_date`)...

(and also convert your timestamp to a string when you save it)

Or you can simply use an integer data type in the database and bypass all the string business.

Upvotes: 0

Related Questions