extracting field data from FormTools2.0.5

[billonthebeach]

Hey guys -- there is a whole lot packed into your little box. Great job.

To extract data from record specific 'fields' in the ft_Form_1 table, to external php file, what do you recommend?

Through the FT API or the "backdoor" ?

The docs for
ft_api_load_field

at
http://docs.formtools.org/api/?page=ft_api_load_field

don't indicate whether or not this will do the job.


Either way, a little code to jumpstart the process would be appreciated.

Thanks,
Bill

[Hannes]

Hey Bill,

ft_api_load_field:

It assumes that a variable name can be found in GET, POST or SESSIONS (or all three)

"backdoor":

Code:

mysql_connect ( "localhost", "user", "password" );
mysql_query("SET NAMES 'UTF8'");
mysql_select_db ( "formtools" );
$result = mysql_query("SELECT `field` FROM `ft_form_1` WHERE `otherfield`="condition");
if(mysql_num_rows($result) == 0){
$errors[] = "field";
}
mysql_close;

Hope it helps.

Cheers,
Hannes