• 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: How to update a table with value from a form field

How to update a table with value from a form field 5 years 9 months ago #39283

  • admin487
  • admin487's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
I want to a update a field such as profile.city in my __user_profiles table with the value of a what the user entered in a form field called {City:value}.

How do I go about doing that? Do I use the Mappings Plugin? If so how would the Query look like?
or do I add some code in the section Script called on form process, and what would that code look like?

Thank you
The administrator has disabled public write access.

How to update a table with value from a form field 5 years 9 months ago #39288

  • adrianp
  • adrianp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 631
  • Thank you received: 146
Hello,

This blog post explains how you can pass your form data within the Joomla! User Profile data.

If the user doesn't actually have this data then you'll need to do an Insert type query as the blog post provides, otherwise, you'll need an Update type query (you can try familiarizing yourself online with such concepts before trying this out and it's recommend that you perform a backup of your database before testing this out).
This is not official customer support. To receive your support, submit a support ticket here.
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!