使用PDO和PHP搜索数据库，而语句不显示echo

Question

I am adding a search input and button to my website using PDO, my else statement works and I receive 'no results'. However my while statement seems to have no response. Am I missing anything or have I written something wrong in my code?

if(isset($_POST['submit'])){
    $search = $_POST['search'];
    $articles = $db->prepare("SELECT * FROM articles WHERE headline = :search");
    $articles->execute(array(':search' => $search));

    if($articles -> rowCount() > 0) {
            while ($rows = $articles->fetchAll(PDO::FETCH_ASSOC)){
                   $headline = $rows['headline'];
                   echo "headline: $headline<br>";
                  }
    } else{
        echo "No Results";
    }
}

Answer 1

You used the wrong fetch method.

while ($rows = $articles->fetchAll(PDO::FETCH_ASSOC)) { ...

fetchAll fetches all the rows. So $rows is an array of rows, not one row. Consequently the loop will only execute once, and $rows['headline']; won't exist.

Just use fetch instead of fetchAll.

Alternatively, if you still want to use fetchAll, you can call it once and then iterate the result with a foreach loop.

$rows = $articles->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
    $headline = $row['headline'];
    echo "headline: $headline<br>";
}

Either way should work the same.

---

You should have error reporting set to display warnings and notices on your development server, so PHP can inform you of problems like this. ($rows['headline'] would generate an undefined index notice.)