equaling a loop to a variable before sending it via phpmailer

Question

I have a checkbox form which is sent to mail.php to be mailed. The selected items should be sent via mail. I have a query to output selected items. In mail body; to echo all selected items which pulled from database, i need to equal the while loop to a variable. But i can not manage it to equal.

<?php
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;

require 'PHPMailer/src/Exception.php';
require 'PHPMailer/src/PHPMailer.php';
require 'PHPMailer/src/SMTP.php';

include 'nedmin/netting/database.php';

if (isset($_POST['sendmail'])) {

$city=array_keys($_POST['cities']);

$cities=implode(",",$city);


$query = $db->prepare("SELECT * FROM semt WHERE semt_id IN('".$cities."')");

$query->execute();

while ($statement = $query->fetch(PDO::FETCH_ASSOC)) {

?>
   <td><?php echo $statement["city_name"]?></td>

<?php }


$mail = new PHPMailer;

try {
   /* SMTP parameters. */
   $mail->isSMTP();
   $mail->SMTPKeepAlive = TRUE;   
   $mail->SMTPAuth = TRUE;
   $mail->SMTPSecure = 'tls';

   ...
   ...
   ...
   $mail->isHTML(TRUE);
   $mail->Subject = "Subject";
   $mail->Body = "Selected cities: $......";

   $mail->send();
}
catch (Exception $e)
{
   echo $e->errorMessage();
}
catch (\Exception $e)
{
   echo $e->getMessage();
}
}
?>

Don't replace your original code with the code from an answer. Readers need to see what the answers are fixing. — Barmar, Jul 07 '19 at 11:07
`WHERE semt_id IN('".$cities."')` is not going to work as expected. See: [can-i-bind-an-array-to-an-in-condition](https://stackoverflow.com/questions/920353/can-i-bind-an-array-to-an-in-condition) — Paul Spiegel, Jul 07 '19 at 12:16

score 0 · Answer 1 · answered Jul 07 '19 at 10:28

0

Concatenate to a string instead of printing output.

$city_names = "";
while ($statement = $query->fetch(PDO::FETCH_ASSOC) {
    $city_names .= "<td>{$statement["city_name"]}</td>\n";
}

Then you can use $city_names in the email.

answered Jul 07 '19 at 10:28

Barmar

741,623
53
500
612

getting HTTP 500 – Ismail Akyyl Jul 07 '19 at 10:42

score 0 · Accepted Answer · answered Jul 07 '19 at 10:30

0

$citiesName = [];

while ($statement = $query->fetch(PDO::FETCH_ASSOC)) { ?>
    <td><?php echo $statement["city_name"]?></td>
    <?php $citiesName[] = $statement["city_name"]?>
<?php }

//code ...
$mail->Body = "Selected cities: " . implode(',', $citiesName);

answered Jul 07 '19 at 10:30

Mike Foxtech

1,633
1
6
7

1

works but only pulls the first item from database. what should i do – Ismail Akyyl Jul 07 '19 at 10:51
in this displays more than one? – Mike Foxtech Jul 07 '19 at 11:08
and then what's the problem then? - I don`t understand – Mike Foxtech Jul 07 '19 at 11:38
i need it to echo all selected items from form by fetching from database. but it only fetch the first selection, not all selections. – Ismail Akyyl Jul 07 '19 at 11:41
it all depends on what comes from the form. It is possible by criterion where - should return only one result – Mike Foxtech Jul 07 '19 at 11:49

equaling a loop to a variable before sending it via phpmailer

2 Answers2