Category Archives: Programming

PHP CLI increase memory limit

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

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

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

Remove spaces from an input field with JavaScript

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

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