Chcę wyświetlić wszystkie zdjęcia z bazy danych dodane przez użytkownika X. Problem w tym że wyświetla tylko pierwsze pasujące. Dodałem w html pętle foreach ale wyświetla błąd typu photo.jpg Warning: foreach() argument must be of type array|object, null given in C:
<?php
class photo_display
{
private $database;
private $userData;
public function __construct($database)
{
$this->database = $database;
}
public function display()
{
$id = $_SESSION['id'];
$query = $this->database->connect()->prepare("SELECT photo FROM photo where user_id = :id");
$query->bindParam(':id',$id, PDO::PARAM_INT);
$query->execute();
if($query->rowcount())
{
$row = $query->fetch();
}
$this->userData = $row;
}
public function display_Photos(string $colName)
{
echo (isset($this->userData[$colName])) ? $this->userData[$colName] : '';
}
}
?>
<div class='container-fluid bg-dark' id='profil'>
<div class='row'>
<div class=" col-12 col-sm-12 col-md-4 col-lg-4 col-xl-4 order-5 order-12 order-6 order-md-4">
<div class="row" id="margin">
<div class="col-xl-12 d-flex justify-content-center">
<?php foreach ($photo_display->display_Photos('photo') as $value) ?>
<img src="<?php echo $value ?>"/>
</div>
</div>
</div>