php mysql image not display properly

Question

I have following code for get image from my database table field.

public function getStudentses() {
    $students_data = array();       

    $query = $this->db->query(
        "SELECT * FROM " . DB_PREFIX . "students 
        WHERE customer_id = '" . (int)$this->customer->getId() . "'");   

    foreach ($query->rows as $result) {             
        $students_data[$result['students_id']] = array(
            'students_id'        => $result['students_id'],
            'firstname'          => $result['firstname'],
            'filename'           => $result['filename'],
            'image'              => $result['image'],
        );
    }       
    return $students_data;
}

This is my HTML code for display image:

<img src="<?php echo $result['image']; ?>" />

but when I render my page the image is not display properly its like some symbols like

s4�.���N����萗�p�A@4pbr��]�����F�G�>�v��W

Why its like this? How can I fix my error?

You may need to increase the mine head of the appropriate information — Xingjia Luo
– Xingjia Luo, Commented Nov 20, 2012 at 9:07
When you post code online, please make sure it is formatted nicely. I've formatted your code, please accept my edit. — Botond Balázs
– Botond Balázs, Commented Nov 20, 2012 at 9:12

Prasanth · Accepted Answer · 2012-11-20 09:15:47Z

4

Modern browsers have this support for using raw image data as source.

You can try to use something like:

<img src="data:image/png;<?php echo $result['image']; ?>" />

You should encode the image using base64 and then output something like:

<img src="data:image/png;base64,<?php echo base64_encode($result['image']); ?>" />

I have use image/png for example. If your image is something else, you should use corresponding encType.

Just make sure to read this and this.

edited Nov 20, 2012 at 9:15

answered Nov 20, 2012 at 9:09

Prasanth

5,2962 gold badges31 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vyktor Over a year ago

Shouldn't $result['image'] be html-escaped?

Abdulfattah Alhazmi Over a year ago

This is the best and the easiest solution I've found ever. Thank you:)

Sandeep Bansal · Accepted Answer · 2012-11-20 09:09:07Z

2

You will most likely need to change the header to an image

http://php.net/manual/en/function.header.php

header('Content-Type: image/jpeg');

answered Nov 20, 2012 at 9:09

Sandeep Bansal

6,44018 gold badges88 silver badges129 bronze badges

1 Comment

Oleg Over a year ago

I suppose it's worth mentioning that in this case the output should also NOT contain any HTML code.

Vyktor · Accepted Answer · 2012-11-20 09:17:25Z

2

Most common practice for this (what I've seen) is to build html:

<img src="image.png.php?student_id=<?php echo $result['students_id']; ?>" />

And then image.png.php:

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "students "
            "WHERE students_id = '" .(int)$request->getRequestParam('sudent_id') . "'"); 

// And now display raw content as image
$student = reset( $query->rows);
if( !$student){
   header('HTTP/1.0 404 Not Found');
   die( 'Blah blah... Blah blah blah');
}

header( 'Content-Type: image/jpeg');
echo $student['image'];

This way you'll be able to create links to images usable from whatever place you'll want (without any database access required on remote site).

answered Nov 20, 2012 at 9:17

Vyktor

21.1k6 gold badges69 silver badges98 bronze badges

Comments

sberry · Accepted Answer · 2012-11-20 09:10:58Z

1

Assuming you are storing the raw binary of the image, you can do this:

'image'              => base64_encode($result['image']),

Then in the html:

<img src="data:image/png;base64,<?php echo $result['image']; ?>" />

This assumes the image is a png. If not, change the mime type accordingly.

answered Nov 20, 2012 at 9:10

sberry

133k20 gold badges145 silver badges171 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:56:11Z

0

if the image is stored by this code

  s4�.���N����萗�p�A@4pbr��]�����F�G�>�v��W

its because you are just copying and pasting this code from database. be sure where it stored the the name/id of the image and the path of the image and get the image by its path and id/name or follow what Prasanth said to you. this my help you How to retrieve images from MySQL database and display in an html tag

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Nov 20, 2012 at 9:18

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Collectives™ on Stack Overflow

php mysql image not display properly

5 Answers 5

2 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related