ereg

[Anon]

I have the following SQL-string :

$query = SELECT tykkelse FROM materiale WHERE materiale = '$materiale$' AND tykkelse = '$tykkelse$'

I want to catch the strings in between '$ and $'. I have made this ereg :

ereg("'(.+)'",$query, $arr);

It gives the following result :

$materiale$' AND tykkelse = '$tykkelse$

But the result I want is materiale and tykkelse. Any suggestions ?

Lars Brandi Jensen

[Anon]

I think it should be like this :

ereg("'\$(.+)\$'",$query, $arr).

But the result in $arr is now : materiale$' AND tykkelse = '$tykkelse. It obviosly only finds the starting and ending of my ereg. That in between isn't catched. Hmmmm, this rocket science.

Lars Brandi Jensen

[Anon]

Ah! The ereg pattern matching algorithm is "greedy" meaning
it matches the longest possible string that matches the pattern
rather than the shortest one (which appears to be what you
were expecting.)

To fix it, you must make the closure in the middle be on anything-
but-a-dollar sign instead of on any-character:

ereg("'\$([^{\$]+)\$'",$query,} $arr)

[Anon]

It's a better one, but it only gets materiale and not tykkelse. It would be elegant if ereg worked. But now i made a workaround like this :

$query = "SELECT tykkelse FROM abjensen where '\$materiale\$' and '\$tykkelse\$'";

//$query1= addslashes($query);//test

$explumderet = explode(" ",$query);

while (list ($key, $val) = each ($explumderet)) {
echo "$key => $val<br>";

if ( ereg("'\$", $val) ) {

$val = ereg_replace("'\\$","",$val);
$val = ereg_replace("\\$'","",$val);

echo "$key replacement=> $val<br>"; // check of ereg getting the variables.

$val = $$val;// make variable variables

}

$liste[$key] = $val;//construct new SQL

}
$query1 = implode(" ",$liste);

print("$query1");

?>

Lars Brandi Jensen