The images are getting into phpMyAdmin as array and also getting saved into my images folder but not getting retrieved . Can someone please help me out ?
<div class="form-group">
<div class="row">
<div class="col-2 text-center">
<img style=" height: 100px;"
src="images/<?php echo $provider[0]['photo']; ?>">
<div class="text-center">Old Photo</div>
</div>
<div class="col">
<label for="">New Photo</label>
<input id="photo" name="photo" type="file" class="form-control-file"
placeholder="Select Photo 1">
</div>
</div>
try {
$conn = new PDO('mysql:host=localhost;dbname=services; charset=utf8','root','sarasaeed');
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "SELECT * FROM providers WHERE id='$id'";
$statement = $conn->prepare($sql);
$statement->execute();
$provider = $statement->fetchAll();
}catch(PDOException $e){
echo "Connection failed: " . $e->getMessage();
}
$conn = null;