How to fetch image from database in drupal

Question

Let me know how to fetch image from database. actually i am trying to fetch image from database using this question. I am try to fetch image from database using following code. $fid is my $row['column_name']

 $fid=$r['field_upload_photo_fid'];
 $image = theme('image_style', array(
'style_name'=> 'small', 
'path' => $file->uri, 
'alt' => 'user picture'
 ));
 print $image;

Actual file url is http://example.com/sites/default/files/styles/Style_name/public/Chrysanthemum.jpg

but now it shows http://example.com/sites/default/files/styles/small/public/styles/Style_name/public/Chrysanthemum.jpg. thats why image not fetching from database.

Also what is a style in $variable.

Answer 1

You have to replace 'Style_name' with an actual image style, then it should work. That's because the function you are using does not only fetch the url of the image, it actually tries to fetch the image for a particular style, not the original.

Per default drupal ships with the image styles 'thumbnail', 'medium' and 'large'. You get these names when going to 'admin/config/media/image-styles', open the style you want to use for your image and look at the machine name - that's the 'style_name' you need.

So in your above example use for example:

$variables = array(
 'path' => $file->uri,
 'style_name'=>'medium'
);

You can use a custom image style as well of course.

---

Edit:

From the comments I guess you do not actually want to retrieve the url for a styled image, but the original url of the image. Here is the code which should retrieve the file url:

$fid=$r['field_upload_photo_fid'];
$file = file_load($fid);
$url_to_your_file = file_create_url($file->uri);

Answer 2

The style is an image style which is described a bit in Working with images in Drupal 7 and 8. I believe that you need to use Style_name as the 'style' in your code instead of 'public':

 $fid=$r['field_upload_photo_fid'];
 $file = file_load($fid);
 $variables = array(
 'path' => $file->uri,
 'style'=>'Style_name'
 );
 print theme('image_style', $variables);

But also, what is the data in $file->uri? If you start with bad data then the result is also going to be bad.