By Armand Niculescu on October 21, 2009
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.
Posted in PHP/MySQL | Tagged php, virtuemart
By Armand Niculescu on August 19, 2009
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.
Posted in PHP/MySQL | Tagged chart, code, mysql, php, tutorial
By Armand Niculescu on March 30, 2009
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.
Posted in PHP/MySQL | Tagged mysql, php, tutorial, utf-8
By Armand Niculescu on May 28, 2007
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 any [...]
Posted in PHP/MySQL | Tagged mysql, php
By Armand Niculescu on April 7, 2006
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 application [...]
Posted in PHP/MySQL | Tagged mysql, php, sql, triggers