PHP Classes

My One Line SQL: Compose and execute common MySQL database queries

Recommend this page to a friend!
  Info   View files View files (9)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 344 All time: 7,050 This week: 206Up
Version License PHP version Categories
myonelinesql 1GNU General Publi...5PHP 5, Databases


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
- DROP TABLE tablename
- DELETE FROM tablename WHERE where_expression
- OPTIMIZE TABLE tablename

Picture of Carlo Tasca
Name: Carlo Tasca <contact>
Classes: 2 packages by
Country: United Kingdom
Age: 53
All time rank: 2754126 in United Kingdom
Week rank: 233 Up5 in United Kingdom Up
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files  
File Role Description
Accessible without login HTML file READ_ME.html Doc. READ ME file
Accessible without login Plain text file examples.php Example File containing examples
Accessible without login Plain text file Conf. PHP file for configuration
Plain text file DBconnect.class.php Class Class to provide DB connection
Plain text file DBQuery.class.php Class Class to support mySQL strings set up
Plain text file MyOneLineSQL.class.php Class Main class for package - Provides methods to define and execute mySQL query in one line of code
Plain text file Parameterable.class.php Class Interface for parameters definitions
Plain text file RunDBQuery.class.php Class Runs mySQL queries
Plain text file SQLable.class.php Class Interface for DB connectivity

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:7,050
This week:206Up