php
MySQL Database Diff Script
Submitted by adam on Tue, 2007-12-25 22:46.Simple PHP script for MySQL database structure diff
Quickstart to PHP Screen Scraping
Submitted by adam on Sun, 2006-11-05 04:17.With the increased use of RSS, screen scraping is becoming less necessary. However, there's still plenty of times that it can get you out of a bind, at least temporarily. I think it's easiest to do screen scraping with PHP and the curl extension (a typical PHP configuration). This shows how I screen scraped the Michigan Lottery website to retrieve the Keno results I used in the article Michigan Keno Stats Over 16 Years.
Reload httpd via PHP (sorta)
Submitted by adam on Fri, 2006-10-27 10:27.The problem:
Apache forked processes (PHP, CGI, etc) runs as a different user (usually www or some variant) which doesn't have permission to restart Apache. To further compound the problem, PHP doesn't allow you to sudo to a user that does have the privileges (they call this a "security feature"). Also, if it did have the privileges, it cannot reload httpd directly because that's it's parent process.
