Re: [PHP] Vars inside an sql query [Regular expression question]- Again

[Marek Kilimajer]

Now I noticed you did not escape backslash that was supposed to escape 
the dolar sign.

preg_match_all("/^.*('\\\$(.*)')/si", $fcontents,$matches);
                      ^ ^
Hatem Ben wrote:
Well, it's finally working, but still very confusing ... thanks all

<?php

$fcontents = join('' , file('query.txt'));

preg_match_all('/(\'\$(.*)\')/si', $fcontents,$matches);

print_r($matches)

?>

Regards,
Hatem
----- Original Message -----
From: "Hatem Ben" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Marek Kilimajer" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 4:35 PM
Subject: Re: [PHP] Vars inside an sql query [Regular expression question] -
Again


It's not working also

----- Original Message -----
From: "Marek Kilimajer" <[EMAIL PROTECTED]>
To: "Hatem Ben" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 5:23 PM
Subject: Re: [PHP] Vars inside an sql query [Regular expression
question] -

Again



preg_match_all("/^('\$(.*)')/si", $fcontents,$matches);
                 ^^
you don't allow any character between start of the string and single
quote.

preg_match_all("/^.*('\$(.*)')/si", $fcontents,$matches);

Hatem Ben wrote:

I'm asking again the same question, coz i guess my question wasn't
clear.

i just need to retreive vars inside query.txt, my regular expression
seems to be correct for me, but i don't find why it doesn't wrk

------ Starting query.txt
select * FROM `table` where id='$value' order by name
------ Ending query.txt
------ Starting parse.php
<?php
$fcontents = join('' , file('query.txt'));
preg_match_all("/^('\$(.*)')/si", $fcontents,$matches);
print_r($matches)
?>
--------- Ending parse.php
rewriting query is another question, that i agree also.

Thanks
Hatem


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php