This is the code for the class, it includes some debugging variables.
Code: Select all
<?php
final class utilities{
var $errors = array();
var $error_type = '0';
var $alltypes = array();
var $type = array();
var $statement = '';
var $success = 0;
var $elements = 0;
public function __construct(){}
public function __destruct(){}
public function GetAssetTypes(){
try{
$sql = "SELECT * FROM `AssetTypes` ORDER BY `Description`;";
$result = mysql_query($sql);
$count = mysql_num_rows($result);
$i=0;
while($type = mysql_fetch_array($result)){
$alltypes[$i] = $type;
$i++;
}
// while ($i < $count) {
// $ID = mysql_result($result,$i,"ID");
// $Description = mysql_result($result,$i,"Description");
// $type['ID'] = $ID;
// $type['Description'] = $Description;
// $alltypes[] = $type;
// $i++;
// }
$this->success = $count;
$this->statement = $sql;
$this->elements = count($alltypes);
return$this->alltypes;
}catch(Exception $e){
$this->errors[] = $e->getMessage();
$this->error_type = '1';
return;
}
}
}
?>my calling routine contains the following code:
Code: Select all
include("class_lib/utilities.php");
.
.
.
.
if($_SESSION['AssetTypes']==''){
$utility = new utilities;
$_SESSION['AssetTypes'] = $utility->GetAssetTypes();
$debug = count($utility->alltypes);
$count = $utility->success;
}