Category Archives: Programming

PHP CLI increase memory limit

October 3, 2009 | 3 Comments

When running a PHP script from command line interface (CLI), a higher memory limit may be required in order for the script to be successfully executed. This can be achieved using the “-d” or “–define” option in the commandContinue reading →

Insert value “0″ for primary keys with auto increment in MySQL

July 12, 2009 | No comments

In order to insert value 0 in a field that is set as primary key for a MySQL table you need to execute the following query prior to any insert query: SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;Continue reading →

Remove blank lines from a textarea using Prototype

February 18, 2009 | No comments

Here is a Javascript function used to remove blank lines from a textarea…Continue reading →

Remove spaces from an input field with JavaScript

December 10, 2008 | 2 Comments

This is a small snippet to remove the spaces from an input field using JavaScript. It can be useful when you want a value without spaces, or when you want to replace the spaces from the input field with other characters.Continue reading →

Disable foreign key checks in MySQL

November 24, 2008 | 3 Comments

Disabling foreign key checks in MySQL is usefull when you are dealing with tables that use foreign keys (InnoDB engine).Continue reading →