RE: [PHP] REGEX for query

2005-08-11 Thread Michael Sims
Jay Blanchard wrote: > [snip] > Assuming unix, I'd do the following from the root of the application > to get a list > of files that contain queries: > > $ egrep "=[:space:]*\".*\b(SELECT|INSERT|UPDATE)\b" * -ril > ... > > Anyway, that's how I'd do it. Hope you got something out of this... > :) [/

RE: [PHP] REGEX for query

2005-08-11 Thread Jay Blanchard
[snip] > > That is a good start, now all I need to do is get the whole query(s) Get them from the mysql logs? [/snip] While that sounds like a good idea there are two things that hamper the effectiveness of this is a total solution; 1. The logs have many queries from other applications that *do

Re: [PHP] REGEX for query

2005-08-11 Thread Robin Vickery
On 8/11/05, Jay Blanchard <[EMAIL PROTECTED]> wrote: > > That is a good start, now all I need to do is get the whole query(s) Get them from the mysql logs? -robin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] REGEX for query

2005-08-11 Thread Jay Blanchard
[snip] Assuming unix, I'd do the following from the root of the application to get a list of files that contain queries: $ egrep "=[:space:]*\".*\b(SELECT|INSERT|UPDATE)\b" * -ril ... Anyway, that's how I'd do it. Hope you got something out of this... :) [/snip] That is a good start, now all I

RE: [PHP] REGEX for query

2005-08-10 Thread Michael Sims
Jay Blanchard wrote: > I have a rather interesting issue. I need to locate every query in > every PHP application we have for an integration project. I have > started doing some research, but I wanted throw this out there as a > little exercize because it is interesting. > > Several queries are wri