PHP Classes

File: test/php/out3.txt

Recommend this page to a friend!
  Classes of Nikos M.   Dialect PHP SQL Query Builder   test/php/out3.txt   Download  
File: test/php/out3.txt
Role: Documentation
Content type: text/plain
Description: Documentation
Class: Dialect PHP SQL Query Builder
Build SQL queries from templates
Author: By
Last change: v.1.4.0 contd

* support default values in sql_function, sql_type
* more standard and versatile sql types supported
* add JSON sql type
Date: 1 year ago
Size: 570 bytes
 

Contents

Class file image Download
Dialect.VERSION = 1.4.0 SQL dialect = mysql SELECT * FROM `table` AS `main` ORDER BY RAND() ASC `trick``ier` 'trick\'\\ier' SELECT `trick``ier` AS `trickier`,`trick'y` AS `tricky` FROM `table` SELECT * FROM `table` WHERE (`id` IN (SELECT `id` FROM `anothertable`)) INSERT INTO `table` (`col1`,`col2`) SELECT `col1`,`col2` FROM `anothertable` WHERE (`id` = 1) SELECT `anothertable`.`col1`,`anothertable`.`col2`,`dynamictable`.* FROM `anothertable`,(SELECT `trick``ier` FROM `table` WHERE (`col4` LIKE '%foo%')) AS `dynamictable` WHERE (`id` = 1)