#1641 Database images : show images preview.

[janness]

Hello Dear phpMyAdmin team.

I have little idea about images in table, I dont know if it's possible now,
but what about show images in php table ?

I mean if someone save name of file into database, it would be also possible to add relative path to the image and show him direct in db.

For example I will add new record with name picture.png. In the structure of table I can specify the path in form of : $IM['BASE']+'images'+'icons'+$FK['dbname1.dbtable1.dbid1-dbname2.dbtableid2.dbid2.valueYear']+databaseVALUE. This is just example and I think it can be interesting, because many time I or everyone else want to see how this picture looks and I must to search for it for long time throught many tables to found the path.

I think it will be not easy, but it can save time of many users,admin or developers for this, who will save file name of picture or file into db.

Thanks a lot and I hope my post isn't just wasting of your time.

[Marc Delisle]

This is already supported. See http://docs.phpmyadmin.net/en/latest/transformations.html. These transformations are MIME-based. To see an example of the results, visit https://sourceforge.net/projects/phpmyadmin/ and in the Overview section, one of the screenshots shows this feature.

[janness]

Hello, I saw transformations which support image thumbnails, if I upload it for example throught database.

But what if I want to just put the file name. In my case, I have table of pictures, thousand of pictures from sport events. I put into database filename 'IMG_1281215.jpg', and the path for this picture is :

www/projectname/images/gallery/%year%/%eventname%/IMG_1281215.jpg .

It's possible to see thumbnail of this picture in some way? I don't find something like this, if it's possible thank you for any hint...

[Marc Delisle]

Try this browser display transformation:
Text/Plain: Imagelink
Displays an image and a link; the column contains the filename. The first option is a URL prefix like "http://www.example.com/". The second and third options are the width and the height in pixels.

[janness]

Thank you very much, it works well . For me '../projectname/images/image.jpg' in local.

And is there any way to put in the first option some variables for example depend on foreign key ? ... ex. '../projectname/images/%year%/image.jpg' .

Because the year of event is stored in another table and every picture can be taken in different year(saved in different folder), I hope you understood it :) .

The %year% is value from another table .. thanks.

[Marc Delisle]

I don't believe that this is currently supported. Reopening this ticket.

[janness]

I try to remake this MIME-function for this, but do not know how it turns out ...

[Marc Delisle]

Thinking of this, the feature request is too specific to be of general use.