Latest PHP articles...

TBG - The BugGenie performance analyze

-- Published 03.11.2011 --

This article will be removed once TBG 3.2 released. This is a shortlist of tips to improve the performance of issue tracking system and project management tool http://www.thebuggenie.com/ (hereinafter "TBG"). This analyse has been done by my colleague developer Vlado and myself using profiling tools and debugging the code. The reason why we did this is, that we truly appreciate effort invested into the tracker that has good potential. On the other hand we jumped into some issues while setting up TBG 3.1.4 so we took a deeper look into it and.. Read more »

Writing database portable PHP applications

-- Published 12.12.2011 --

Writing database cross-compatible SQL queries for portable web applications is difficult. In fact, each modern relational database system (RDBMS) introduces its own "specialties" and proprietary SQL syntax that aims to provide the best perfomance and functionalities for its own database engine. Unfortunatelly this also means loss of the portability of the application, once one starts implementing such a particular syntax. In this article I will point out basic differences for defining a simple SQL table named "im_inventory" - differences in definitions of indexes, primary keys, autoincremental columns and column quotation. Table definition -.. Read more »

Show Skype Status

-- Published 04.11.2011 --

This is a small utility to display current status of a skype user. You can download zip files here: http://download.synet.sk/skype_status.zip » Skype status - demo Enter a valid skype login name and press "Check status!": Skype Status class: /* * This class reads current account status for supplied skype account. * * @version: version 1.0.1 * @licence: free * * Changelog: * 1.0.0 - initial release, 12/2008 * 1.0.1 - 11/2011 * - removed dependency on cURL extension by switching to stream context, * if cURL.. Read more »

TortoiseHg - How to export changed files

-- Published 02.11.2011 --

TortoiseHg is excellent windows client for Mercurial Hg distributed source control management tool (SCM). It is a standalone installer that installs both Mercurial client and Mercurial Server in one shot. It has excellent performance on mainstream filesystems (Windows NTFS and linux EXT3), extensibility, and heap of features and settings. The only thing I truly missed was the ability to export changed files between two arbitrary commits. Not patches, but whole files. This feature was only supported by SVN and I found it irreplacible while working on many projects. Luckily, it is pretty easy to add this feature to a TortoiseHg client via.. Read more »

Zend Certified Engineer (ZCE) - yes or no?

-- Published 30.10.2011 --

For a professional PHP developer, it is not quite easy to prove his programming capabilities. Programming requires not only a/ technical knowledge, but mainly b/ programmatical visualization - which is hardly measurable quality phenomenon definable as an ability to find the most resources saving solution from long run. Putting both abilities a/ & b/ together one can determine what shapes a "good programmer". Technical abilities (a/) are quantifiable and thus testable. However, vizualization (b/) can be assessed only indirectly after a time since solution implemented. Holder of the Zend certificate is at least 50% guarantee, that one has good technical skills. On the.. Read more »

MSSQL, SQLSRV, PHP and UTF-8

-- Published 15.08.2011 --

Recently I was trying to setup Microsoft SQL Server 2005 for PHP application with UTF-8 support. Looking like a trivial task I hoped to solve the issue within 1-2 hours. In fact, I spent 2 nights figuring out the solution... So here is everything about setting up MS SQL server 2005 and 2008 for PHP with UTF-8 support. Chaos around PHP drivers for MS SQL Part of the problems is caused by the availability of various drivers for the same server under different names distributed via different channels. Currently, following drivers are available for MS.. Read more »

Benchmarking PHP performance 5.0 to 5.3

-- Published 25.07.2011 --

Recently I stumbled over article by Johannes Schlüter announcing amazing +20-30% performance increase in new PHP release. I started to wonder about performance gains between major PHP versions. Here are my benchmark results for versions 5.0.0 up to latest 5.3.5. (at the time of writing): Fig. 1 - Increase in performance between PHP 5.0.0 against PHP 5.3.5 is about 300 - 350 % Benchmarking scenario: WAMP server with apache 1.3 (original intention to include also PHP 4 benchmarks) and installed PHP versions 5.X.X hardware configuration is irrelevant since all PHP versions run on.. Read more »

A must-know for professional PHP developer

-- Published 26.04.2011 --

Basic abilities Web developer vs. Web designer This article applies to web developers, not web designers. Web designer would focus on visual presentation of business logic implemented by a web developer. Here is my list of abilities that professional PHP developer should posses... T-shirt I suggested to my wife and she made it for me:-) PEAR CODING STANDARDS Must have good command of coding standards. PHP IDE WITH DEBUG MODE Must know how to set up debugging environment. Industrial applications with hundreds of complex objects cannot be effectively developed and.. Read more »

Compiling PHP 5.3.3 under CentOS 5.5 with Oracle instantclient 10.2 and OCI8

-- Published 28.11.2010 --

good luck!" # if OCI8/PDO_OCI compiled but not loaded, add into php.ini (/etc/php/php.ini) as needed: # extension=pdo_oci.so # extension=oci8.so Now you should have PHP 5.3.3 compiled in /usr/local/php5. Restart apache [service httpd restart], create file in your document root directory with phpinfo() and check loaded modules. Potential problems: ========================================== PROBLEM 1: ========================================== if apxs not found, try: locate apxs if not found, you have to install httpd-devel package like this (cca 40 Mb): yum install httpd-devel run: updatedb locate apxs Now you should see apxs path e.g. [/usr/sbin/apxs] ========================================== PROBLEM 2: xml2-config not found... Read more »

The Best of PHP 2010

-- Published 15.01.2011 --

During last 6-8 months I did quite extensive research regarding various PHP open source or dual licensed (e.g. community editions) applications. Here is my list of what I found best currently available PHP software. Please note, that this is my personal opinion based on my own tests & experience, and I might have easily missed out other great stuff. It is in no way meant to disrespect great work of other PHP developers. I will try to be objective (subjectively objective:-)) and provide also brief explanations for my choices. Best PHP Framework: Yii Framework I discovered Yii about 5-7.. Read more »