Alter table html to add image column

  • Resolved ahmedsuror

    (@ahmedsuror)


    4 years, 2 months ago

    Hello everyone,
    I have a table fetched its data through “Data Publisher” section, the table fetched correctly, I have a column in a MySQL database that holds a link to a picture, what I want is to add a column to the table using any possible way to have a “img” tag and pass the link column of my DB to the “src” attribute of the “img” tag and when the table loads using the shortcode on the desired page the image column now should output the relevant image.. Is that possible?!
    Thanks in advance…

    • This topic was modified 4 years, 2 months ago by ahmedsuror.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @ahmedsuror,

    Welcome to the forum! ??

    Version 3.6.0 (latest) has a new option that does exactly what you are looking for. To show your image:
    – Start the Data Explorer
    – Find your table
    – Click the Manage link
    – Click tab Settings
    – Click Column settings
    – Select “Image URL” as the column type for your image column
    – Save your settings

    This will add the img tag to your publication.

    Hope this helps,
    Peter

    Thread Starter ahmedsuror

    (@ahmedsuror)

    Really I can’t thank you enough .. Have a good day.

    Thread Starter ahmedsuror

    (@ahmedsuror)

    Another Q please, can I make a custom select statements to get data like views?

    • This reply was modified 4 years, 2 months ago by ahmedsuror.
    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @ahmedsuror,

    Sorry! You can’t. I got his request from another plugin user as well. I will see if I add this feature in a future release.

    As an alternative, you can execute a create view script from the Data Explorer.

    Maybe this helps (a little)…

    Best regards,
    Peter

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Alter table html to add image column’ is closed to new replies.

Tags