Recent blog posts
How to Install PostgreSQL 9.1 or the latest PostgreSQL version 9.3 on Debian 7 Wheezy. Basic settings after installation.
November 19th, 2013 9,680
gettext is an ideal way for internationalization of software application resources. It extracts terms parsing source code. Poedit is an excellent front end.
October 21st, 2013 36,204
Logs is the best place to start troubleshooting. Concerning MySQL (or MariaDB), you need to refer to: General query Log, Error Log and Slow Query Log
October 13th, 2013 22,486
Fortunately, it is possible to use prepared statements with MySQL and PHP using MySQLi extension. But, how to bind params, if their number is variable?
Use of secondary icon in jQuery-UI button with jQuery-UI-bootstrap breaks the button layout. Here is a simple CSS fix as a workaround.
September 22nd, 2013 108,813
Automatically post on Facebook with PHP using Facebook PHP SDK. How to create a Facebook app. Obtain and extend Facebook access tokens. Cron automation.
September 18th, 2013 38,487
Automatically post on Twitter with PHP using Codebird-php. How to create a Twitter app. A PHP solution with cron automation.
A Simple PHP Class to Create RSS 2.0 Feed. This post covers RSS version 2.0. In simple words, an rss feed consists of a CHANNEL and channel ITEMS. You can
Detailed instructions to create a jquery-ui autocomplete using php and Mysql as server side technologies. Support for prepared statements.
Recent tech tips
A good solution is to use immutable disks. When a virtual disk marked as immutable, it becomes read-only and differences will be stored in differencing disks
It is useful to prevent direct access of AJAX calls (from browser address bar). A solution could be the following simple function check_is_ajax()
November 4th, 2013 10,597
Date manipulation is a common and useful development task. It was never easy with PHP, until PHP5 and DateTime class. Take a look at date_convert() function
Sometimes you want to check if a string represents a valid timezone. Using PHP versions greater than 5.2, timezone_identifiers_list() would be a solution.
Browser (and browser version) detection is an "all time classic" development requirement. jQuery.browser WAS an excellent solution, but it was removed
September 27th, 2013 10,550
PHP shuffle randomizes (shuffles) the order of the elements in an array. You may use this function to create a simple banner rotator.
September 27th, 2013 4,664
Sometimes, you want to create a list of available time zones to prompt your user to select his/her time zone. PHP offers timezone_identifiers_list
September 13th, 2013 2,490
In most cases you can distinguish if a PHP script was invoked from the command line (or Cron) or by the web server, using php_sapi_name()
September 9th, 2013 8,122
Sometimes you need to replace accented characters with non accented, for example when you want to perform an accent insensitive search. See this function.