Right then.
Here's what I have done, and it works:
===Contents of query.txt=======
<?php
$fcontents = <<<QUERY
select * FROM `table` where id='$value' order by name
QUERY;
?>
===End Contents of query.txt===
Then:
===Contents of parse.php=======
<?php
include('query.txt');
preg_match_all("/^('\$(.*)')/si", $fcontents,$matches);
print_r($matches)
?>
===End Contents of parse.php===
Now, whereas this works, I am still looking for a way to
store and interpolate variables contained in "query.txt"
without the kludge of having to embed the assignment of
"$fcontents" inside the file as above :-(
Have fun,
Monu
-----Original Message-----
From: Hatem Ben [mailto:[EMAIL PROTECTED]
Sent: 12 June 2003 14:59
To: [EMAIL PROTECTED]
Subject: [PHP] Vars inside an sql query [Regular expression question] -
Again
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
