[phorm] [Phorm:] logging to DB prob

From: webbbs@xxxxxxxxx
To: support@xxxxxxxxx
Date: 22 Oct 2004 16:17:29 -0000
The following new message has been posted on Phorm Support Forum at 
<http://www.phorm.com/support/>. 

*************************************************************************** 

  MESSAGE:  (#4404) logging to DB prob 
            <http://www.phorm.com/support/?rev=4404> 
  AUTHOR:   jf 
  DATE:     October 22, 2004 at 12:17 p.m. EST 

Hello-- 

I have Phorm up and running, at least the forms are processed and redirects 
are as expected. However, I do have one snag: I would like some form fields 
logged to a MYSQL database but my table shows up empty after form processing. 
I receive no error messages, so I'm sure this has to do with my SQL. I have 
this in the form's config file: 

$PHORM_MYDBV = "../dbconn.php"; 
$PHORM_MYTABLE = "contacts"; 
$PHORM_MYVARS = "name=name, email=PHORM_FROM, address=address, city=city, 
state=state, zip=zip, country=country"; 

and here was the SQL I used to set up the table" 

DROP TABLE IF EXISTS contacts; 
CREATE TABLE contacts ( 
id int(4) NOT NULL auto_increment, 
name varchar(30) NOT NULL default '', 
email varchar(60) NOT NULL default '', 
address varchar(100) NOT NULL default '', 
city varchar(60) NOT NULL default '', 
state varchar(20) NOT NULL default '', 
zip varchar(10) NOT NULL default '', 
country varchar(30) NOT NULL default '', 
PRIMARY KEY (id) 
) TYPE=MyISAM; 

Any suggestions on how I can get my form data into this db? 

On a security note... any permissions I should set on the config files? Any 
specific permission to assign to dbconn.php, like 644? 

Also, off topic... does phorm work as a central form processor for a network? 
More specifically, can this be installed in one central location, then forms 
from other sites on the server can all use it (with PHORM_REFERRER properly 
configged)? 

thanks! 
JF ;) 

*************************************************************************** 

This is an automatically-generated notice.  If you'd like to be removed from 
the mailing list, please visit Phorm Support Forum at 
<http://www.phorm.com/support/>, or send your request to webbbs@xxxxxxxxxx  If 
you wish to respond to this message, please post your response directly to the 
board.  Thank you! 
-------------------------------------------------
You are receiving this message because you are subscribed to the Phorm mailing 
list. To send messages to the mailing list, simply send email to 
phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe 
from the list by sending email to phorm-request@xxxxxxxxxxxxx with 
'unsubscribe' in the SUBJECT field.
[phorm] [Phorm:] logging to DB prob

Other related posts:
