[phorm] [Phorm:] Inserting into MySql

From: webbbs@xxxxxxxxx
To: support@xxxxxxxxx
Date: 21 Aug 2004 01:02:53 -0000
The following new message has been posted on Phorm Support Forum at 
<http://www.phorm.com/support/>. 

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

  MESSAGE:  (#4277) Inserting into MySql 
            <http://www.phorm.com/support/?rev=4277> 
  AUTHOR:   beachnut 
  DATE:     August 20, 2004 at 9:02 p.m. EST 

I have tried everything that I know how to do on the computer(and that isn't 
much) to insert my form data into my Sql table. And nothing seems to work! 

I have downloaded the new widget config file, changed to my eMail address and 
ran it. Only problem is, how would I access the table that is set up, from my 
computer??? 

So I changed the config.php to go to my table like such: 

$DHost = "localhost"; 
$DUser = "beachnut_p"; 
$DPass = "*****"; 
$DBase = "members"; 

# Note that the values for TypeList, ColorList and ContactBy are created 
# in this file. 
$PHORM_MYTABLE = "test1"; 
$PHORM_MYVARS = "Name=Name, Email=PHORM_FROM, Types=TypeList, 
Colors=ColorList, ". 

"Contact=Contact, ContactBy=ContactBy"; 

Now, I believe that this should work! 

But it doesn't. 

This is what I get on my ack.html page: 
**************** 
Log: insert into test1 (Name,Email,Types,Colors,Contact,ContactBy) values 
('beachy','beachy@xxxxxxx','Residential and Food Service','blue','No','') 

Thank you beachy! 

The information on Residential and Food Service widgets in blue will be sent 
to you at beachy@xxxxxxxx 
****************** 
Evidently, it does not like the ,'No','') I think it is looking for ,'No') 

I ran a query from MySql and it also identified the character on line 60 of 
widgets.html, which is the line that contains (No) as having an unknown 
character. 

If it helps, I was getting responses from my form prior to installing the Sql 
connection in my config.php. It is not working now!! 

I decided to change my input to (yes), but that did not help because it still 
came back with the same problem when I ran the MySql query. 

Any help GREATLY APPRECIATED!! 

Phil M 

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

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:] Inserting into MySql

Other related posts:
