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...
> :) [/
[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
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
[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
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
Howdy boys and girls!
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 written as
6 matches
Mail list logo
