Need help with db-array

mrhatch

Hi there,

I have a question about a function that I don't have, yet ;-)

I'm fetching my arrays from a database via mysql_fetch_array(mysql_query("$QUERY")); and send it through a function that will strip slashes on the whole array.

So far, so good. But right after that, I want to send the $result through a function, that returns $key as a named variable based on the fieldname in the database table.

So:
$row["username"]->"Peter"
shall become
$username="Peter";

How do I work that out, because so far that put me off, and I always had to do the
$uname=$row["uname"];
stuff.

And, in addition to that: What does it mean, if you reference a variable via $$ ($val -> $$val)?

Thanks in advance for any enlightenment🙂

barand

use

[man]extract[/man] ($row) ;

$$x refers to a variable whose name is the contents of $x.

$a = 'hello';
$x = 'a';

echo $$x ; // hello

hth

mrhatch

Oh wow, that was easy. Thank you very much indeed.

But the second problem isn't really resolved. What sense does it make, I really don't get the point.

mrhatch

...and immediately another question occurs: How do I have to treat Null-values? With reference to my php-manual, which says that in a loop Null-Values cannot overwrite preceding values, this function has limited possibilities.

Is there any known workaround, because it is a wonderful and time-saving function 😃

Weedpacket

Originally posted by mrhatch
But the second problem isn't really resolved. What sense does it make, I really don't get the point.

As well as sketched in barand's post, this is covered in the manual as well. It allows the names of variables to be stored in variables.