Class: My One Line SQL

This package can be used to compose and execute common types of MySQL database queries.

It can run several types of common queries within a single call using eventual parameters to define queries that take variable values.

Currently it supports the following types of queries:

- SELECT what FROM tablename
- SELECT what FROM tablename WHERE where_expression
- SELECT what FROM tablename ORDER BY order_expression ASC/DESC
- SELECT what FROM tablename WHERE where_expression ORDER BY order_text ASC/DESC
- SELECT what FROM tablename WHERE where_expression ORDER BY order_text ASC/DESC LIMIT query_limits
- UPDATE tablename SET which_set WHERE where_expression
- INSERT INTO tablename (fields) VALUES (which_VALUES)
- CREATE TABLE table_structure
- ALTER TABLE tablename ADD add_what AFTER after_what
- SHOW TABLES
- DROP TABLE tablename
- DELETE FROM tablename WHERE where_expression
- OPTIMIZE TABLE tablename

READ ME file

File containing examples

PHP file for configuration

Class to provide DB connection

Class to support mySQL strings set up

Main class for package - Provides methods to define and execute mySQL query in one line of code

Interface for parameters definitions

Runs mySQL queries

Interface for DB connectivity