sqlresult Class Reference

List of all members.

Public Member Functions

 __construct ()
 __destruct ()
 showResult ($sSQL, $sUser, $sPassword, $bLog, $bShowAll)
 formatStatement ($sSQL)


Detailed Description

Offers functionality for sqlresult.php.

Author:
Stephan Schuetz, stephan.schuetz(at)fhnw.ch
Date:
14.10.2007
Version:
1.0
(c) Copyright GITTA 2007. Creative Commons License "Attribution-Noncommercial-Share Alike" http://creativecommons.org/licenses/by-nc-sa/3.0/

Constructor & Destructor Documentation

sqlresult::__construct (  ) 

Constructor

sqlresult::__destruct (  ) 

Destructor


Member Function Documentation

sqlresult::showResult ( sSQL,
sUser,
sPassword,
bLog,
bShowAll 
)

Execute SQL statement and prepare the result for output (includes in addition to the result of the statement also the log creation).

Parameters:
$sSQL SQL statement.
$sUser User ID.
$sPassword Password of the user.
$bLog Set to true if a log should be generated.
$bShowAll Set to true if the result should contain all the data (without concerning the restirction of maximum number of rows in result).
Returns:
Array with formatted SQL result, SQL statement and if selected the log entry (res: SQL result, log: log entry).

sqlresult::formatStatement ( sSQL  ) 

Formatting SQL statement with GeSHi.

Parameters:
$sSQL SQL statement.
Returns:
Formatted SQL statement.


The documentation for this class was generated from the following file:
Generated on Sun Dec 2 19:47:28 2007 for elSQL - e-learn SQL by  doxygen 1.5.3