PHP
  Home arrow PHP arrow Database Techniques and PHP
Administration  
AJAX  
Apache  
BrainDump  
DHTML  
Flash  
Java  
JavaScript  
Multimedia  
MySQL  
Oracle  
Perl  
PHP  
Practices  
Python  
Reviews  
Security  
Style-Sheets  
Web Services  
XML  
Zend  
Zope  
Forums Sitemap 
IBM® developerWorks 
Sun Developer Network 
E-Commerce Hosting 
Linux Web Hosting 
Managed Hosting 
Small Business Hosting 
Mobile Linux 
App Generation ROI 
VPS Hosting 
Weekly Newsletter

 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
PHP

Database Techniques and PHP
By: O'Reilly Media
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 3
    2007-06-21

    Table of Contents:
  • Database Techniques and PHP
  • Issuing a Query
  • Inside a row array
  • Advanced Database Techniques

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Database Techniques and PHP


    (Page 1 of 4 )

    Picking up where we left off last week in our discussion of databases and PHP, we'll talk about connecting, issuing a query, and more. This article is excerpted from chapter eight of the book Programming PHP, Second Edition, written by Kevin Tatroe, Rasmus Lerdorf, and Peter MacIntyre (O'Reilly, 2006; ISBN: 0596006810). Copyright © 2006 O'Reilly Media, Inc. All rights reserved. Used with permission from the publisher. Available from booksellers or direct from O'Reilly Media.

     Connecting 

    Once you have a DSN, create a connection to the database using the connect() method. This returns a database object you’ll use for tasks such as issuing queries and quoting parameters:

      $db = DB::connect(DSN [, options ]);

    Theoption value can either be Boolean, indicating whether or not the connection is to be persistent, or an array of options settings. Theoption values are given in Table 8-2.

    Table 8-2. Connection options

    Option Controls

    persistent

    Connection persists between accesses

    optimize

    What to optimize for
    debug Display debugging information

    By default, the connection is not persistent and no debugging information is displayed. Permitted values foroptimizeare'performance'and'portability'. The default is'performance'. Here’s how to enable debugging and optimize for portability:

      $db = DB::connect($dsn, array('debug' => 1, 'optimize' => 'portability'));

    Error Checking

    PEAR DB methods return DB_ERROR if an error occurs. You can check for this with DB::isError():

      $db = DB::connect($datasource);
      if (DB::isError($db)) {
       
    die($db->getMessage());
      }

    TheDB::isError()method returnstrueif an error occurred while working with the database object. If there was an error, the usual behavior is to stop the program and display the error message reported by thegetMessage()method. You can callgetMessage()on any PEAR DB object.

    More PHP Articles
    More By O'Reilly Media


       · This article is an excerpt from the book "Programming PHP, Second Edition,"...
     

    Buy this book now. This article is excerpted from chapter eight of the book Programming PHP, Second Edition, written by Kevin Tatroe, Rasmus Lerdorf, and Peter MacIntyre (O'Reilly, 2006; ISBN: 0596006810). Check it out today at your favorite bookstore. Buy this book now.

       

    PHP ARTICLES

    - Working With Different Namespaces in PHP 5
    - User Management Explained: Overview
    - Using Namespaces in PHP 5
    - Database Security: Guarding Against SQL Inje...
    - Building a Modular Exception Class in PHP 5
    - Database and Password Security for Web Appli...
    - Handling MySQL Data Set Failures in PHP 5
    - Building Site Registration for Web Applicati...
    - Intercepting Customized Exceptions in PHP 5
    - Securing Your Web Application Against Attacks
    - Sub Classing Exceptions in PHP 5
    - Authentication for Web Application Security
    - Building a Content Management System with Co...
    - Filters and Login Systems for Web Applicatio...
    - Working with the Email Class in Code Igniter





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
    Stay green...Green IT