php array , how to display array data in email

Question

$qua1 = "5";

$queryNotification= "SELECT * from stock where stockQty <= :qua1 ";
$stmt3 = $conn->prepare($queryNotification);
$stmt3->bindParam(':qua1',$qua1);
$stmt3->execute();

while ($queryNotRow = $stmt3->fetch()){

$a=array("Qty"=>$queryNotRow['stockQty'],"name "=>$queryNotRow['stockName'],"cb "=>$queryNotRow['stockPrice']);
// $array[$queryNotRow['stockQty']] = $queryNotRow['stockName'];

foreach( $a as $row ):
$b = "stockqty = " . $queryNotRow['stockQty'] . " and StockName = " . $queryNotRow['stockName'] . "<br>";
endforeach;

echo $b;

}

If I add send email code inside the foreach loop , the system will send many email according on how many data. How can I only send all the data by ONE EMAIL??

[0] => Array ( [Qty] => 5 [name ] => 5 ) printr will show this == — Ch Hong
– Ch Hong, Commented Oct 10, 2015 at 9:44

Alok Kumar Mishra · Accepted Answer · 2015-11-21 11:11:35Z

2

$a=array("Qty"=>$queryNotRow['stockQty'],"name "=>$queryNotRow['stockName']);

foreach($a as $key=>$data){
echo 'stock'.$key.'='.$data.'<br/>';
}

edited Nov 21, 2015 at 11:11

answered Oct 10, 2015 at 9:19

Alok Kumar Mishra

16916 bronze badges

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

1 Comment

Ch Hong Over a year ago

get this error (Notice: Array to string conversion in))

Tom · Accepted Answer · 2015-10-10 09:47:10Z

1

foreach( $a as $row ):
    echo "stockqty = " . $row['Qty'] . " and StockName = " . $row['name'] . "<br>";
endforeach;

answered Oct 10, 2015 at 9:47

Tom

3,0601 gold badge21 silver badges23 bronze badges

2 Comments

Ch Hong Over a year ago

if i want to send this all data through ONLY one email, is it possible??

Tom Over a year ago

of course it is. instead of echoing it, you can create string with those variables. I believe we have answered your question and you can go from here. If theres new problem you're facing, browse thru previously asked questions ( theres a lot covering these things ), in case of no luck with that, consider posting new question.

Niranjan N Raju · Accepted Answer · 2015-10-10 09:46:55Z

0

try this,

$a[] = array(
        "Qty" => 1,
        "name " => 2
    );

foreach ($a as $row) {
        echo $row['Qty']."===".$row['name'];
}

answered Oct 10, 2015 at 9:46

Niranjan N Raju

12k4 gold badges24 silver badges41 bronze badges

Collectives™ on Stack Overflow

php array , how to display array data in email

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related