Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Custom interaction with mysql

  • bulgin
  • bulgin's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
4 years 5 months ago #190916 by bulgin
Custom interaction with mysql was created by bulgin
Hello.

I've searched the forums and documentation and cannot find a simple example or explanation on how to interact with custom mysql commands to the backend database tables.

For example, something as simple as setting a value on a field in a mysql database or similar I come up empty-handed.

I have read some examples of users creating custom scripts, which is great, but there is no mention of *where* to place these scripts within the limesurvey interface or the systematic workflow of these scripts - they are usually just dumped as a script as a response to the user without mention of where to place them.

A simple, basic tutorial on how to create custom scripts that interact in a simple way with Limesurvey would be great and be a good starting point for users who need to set and manipulate custom values.

Thanks.
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 5 months ago #190918 by tpartner
Replied by tpartner on topic Custom interaction with mysql
It would be safer to use the API.

- manual.limesurvey.org/RemoteControl_2_API
- api.limesurvey.org/classes/remotecontrol_handle.html

Search the forums for "API".

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • bulgin
  • bulgin's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
4 years 5 months ago #190919 by bulgin
Replied by bulgin on topic Custom interaction with mysql
Thank you - that seems like the way to go!

Since it's above my pay grade to understand such programming what kind of programmer am I looking for who can both understand these methods while also being able to implement something specific to limesurvey?

Thank you.
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 5 months ago #190935 by tpartner
Replied by tpartner on topic Custom interaction with mysql
You can contact me at the link below or other partners here - www.limesurvey.com

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
More
4 years 5 months ago #191100 by davebostockgmail
Replied by davebostockgmail on topic Custom interaction with mysql
I have interacted with MySql from Limesurvey in the past ... what I have done is to use a PHP script as a middle layer to interact with the database and return the results to the survey.

Here is an example

www.limesurvey.org/forum/can-i-do-this-w...er-all-needed-solved
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 5 months ago #191115 by DenisChenu
Replied by DenisChenu on topic Custom interaction with mysql
Alternative solutuion : plugin usage

Sample gitlab.com/SondagesPro/QuestionSettingsType/findUserAgentInfo

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose