+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: API (https://forums.formtools.org/forumdisplay.php?fid=17)
+--- Thread: Data Extraction (/showthread.php?tid=1726)
Data Extraction - d_raghu9 - Oct 27th, 2011
Hi there,
i have just installed formtools and have managed to push into to the DB. Question is, how can i pull information from Database using API
Any help would be appreciated
Cheers
R
RE: Data Extraction - Ben - Oct 28th, 2011
Hi R,
Welcome to the forums!
What do you need to do with the data? Just display it, or something more advanced that needs custom code? The reason I ask is that if you're just trying to display the info, check out the ft_api_show_submissions() function:
http://docs.formtools.org/api/?page=ft_api_show_submissions
That ties in with the Export Manager module to display the data in your own pages.
But if you need to do more advanced stuff with the data, I'd actually bypass the API and use the Core functions themselves. Specifically, the ft_search_submissions() function, found in /global/code/submissions.php. But for simplicity, look at the ft_api_show_submissions function code to see how it works. That would be how I'd proceed.
- Ben
RE: Data Extraction - d_raghu9 - Oct 30th, 2011
Thanks Ben,
I need not display the data. Its a user registration form. So the user id is getting generated dynamically. I need to fetch that user id so that i can pass it to other modules in my app.
Does your solution still work?
Cheers
R