Извеждане на резултати с PDO

[vinsbg]

Реших да се захвана пренапиша някой страници с PDO и да започна да го уча. Логин формата и разни други странички ги промених добре и работят коректно. Тук обаче нещо не се получава.
Това е кода, но страницата е празна. Моля за малко помощ.

<?php
             error_reporting(E_ALL); 
             ini_set('display_errors', 1);
              $pdo = Database::connect();
               $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		
	      if(isset($_GET['rest_id']) && is_numeric($_GET['rest_id'])){
			    	$rest_id = $_GET['rest_id'];
			
				$query = "SELECT m.meal_id, meal_name, meal_image, meal_weight, meal_price, meal_description 
							FROM meals m 
							JOIN meal_restaurant mr 
							ON m.meal_id = mr.meal_id 
							WHERE restaurant_id = '$rest_id' ORDER BY meal_id";

                    		echo '<table class="table table-striped table-bordered responsive">';
                    		echo "<thead>";
                    		echo "<tr>
                    			<th>ID</th> 
                    			<th>Снимка</th>
                    			<th>Име</th> 
                    			<th>Деиствие</th>
                    	    	      </tr>
                    	  	   </thead>";
                    	        echo '<div class="row">';
                    	 	echo '<div class="box col-md-12">';
                     		echo '<div class="box-content">';
                      		echo "<tbody>";
                    		
				if (is_array($query))
		    		{
				    foreach($pdo->query($query) as $row) 
				    {

		                        echo '<tr>';                        
		                        echo '<td class="center">'. $row['meal_id'] .'</td>';
                		        echo '<td class="center"><img src="' . $row['meal_image'] . '" width="50" height="50"/></td>';
		                        echo '<td class="center">' . $row['meal_name'] . '</td>';

                               	        echo '<td class="center">
                        		      <a class="btn btn-danger" href="users/mealDelete.php?meal_id=' . $row['meal_id'] . '">
                        		      <i class="glyphicon glyphicon-remove icon-white"></i>
                        			Изтриване</a>
                        		      <a  class="btn btn-info" href="users/mealEdit.php?meal_id=' . $row['meal_id'] . '">
	                        	      <i class="glyphicon glyphicon-edit icon-white"></i>
	                        	      Редакция</a></td>';
                        		echo "</tr>";
                    
                    		    }

                    	       }
                    echo '</tbody>';
                 echo '</div>';
                 echo '</div>';
                 echo '</div>'; 
                  echo '</table>';                    	     
               }
             Database::disconnect();
	?>

foreach-a е празен. Някакви идеи защо?
Урока, който следвам е този - http://www.startutorial.com/articles/view/php-crud-tutorial-part-3 ( не е реклама )
и леко съм го модифицирал за моите нужди, като заявката например.

 

[d_badboy]

http://php.net/manual/en/pdo.connections.php

<?php
$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
foreach($dbh->query('SELECT * from FOO') as $row) {
  print_r($row);
}
$dbh = null;
?>

http://php.net/manual/en/pdostatement.fetch.php
http://php.net/manual/en/pdostatement.fetchall.php
:?:

 

[vinsbg]

http://php.net/manual/en/pdo.connections.php

<?php
$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
foreach($dbh->query('SELECT * from FOO') as $row) {
  print_r($row);
}
$dbh = null;
?>

http://php.net/manual/en/pdostatement.fetch.php
http://php.net/manual/en/pdostatement.fetchall.php
:?:

Със заявката вътре в foreach-a стана, но няма ли начин да не е там?

foreach($pdo->query("SELECT m.meal_id, meal_name, meal_image
							FROM meals m 
							JOIN meal_restaurant mr 
							ON m.meal_id = mr.meal_id 
							WHERE restaurant_id = '$rest_id' ORDER BY meal_id") as $row) 
				{
		                        echo '<tr>';                        
		                        echo '<td class="center">'. $row['meal_id'] .'</td>';
                		        echo '<td class="center"><img src="' . $row['meal_image'] . '" width="50" height="50"/></td>';
		                        echo '<td class="center">' . $row['meal_name'] . '</td>';

                               	        echo '<td class="center">
                        		      <a class="btn btn-danger" href="users/mealDelete.php?meal_id=' . $row['meal_id'] . '">
                        		      <i class="glyphicon glyphicon-remove icon-white"></i>
                        			Изтриване</a>
                        		      <a  class="btn btn-info" href="users/mealEdit.php?meal_id=' . $row['meal_id'] . '">
	                        	      <i class="glyphicon glyphicon-edit icon-white"></i>
	                        	      Редакция</a></td>';
                        		echo "</tr>";
                    
                    		    }

Благодаря за помощта! :?:

 

[d_badboy]

<?php
$result = $pdo->query("SELECT m.meal_id, meal_name, meal_image
    FROM meals m 
    JOIN meal_restaurant mr 
    ON m.meal_id = mr.meal_id 
    WHERE restaurant_id = '".$rest_id."' ORDER BY meal_id");
foreach($result as $row) {
?>
<tr>
    <td class="center"><?php echo $row['meal_id']; ?></td>
    <td class="center"><img src="<?php echo $row['meal_image']; ?>" width="50" height="50"/></td>
    <td class="center"><?php echo $row['meal_name']; ?></td>
    <td class="center">
        <a class="btn btn-danger" href="users/mealDelete.php?meal_id=<?php echo $row['meal_id']; ?>">
            <i class="glyphicon glyphicon-remove icon-white"></i> Изтриване
        </a>
        <a class="btn btn-info" href="users/mealEdit.php?meal_id=<?php echo $row['meal_id']; ?>">
            <i class="glyphicon glyphicon-edit icon-white"></i> Редакция
        </a>
    </td>
</tr>
<?php
}
?>