SQL Database Function Wrappers

When interacting with a database, functions are called that are common to every transaction; functions to establish a connection, execute the query and then close the connection.  This article shows how to create functions that will eliminate this redundancy.  We will create a Select function to retrieve data, an Insert function to insert data, an Update function to update data and a Delete function to remove data.

The following pages use MySQL as the database, but the database layer is irrelevant.  These functions can be adapted to use other databases and might be covered in a future article.

Click the "Next Page" link below to begin.