Welcome, Guest
Username: Password:

TOPIC: Return Data from External Database

Return Data from External Database 3 years 2 months ago #92080

  • thomsol
  • thomsol's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
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)
The administrator has disabled public write access.

Return Data from External Database 3 years 2 months ago #92086

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5761
  • Thank you received: 1251
  • Karma: 512
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.
The administrator has disabled public write access.

Return Data from External Database 3 years 2 months ago #92091

  • thomsol
  • thomsol's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
Ajax... ugh!! (sorry, not my skillset)... Any chance this will be handled with the plug-ins due in 2.1?
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.237 seconds