Invalid argument foreach () return blank message

Question

Invalid argument foreach () return blank message

Navigation

#1 by (4 votes)
#2 by (2 votes)

2

<table border="1">
    <?php
        foreach($arrayReturn['qsa'] as $value){
    ?>
        <tr>
            <td>NOME:</td>
            <td><?=$value['qual'];?></td>
            <td><?=$value['nome'];?></td>
        </tr>


    <?php
        }
    ?>
</table>

It turns out that sometimes there are no values in the database. And I get the following error: Warning: Invalid argument supplied for foreach () in /home/user/public_html/script.php

How do I change the code to write: "Not available"? Can anyone help?

php mysql

asked by anonymous 07.08.2017 / 23:10

2 answers

2

Just check if index exists this way

<?php if(isset($arrayReturn['qsa'])): ?>
     <?php foreach($arrayReturn['qsa'] as $value): ?>
            <tr>
                <td>NOME:</td>
                <td><?=$value['qual'];?></td>
                <td><?=$value['nome'];?></td>
            </tr>
    <?php endforeach;?>
<?php else: ?>

<p>Não disponivel</p>

<?php endif;?>

07.08.2017 / 23:26

Pure Javascript Portfolio Filter PHP - Problem with string accentuation in a string

score 4 · Accepted Answer

You can check the array before going to foreach

if( is_array($arrayReturn['qsa']) && count($arrayReturn['qsa']) > 0 ) {
    // Aqui continua o seu foreach
}else{
    echo '<tr><td colspan="3">Não Disponível</td></tr>';
}