How to fetch image from database in php
Intro:
Earlier than beginning with the dialogue relating to the fetching of pictures.
First, create a desk title referred to a picture within the database.
Beneath is the SQL question execute in PHPMyAdmin so a desk is created
<!DOCTYPE html>
<html>
<head>
<title>Image retrieve</title>
</head>
<body>
<form name=”form1″ action=”” method=”post” enctype=”multipart/form-data”>
<table>
<tr>
<td><input type=”submit” name=”submit2″ value=”display”></td>
</tr>
</table>
</form>
<?php
$con = mysqli_connect(‘127.0.0.1:3306′,’root’,”,’admin’) or die(‘Unable To connect’);
if(isset($_POST[“submit2”]))
{
$res=mysqli_query($con,”select * from images”);
echo “<table>”;
echo “<tr>”;
while($row=mysqli_fetch_array($res))
{
echo “<td>”;
echo ‘<img src=”data:image/jpeg;base64,’.base64_encode($row[‘image’] ).'” height=”200″ width=”200″/>’;
echo “<br>”;
?><a href=”delete.php?id=<?php echo $row[“id”]; ?>”>Delete</a> <?php
echo “</td>”;
}
echo “</tr>”;
echo “</table>”;
}
?>
</body>
</html>
After executing the above SQL question desk is created as proven under.
I am John C. Crawford. I am the founder of EnjoyWiki.com. I am a professional freelancer, blogger and content writer. I have several blogs and EnjoyWiki.com is one of them. I always love to share my experience on my blogs.
How to position fans to cool a room
Who played Johnny gill in the new edition movie
