PHP Classes
elePHPant
Icontem

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    
Last Updated Ratings Unique User Downloads Download Rankings
2008-04-07 (8 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 342 All time: 6,675 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
- SHOW TABLES
- 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
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 cvars.inc.php 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:342
This week:0
All time:6,675
This week:959Up