My One Line SQL 1.0
Several types of common queries can be run with a single call by using eventual parameters to define queries that take variable values.
Key Features of My One Line SQL:
- 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
Requirements:
PHP 5.0 or higher
More popular Database Tool
- PHP DataGrid 4.2.8 (1 year, 6 months 9 days ago)
- ajaxCRUD 5.0 (2 years, 5 months ago)
- phpMyDataGrid 2007 - AJAX Enabled Datagrid 1.0 (2 years, 5 months ago)
- XAJAX Grid 1.0 (2 years, 4 months 29 days ago)
- PHP MySQL Connection Class 1.0 (2 years, 9 months 4 days ago)
Listing Files

DBQuery.class.php- 5.3 KB
- 10/01/2008 01:31:28

cvars.inc.php- 488 Bytes
- 10/01/2008 01:31:28

examples.php- 6.6 KB
- 10/01/2008 01:31:28

MyOneLineSQL.class.php- 13.9 KB
- 10/01/2008 01:31:28

READ_ME.html- 24.8 KB
- 10/01/2008 01:31:28

SQLable.class.php- 437 Bytes
- 10/01/2008 01:31:28

DBconnect.class.php- 1.5 KB
- 10/01/2008 01:31:28

RunDBQuery.class.php- 10.2 KB
- 10/01/2008 01:31:28

Parameterable.class.php- 512 Bytes
- 10/01/2008 01:31:28
- FREE MySQL Cloud Database Super Simple, Zero-Management MySQL Cloud DB. Use It FREE!
- Pinterest clone Start your own pin board social network today. Get Pintastic and start your own pinterest clone network.
- MYRE Real Estate Software Professional Real Estate solutions by MYREPHP PROGRAMMING!
