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.

Advanced Day-to-Night Photoshop Tutorial

In this tutorial I will teach you how to edit in photo in Lightroom and Photoshop to dramatically alter its appearance and mood. We’ll change a broad daylight scene into a night-time one, lit by a street lamp. I’ll also take the opportunity to describe some non-destructive editing techniques in Photoshop.

HDR How-to: Photoshop vs. Picturenaut

Just in case you’re unfamiliar with the therm, HDRI stands for High Dynamic Range Imaging. As I’ve discussed before, a regular photo can’t capture the full range of lights and shadows that the human eye can see. Photographers have long learned to avoid high-contrast situations or to use them to create artistic effects. It all changed when Paul Devebec presented at SIGGRAPH 1997 a method for combining several images with different exposures into one single image with a much higher range of luminosity. To put things in perspective, a camera sensor can cope with contrast ranges on the order of 4000:1, while a scene of a room with an outside view in full sun (something our eyes see every day) has a dynamic range of 100,000:1.

Best 50 Photoshop CS4 shortcuts

Finding tools or remembering where is a button you need fast can be disturbing sometimes so I have selected 50 useful keyboard shortcuts to help you work faster.

Photography: RAW matters

If you own a semi-pro or pro digital camera and you’ve seen file quality settings such as “Extra fine”, “Fine”, “Standard”, “RAW” but never know what “RAW” stands for; if you heard about RAW on forums but never quite understood it; if you ever looked in awe at photos wondering how you could achieve such great colors, then look no further, as I am going to explain all there is to know about RAW.


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.

Photography – understanding exposure

To aid those who want to be in control of their cameras, to go beyond point-and-shoot, I decided to write a series of tutorials on the basics of photography. If you don’t know what the exposure or aperture are, this little tutorial is for you, so read on.

Organize Your Brushes!

When you’ll be moving to hard core photo editing the last thing you want to spend time on is searching for the brushes you need in the multitude of brushes you have loaded. You should get used to loading only the brushes you need, it will save you a lot of time and energy.

Generate Objects from Xml Files

Recently needed some quick method to use objects generated from an existing xml file without bothering to create an xml schema for it. After a few attempts and searching for explanations why a simple task like this wouldn´t work, finally put the steps together:

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.