how to retrieve image from database in php mysqli
// database connection
$conn = mysqli_connect("localhost", "root", "", "student");
// Fetch image from database
$img = mysqli_query($conn, "SELECT * FROM student_table");
while ($row = mysqli_fetch_array($img)) {
echo "<img src='images/".$row['imagename']."' >";
}display image from mysqli database
<?php // Include the database configuration file require_once 'dbConfig.php'; // Get image data from database $result = $db->query("SELECT image FROM images ORDER BY uploaded DESC"); ?>
<?php if($result->num_rows > 0){ ?> <div class="gallery"> <?php while($row = $result->fetch_assoc()){ ?> <img src="data:image/jpg;charset=utf8;base64,<?php echo base64_encode($row['image']); ?>" /> <?php } ?> </div> <?php }else{ ?> <p class="status error">Image(s) not found...</p> <?php } ?>Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
