Class: database

database __construct( [connInfo $connInfo = null], [connType $connType = "mysql"])

[line 125]

This is the two argument constructor for the database connection object. This will create the database connection if possible or if it fails it will set the 'connected' flag to false indicating that we aren't connected to the database.

Tags:

• access - public

Parameters:

• connInfo $connInfo - The connection information about how to connect to the database. This value should be an array setup in the following fashion. array ( "host" => "hostname", "name" => "database_name", "user" => "username", "pass" => "password" ) If this array is NULL or any of the elements are missing, then they will be defaulted to the values as specified in the constructor.
• connType $connType - The type of database that we are connecting to

TRUE commit( )

[line 880]

This function is used in order to commit all of the queries which were executed on the database to the database.

Tags:

• return - on success, FALSE on failure
• access - public

Parameters:

void freeResults( res $res)

[line 217]

This function is used in order to free the results from the query that is passed in as the argument.

Tags:

• access - public

Parameters:

• res $res - The result set to clear

The getArray( res $res)

[line 699]

This function is used in order to retrieve an associative array from the database statement.

Tags:

• return - associative array retrieved from the database query or NULL if if value passed in was NULL
• access - public

Parameters:

• res $res - The result that the 'query' function returned

The getBoth( res $res)

[line 753]

This function is used in order to retrieve both the associative array and the indexed array from the database statement.

Tags:

• return - associative array and the indexed array retrieved from the database query or NULL if value passed in was NULL
• access - public

Parameters:

• res $res - The result that the 'query' function returned

The getDatabaseConnection( )

[line 784]

This function is used in order to retrieve the actual database connection that was created on instantiation of the object.

Tags:

• return - database connection object
• access - public

Parameters:

TRUE getLogging( )

[line 980]

This function is used in order to determine if we are keeping logs of all of the queries that occur.

Tags:

• return - if we are logging all of the queries, FALSE if we are not
• access - public

Parameters:

The getNumber( res $res)

[line 736]

This function is used in order to retrieve an indexed array from the database statement.

Tags:

• return - indexed array retrieved from the database query or NULL if value passed in was NULL
• access - public

Parameters:

• res $res - The result that the 'query' function returned

The getTotalTime( [$dp $dp = null])

[line 927]

This function is used in order to retrieve the total amount of time it took to execute all of the queries on the database.

Tags:

• return - total amount of time taken to execute all of the database queries in microseconds.
• access - public

Parameters:

• $dp $dp - How many decimal places to round the number to, ignore this parameter if you do not want to round the number, otherwise if invalid then NULL will be returned.

NULL numRows( res $res)

[line 674]

This function is used in order to return the number of rows for a given query.

Tags:

• return - if the parameter is invalid or the number of rows that is with the database statement
• access - public

Parameters:

• res $res - The statement that has been executed.

void printLog( )

[line 1010]

This function is used in order to display the log in a more useful manner.

This function will output the information directly onto the page.

Tags:

• access - public

Parameters:

This query( query $query, args1-X 1)

[line 274]

This function is the starting function for the query that is being run.

It will take in the query with the following values for the parameters and then insert the values in their corresponding spots after making sure that the data passed in matches the correct data type (based on regular expression).

The following are parameter types for the values:

• %u - unsigned integer - ^[0-9]+$
• %d - signed integer - ^[-+]?[0-9]+$
• %p - decimal number - ^[-+]?[0-9]+(\.[0-9]+)?$
• %s - string (no HTML permitted)
• %h - string (HTML permitted)
• %l - list of strings (comma separated) or an array (no HTML permitted)
• %i - IP Address - ^(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$
• %b - Binary Files
• %f - field

The number of arguments passed into this function is required to be directly related to the number of parameters included in the query. For example, if there are two parameters in the query then there should be three arguments for the function (one argument for the query and two arguments for the necessary parameters).

Example of how to use the parameters in a query: $db = new database (); //make the database connection
$result = $db -> query ( "SELECT * FROM `members` WHERE `id` = %u AND `username` = %s", $user_id, $username ); //Create the query
The query will validate the variable $user_id will be validated as an unsigned integer and the $username will be validated as a string.

Tags:

• return - function will either return a PDO Statement which has been executed (if all validation is successful) or NULL NULL will be returned in the following cases:
  • No database connection
  • Too few arguments
  • Too many arguments
  • Invalid Data Type
  • Unknown Parameter Type
• access - public

Parameters:

• args1-X 1 - All of the corresponding values for the query (the number of these is based on however many parameters there are in the database query)
• query $query - The query that we will be building on

An retrieveAllRows( res $res)

[line 769]

This function is used in order to retrieve all of the rows which were obtained by the database query.

Tags:

• return - array of all of the results retrieved from the database
• access - public

Parameters:

• res $res - The result that the 'query' function returned

Either retrieveErrorMessage( res $res, [onlyMessage $onlyMessage = TRUE])

[line 629]

This function is used in order to retrieve the error that was with a corresponding query (i.e. invalid SQL).

Tags:

• return - the string containing the error message or the entire exception.
• access - public

Parameters:

• res $res - The statement that has been executed.
• onlyMessage $onlyMessage - If the user only wants the error message returned or not. This is defaulted to only return the error message.

The retrieveLog( )

[line 1001]

This function is used in order to retrieve the raw version of the log (the array that actually holds the log).

Tags:

• return - array containing the actual log
• access - public

Parameters:

The retrieveNumberOfQueries( )

[line 957]

This function is used in order to retrieve the number of queries which were executed on the database.

Tags:

• return - number of successful queries executed on the database
• access - public

Parameters:

TRUE rollback( )

[line 837]

This function is used in order to rollback any queries which were executed on the database.

Tags:

• return - on success, FALSE on failure
• access - public

Parameters:

void setLogging( $value $value)

[line 967]

<em> This function is used in order to turn on/off the query logging functionality.

Tags:

• access - public

Parameters:

• $value $value - Either TRUE or FALSE depending if you want all queries to be logged (TRUE they will be, FALSE they will not be)

void setVerbose( verbose $verbose)

[line 724]

This function is used in order to set whether or not verbose mode is on or off.

Tags:

• access - public

Parameters:

• verbose $verbose - TRUE if the verbose mode is to be turned on, FALSE otherwise

TRUE startTransaction( )

[line 794]

This function is used in order to start a transaction so that the set of queries can be rolled back or committed at any time.

Tags:

• return - on success, FALSE on failure
• access - public

Parameters: