php - stroftime returns -1 - Teh Forum

<body> <div id="header"> <span class="left"> <span class="back"><a href="lthread_list.php?webtag=DEFAULT"><span class="image mobile_back" title="Back"></span></a></span> <span class="image mobile_logo" title="Beehive Forum Logo"></span> </span> <ul> <li> <a class="reply_all" href="lpost.php?webtag=DEFAULT&reply_to=32290.0&return_msg=32290.1"> <span class="image mobile_reply_all"></span><span class="text">Reply to All</span> </a> </li> <li> <a class="navigation" href="#"> <span class="image mobile_navigation"></span><span class="text">Show messages</span> </a> </li> <li> <a class="main" href="#"><span class="image mobile_menu" title="Menu"></span> </a> </li> </ul> </div> <div class="menu main"> <ul> <li><a href="lthread_list.php?webtag=DEFAULT">Messages</a></li> <li><a href="lpm.php?webtag=DEFAULT">Inbox</a></li> <li><a href="lsearch.php?webtag=DEFAULT">Search</a></li> <li><a href="llogon.php?webtag=DEFAULT">Login</a></li> </ul> </div> <div class="menu navigation"><a href="lmessages.php?webtag=DEFAULT&msg=32290.1">1–10</a><a href="lmessages.php?webtag=DEFAULT&msg=32290.11">11–14</a></div> <div id="page_content"> <h3 class="thread_title"><a href="index.php?webtag=DEFAULT&amp;msg=32290.1">php - stroftime returns -1</a> </h3> <div id="messages" data-navigation="32290_1_14_10"> <a name="a32290_1"></a><div class="message" id="message_32290_1"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">24 Apr 2007 19:16</span> <div class="clearer"></div> </div><div class="message_to">To: ALL<span class="message_count">1 of 14</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=32290.1">32290.1</a></div> <div class="message_body"> I'm helping someone with some php code and I've found something I can't figure out:<br /> <br /> <div class="quotetext" id="code-PHP"><b>PHP code:</b></div><pre class="code"><a target="_blank" href="http://www.php.net/echo"><span style="color: #000066;">echo</span></a> odbc_result<span style="color: #66cc66;">(</span><span style="color: #0000ff;">$rs</span>,<span style="color: #ff0000;">'date_of_birth'</span><span style="color: #66cc66;">)</span>; <span style="color: #0000ff;">$dob</span> = <a target="_blank" href="http://www.php.net/strtotime"><span style="color: #000066;">strtotime</span></a><span style="color: #66cc66;">(</span>odbc_result<span style="color: #66cc66;">(</span><span style="color: #0000ff;">$rs</span>,<span style="color: #ff0000;">'date_of_birth'</span><span style="color: #66cc66;">)</span><span style="color: #66cc66;">)</span>; <a target="_blank" href="http://www.php.net/echo"><span style="color: #000066;">echo</span></a> <span style="color: #0000ff;">$dob</span>;</pre><br /> <br /> returns "1953-03-30 00:00:00" and "-1" for the two echos.<br /> <br /> And yet for another record it works fine, returning "1980-10-14 00:00:00" and "340326000".<br /> <br /> I can't see any difference between the dates in the database (which is an Access one; yes <em>I know</em>)<br /> <br /> Any ideas?<br /> <br /> <br /> AH! I think I just figured it out. *test* Yup, it's because the date is before the 1-Jan-1970 epoch.<br /> <br /> Ok... so I can't believe this is the first time anyone has used birth dates with PHP, so any suggestions on how to fix it? </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=32290.1&return_msg=32290.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="32290.1"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a32290_2"></a><div class="message" id="message_32290_2"> <div class="message_header"> <div class="message_from"> From: Matt<span class="message_time">24 Apr 2007 19:31</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 24 Apr 2007 19:42"></span></span> <span class="message_count">2 of 14</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=32290.2">32290.2</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=32290.1#a32290_1" target="_self">32290.1</a></div> <div class="message_body"> I'm pretty certain that's a limitation of the Win32 builds of PHP, it not being able to calculate a timestamp from a date that falls before the Unix epoch.<br /> <br /> To fix it you'd ideally adjust the query to return the date column in a format better supported by PHP. If you can get it to return it as a unix timestamp then that would be ideal, but I guess you can't do that otherwise you already would have, right?<br /> <br /> In which case try using mktime() instead, and exploding the result from the database, like so:<br /> <br /> <div class="quotetext" id="code-php"><b>php code:</b></div><pre class="code"> <a target="_blank" href="http://www.php.net/list"><span style="color: #000066;">list</span></a><span style="color: #66cc66;">(</span><span style="color: #0000ff;">$date</span>, <span style="color: #0000ff;">$time</span><span style="color: #66cc66;">)</span> = <a target="_blank" href="http://www.php.net/explode"><span style="color: #000066;">explode</span></a><span style="color: #66cc66;">(</span><span style="color: #ff0000;">' '</span>, odbc_result<span style="color: #66cc66;">(</span><span style="color: #0000ff;">$rs</span>, <span style="color: #ff0000;">'date_of_birth'</span><span style="color: #66cc66;">)</span><span style="color: #66cc66;">)</span>; <a target="_blank" href="http://www.php.net/list"><span style="color: #000066;">list</span></a><span style="color: #66cc66;">(</span><span style="color: #0000ff;">$year</span>, <span style="color: #0000ff;">$month</span>, <span style="color: #0000ff;">$day</span><span style="color: #66cc66;">)</span> = <a target="_blank" href="http://www.php.net/explode"><span style="color: #000066;">explode</span></a><span style="color: #66cc66;">(</span><span style="color: #ff0000;">'-'</span>, <span style="color: #0000ff;">$date</span><span style="color: #66cc66;">)</span>; <a target="_blank" href="http://www.php.net/list"><span style="color: #000066;">list</span></a><span style="color: #66cc66;">(</span><span style="color: #0000ff;">$hour</span>, <span style="color: #0000ff;">$minute</span>, <span style="color: #0000ff;">$second</span><span style="color: #66cc66;">)</span> = <a target="_blank" href="http://www.php.net/explode"><span style="color: #000066;">explode</span></a><span style="color: #66cc66;">(</span><span style="color: #ff0000;">':'</span>, <span style="color: #0000ff;">$time</span><span style="color: #66cc66;">)</span>; <a target="_blank" href="http://www.php.net/echo"><span style="color: #000066;">echo</span></a> <a target="_blank" href="http://www.php.net/mktime"><span style="color: #000066;">mktime</span></a><span style="color: #66cc66;">(</span><span style="color: #0000ff;">$hour</span>, <span style="color: #0000ff;">$minute</span>, <span style="color: #0000ff;">$second</span>, <span style="color: #0000ff;">$month</span>, <span style="color: #0000ff;">$day</span>, <span style="color: #0000ff;">$year</span><span style="color: #66cc66;">)</span>;</pre><div class="edit_text">EDITED: 24 Apr 2007 19:42 by MATT</div> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=32290.2&return_msg=32290.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="32290.2"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a32290_3"></a><div class="message" id="message_32290_3"> <div class="message_header"> <div class="message_from"> From: Drew (X3N0PH0N)<span class="message_time">24 Apr 2007 19:39</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 24 Apr 2007 19:42"></span></span> <span class="message_count">3 of 14</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=32290.3">32290.3</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=32290.1#a32290_1" target="_self">32290.1</a></div> <div class="message_body"> <p>You need to update PHP I reckon. Unless it's a platform issue, which you using access suggests it may be.</p> <p> </p> <p>If the dates are in a regular format in the database it's probably going to be easiest to write your own function to convert them to timestamps. Why the fuck are they in the db as strings in the first place? -_-</p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=32290.3&return_msg=32290.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="32290.3"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a32290_4"></a><div class="message" id="message_32290_4"> <div class="message_header"> <div class="message_from"> From: Drew (X3N0PH0N)<span class="message_time">24 Apr 2007 19:40</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 24 Apr 2007 19:41"></span></span> <span class="message_count">4 of 14</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=32290.4">32290.4</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=32290.1#a32290_2" target="_self">32290.2</a></div> <div class="message_body"> t'll teach me to post after not refreshing for a while. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=32290.4&return_msg=32290.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="32290.4"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a32290_5"></a><div class="message" id="message_32290_5"> <div class="message_header"> <div class="message_from"> From: Matt<span class="message_time">24 Apr 2007 19:45</span> <div class="clearer"></div> </div><div class="message_to">To: Drew (X3N0PH0N) <span><span class="image post_read" title="Read: 24 Apr 2007 19:50"></span></span> <span class="message_count">5 of 14</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=32290.5">32290.5</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=32290.1#a32290_4" target="_self">32290.4</a></div> <div class="message_body"> You'd think so. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=32290.5&return_msg=32290.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="32290.5"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a32290_6"></a><div class="message" id="message_32290_6"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">24 Apr 2007 19:46</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 24 Apr 2007 19:48"></span></span> <span class="message_count">6 of 14</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=32290.6">32290.6</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=32290.1#a32290_2" target="_self">32290.2</a></div> <div class="message_body"> Don't know how to change the query to return it in a different format. <span class="emoticon e_embarrassed" title=":$"><span class="e__">:$</span></span><br /> <br /> That code you posted looks good - far better than all the stupid "safestrtotime" suggestions I've come across.<br /> <br /> Thanks. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=32290.6&return_msg=32290.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="32290.6"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a32290_7"></a><div class="message" id="message_32290_7"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">24 Apr 2007 19:49</span> <div class="clearer"></div> </div><div class="message_to">To: Drew (X3N0PH0N) <span><span class="image post_read" title="Read: 24 Apr 2007 19:50"></span></span> <span class="message_count">7 of 14</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=32290.7">32290.7</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=32290.1#a32290_3" target="_self">32290.3</a></div> <div class="message_body"> Can't (easily) update PHP version - it needs to all be self-contained, and is using phpDev for that.<br /> <br /> They are stored as date/time values in the db, just not returning as a proper timestamp for whatever reason... I'll blame Microsoft. <span class="emoticon e_smile" title=":)"><span class="e__">:)</span></span> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=32290.7&return_msg=32290.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="32290.7"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a32290_8"></a><div class="message" id="message_32290_8"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">24 Apr 2007 19:58</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 24 Apr 2007 20:11"></span></span> <span class="message_count">8 of 14</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=32290.8">32290.8</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=32290.1#a32290_2" target="_self">32290.2</a></div> <div class="message_body"> Bum, that code doesn't work either. <span class="emoticon e_sad" title=":("><span class="e__">:(</span></span><br /> <br /> Probably just make it a known limitation / "feature" of the system - only people younger than 37 can use it. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=32290.8&return_msg=32290.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="32290.8"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a32290_9"></a><div class="message" id="message_32290_9"> <div class="message_header"> <div class="message_from"> From: Drew (X3N0PH0N)<span class="message_time">24 Apr 2007 20:07</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 24 Apr 2007 22:30"></span></span> <span class="message_count">9 of 14</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=32290.9">32290.9</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=32290.1#a32290_8" target="_self">32290.8</a></div> <div class="message_body"> <p>Where does it fail? there's nowt in that that should fail except perhaps mktime. But if that's it then that's some fucking bullshit and you should complain.</p> <p> </p> <p>But anyway, surely there's a query you can use to get the date out as you want it if it's stored as a date object thing?</p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=32290.9&return_msg=32290.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="32290.9"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a32290_10"></a><div class="message" id="message_32290_10"> <div class="message_header"> <div class="message_from"> From: Matt<span class="message_time">24 Apr 2007 20:19</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 24 Apr 2007 22:30"></span></span> <span class="message_count">10 of 14</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=32290.10">32290.10</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=32290.1#a32290_8" target="_self">32290.8</a></div> <div class="message_body"> <p>Is there a specific reason why you can't upgrade PHP? I've just tested the code on PHP 5 here on Windows and it works fine.</p> <p> </p> <p>If it's the easy PHP installation you're after, it's not all that hard to create your own set up routine for Apache and PHP.</p><div class="edit_text">EDITED: 24 Apr 2007 20:20 by MATT</div> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=32290.10&return_msg=32290.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="32290.10"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div></div> <div class="message_page_footer"> <ul> <li class="right_col"><form accept-charset="utf-8" method="get" action="lmessages.php" target="_self"><input type="hidden" name="webtag" id="webtag" class="bhinputtext" value="DEFAULT" dir="ltr" /><input type="hidden" name="msg" id="msg" class="bhinputtext" value="32290.11" dir="ltr" /><input type="submit" name="submit" id="keep_reading" value="Keep reading…" class="button" /></form></li> </ul> </div> </div> </body>