Fancy Javascript slideshow – no framework required
If you thought having broadband makes page size irrelevant, you were wrong. Bandwidth costs money and a few saved kilobytes over a million impressions means real savings, not to mention that Google ranks sites based on their speed too. I’ll show you how you can create a fancy slideshow in under 2KB, rather than about 100KB for JQuery + JQuery Cycle plugin.
Full Story
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 Story
Using 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 Story
Javascript 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 Story
AS3 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 Story
AS3 Tutorial: Creating a Slideshow
The code is AS3 and the tutorial assumes some general knowledge of flash and actionscript 1 and 2.
Full Story
Searching 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 Story
Search 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 Story
Forgot 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