php foreach each result in one variable

Question

I am trying to get each result of a query into one variable so that I can include it into my wp_mail message.

This is what I am using.

$result = $wpdb->get_results("SELECT * 
                               FROM $tableName 
                               WHERE userId = $user_ID 
                               AND status LIKE '1'"
                            );
foreach( $result as $key => $value)
{
    $string .= $value.',';
}

echo $string;
$email = $_POST['parentsEmail'];    
$child = $_POST['childsName'];
wp_mail( $email, "".$child." has finished", "".$child." has completed the following ".$string." ");

I have been searching and found another thread asking something similiar and this was suggested.

$string .= $value.',';

However when I try to do the same thing, I get

Catchable fatal error: Object of class stdClass could not be converted to string in

Value is an array right? Don't you need to explode the array or implode it? — Goikiu
– Goikiu, Commented Jan 10, 2014 at 14:36

Community · Accepted Answer · 2014-03-25 06:29:20Z

2

You can use this instead using mysql

SELECT 
    CONCAT(col1,col2,col3) `value`
FROM $tableName 
WHERE userId = $user_ID AND status LIKE '1'

You can use this instead using mysql ok

edited Mar 25, 2014 at 6:29

CommunityBot

11 silver badge

answered Jan 10, 2014 at 14:37

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

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

Comments

Glavić · Accepted Answer · 2014-01-10 15:01:07Z

1

You can concat rows field in SQL statement with GROUP_CONCAT() function:

$sql = "
    SELECT GROUP_CONCAT(field_name) AS concat_alias
    FROM $tableName
    WHERE userId = $user_ID AND status LIKE '1'
";
echo $string = $wpdb->get_var($sql);

edited Jan 10, 2014 at 15:01

answered Jan 10, 2014 at 14:49

Glavić

43.6k13 gold badges79 silver badges108 bronze badges

6 Comments

Kumar V Over a year ago

if you are using gropu_cancat, then you have to use group by.

Glavić Over a year ago

@kumar_v: not in this case.

Bowenac Over a year ago

I end up with array? How do I get the contents of the array?

Glavić Over a year ago

@user1949929: I have just updated the answer, where you fetch using get_var().

Glavić Over a year ago

@user1949929: np, glad I can help. If you wish to use different separator, you can set that in GROUP_CONCAT() function like: GROUP_CONCAT(field_name SEPARATOR ' | ')...

|

Collectives™ on Stack Overflow

php foreach each result in one variable

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related