[SOLVED] Assign each value from mysql query automatically?

[scooter41]

Hi There... is there anyway after retrieving a mysql query, I can automatically assign "all values with a respective variable name"?

 

Example:

 

instead of saying

 

$name=$row['name'];

$email=$row['email];

$username=$row['username'];

 

that I can just say ...

 

retrieve data query...

then for all row fields, assign to a respective variable name?

 

I'm moving from a perl/cgi land which it was relatively simple there, so assume it is here too

 

Thanks for any help in advance.

[GingerRobot]

Sure. Try:

 

<?php
foreach($row as $k => $v){
$$k = $v;
}
?>

[Orio]

That should do the work:

 

<?php

foreach($row as $k => $v)
$$k = $v;

?>

 

Orio.

[scooter41]

perfect thanks guys!

[GingerRobot]

No problem. Just fyi, the use of the double dollar sign means you are using a variable variable: the name of the variable you assign $v to is the value of the variable $k. Perhaps another example illustrates that better:

 

<?php
$foo = 'bar';
$bar = 'test';
echo $$foo; //is equivilant to echo $bar, since 'bar' is the value of $foo
//produces test
?>