Ace HTML Pro is an advanced code editor for web developers. It can work with HTML, XHTML, ASP, JavaScript, CSS, WML, XML, Perl, PHP and JSP. You can manage projects in a Visual Studio sort of way, and there and handy features such as FTP uploading, and search and replace through folders and sub-folders. The application sells for $69.95 US, but for the next two weeks you can get your own activation code for free! (more…)

I had previously posted the code to ping a server or remote host from an ASP page. Well no doubt there are many PHP programmers that would like to be able to ping from a PHP page or web application as well. This would be handy for testing up-time and server status. The code also includes code to prevent form spoofing. (more…)

If you're ever trying to restore a MySQL database from a backup file, you may receive the following error: 051005 14:27:04 Error in foreign key constraint creation for table `table_name`. This is most likely to the fact that you are using InnoDB table formats, and you have foreign key contraints set up. Here's how to get past it. (more…)

This JavaScript function will enable your web application to populate a drop-down menu of items on the fly, based on the selection of another list, without reloading the page. I also provide the code to build the arrays by loading them from a database with ASP and PHP. (more…)

This stored procedure will allow you to incorporate proximity searches into your web application. This is the perfect solution to retrieve businesses or otherwise within a certain distance of a specific zip/postal code, and calculate the distance in miles as well. This code takes into account the curvature of the earth in performing the distance calculation. It is assumed that you're storing the geocode for each address in a database. (more…)