Accessing Database from The UI

More
2 months 2 weeks ago #182903 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

Please Log in or Create an account to join the conversation.

LimeSurvey Partners
More
2 months 2 weeks ago #182908 by tpartner
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

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Official LimeSurvey Partner - partnersurveys.com

Please Log in or Create an account to join the conversation.

More
2 months 2 weeks ago #182911 by skandoi
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

Please Log in or Create an account to join the conversation.

More
2 months 2 weeks ago #182921 by tpartner
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.
Official LimeSurvey Partner - partnersurveys.com

Please Log in or Create an account to join the conversation.

More
2 months 2 weeks ago #182923 by skandoi
can you only suggest the location where i write the code . I will try by myself .

Please Log in or Create an account to join the conversation.

More
2 months 2 weeks ago #182925 by tpartner
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.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Official LimeSurvey Partner - partnersurveys.com

Please Log in or Create an account to join the conversation.

More
1 month 3 weeks ago #183599 by skandoi
Hi ,

I tried but not able to do that, can you please give any example if possible .

Thanks ,
subham

Please Log in or Create an account to join the conversation.

More
1 month 3 weeks ago #183619 by Joffm


Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in or Create an account to join the conversation.

More
1 month 3 weeks ago #183623 by tpartner
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.
Official LimeSurvey Partner - partnersurveys.com

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!