Image nut Read in Php from database

Question

I have this problem when I read a picture from the database.

It shows like this:

This my code:

<?php
include 'Header.php';
include 'yzd.php';
?>

<div class="container">
<h1> All Project </h1>
<?php
$posts = mysqli_query($db_connect,"select * from Project order by id desc");

while($post = mysqli_fetch_array($posts)){
    echo "
    <article>
    <a href='Project.php?id=$post[id]'>
    <h1>$post[NameProject]</h1>
    </a>
    <p class='text-muted']>
    <h3>$post[TypeProject]</h3>
    </p>
    <h4>$post[Description]</h4>

    $post[Pic];

    <p>-----------------------------------------------------------------------------</p>
    </article>";

}
?>

[![enter image description here][2]][2]

if you're going to post an image of code, don't expect much help — Funk Forty Niner, Feb 26 '17 at 02:07
Hello! It seems as if your question is very poorly written. The way it is, it is only going to attract downvotes, and no answers. — BusyProgrammer, Feb 26 '17 at 02:50
dont store the actual image in the database, store its location. — DevDonkey, Mar 01 '17 at 09:33

score 2 · Accepted Answer · edited Jun 20 '20 at 09:12

2

Try converting the raw image output into a base 64 data URI (see here) you may be able to do this by changing

$post[Pic]

into

<img src='".'data:image/png;base64,' . base64_encode($post["Pic"])."'/>

Given all of the images in your databases are stroed as png(s) The type may need to be varied dependent on image type.

Please in the future use code snippets and not screenshots.

edited Jun 20 '20 at 09:12

Community

1
1

answered Feb 26 '17 at 02:31

ryanolee

89
4

Image nut Read in Php from database

1 Answers1