- Posts: 185
- Thank you received: 11
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Custom interaction with mysql
- bulgin
- Topic Author
- Offline
- Elite Member
Less
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.
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10115
- Thank you received: 3597
4 years 5 months ago #190918
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
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".
- 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
- Topic Author
- Offline
- Elite Member
Less
More
- Posts: 185
- Thank you received: 11
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.
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10115
- Thank you received: 3597
4 years 5 months ago #190935
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
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.
- davebostockgmail
- Offline
- Elite Member
Less
More
- Posts: 169
- Thank you received: 26
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
Here is an example
www.limesurvey.org/forum/can-i-do-this-w...er-all-needed-solved
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13675
- Thank you received: 2496
4 years 5 months ago #191115
by DenisChenu
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.
Replied by DenisChenu on topic Custom interaction with mysql
Alternative solutuion : plugin usage
Sample gitlab.com/SondagesPro/QuestionSettingsType/findUserAgentInfo
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.