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
VirtueMart quick tip: show brand/manufacturer logo in product details
VirtueMart supports Manufacturer details but by default it just shows the manufacturer’s name in brackets, with a javascript pop-up window, that looks pretty ugly. Fortunately we can add the logo by using the description field of the Manufacturers details and by hacking one file.
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
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