/ LJCPHPCodeDoc / LJCDBAccessLib / LJCDbAccess


Syntax

PHP
class LJCDbAccess

Provides standard PDO Data Access.

Remarks

The Data Access class encapsulates the repetitive code required to perform common database functions using PDO. This reduces the amount of application code required to access this functionality and provides a standard location for implementing common best practices.

Public Functions
Static Methods
GetValue Returns a data value if the element exists.
Constructor Methods
construct Initializes a class instance.
Data Methods
Execute Executes a non-query sql statement.
Load Loads the records for the provided SQL statement.
Retrieve Retrieves a record for the provided SQL statement.
Other Methods
GetConnection Creates the PDO connection.
LoadTableSchema Returns the Table Schema DbColumns collection.
SetConnectionValues Sets the $ConnectionValues property.
8 Functions

Public Properties
$ConnectionValues The Database Connection values.

Copyright © Lester J. Clark and Contributors.
Licensed under the MIT License.