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

Oh, ok this is how i want to do it exactly : ------------ query.php <?php $query = "select * FROM table where id='$value' order by name"; ?> ------------ parse.php <?php $fcontents = join('' , file('query.php')); preg_match_all("/^('\$(.*)')/si", $fcontents,$matches); print_r($matches) ?> Thanks "Chris Hayes" <chayes@antenna.nl> a écrit dans le message de news: 5.2.0.9.0.20030612134632.027a6da0@pop4.antenna.nl... > At 13:54 12-6-03, you wrote: > >>I got a headache doing this, i need to get vars inside an sql query. For > >>example : > >> > >>$query = "select * FROM table where > >>id='$value' order by name"; > >>preg_match_all("/^('\$(.*)')/si", $query,$matches); > > > >That doesn't work as the new string already is like "select * FROM table > >where id='2' order by name" assuming $value was 2... > > True, so try using > > $query = "select * FROM table where > id='__VALUE__' order by name"; > > if you insist on doing it this way. > > If you decide to keep trying with the $value, you need to know that > variables inside "double quotes" are entered on the spot, while not so with > 'single quotes'. > > > Also it is nice to know that the $ has a special position in preg_matching, > i kept this mail from a post from december in this list: > > > such as $, you must escape it twice. For example: > > > > $matchme = "\$example"; > > if (preg_match("/\$example/", $matchme)) { > > > > will not be matched because PHP interprets the \$ and passes it as $. > > Instead, you must do this: > > > > if (preg_match("/\\\$example/", $matchme)) { >