Location: PHPKode > scripts > Database Queries > database-queries/DatabaseQueriesExample.php
<?php	
include_once("DatabaseQueriesFactory.php");
include_once("ConnectionManagerFactory.php");
include_once("DBTypes.php");


 /**
  * Get the corresponding ConnectionManager object w.r.t to database specified in DB_TYPE constant(DBTypes.php).
  * Factory Method. One can use their own connection object. I used here ConnectionManager Class to connect to the database.
  *	You can find the ConnectionManager Class at the following url http://www.phpclasses.org/browse.html/package/1429.html
  */
$objConnectionClass = ConnectionManagerFactory::getInstanceOf(DB_TYPE);

/** 
 * Invoke the doConnection object to make a connection to the specified database
 */
$objConnectionClass->doConnection();

/**
 * Get the connectionHandle (Base Class Method).
 */
$conn = $objConnectionClass->getConnectionHandle();

/**
 * Select the database.
 */
$objConnectionClass->selectDatabase();

$selquery = "select * from alumini order by firstname";



/**
 *  $edited = "F";
 * 	$selquery = "SELARTICLES"; //(Procedure name).
 *  $params = array("@edited"=>array($edited=>SQLCHAR, false)); // (Procedure Parameters).
 */	
	
$params = null;

/**
 * Get the corresponding DatabaseQueries object w.r.t to database specified in DB_TYPE constant(DBTypes.php).
 * Factory Method.
 */

/**
 * if $params in null it means the query is of type inline otherwise it is a procedure and provide the $params associative array
 * as follows:-
 * $params -- Associative array  eg. array("@edited"=>array($edited=>SQLCHAR, false));
 * where -- @edited is input/output paramter,
 *		 -- $edited is the value of Input Parameter @edited,
 * 		 -- SQLCHAR is a the MSSQL Constant for CHAR column type,
 *		 -- false indicates @edited is not an output parameter.
 */
		
$objDatabaseClass = DatabaseQueriesFactory::getInstanceOf($selquery, $conn, $params, DB_TYPE);

/**
 * Call the executeQuery method.
 */
if(!$objDatabaseClass->executeQuery())
{
	die("Cannot query");
}

 /* $result = your resultset fetched from database by calling base class method getResultSet(). */

$result = $objDatabaseClass->getResultSet();
$row = $objDatabaseClass->getResultArray();
echo $row["firstname"];
 
/**
 *  get the number of rows in a result set.
 */
$rowcount = $objDatabaseClass->getNumRows();


unset($objConnectionClass);
unset($objDatabaseClass);
?>
Return current item: Database Queries