• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: SQL mapping insert uploaded image joomla article

SQL mapping insert uploaded image joomla article 10 years 2 months ago #30528

  • info3946
  • info3946's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 18
  • Thank you received: 1
Hi I have a form which is sql mapped to the joom_content table
I am trying to insert an image uploaded using the file upload element {image:value} into the article body
I have placed
{Message:value} {image:value}
into introtext.
However it renders the file as a link to download as opposed to showing the image.
How can i get the file to render as an image?
Thanks
The administrator has disabled public write access.

SQL mapping insert uploaded image joomla article 9 years 5 months ago #33091

  • modernmagic
  • modernmagic's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 33
  • Thank you received: 2
I want to do this too. Any luck?
The administrator has disabled public write access.

SQL mapping insert uploaded image joomla article 9 years 5 months ago #33094

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
The upload field has an additional placeholder that returns the path to the uploaded file (not a download link): {field name here:path}

More on upload field configuration here:

https://www.rsjoomla.com/support/documentation/rsform-pro/form-fields/file-upload.html
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.

SQL mapping insert uploaded image joomla article 9 years 2 months ago #34110

  • info3946
  • info3946's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 18
  • Thank you received: 1
You can do this with the following code in your
introtext (mediumtext) field
{"image_intro":"{image:path}","float_intro":"","image_intro_alt":"","image_intro_caption":""}

(This only sets the intro image)
My element is called "image" so you may need to change that to match your element name.
Last Edit: 8 years 7 months ago by info3946. Reason: corrected code
The administrator has disabled public write access.

SQL mapping insert uploaded image joomla article 9 years 2 weeks ago #34827

  • info3946
  • info3946's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 18
  • Thank you received: 1
Hi I am modifying this sql mapping to try to pull a FB image into my intro image
This works for file upload
{"image_intro":"{image:path}","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"{image:path}","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}

I have created a text field to enter the facebook image url
{fbimage}

Then changed my mapping above to
{"image_intro":"{fbimage:value}","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"{fbimage:value}","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}

Works a treat! Enjoy
The administrator has disabled public write access.

SQL mapping insert uploaded image joomla article 8 years 10 months ago #35224

hello...
how to display image in article joomla use File Upload form : i use mappings {text:value}, {photo:value} the result is
"this is text demo..., 5759320b90fc2-yt.jpg"

can help me because i not understand...
please show me example...thanks
The administrator has disabled public write access.

SQL mapping insert uploaded image joomla article 8 years 7 months ago #35864

  • info3946
  • info3946's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 18
  • Thank you received: 1
You need to use <img src="{photo:path}" alt="{text:value}" />
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!