Recent blog posts
Debian 7 Wheezy with Xfce4 is a lightweight desktop environment, fast and user friendly. Support for sound, Flash, Nvidia and networking "out of the box".
Detailed guide to create OpenVPN server on Debian. Manage VPN users. Connect from any operating system.
Avoid reverse DNS errors when sending mail from a machine without public IP or domain available. Adjust exim4 to use SMARTHOST.
How to Install PostgreSQL 9.1 or the latest PostgreSQL version 9.3 on Debian 7 Wheezy. Basic settings after installation.
November 19th, 2013 17,426
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 68,462
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 42,754
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 171,542
Automatically post on Facebook with PHP using Facebook PHP SDK. How to create a Facebook app. Obtain and extend Facebook access tokens. Cron automation.
Recent tech tips
If you want to start a youtube playlist from random video, just add: &index=random_number to the src attribute of the embed code.
Php has functions to easily get basename and file extension. In some cases using of regular expression is necessary.
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 14,413
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 18,118
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 8,263
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