Parsing a simple sql string in php
| From: | Ashley Sheridan | Date: | Fri, 06 May 2011 09:05:05 +0000 |
| Subject: | Parsing a simple sql string in php | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-312701@lists.php.net to get a copy of this message | ||
Hiya, has anyone had any experience with parsing a string of sql to break it down into its component
parts? At the moment I'm using several regex's to parse a string, which works, but
I'm sure there's a more elegant solution.
The general idea is to produce a nice looking page giving details of updated fields and values.
I'm only concerned with update statements really, and the queries are very simple, operating on
one table at a time, with no sub queries or selects.
Thanks in advance if anyone is able to suggest anything!
Thanks
Ash