This is a wrapper class to simplify MySQL queries.
It features
- Connect to a MySQL server reusing connections previously opened to the same server
- Insert or update rows using arrays of fields and values
- Delete rows that satisfy a given condition
- Could execute transaction by sending an array of query
- Emulate sub-selects with NOT IN clause
- Select single field values providing a default value in case no row is returned
This class implements a simple database abstraction interface to access databases.
It provides an abstract class that defined base methods to establish a database connection to a MySQL database.
It also provides an implementation class that extends the base abstract class and implements functions to executing MySQL database queries and retrieve query results in arrays.
This class is a simple MySQL database access wrapper
It can execute SELECT, UPDATE and INSERT SQL queries using single calls that take the table names, column names, column values and table search conditions.
This is a wrapper class to simplify PostgreSQL queries. This is the PostgreSQL version of another previously submitted here to access MySQL for the same purpose.
It features:
- Connect to a PosgreSQL server reusing connections previously opened to the same server
- Insert or update rows using arrays of fields and values
- Delete rows that satisfy a given condition
- Retrieve the next unused field id
- Select single field values providing a default value in case no row is returned
This class is a very simple MySQL database abstraction layer.
There is a base abstract class and an implementation of class that can connect to MySQL databases, execute queries, retrieve query results and get the last inserted table record identifier.
This class can be used to store and retrieve objects from MySQL database tables.
It is a base class that should be extended by a class that specifies the table name and other details that define how to store and retrieve objects in the given table.
The base class can check the variables that changed to learn which table fields should be set when inserting or updating a new object in the table.
It can also retrieve an objects given the identifiers or a search condition, as well delete a loaded object.
Access different databases with the same functions
This package provides access to different databases with the same functions.
There is a base abstract class that defines an interface for establishing connections, executing SQL queries, and retrieving query results.
Then there are implementation classes that implement the same interface to access different types of database. Currently there are implementation classes for accessing MySQL and Microsoft SQL server.