+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: extracting field data from FormTools2.0.5 (/showthread.php?tid=932)
extracting field data from FormTools2.0.5 - billonthebeach - Nov 13th, 2010
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
RE: extracting field data from FormTools2.0.5 - Hannes - Nov 26th, 2010
Hey Bill,
ft_api_load_field:
Quote: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