XML RSS feed Articles » PHP

Extracting META information from SQL Server (INFORMATION_SCHEMA)

How to retrieve META information from Microsoft SQL Server, using the INFORMATION_SCHEMA, with system tables (sysobjects, sysindexkeys, sysindexes, syscolumns, systypes, etc) and/or with system stored procedures (T-SQL).

PEAR::Pager Tutorials - Use Pager with Smarty. Use Pager_Wrapper with AJAX

Since I keep getting emails asking for help with PEAR::Pager, here's a couple of new examples about the most requested features: 1) how to use Pager with a template engine like Smarty; 2) how to use Pager_Wrapper to paginate database results and display them using AJAX.

An update on my PEAR packages

An update about some of the PEAR packages I maintain: [M]DB_QueryTool, Mail_Queue, MDB2, Translation2.

Get involved in PEAR!

An overview of the many ways to get involved in PEAR, and a few concrete suggestions.

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.
« Previous   1   2   3   4   5   Next »

Lorenzo Alberton

Lorenzo Alberton Lorenzo has been working with large enterprise UK companies for the past 10+ years and is currently CTO at DataSift. He's an international conference speaker and a long-time contributor to many open source projects. Lorenzo Alberton's profile on GitHub Lorenzo Alberton's profile on LinkedIN View Lorenzo Alberton's profile on PHP PEAR
View Lorenzo Alberton's Twitter stream Lorenzo Alberton - Sun Certified MySQL 5 Developer PHP5 ZCE - Zend Certified Engineer