Get PHP assoc array key in loop

Question

I have the following code:

while ($row = mysql_fetch_array($result, MYSQL_NUM)) 
 {
  for ($i=0; $i<count($row); $i++)
  {
            (DO THING HERE)
   $row[$i] = str_replace("\n", " ", $row[$i]);
   $row[$i] = str_replace("\r", " ", $row[$i]);
  }

 }

I basically want to do, if the associative array key is equal to "email" (so $row['email']) then append "@gmail.com" to it.

Answer 1

I'm not sure if this is exactly what you want but:

$row['email'].='@gmail.com';

This will append @gmail.com to the email row.

Answer 2

Use a foreach loop and get both the key and the value for the assoc array.

foreach($row as $key => &$value)
{
    if($key == 'email') $value .= "@gmail.com";
}

Also you should be using mysql_fetch_array($result, MYSQL_ASSOC) if you want an associative array returned.

A more efficient way to append to the email key would be something like:

if(isset($row['email']))
    $row['email'] .= '@gmail.com';

Instead of looping through all the columns.

Answer 3

See the MYSQL_NUM you have there? That is going to return your data using the column indexes as keys (ie 0, 1, 2, etc).

You must either

a) find out which column index the email field is and do:

while ($row = mysql_fetch_array($result, MYSQL_NUM)) 
{
    // 'email' is in column number 5
    $row[5] .='@gmail.com';

    for ($i=0; $i<count($row); $i++)
    {
        $row[$i] = str_replace("\n", " ", $row[$i]);
        $row[$i] = str_replace("\r", " ", $row[$i]);
    }
}

b) OR you can change MYSQL_NUM to MYSQL_ASSOC, and do:

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) 
{
    $row['email'] .='@gmail.com';

    foreach($row as &$value)
    {
        $value = str_replace("\n", " ", $value);
        $value = str_replace("\r", " ", $value);
    }
}

Note the "&" before $value to make it a reference.

I would do the latter (I prefer foreach to for :)

Answer 4

Paulo had it almost exactly right:

while ($row = mysql_fetch_assoc($result)) {
    foreach($row as $key => &$value) {
        if($key == 'email') $value .= '@gmail.com';
        $value = str_replace("\n", " ", $value);
        $value = str_replace("\r", " ", $value);
    }
}

Note the "&" in the foreach line. That means you're modifying the value in the $row array, not just a copy of it.