Download the PHP package marcel-maqsood/database-connector without Composer

Database-Connector | PersistentPDO

You can install this package with the following command:

Configuration

Our Database-Connector has a very easy configuration:

Also, you can either add our PersistentPDO within any of your ConfigProviders or directly inside your applications :

The syntax is the same for ConfigProviders but by adding it into your dependencies, you will always have access to it at any module of your application without thinking about its configuration again.

Functionality:

get():

Fetches data from the database based on specified conditions.

This function constructs and executes a SQL query to retrieve data from the database.

It receives the follwing params:

• $field - The field in which to search for the $identifier.
• $table - The table in which to search.
• $conditions - An array oe string of conditions to filter the results.
• $joins - An array that defines which tables should be used for certain columns.
• $groupDetails - An array that defines how multiple row values can be grouped.
• $debug - if the generated SQL should be printed for debugging.

conditions are getting appended after "WHERE" don't include it.

The first condition should not include a 'logicalOperator' key, as there is no preceding condition to combine with, also it won't get used if defined. Example: string"name = 'test'" this function returns a (field value) or , if no row was found matching your conditions.

getAll():

For further details, see get(); as this method uses the same syntax.

The main difference between get() and getAll() is self explaining: getAll() fetches every row that matches your conditions instead of just the first one.

It returns either or an filled with keys and values where every value is a .

getAllBase()

The main difference between getAll() and getAllBasae() is : getAllBase() requires a SQL string instead of plain table-names, conditions, joins or anything.

This is extremly useful when you need to make edge-case queries like checks for items that are present in one table but not in another as this is not supported by our other functions and thus require custom SQL statements.

Just like getAll() - It returns either or an filled with keys and values where every value is a .

update()

Updates data in the database based on specific conditions.

It receives the follwing params:

• $updates - An array with fields and the new values:

• $debug - if the generated SQL should be printed for debugging.
• $conditions - this function uses the same syntax as get().

This functions returns a bool: the result of the given statement.

insert()

Inserts data in the database based on specific conditions.

It receives the follwing params:

• $table - The table in which this entry should be added
• $inserts - An array with fields and values.
• $debug - if the generated SQL should be printed for debugging.

$inserts array is defined like $updates array of update().

This function either returns the ID of the inserted row or false, if there was an issue with the statement.

delete()

Deletes data in the database based on specific conditions.

It receives the follwing params:

• $table - The table in which this entry should be added
• $conditions - this function uses the same syntax as get().

This functions returns a bool: the result of the given statement.

Condition Array

As stated earlier, conditions can either be a string (x = y) without appended "WHERE" or a condition array, which can look something like this:

This insures that you can either use simple conditions for only certain cols and tables or even conditions that need to contain some more logic, as: if ´COL´ IS NOT NULL then use ´COL´ otherwise use ´otherCOL´