18 RSJoomla! Years Sale 2025

  • 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: one form for multiple mysql tables

one form for multiple mysql tables 4 years 2 months ago #41063

Hi,

is there a way to set a textbox (plus other fields, of course) into ONE default form and, depends of the name of the textbox field (the one i mention before) put the data into different preset tables ?
For example:
i have a mysql db with 3 different tables: A / B / C and i have one single form with a textbox (or dropdown menu) and some other fields.
Is there a way to direct all the data of the form into the table ( A / B or C) that i setup into the first textbox ?

In this way i can create only one form to populate a lot of different tables into a db instead of creating multiples forms, each one for different tables...

thanks in advance.
Regards.
Last Edit: 4 years 2 months ago by virgilio.verlingieri.
The administrator has disabled public write access.

one form for multiple mysql tables 4 years 2 months ago #41070

  • iceferret
  • iceferret's Avatar
  • OFFLINE
  • Gold Boarder
  • Posts: 247
  • Thank you received: 65
Interesting idea. Never done it but I think that I would start by(in scripts called on form process) connecting to the database then use switch statements to call the insert into table A/B/C queries
explanation here
If you can keep your head when all about you are losing theirs, then you obviously don't understand the situation!
The administrator has disabled public write access.
The following user(s) said Thank You: virgilio.verlingieri
  • 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!