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
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
Importing large databases in MySQL
One of the things I like about PhpMyAdmin is its ability to export an entire database as a series of SQL statements (CREATE and INSERT), a feature I miss in SQL Server. On the other hand the same PhpMyAdmin has a very serious limitation when it comes to import back SQL files: it wouldn’t import [...]
Full StoryA very fast introduction on Mysql triggers
I started to work on a pet project for tracking deleted/pending domains (myDomainTracker) and after starting development I was facing a big problem: How to do the data validation directly from MySQL ? Many times I wanted to do data validation directly when inserting into a MySQL table and leave the source code of my [...]
Full Story