PHP Classes
elePHPant
Icontem

File: examples/mysql_1.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Cesar D. Rodas  >  Database Abstraction Layer  >  examples/mysql_1.php  >  Download  
File: examples/mysql_1.php
Role: Example script
Content type: text/plain
Description: Example of an MySQL query
Class: Database Abstraction Layer
SQL database abstraction layer
Author: By
Last change: * Fixing minor bug
Date: 7 years ago
Size: 3,026 bytes
 

Contents

Class file image Download
<?php
/*
***************************************************************************
* Copyright (C) 2007 by Cesar D. Rodas *
* cesar@sixdegrees.com.br *
* *
* Permission is hereby granted, free of charge, to any person obtaining *
* a copy of this software and associated documentation files (the *
* "Software"), to deal in the Software without restriction, including *
* without limitation the rights to use, copy, modify, merge, publish, *
* distribute, sublicense, and/or sell copies of the Software, and to *
* permit persons to whom the Software is furnished to do so, subject to *
* the following conditions: *
* *
* The above copyright notice and this permission notice shall be *
* included in all copies or substantial portions of the Software. *
* *
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, *
* EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF *
* MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.*
* IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR *
* OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, *
* ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR *
* OTHER DEALINGS IN THE SOFTWARE. *
***************************************************************************
*/
require("../dbal/dbal.php");
/* connect */
$dbh = new dbal("mysql://root@localhost/foobar");
/* set cache, directory*/
$dbh->setCacheDir("./cache");
/* execute an SQL */
$dbh->execute("create table foo(bar integer, xFoo varchar(250))");
/* compile an SQL */
$dbh->compile("insert into foo values(:bar, :xFoo)");
/* Execute SQL, passing parameters */
for($i=0;$i<50; $i++)
   
$dbh->execute( array('bar'=>$i, 'xFoo'=>"xfoo vale $i") );
   
/* now query*/
    /* first method */

   
$dbh->compile("select * from foo where bar between :min and :max");
   
/* the result is cache for 60 seconds */
   
$record = $dbh->query(array('min'=>5, 'max' => 40), 60);
   
/**
     * Equivalent to:
     * $record = $dbh->query("select * from foo where bar between :min and :max",array('min'=>5, 'max' => 40), 60);
     */
   
if (!$record) {
        echo
$dbh->getLastError();
    } else {
       
/* bind parameters */
       
$bar = & $record->bindColumn('bar');
       
$xFoo = & $record->bindColumn('xFoo');
       
/* also the result is saved on $f*/
       
while ( $f = $record->getNext() ) {
            echo
"$bar = $xFoo<br>";
           
print_r($f);
            echo
"<hr>";
        }
    }
?>