#summary Demonstration of AplConnection, AplQuery

{{{
<?php

/*
  if you want to connect to an oracle database then
  change the APL_DB_PROVIDER defination line in config.php as

  defined("APL_DB_PROVIDER")?null:define("APL_DB_PROVIDER","oracle"); 

*/
require_once("config.php");
require_once("apl.php");
require_once("db/apldb.php");
/*
  Create connection and query objects
*/
$connObj = new AplConnection("localhost","mysql_user","mysql_pass","test_database");
$qryObj  = new AplQuery( $connObj );

try{
  $activePage = 1;
  $rowsPerPage = 20;
  /*
    Execute our sql statement
  */
  $qryObj->open("select * from my_table where my_query_criteria=34",$rowsPerPage,$activePage);
  /*
    Display column names and values for each row in our query result
  */
  do{
    $rowData = $qryObj->fetch();
    foreach( $rowData as $key => $value )
      echo $key." : ".$value."<br />";
  }while( $qryObj->nextRecord() );
  $qryObj->close();
  /*
    Catch if any exception has thrown
  */
}catch(Exception $e)
{
  if( $e->getCode() == EX_DB_NO_ROWS )
    echo "No Rows Found In Table";
  else
    echo $e->getMessage();
}

?>
}}}