Skip to main content

Home/ PHP Programming/ Group items tagged database abstraction

Rss Feed Group items tagged

renews_

Doctrine - PHP Object Relational Mapper - 0 views

  •  
    Doctrine is an object relational mapper (ORM) for PHP 5.2.3+ that sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL. This provides developers with a powerful alternative to SQL that maintains flexibility without requiring unnecessary code duplication.
sloansteddi

PEAR::Pager Tutorials - Paginate database results - 0 views

  • Method #2: Pager_Wrapper to the rescue!
  •  
    This tutorial explains how to paginate database results using PEAR::Pager and Pager_Wrapper. The latter is useful, because without it (Pager_Wrapper), you are selecting the ENTIRE result set for each page, which undoes one of the important advantages of paginating.
Raúl - [^BgTA^]

Abstracting Database Access Using Polymorphism with Objects in PHP 5 - 0 views

  •  
    Usar polimorfismo en PHP5 para acceder a diferentes BD
sloansteddi

How to use PHP and PEAR MDB2 (Tutorial) | David and Katherine Goodwin - 0 views

    • sloansteddi
       
      Prepare takes the $sql (with '?'s where data will go), along with the TYPES (array) of data to prepare the sql for, and a 3rd paramater for manipulating or result-getting (see next paragraph). It assigns this to $prepared_statement. Another array is created with the data (in the same order as the types, of course), and the RESULT is aquired by running the execute() method on the $prepared_statement object, passing the execute method the "$data" array to fill in the '?'s After this do everything as normal.
  • column = ?
  • id = ?
  • ...1 more annotation...
  • I have a feeling that MDB2 lower cases all field names - so you'll probably need : echo $row['name'] A good idea would be to print_r($row) or similar, to see what's in it
  •  
    A great walk through on getting started with MDB2
1 - 4 of 4
Showing 20 items per page