Array seems empty with Implode on array_values

Question

Some assistance would be greatly appreciated:

The 'foreach' section works perfectly and echo's the result set perfectly; as soon as I try the implode it fails? Thank you!

$ctr = 0;
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {

    $RespondentsResultSetArray[$ctr] = array(
        "Firstname" => $row['cnt_firstname'],
        "Lastname" => $row['cnt_lastname']
    );

    $ctr = $ctr + 1;
}

foreach ($RespondentsResultSetArray as $key) {
    echo $key["Firstname"] . ' ' . $key["Lastname"] . ', ';
}

sqlsrv_free_stmt($stmt);

echo implode(', ',array_values($RespondentsResultSetArray));

user1844933 · Accepted Answer · 2014-02-19 09:26:02Z

1

try this

implode(',',$RespondentsResultSetArray);

answered Feb 19, 2014 at 9:26

user1844933

3,4132 gold badges27 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Codrutz Codrutz · Accepted Answer · 2014-02-19 09:33:17Z

0

You are passing an array of arrays to implode function. Here is a little deviation of your code, that should get you to the same result:

$full_array = array();
foreach ($RespondentsResultSetArray as $key) {
    echo $key["Firstname"] . ' ' . $key["Lastname"] . ', ';
    array_push($full_array,$key["Firstname"]);
    array_push($full_array,$key["Lastname"]);

}



echo implode(', ',$full_array);

Also, for the future, try to chose smaller names for your variables, and use lowercase for your variable names and array index.

answered Feb 19, 2014 at 9:33

Codrutz Codrutz

4805 silver badges15 bronze badges

1 Comment

BernardV Over a year ago

Thank you for advice and answer, this has solved my problem! I just made some slight modifications for the output to look the same as the foreach.

Ted Cohen · Accepted Answer · 2014-02-19 09:43:18Z

0

The php implode function accepts an array of strings. You are not passing it an array of strings.

To user1844933 that just answered, your suggestion would pass implode an array of arrays. That won't work for the same reason.

$RespondentsResultSetArray=array();
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    array_push($RespondentsResultSetArray,$row['cnt_firstname'].' '.$row['cnt_lastname']);
}
$saved_to_variable=implode(', '$RespondentsResultSetArray);

Will create an array of strings which you can then implode

Since you recently commented that you want to save it to a variable rather than echo it, I just changed the last line of the example code. I believe that will give you the properly spaced, and delimited string that you desire.

edited Feb 19, 2014 at 9:43

answered Feb 19, 2014 at 9:28

Ted Cohen

1,05110 silver badges17 bronze badges

1 Comment

BernardV Over a year ago

Thank you, any possible assistance on passing it what it needs, or should I use a method other than implode similar to foreach, as my end goal is to have one string correctly spaced with commas added saved to a variable.

krishna · Accepted Answer · 2014-02-19 09:43:27Z

0

since$RespondentsResultSetArray is multidimensional array use foreach loop before echo

$string = ""; 
foreach($RespondentsResultSetArray as $values)
{
echo implode(array_values($values),",");
$string= $string.",".implode(array_values($values),",");
}

$string=ltrim($string,",");
echo $string;

Demo

edited Feb 19, 2014 at 9:43

answered Feb 19, 2014 at 9:37

krishna

4,0892 gold badges32 silver badges56 bronze badges

Collectives™ on Stack Overflow

Array seems empty with Implode on array_values

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related