PHP Array. Change every row data in table to a string then pass to array

Question

I am trying to use to a loop to pull all rows from a table, and change every row to a string then pass to an array. Here is the script I am currently working on.

PHP:

function toggleLayers(){
    $toggleArray = array($toggle);
    for($i=0;$i<$group_layer_row;$i++){
        $toggle=mb_convert_encoding(mssql_result ($rs_group_layer, $i, 0),"UTF-8","SJIS")."_".mb_convert_encoding(mssql_result ($rs_group_layer, $i, 1),"UTF-8","SJIS");
        return $toggleArray($toggle);
    }
}

Right now it only returns a string without passing to the array. Been looking and can't seem to find anywhere or anyone that can explain this to me in plain english.

Hope you can help. Thanks

The PHP documentation site is in plain English. Check for example this page on how to use an array: php.net/manual/en/language.types.array.php — The Nail
– The Nail, Commented Dec 6, 2011 at 0:25
@TheNail: A loop is a statement, not an expression -- so it doesn't evaluate to anything. — Jon
– Jon, Commented Dec 6, 2011 at 0:32
first line inside the function - $toggle isn't set. When you initialise the for loop $group_layer_row isn't set. $rs_group_layer isn't defined anywhere yet you try to use it in your db query. You have the return statement inside the loop so on the first pass you exit the entire function. $toggleArray($toggle) would attempt to run a function with the name stored inside $toggleArray (not what you want) see uk3.php.net/manual/en/functions.variable-functions.php . — Dean Marshall
– Dean Marshall, Commented Dec 6, 2011 at 0:46

Dan Heberden · Accepted Answer · 2011-12-06 00:34:57Z

1

I have no idea what vars are what in your example, but if you wanted to loop through an array and change its contents, here's how i'd do it:

$myArray = array( 'thing', 'thing2' );
// the ampersand will pass by reference, i.e.
// the _Actual_ element in the array
foreach( $myArray as &$thing ){
  $thing .= " - wat?!";
}

print_r( $myArray );

will give you

[0] =>
  'thing - wat?!'
[1] =>
  'thing2 - wat?!'

answered Dec 6, 2011 at 0:34

Dan Heberden

11.1k3 gold badges35 silver badges29 bronze badges

Add a comment |

Cyclonecode · Accepted Answer · 2015-12-05 03:39:08Z

0

I think you will gonna change your code to something like this:

$toggleArray = array();
for ($i = 0; $i < $group_layer_row; $i++) {
   // push your string onto the array
   $toggleArray[] = mb_convert_encoding(mssql_result($rs_group_layer, $i, 0), "UTF-8", "SJIS") . "_" . mb_convert_encoding(mssql_result ($rs_group_layer, $i, 1), "UTF-8", "SJIS");
}
return $toggleArray;

edited Dec 5, 2015 at 3:39

answered Dec 6, 2011 at 0:24

Cyclonecode

30.3k11 gold badges76 silver badges97 bronze badges

where does $group_layer_row initially come from?

Dean Marshall
– Dean Marshall

12/06/2011 00:37:35
Commented Dec 6, 2011 at 0:37
@DeanMarshall $group_layer_row is a count of the rows in the table. $rs_group_layer=mssql_query($sql, $con); $group_layer_row=mssql_num_rows($rs_group_layer);

Yus
– Yus

12/06/2011 00:43:00
Commented Dec 6, 2011 at 0:43
@Yus any variable that you want to use in a function must either be a parameter or you have to declare it global (or is a superglobal, static member or constant, but that is not likely here)

The Nail
– The Nail

12/06/2011 00:45:39
Commented Dec 6, 2011 at 0:45
@KristerAndersson Thanks your answer was correct, I also realized I did not include the php file...

Yus
– Yus

12/06/2011 01:20:06
Commented Dec 6, 2011 at 1:20

Add a comment |

Collectives™ on Stack Overflow

PHP Array. Change every row data in table to a string then pass to array

2 Answers 2

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related