diff options
| author | Stanislau <stanislau.wolski@gmail.com> | 2011-10-18 18:22:44 +0300 |
|---|---|---|
| committer | Stanislau <stanislau.wolski@gmail.com> | 2011-10-18 18:22:44 +0300 |
| commit | abf8d3aaf8e27f7f6b4f86af7a7431ca26c2d51f (patch) | |
| tree | 0c96f3fa39227252420fc99bfa319da01626751f /codebase | |
| parent | eea651fc447c54ff229dea7a7a6e3f0896cad4b9 (diff) | |
| download | connector-php-abf8d3aaf8e27f7f6b4f86af7a7431ca26c2d51f.zip connector-php-abf8d3aaf8e27f7f6b4f86af7a7431ca26c2d51f.tar.gz connector-php-abf8d3aaf8e27f7f6b4f86af7a7431ca26c2d51f.tar.bz2 | |
[add] support to non-select sql
Diffstat (limited to 'codebase')
| -rw-r--r-- | codebase/db_common.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/codebase/db_common.php b/codebase/db_common.php index 7c8f942..94e843a 100644 --- a/codebase/db_common.php +++ b/codebase/db_common.php @@ -222,7 +222,7 @@ class DataRequestConfig{ if (count($data)!=2) $data = preg_split("/[ \n\t]+from/i",$sql,2); $this->fieldset = preg_replace("/^[\s]*select/i","",$data[0],1); - + if (count($data) == 1) return; $table_data = preg_split("/[ \n\t]+where/i",$data[1],2); /* if sql code contains group_by we will place all sql query in the FROM @@ -719,7 +719,8 @@ abstract class DBDataWrapper extends DataWrapper{ sql string for select operation */ protected function select_query($select,$from,$where,$sort,$start,$count){ - $sql="SELECT ".$select." FROM ".$from; + $sql="SELECT ".$select; + if ($from) $sql.=" FROM ".$from; if ($where) $sql.=" WHERE ".$where; if ($sort) $sql.=" ORDER BY ".$sort; if ($start || $count) $sql.=" LIMIT ".$start.",".$count; |