I would like to know if its possible to transform the input of a cell into an image.
We have a table with 27k rows that has a column named ID. In the ID there is a number that matches a profile. Each profile has its unique profile pic and we would like to transform the ID column into an image.
Well if you have that table in database then can use CONCAT function in MySQL. On this link you have example with link how to achieve this with query. Below you can check example with HTML img tag
SELECT column_id,
column_2,
cplumn_3,
CONCAT('<img src="https://img.fminside.net/faces/ ', column_id, '.png">') as column_image
FROM your_table_name
You will replace columns and tables names with your real data.
Hi,
I would like to know if its possible to transform the input of a cell into an image.
We have a table with 27k rows that has a column named ID. In the ID there is a number that matches a profile. Each profile has its unique profile pic and we would like to transform the ID column into an image.
Example:
ID in Column = 11133
Image = https://img.fminside.net/faces/11133.png
What I would like to do is transform the look of the cell into an image, using the number in the column ID.
So: https://img.fminside.net/faces/colum_1.png
column_1 referring to the number in the column ID.
Thank you in advance.
Hi Len,
Thank you for your purchase.
Well if you have that table in database then can use CONCAT function in MySQL. On this link you have example with link how to achieve this with query. Below you can check example with HTML img tag
SELECT column_id, column_2, cplumn_3, CONCAT('<img src="https://img.fminside.net/faces/ ', column_id, '.png">') as column_image FROM your_table_nameYou will replace columns and tables names with your real data.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables