A Simple Twitter Search Parser with PHP
I was recently asked to aggregate tweets based on their hashtags using PHP (no Ajax), so I decided to turn this into a small tutorial that will hopefully enable you build all sorts of XML parsers in PHP.
Full StoryUsing MySQL to generate daily sales reports with filled gaps
I was surprised to see that there’s not a great deal of info on the web on how to do a proper daily report – one that doesn’t have any gaps when data is missing. In this post I’ll try to quide you through building such a report using MySQL and PHP for a nice chart.
Full StoryJavascript animated collapsible panels without any frameworks
If you need to make collapsible panels that remember their state, but don’t want to use any javascript framework, this tutorial will help you do this with no headaches – and you’ll learn some neat javascript tricks too!
Full Story
Does your PHP/MySQL app speak Unicode?
I find it very annoying when I come across web apps that still can’t handle non-ASCII characters correctly. In this article, I’ll show you how, with just a few lines of code, you can “globalize” your online app.
Full StoryAS3 Performance Optimization
Working on a CPU-intensive app in flash is a challenging experience. It can be wonderful or frustrating, depending on your mindset. Based on my experience with flashCHESS and other intensive applications, I’ll give some tips and ideas on how to get the most out of your flash project.
Full StoryAS3 Tutorial: Creating a Slideshow
The code is AS3 and the tutorial assumes some general knowledge of flash and actionscript 1 and 2.
Full StorySearching in all tables and columns of a database
I was forced recently to do some maintenance and bug fixing on an aging .NET-based CMS. Most of the problems were in the SQL Server database, with lots of corrupted entries. The most frustrating thing however was that at times I didn’t even know where to find the entries. Try finding some specific strings in [...]
Full StorySearch and Replace tool for MSSQL
Every now and then I come across some bad practices that needs repairing. This time the “no-no” was in a database tables. I had to change hard-coded links in quite a few tables. Replacing 10,000 absolute URLs spread across the database can be a huge headache, so I decided to work smart, not hard. So [...]
Full StoryForgot or lost SQL Server “sa” password
Here’s a neat thing to remember if you’re using MSSQL: To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the following command:
Full Story