Data Extraction

[d_raghu9]

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

[Ben]

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_a...ubmissions

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

[d_raghu9]

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