Location: PHPKode > scripts > metafire > metafire/test_metafire.php
<?
	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!";
	
	
	
	
?>
Return current item: metafire