非法字符串偏移'slug'PDO

Question

I'm trying to pull the pages from my database and make them an actual page url:

http://i.imgur.com/r5AuaKB.png

$stmt = $auth_user->runQuery("SELECT * FROM pages");
$stmt->execute();
$menu = $stmt->fetch(PDO::FETCH_ASSOC);

foreach($menu as $page) {
    if(basename($_SERVER['REQUEST_URI']) == $page['slug']){
        require_once('inc/page/' . $page['slug'] . '.php');
    }
}

But for some reason it doesn't work. I keep getting this

Illegal string offset 'slug'

error. How do I resolve this?

Answer 1

$page is actually a string, hence the error. fetch returns one row, so this:

$menu = $stmt->fetch(PDO::FETCH_ASSOC);
foreach($menu as $page) { ...

actually loops through each column as a string.

Instead:

$stmt->execute();

while ($page = $stmt->fetch(PDO::FETCH_ASSOC)) { ...