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 PHP5 ZCE - Zend Certified Engineer has been working with large enterprise UK companies for the past years and is now CTO at DataSift. He's an international conference speaker and a long-time contributor to many open source projects. Lorenzo Alberton's profile on LinkedIN View Lorenzo Alberton's Twitter stream

Lorenzo Alberton - Sun Certified MySQL 5 Developer