Javascript PHP String not returning desired results

Question

I am using this javascript or PHP to convert a database field into a string so that I can sort on that column, however when the value of the database is null - the sorting is screwed up because I get a weird value around 1970 for the year

Does anyone know how to fix this ??

$movie_str = date('Ymd', strtotime($row['CD_MOVIE']));

Can you give us the content of $row['CD_MOVIE'] and the actual weird value — cl3m
– cl3m, Commented Mar 2, 2016 at 15:20
I am using this javascript to convert a database... - Er... Where's the JavaScript? — Praveen Kumar Purushothaman
– Praveen Kumar Purushothaman, Commented Mar 2, 2016 at 15:21
"weird value around 1970" means that strtotime() failed, returned boolean false, which was then type-cast to an integer 0 for date(), which then converted it to the epoch, Jan 1/1970 — Marc B
– Marc B, Commented Mar 2, 2016 at 15:25
@Rus : It's hard to tell what exactly went wrong without you telling us what value is inside $row['CD_MOVIE']. — John Slegers
– John Slegers, Commented Mar 2, 2016 at 15:28

Maxime Savard · Accepted Answer · 2016-03-02 15:54:19Z

3

Depending on what you want to do when your value is null, you could do something like

$val = $row['CD_MOVIE'];
$movie_str = (!is_null($val)) ? date('Ymd', strtotime($val)) : "0";

edited Mar 2, 2016 at 15:54

answered Mar 2, 2016 at 15:26

Maxime Savard

12812 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ronald Over a year ago

I just want the value to be '0'

Maxime Savard Over a year ago

I changed my answer :)

ImClarky Over a year ago

Could be shortened to: $movie_str = (!is_null($val)) ? date('Ymd', strtotime($val)) : 0;

Collectives™ on Stack Overflow

Javascript PHP String not returning desired results

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related