DB Images

There’s no special support for images.

It looks as if database images could be introduced into the HTML inline if you send to the browser encoded in base64. You should be able to create those encodings from jpegs using string base64_encode ( string $data ) in a PHP snippet. But you could quickly get into performance issues.

Do you mean hyperlinks in a column in the database – in which case yes. You just use a PHP snippet in a column to wrap the link in that column with the associated text (in another database column) with a pair A tags. There are hyperlinks in the example snippets that navigate wp_post etc. But will post an simple example if you need one.

John

This usable SQL does not work for me either: `SELECT ID, ‘<img src=”https://www.google.co.uk/images/srpr/logo11w.png&#8221; />’ AS ‘ColB’
FROM wp_posts limit 2`

I am not sure what’s wrong. If I use chrome inspect element, your HTML is there but greyed out. I think there maybe some level of anti HTML injection going on somewhere.

However this works, try a PHP snippet above the first column, your google image is displayed
return "<img src=\"https://www.google.co.uk/images/srpr/logo11w.png\" />";

This also works: try using the SQL
SELECT ID, ‘https://www.google.co.uk/images/srpr/logo11w.png&#8217; AS ‘ColB’ FROM wp_posts limit 2
with the PHP snippet return “<img src=’$value’ />”;

If you this SQL

SELECT ID, 'https://www.google.co.uk/images/srpr/logo11w.png' AS 'image', 'http://www.google.com' as 'link' FROM wp_posts limit 2

and this PHP snippet above the link column

return "<a href='".$value."'><img src='".$row['image']."'./>/a>";

you can click on the images in the 3rd column and get taken to google.

Yes, someone has raised that before. My only suggestion is to use CSS to hide the column or put

return '';

as a PHP snippet in the top of the unwanted column which will blank the column. Put the the column in the middle of the table and make it a feature! There does need to be a clean way to suppress display columns and sorry don’t have time to implement on this at moment.