[RIGHT]Hello, everybody i got a little problem with a script, i was typing it and verify and all the code and it give me this error
Parse error: syntax error, unexpected T_PUBLIC in C:\Apache2.2\htdocs\hatshop\business\database_handler.php on line 44
here's the code
<?php
// Class providing generic data access functionality
class DatabaseHandler
{
// Hold an instance of the PDO class
private static $_mHandler;
// Private constructor to prevent direct creation of object
private function __construct()
{
}
// Return an initialized database handler
private static function GetHandler()
{
// Create a database connection only if one doesn’t already exist
if (!isset(self::$mHandler))
{
// Execute code catching potential exceptions
try
{
// Create a new PDO class instance
self::$mHandler =
new PDO(PDO_DSN, DB_USERNAME, DB_PASSWORD,
array(PDO::ATTR_PERSISTENT => DB_PERSISTENCY));
// Configure PDO to throw exceptions
self::$_mHandler->setAttribute(PDO::ATTR_ERRMODE,
PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e)
{
// Close the database handler and trigger an error
self::Close();
trigger_error($e->getMessage(), E_USER_ERROR);
}
}
// Return the database handler
return self::$_mHandler;
// Clear the PDO class instance
//lign 44
public static function Close()
{
self::$_mHandler = null;
}
// Wrapper method for PDO::prepare
public static function Prepare($queryString)
{
// Execute code catching potential exceptions
try
{
// Get the database handler and prepare the query
$database_handler = self::GetHandler();
$statement_handler = $database_handler->prepare($queryString);
// Return the prepared statement
return $statement_handler;
}
catch (PDOException $e)
{
// Close the database handler and trigger an error
self::Close();
trigger_error($e->getMessage(), E_USER_ERROR);
}
}
// Wrapper method for PDOStatement::execute
public static function Execute($statementHandler, $params = null)
{
try
{
// Try to execute the query
$statementHandler->execute($params);
}
catch(PDOException $e)
{
// Close the database handler and trigger an error
self::Close();
trigger_error($e->getMessage(), E_USER_ERROR);
}
}
// Wrapper method for PDOStatement::fetchAll
public static function GetAll($statementHandler, $params = null,
$fetchStyle = PDO::FETCH_ASSOC)
{
// Initialize the return value to null
$result = null;
// Try executing the prepared statement received as parameter
try
{
self::Execute($statementHandler, $params);
$result = $statementHandler->fetchAll($fetchStyle);
}
catch(PDOException $e)
{
// Close the database handler and trigger an error
self::Close();
trigger_error($e->getMessage(), E_USER_ERROR);
}
// Return the query results
return $result;
}
// Wrapper method for PDOStatement::fetch
public static function GetRow($statementHandler, $params = null,
$fetchStyle = PDO::FETCH_ASSOC)
{
// Initialize the return value to null
$result = null;
// Try executing the prepared statement received as parameter
try
{
self::Execute($statementHandler, $params);
$result = $statementHandler->fetch($fetchStyle);
}
catch(PDOException $e)
{
// Close the database handler and trigger an error
self::Close();
trigger_error($e->getMessage(), E_USER_ERROR);
}
// Return the query results
return $result;
}
// Return the first column value from a row
public static function GetOne($statementHandler, $params = null)
{
// Initialize the return value to null
$result = null;
// Try executing the prepared statement received as parameter
try
{
/* Execute the query, and save the first value of the result set
(first column of the first row) to $result */
self::Execute($statementHandler, $params);
$result = $statementHandler->fetch(PDO::FETCH_NUM);
$result = $result[0];
}
catch(PDOException $e)
{
// Close the database handler and trigger an error
self::Close();
trigger_error($e->getMessage(), E_USER_ERROR);
}
// Return the query results
return $result;
}
}
?>
