A simple server-side dashboard for Union Platform
Union is a development platform for creating multiuser applications. It contains a server written in Java and client libraries in AS3, Javascript with Websocke and even server-side with Node.js. The communication protocol is XML-based and open so anyone can write a custom client in any language. In fact, in this article I’ll show you how Union can talk with PHP.
Full Story
The “right way” to handle file downloads in PHP
I’ve seen many download scripts written in PHP, from simple one-liners to dedicated classes. Yet, at least half of them share common errors; in many cases programmers simply copy the code from something that works, without even attempting to understand what it really does. What follows is not a complete working download script, but rather a set of issues you should be aware about and that will allow you to write better code.
Full Story
Should your CMS be allowed to do that?
I happen to love WordPress. Its features and sheer variety of plugins makes it ideal not just for blogs but for a whole range of sites. Having worked with many CMSes, both opern source and proprietary, I think WP strikes the best balance between features and ease of use. However, recently there has been quite [...]
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
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