Re: Parsing a simple sql string in php

On Fri, May 6, 2011 at 10:05 AM, Ashley Sheridan <ash@ashleysheridan.co.uk> wrote: > 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! I'd suggest at least taking a look at pear's sql parser package - using it might save you some headaches ;) http://pear.php.net/package/SQL_Parser > Thanks > Ash > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- http://blogs.linux.ie/kenguest/