mySQL Timestamp convert to RSS PubDate

mySQL Timestamp convert to RSS PubDate:

<?php
$year = substr($timestamp, 0, 4);
$month = substr($timestamp, 4, 2);
$day = substr($timestamp, 6, 2);
$hour = substr($timestamp, 8, 2);
$min = substr($timestamp, 10, 2);
$sec = substr($timestamp, 12, 2);
$pubdate = date(‘D, d M Y H:i:s O’, mktime($hour, $min, $sec, $month, $day, $year));
?>

even better way:

<?php $pubdate = date(‘D, d M Y H:i:s O’, strtotime($timestamp)); ?>

 

via mySQL Timestamp convert to RSS PubDate – PHP Code Snippet.

Track your Dynamic IP

dynamic-vs-static-ip

 

For several reasons I’d like to keep my dynamic IP instead of install a static IP, but I had to use a service such as easydns.com, no-ip.org etc. The only thing I was needed was just the current IP of my home router. So, I had this simple idea which when the linux box detects an IP change, then the script updates the web page. So, when I want to get informed about the ip of my home router, I’m visiting the address example.com/myip/index.php. For this, I made a php script which runs nicely. (more…)