- Posts: 14
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Accessing Database from The UI
- skandoi
- Topic Author
- Offline
- New Member
Less
More
4 years 11 months ago #182903
by skandoi
Accessing Database from The UI was created by skandoi
I want to access the limesurvey database from the Template , is it possible ? . My problem is if any one fill the form (survey ) i want to compare the token of participant from the database before submitting the form so , please suggest me any idea how I achieve this .
Thanks,
subham
Thanks,
subham
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10635
- Thank you received: 3699
4 years 11 months ago #182908
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 Accessing Database from The UI
There is no direct way to access the database from within the LimeSurvey GUI.
You would probably need to code a remote PHP script to do that, maybe via the API.
- manual.limesurvey.org/RemoteControl_2_API
You would probably need to code a remote PHP script to do that, maybe via the API.
- manual.limesurvey.org/RemoteControl_2_API
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
- skandoi
- Topic Author
- Offline
- New Member
Less
More
- Posts: 14
- Thank you received: 0
4 years 11 months ago #182911
by skandoi
Replied by skandoi on topic Accessing Database from The UI
Actually i want to use API dynamically , can you suggest how I use API dynamically (when the participants fill the form at that time that API will called to check the condition according to my requirements I write the condition ) and where ?
Thanks for reply
Thanks for reply
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10635
- Thank you received: 3699
4 years 11 months ago #182921
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 Accessing Database from The UI
An AJAX call to the remote PHP script would work but it's too much coding for me to give a working example.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
- skandoi
- Topic Author
- Offline
- New Member
Less
More
- Posts: 14
- Thank you received: 0
4 years 11 months ago #182923
by skandoi
Replied by skandoi on topic Accessing Database from The UI
can you only suggest the location where i write the code . I will try by myself .
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10635
- Thank you received: 3699
4 years 11 months ago #182925
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 Accessing Database from The UI
The AJAX call would be a script in the survey (question source or custom.js file), presumably fired when the form is submitted.
The API call (or SQL query) would be in a remote PHP script accessed via the AJAX call.
The API call (or SQL query) would be in a remote PHP script accessed via the AJAX call.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
- skandoi
- Topic Author
- Offline
- New Member
Less
More
- Posts: 14
- Thank you received: 0
4 years 11 months ago #183599
by skandoi
Replied by skandoi on topic Accessing Database from The UI
Hi ,
I tried but not able to do that, can you please give any example if possible .
Thanks ,
subham
I tried but not able to do that, can you please give any example if possible .
Thanks ,
subham
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12791
- Thank you received: 3941
4 years 11 months ago #183619
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Accessing Database from The UI
If you do a search here for "ajax call" you find at least two examples:
www.limesurvey.org/forum/can-i-do-this-w...ecific-quotas#181176
and
www.limesurvey.org/forum/can-i-do-this-w...rmation-email#181066
The php script is your part.
Joffm
www.limesurvey.org/forum/can-i-do-this-w...ecific-quotas#181176
and
www.limesurvey.org/forum/can-i-do-this-w...rmation-email#181066
The php script is your part.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10635
- Thank you received: 3699
4 years 11 months ago #183623
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 Accessing Database from The UI
Searching the forums for "jsonRPCClient" will yield many examples of using the API with PHP.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.