Tags
AJAX, Apache, Book Review, Charset, Cheat Sheet, Data structures, Database, Firebird SQL, Imagick, INFORMATION_SCHEMA, JavaScript, Linux, mod_rewrite, MySQL, Oracle, PDO, PEAR, Performance, PHP, PostgreSQL, Profiling, Scalability, Security, SPL, SQL Server, SQLite, Testing, Tutorial, TYPO3, Windows, Zend FrameworkBuy me a book
Articles
» PHP
Firebird 2 cheat sheet
Cheat sheet for the upcoming Firebird 2. A handy reference of the FB2 datatypes, an useful query reference and a list of the PHP Firebird/Interbase functions.
PostgreSQL cheat sheet
Cheat sheet for PostgreSQL 8. A handy reference of the PostgreSQL datatypes, an useful query reference (with an eye on the INFORMATION_SCHEMA tables) and a list of the internal PostgreSQL functions.
PEAR::Pager Tutorials - Article Pagination and Navigation
How to navigate through the paragraphs of a long article with PEAR::Pager.
PEAR::Pager Tutorials - Navigation with Pager and AJAX (or simple Javascript)
PEAR::Pager can generate javascript links and AJAX calls. Read how in this new Pager tutorial, examples are included.
DBMS and charsets, a summary and a call for help
Some clarification about charset settings for the various DBMS (MySQL, PostgreSQL, Firebird/Interbase, Oracle, Sqlite) and a call for help for charset setting support in PEAR::MDB2.
PEAR::Pager Tutorials - Create pretty links with Pager and mod_rewrite
How to tell PEAR::Pager about your links format and use it to generate mod_rewrite compatible links.
PEAR::Pager Tutorials - Paginate database results
Paginate database results with PEAR::Pager, in an efficient way.
PEAR::Pager Tutorials
New series of tutorials on PEAR::Pager.
Read-only db access to prevent SQL injection attacks
An idea for safer db applications: use read-only db access wherever possible. Use GRANT to create an user with read-only rights, and use it to prevent SQL injection attacks.
Secure PHP installation on unix/linux systems
Simple guide to a more secure PHP installation on unix/linux systems.
Lorenzo Alberton
Lorenzo 
works as a Consultant / Software Engineer / Technical Team Leader at Ibuildings, always busy with many cool clients.
He's a long-time contributor to many open source projects.
