PHP Classes

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

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Info   View files View files (9)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2008-04-07 (7 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 342 All time: 6,570 This week: 959Up
Version License PHP version Categories  
myonelinesql 1GNU General Publi...5PHP 5, Databases
Description Author  

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 United Kingdom
Age: 44
All time rank: 2559115 in United Kingdom United Kingdom
Week rank: 1611 Up65 in United Kingdom 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  
 0%Total:342All time:6,570
 This week:0This week:959Up