Re: parsing out quoted text

On Fri, 09 Jun 2006 14:53:09 +0200, sam <php@itab.com> wrote:

$str='bass "electric organ" bagpipes'; $parser($str); $query="SELECT * FROM table WHERE tb_instr = "bass" AND tb_instr = "electric organ" //<<quoted phrase AND tb_instr = "bagpipes"; Anybody know where I can just copy code that will do the above? thanks

I once for just the fun of it, made a regular expression to solve this kind of problem. I haven't tried it in production enviroment, but only on some basic examples. It should support both single and double quotes. $str = 'bass "electric organ" bagpipes'; preg_match_all("/(?<=('|\"))[^\\1]+(?=\\1)|[^ \"']+/",$str,$match); /* $match[0] Array (

    [0] => bass
    [1] => electric organ
    [2] => bagpipes

) */ foreach($match[0] as $key => $value) { $match[0][$key] = 'tb_instr = "'.mysql_escape_string($value).'"'; } $sql = "SELECT * FROM table WHERE ".implode(' AND ',$match[0]); print($sql); //SELECT * FROM table WHERE tb_instr = "bass" AND //tb_instr = "electric organ" AND tb_instr = "bagpipes"