Lets assume I have the following string:
"SELECT field1, field2, field3 FROM tablename WHERE field1 = 'something' "
Is there any way to get "field1, field2, field3"? assuming it might also
have join, left join - things like that.
I can easily do it with preg_match, but I have to make sure its "foolproof".
It would be a lot better if it will also be able to parse the whole query -
catch limit, where, joins, comments....
Is there any php class that could do it?
I've looked in the pear site and on Google but haven't had any luck.
Use ROT26 for best security