Tsvetilin Boynovski Tsvetilin Boynovski - 4 months ago 13
PHP Question

Passing an array from SQL to Swiftmailer

I need to pass an array with emails to Swiftmailer so it can send multiple mails at once. The array I should pass to it is:

$to[];


I am using this code to get the data from DB but it keeps saying
array(0) { }
when I
var_dump
$to
. No error from the database whatsoever, I tried using mysqli_error and still nothing:

<?php
$sql = "SELECT user_email,user_id FROM users";
$q = mysqli_query($connection_offerme,$sql);
if($q){
$to = array();
while($row = mysqli_fetch_assoc($q))
{
$to[] = $row['user_email'];
}

var_dump($to);
}
else {
echo "no results";
printf("Errormessage: %s\n", mysqli_error($connection_offerme));
}

?>


edit: PS. the result I get from this is
array(0) { }
and not "no results" plus a sql error

Answer

Answer is simple: PHP does not allow usage of var_dump(); function between if(){} and else{}.

Proper use of the var_dump(); in my code above would be:

        <?php
        $sql = "SELECT user_email,user_id FROM users";
        $q = mysqli_query($connection_offerme,$sql);
        if($q){
            $to = array();
            while($row = mysqli_fetch_assoc($q))
            {
                $to[] = $row['user_email'];
            }

            var_dump($to); // - VAR_DUMP(); NOT ALLOWED HERE

        }
        else {
            echo "no results";
            printf("Errormessage: %s\n", mysqli_error($connection_offerme));
        }
            var_dump($to); // - VAR_DUMP(); SHOULD GO HERE INSTEAD
        ?>
Comments