PHP Classes

File: test_sqlcall.php

Recommend this page to a friend!
  Classes of Vincent DiBartolo  >  SQLCall  >  test_sqlcall.php  >  Download  
File: test_sqlcall.php
Role: Example script
Content type: text/plain
Description: Some Tests for the SQLCall object
Class: SQLCall
Easiest possible access to results of a query
Author: By
Last change: Show alternative form of access
Date: 19 years ago
Size: 1,490 bytes


Class file image Download

//assume you have these set somewhere
global $db_user, $db_password, $db_host, $db_name;
$sqlcall = new SQLCall($db_user, $db_password, $db_host, $db_name);

//"true" as a parameter to this method will print out the error message
//if any exists. Method returns true or false so can be used in conditionals.

//set up a select statement to show off the goods
$sqlcall->doSelect("SELECT id, member_id AS mid FROM visitors", false);
"This select retrieved " . $sqlcall->getFieldCount() . " columns per row.<BR>";

$sqlcall->getNext() ){

//The beauty of simplicity - the object sets member variables corresponding
  //to the names of each of the columns in the result set, so that you can
  //simply do $sqlcall-><column name> to access the result. Notice how
  //aliases are handled seamlessly
print "ID: $sqlcall->id, Member ID: $sqlcall->mid<BR>";

//all results are also available as $sqlcall->f<n> where n is a 1-based
  //index. This is good for generic processing.
print "Alternative (should be the same output): ID: $sqlcall->f1, Member ID: $sqlcall->f2<BR>";


//There is no column "x" in this table - expect an error here.
//The error is written into a comment in the source HTML.
$sqlcall->doDelete("DELETE FROM visitors WHERE x = -1");
if( !
$sqlcall->hadErrors(true) ){
"Ok on the delete.<BR>";

//always finalize the sqlcall object


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