Login   Register  
PHP Classes
elePHPant
Icontem

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

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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 (6 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 339 All time: 6,253 This week: 1,792Up
Version License PHP version Categories  
myonelinesql 1GNU General Public Lice...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
Age: 43
All time rank: 2478111 in United Kingdom United Kingdom
Week rank: 1826 Up75 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 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:339All time:6,253
 This week:0This week:1,792Up