Pastable version of Adding seconds to a MySQL timestamp

<div style="overflow:auto;border:solid 1px #ccc;background:#000;color:#F8F8F8">
          <div class="section">
            
            <pre style="float:left;margin:0 10px;border-right:0;color:#666;">1
2
3
4
5
6
7
8
9
10
11</pre>
            <pre class="sunburst">/**
 * Split the supplied timestamp string, add the seconds and concatenate the whole thing back into timestamp format. 
 * Note! that the mktime function will perform even if the supplied amount of seconds exceeds 59. It just adds them 
 * as minutes, hours, days, etc. and returns the Unix timestamp from which we can form the MySQL timestamp. 
 */
function addSecondsToTimestamp ($_timestamp, $_amount) 
{
    ist($year, $month, $day, $hours, $minutes, $seconds) = preg_split(&quot;/-| |:/i&quot;, $_timestamp);
    $seconds += $_amount;
    return date('Y-m-d H:i:s', mktime($hours, $minutes, $seconds, $month, $day, $year));
}
</pre>
          </div>
        </div>

Refactor :my => 'code'

Recent

Popular

Pastable version of Adding seconds to a MySQL timestamp