converting array $row values to $string

[monomaniac21]

hi all

is there a function to convert all values of array $row into seperate
variables:

$row = mysql_fetch_array($result);

// i dont want to have to do this anymore :-)

$name = $row['name'];
$address1 = $row['address1'];
$address2 = $row['address2'];
etc etc etc


Regards

marc

[Nyoka]

You could write your own function similar to:
function convertArray ($array) {
foreach ($array AS $name =$value) {
global $$name;
$$name = $value;
}
}

Make sure you do a print_r ($array) before using this so you are away
of what variables are going to be used.

monomaniac21 wrote:

hi all

is there a function to convert all values of array $row into seperate
variables:

$row = mysql_fetch_array($result);

// i dont want to have to do this anymore :-)

$name = $row['name'];
$address1 = $row['address1'];
$address2 = $row['address2'];
etc etc etc


Regards

marc

[Hans 'pritaeas' Pollaerts]

Maybe this works (untested):

$row = mysql_fetch_array($result);
foreach ($row as $name =$value) {
$eval = "${$name} = $value";
eval ($eval);
}

"monomaniac21" <mc******@googlemail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...

hi all

is there a function to convert all values of array $row into seperate
variables:

$row = mysql_fetch_array($result);

// i dont want to have to do this anymore :-)

$name = $row['name'];
$address1 = $row['address1'];
$address2 = $row['address2'];
etc etc etc


Regards

marc

[monomaniac21]

Cheers Nyoka I'm sure it does work.

but i dont understand it. what is the double $$ for and "global"?

:-)
Nyoka wrote:

You could write your own function similar to:
function convertArray ($array) {
foreach ($array AS $name =$value) {
global $$name;
$$name = $value;
}
}

Make sure you do a print_r ($array) before using this so you are away
of what variables are going to be used.

monomaniac21 wrote:

hi all

is there a function to convert all values of array $row into seperate
variables:

$row = mysql_fetch_array($result);

// i dont want to have to do this anymore :-)

$name = $row['name'];
$address1 = $row['address1'];
$address2 = $row['address2'];
etc etc etc


Regards

marc

[monomaniac21]

What i cant see is how the function finds out the name given to each
row of the array?

Can anyone explain this to me?

monomaniac21 wrote:

Cheers Nyoka I'm sure it does work.

but i dont understand it. what is the double $$ for and "global"?

:-)
Nyoka wrote:

You could write your own function similar to:
function convertArray ($array) {
foreach ($array AS $name =$value) {
global $$name;
$$name = $value;
}
}

Make sure you do a print_r ($array) before using this so you are away
of what variables are going to be used.

monomaniac21 wrote:

hi all
>
is there a function to convert all values of array $row into seperate
variables:
>
$row = mysql_fetch_array($result);
>
// i dont want to have to do this anymore :-)
>
$name = $row['name'];
$address1 = $row['address1'];
$address2 = $row['address2'];
etc etc etc
>
>
>
>
Regards
>
marc

[ImOk]

After you do the fetch run

extract($row);

This will cretae memory variables of the same name as the keys and
containing the values.

Study the example from docs:

$size = "large";
$var_array = array("color" ="blue",
"size" ="medium",
"shape" ="sphere");
extract($var_array, EXTR_PREFIX_SAME, "wddx");

echo "$color, $size, $shape, $wddx_size\n";


monomaniac21 wrote:

hi all

is there a function to convert all values of array $row into seperate
variables:

$row = mysql_fetch_array($result);

// i dont want to have to do this anymore :-)

$name = $row['name'];
$address1 = $row['address1'];
$address2 = $row['address2'];
etc etc etc


Regards

marc

[Kimmo Laine]

"monomaniac21" <mc******@googlemail.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...

What i cant see is how the function finds out the name given to each
row of the array?

Can anyone explain this to me?

It's using a feature of php called variable variable.

let's say you have a couple of variables:
$name = "fred flintstone";
$pointer = "name";

You can point to variable $name with the $pointer using the variable
variable syntax: $$pointer is evaluated as $"name", and since $pointer
contains the string "name".

echo $$pointer; // This will print "fred flintstone"

The very same mechanisms is used in the example function.

--
"ohjelmoija on organismi joka muuttaa kofeiinia koodiksi" -lpk
sp**@outolempi.net | Gedoon-S @ IRCnet | rot13(xv***@bhgbyrzcv.arg)

[Kimmo Laine]

"Hans 'pritaeas' Pollaerts" <pr******@hotmail.comwrote in message
news:e9**********@news3.zwoll1.ov.home.nl...

Maybe this works (untested):

$row = mysql_fetch_array($result);
foreach ($row as $name =$value) {
$eval = "${$name} = $value";
eval ($eval);
}

No reason to get eval involved.
This:

foreach($row as $name =$value)
$$name = $value;

works just fine.
--
"ohjelmoija on organismi joka muuttaa kofeiinia koodiksi" -lpk
sp**@outolempi.net | Gedoon-S @ IRCnet | rot13(xv***@bhgbyrzcv.arg)

[Markus Ernst]

monomaniac21 schrieb:

Cheers Nyoka I'm sure it does work.

but i dont understand it. what is the double $$ for and "global"?

manual_exists() == true!

www.php.net/global
www.php.net/variables
:-)

[Jerry Stuckle]

monomaniac21 wrote:

hi all

is there a function to convert all values of array $row into seperate
variables:

$row = mysql_fetch_array($result);

// i dont want to have to do this anymore :-)

$name = $row['name'];
$address1 = $row['address1'];
$address2 = $row['address2'];
etc etc etc


Regards

marc

Why not just

list($name, $address1, $address2) = mysql_fetch_array($result);

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Rik]

Jerry Stuckle wrote:

list($name, $address1, $address2) = mysql_fetch_array($result);

Better:
list($name, $address1, $address2) = mysql_fetch_row($result);

Grtz,
--
Rik Wasmus

[Jerry Stuckle]

Rik wrote:

Jerry Stuckle wrote:

> list($name, $address1, $address2) = mysql_fetch_array($result);

Better:
list($name, $address1, $address2) = mysql_fetch_row($result);

Grtz,

True.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================