Diagnostic PHP: Get All User Functions

Sometimes I want to see all the user-defined functions that are in memory when a page loads. Maybe the page doesn’t need certain functions and I can realize performance improvements by removing them. And sometimes — I’m being candid here — I copy functions from one application into a library file for another and don’t need any of them for the current application. This function, offering some diagnostic PHP, helps.
Ok. I’m hooked… let me read the full article →

Update MySQL table using subquery, Excel data

Import Data From Excel

If you’re a developer like me who builds custom database-driven Web sites and Web applications, you don’t necessarily create a user-maintainable content management system (CMS) for absolutely everything you build. In this article, I’m going to show you a simple and practical low-tech solution for adding content from your clients for database-driven content for which you did not build a CMS. The only tools you need for this solution are Microsoft Excel and SQL (in my case, the MySQL flavor).
Ok. I’m hooked… let me read the full article →