[top-snip]
nice! I'll give it a look this morning
[/snip]
This is another rather hackish attempt at using the tokeniser.
It turns this:
into this:
SELECT * FROM my_table WHERE (up = 'down') ORDER BY my_column $banana
ASC strtoupper( group by something)
Which isn't perfect by a long shot, bu
Robin Vickery wrote:
This is another rather hackish attempt at using the tokeniser.
you beast ;-)
apart from the fact that I don't use mysql this is really cool.
I have no time to play right now (gotta catcha plana) but I have
it on my to do list of things I need to take apart and
understand p
This is another rather hackish attempt at using the tokeniser.
It turns this:
into this:
SELECT * FROM my_table WHERE (up = 'down') ORDER BY my_column $banana
ASC strtoupper( group by something)
Which isn't perfect by a long shot, but I'm away home now so it'll have to do.
I'd be interested
On 8/23/05, Jay Blanchard <[EMAIL PROTECTED]> wrote:
> You may (or may not) remember me posting to the list a couple of weeks
> ago asking about using REGEX to get queries out of PHP files for a
> migration project. I had to let it go for several days, but started
> working on it again yesterday, h
Jay Blanchard wrote:
[top-snip, because it makes sense in the context]
On line 98 I changed from
echo "Line " . str_pad($lineNo, 4, ' ', PAD_LEFT) . ": " .
$fileLine;
to
echo "Line " . str_pad($lineNo, 4, ' ', PAD_LEFT) . ": " .
ltrim($fileLine);
to account for indented code, lines ev
[top-snip, because it makes sense in the context]
On line 98 I changed from
echo "Line " . str_pad($lineNo, 4, ' ', PAD_LEFT) . ": " .
$fileLine;
to
echo "Line " . str_pad($lineNo, 4, ' ', PAD_LEFT) . ": " .
ltrim($fileLine);
to account for indented code, lines everything up neatly.
Al
[snip]
here is a new and improved version:
http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
hi Jay,
here is a new and improved version:
*/
/* script help message */
if (in_array('--help', $_SERVER['argv']) ||
in_array('-h', $_SERVER['argv']) ||
in_array('-?', $_SERVER['argv']))
{
echo '
Use this command to search for SQL query strings inside php files.
call from command
On 8/23/05, Jochem Maas <[EMAIL PROTECTED]> wrote:
> Jay Blanchard wrote:
> >
> > Also, sweet move with the array_reverse...
> >
> > $fileParts = array_reverse(explode('.', $theFile));
> > if("php" == $fileParts[0]){
> >
> > ...it prevents problems with funky file names containing more
Jay Blanchard wrote:
You may (or may not) remember me posting to the list a couple of weeks
ago asking about using REGEX to get queries out of PHP files for a
migration project. I had to let it go for several days, but started
working on it again yesterday, here is the code (no REGEX was used in
[snip]
> argv[] is always available
[/snip]
As an example you could something like this...
$requestedDatabase = $argv[1];
so that [EMAIL PROTECTED]:/usr/myApp/whatever php chaFinder.php CHA >
output.txt
will have $requestedDatabase == 'CHA'
[snip]
btw if my file names are funky I am too?
[/sni
Jay Blanchard wrote:
[snip]
I figured as much - I was think of adding an optional param so that you
can optionally
add such an extra limit e,g:
cd /my/projects/stuff; php findqry.php --limit CHA > ./results.txt
[/snip]
argv[] is always available
indeed - I'll add something for that...
Also
[snip]
I figured as much - I was think of adding an optional param so that you
can optionally
add such an extra limit e,g:
cd /my/projects/stuff; php findqry.php --limit CHA > ./results.txt
[/snip]
argv[] is always available
Also, sweet move with the array_reverse...
$fileParts = array_reverse(
Jay Blanchard wrote:
[snip]
heh Jay, I have been playing with this ...
I rewrote your code abit (including removing the check for the string
'CHA'
- cos that was limiting my search too much ;-)
[/snip]
Cool, I'll have a look. I was using the 'CHA' because I was looking for
queries to the specifi
[snip]
heh Jay, I have been playing with this ...
I rewrote your code abit (including removing the check for the string
'CHA'
- cos that was limiting my search too much ;-)
[/snip]
Cool, I'll have a look. I was using the 'CHA' because I was looking for
queries to the specific database.
--
PHP Gen
Jay Blanchard wrote:
You may (or may not) remember me posting to the list a couple of weeks
I am a goldfish. hi my name is 10second Tom ;-)
ago asking about using REGEX to get queries out of PHP files for a
migration project. I had to let it go for several days, but started
working on it
You may (or may not) remember me posting to the list a couple of weeks
ago asking about using REGEX to get queries out of PHP files for a
migration project. I had to let it go for several days, but started
working on it again yesterday, here is the code (no REGEX was used in
the making of this code
17 matches
Mail list logo
