HunterDB Code

<?php

/*
********************************************************
Name: queryTest.php
Author: Rob Hunter
Date 1/14/11
Description: This file shows some of the ins and outs of querying.
********************************************************
*/


require_once('../lib/initHunterDB.php');

//create query
$query = new HDB_Query();

//you can chain cast off filters for bonus combo points    
$query->setTopOperator('OR');
$query->filter('type','=','Car')
    ->filter('createdDate','>',1294274216)
    ->filter('OR', 'my.year','=',1998,
                   'my.year','=',2002
                    );
        
    //debugHTML is useful see see what filters you have (if you forgot)        
    print $query->debugHTML();
    
    print $query->getSQL();
    
    //excute returns your results in an array
    $results = $query->execute();

//iterate over results    
if (!empty($results)){
    foreach ($results as $result){
        //debugHTML works on Content and Queries!
        print $result->debugHTML();
    }
}
else{
    echo "No results found<br>";
}   

//Here we dump the whole DB for comparison's sake.  Keep in mind that there's 
//a hard limit of 100 results per query, so if you have more than that, this 
//won't do much good.
echo "<br>Compare against full db<br><br>";

$query = new HDB_Query();

$results = $query->execute();

if (!empty($results)){
    foreach ($results as $result){
        print $result->debugHTML();
    }
}
else{
    echo "No results found<br>";
}

echo "<br>Test QueryType 'count'<br>";

$query = new HDB_Query('count');

//you can chain cast off filters for bonus combo points    
$query->setTopOperator('OR');
$query->filter('type','=','Car');

$count = $query->execute();

echo "Count: $count<br>";
//print_r($count);

?>