diff options
| author | Callum West <admin@teriyeri.com> | 2014-06-27 11:51:41 +0100 |
|---|---|---|
| committer | Callum West <admin@teriyeri.com> | 2014-06-27 11:51:41 +0100 |
| commit | ea9f7d335aff00546e2dbeba2e176d6aa99f88c6 (patch) | |
| tree | 95dbcb173a814372ea32101a67361df3c6d0f449 | |
| parent | 103f69ead1d6b588d454829aecf95220cd2d9484 (diff) | |
| download | php-mysql-pdo-database-class-ea9f7d335aff00546e2dbeba2e176d6aa99f88c6.zip php-mysql-pdo-database-class-ea9f7d335aff00546e2dbeba2e176d6aa99f88c6.tar.gz php-mysql-pdo-database-class-ea9f7d335aff00546e2dbeba2e176d6aa99f88c6.tar.bz2 | |
Update Db.class.php
Added option for "SHOW" query, and changed requirement to check for first 6 letters. Not all query types are words with 6 letters.
| -rw-r--r-- | Db.class.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/Db.class.php b/Db.class.php index c96434a..fe11d36 100644 --- a/Db.class.php +++ b/Db.class.php @@ -172,9 +172,10 @@ class DB $this->Init($query,$params); # The first six letters of the sql statement -> insert, select, etc... - $statement = strtolower(substr($query, 0 , 6)); + $rawStatement = explode(" ",$query); + $statement = strtolower($rawStatement[0]); - if ($statement === 'select') { + if ($statement === 'select' || $statement === 'show') { return $this->sQuery->fetchAll($fetchmode); } elseif ( $statement === 'insert' || $statement === 'update' || $statement === 'delete' ) { |