Browse: Home / mysql

mysql

Using MySQL to generate daily sales reports with filled gaps

Using MySQL to generate daily sales reports with filled gaps

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 | Tagged , , , , | 14 Responses

Does your PHP/MySQL app speak Unicode?

Does your PHP/MySQL app speak Unicode?

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 | Tagged , , , | 19 Responses

Importing large databases in MySQL

Importing large databases in MySQL

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 | Tagged , | 3 Responses

A very fast introduction on Mysql triggers

A very fast introduction on Mysql triggers

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 | Tagged , , ,