Class: Simple Operations

This class can be used to build SELECT, UPDATE and DELETE SQL queries to MySQL from lists of parameters.

It features:

- Establish a database connection automatically from the constructor function
- Build a SELECT query to a table with a given optional condition and order by clause
- Build an SQL UPDATE query from a list of table fields and values and a search condition
- Build a table row DELETE query using a search condition
- Delete a single file with given path
- Delete all files inside a folder

DB Operations Like Connection in Different Mode, SQL Builder, Delete File(s)

SQL Script to Create Database for this Class

Example For this Class