PHP Classes

File: test_metafire.php

Recommend this page to a friend!
  Classes of meta  >  metafire  >  test_metafire.php  >  Download  
File: test_metafire.php
Role: Example script
Content type: text/plain
Description: example file
Class: metafire
database abstraction layer for firebird/interbase
Author: By
Last change: modify some functional test
Date: 19 years ago
Size: 2,184 bytes
 

Contents

Class file image Download
<?
   
require("metafire.lib.php");
   
$fbird = new metafire;
   
// test simple query
    // use this if only select operation
   
   
$sql = "select first_name,last_name from employee";
   
$intQuery=$fbird->Query($sql,0,1);
   
$rows=0;
    while (
$fbird->fetchObject($intQuery)) {
       
$rows++;
        echo
$rows.". ".$fbird->fetchRow("first_name")." ".$fbird->fetchRow("last_name")."<br>";
    }
    echo
"Query script: ".$fbird->strQuery."<br><br><br>";
   
$freeResult=$fbird->FreeQueryResult($intQuery);
   
   
   
/*
    $coln = $fbird->GetNumFields($intQuery);
    for ($i=0 ; $i < $coln ; $i++) {
          $col_info = $fbird->GetFieldInfo($intQuery,$i);
             echo "name: ".$col_info['name']."\n";
            echo "alias: ".$col_info['alias']."\n";
             echo "relation: ".$col_info['relation']."\n";
            echo "length: ".$col_info['length']."\n";
            echo "type: ".$col_info['type']."<br>";
        }
          $freeResult=$fbird->FreeQueryResult($intQuery);
    */
   
   
    /*
    // test query with transaction
    // prefereble for insert,update,delete operation as u can rollback when u need to
    $sql = "update employee set last_name='Nelson' where emp_no=2";
    //$fbird->Query($sql,1,1);
   
    //not auto commit
    $intQuery=$fbird->Query($sql,1,0);
    //$fbird->CommitTransaction($intQuery);
   
    //u can only rollback what u have no committed
    $fbird->RollbackTransaction($intQuery);
    */
   
   
       
    // test prepared query 'update' with transaction, commit and rollback
   
$updates = array(
       
'Australia' => 'Dollar',
       
'Belgium' => 'Franc'
       
);
   
   
/*
    $sql ="UPDATE country set currency= ? where country = ?";
   
    //using transaction
    //$intPreQuery=$fbird->PreQuery($sql,1);
   
    //default, without transaction
       $intPreQuery=$fbird->PreQuery($sql);

        while (list($id, $name) = each($updates)) {
                    $intQuery=ibase_execute($intPreQuery, $name, $id);
        }
       $fbird->FreePreQuery($intPreQuery);
      
       // always commit if using transaction
       //$aryResult=$fbird->CommitTransaction($intPreQuery);
      
    // transaction could be more powerful in sql script running in database backend engine
    */
   
   
       
echo "Done!";
   
   
   
   
?>

For more information send a message to info at phpclasses dot org.