Return Data from External Database

More
4 years 5 months ago #92080 by thomsol
thomsol created the topic: Return Data from External Database
I want to have a lookup against an external database to retrieve information based on a survey response. For example: user enters vehicle identification #, I want to look up the make, model, year, etc.

The way I'm attempting to do this is by adding a function to the em_core_helper.php module, which contains the logic to connect to the database, then look up the information.

Question, can the return from this function be a name->value pair, such that I could reference it as {car_id(qCarId.shown)["Model"]} or [car_id[CarId.shown)->Model?

Open to ideas of another way to do this....

(This question was moved from installation category)

Please Log in to join the conversation.

More
4 years 5 months ago #92086 by tpartner
tpartner replied the topic: Return Data from External Database
Rather than modifying the core code, it may be easier/safer to make an AJAX call to a remote script that accesses the "cars" DB for you.

Alternatively, here's an example of how to access data from a remote CSV file - www.limesurvey.org/en/forum/design-issue...filled-questions-csv

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
4 years 5 months ago #92091 by thomsol
thomsol replied the topic: Return Data from External Database
Ajax... ugh!! (sorry, not my skillset)... Any chance this will be handled with the plug-ins due in 2.1?

Please Log in to join the conversation.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now