将数组从SQL传递给Swiftmailer

Question

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
", mysqli_error($connection_offerme));
                }

                ?>

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

Answer 1

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
", mysqli_error($connection_offerme));
        }
            var_dump($to); // - VAR_DUMP(); SHOULD GO HERE INSTEAD
        ?>