pushing web form params into mysql table

2007-06-25 Thread shadkeene
This is rather long, but I just posted my old perl script, mysql table, and my new html form of which I'm trying to pass the values into the mysql table. I'm digging into mysql now as I was previously using a program to pass form values to a .csv spreadsheet, but it was suggested that using mysql

Re: pushing web form params into mysql table

2007-06-25 Thread Greg Jetter
On Sunday June 24 2007 6:39 pm, [EMAIL PROTECTED] wrote: > This is rather long, but I just posted my old perl script, mysql > table, and my new html form of which I'm trying to pass the values > into the mysql table. I'm digging into mysql now as I was previously > using a program to pass form val

Re: pushing web form params into mysql table

2007-06-25 Thread Ricky Zhou
Greg Jetter wrote: > my $query = "insert into tablename > (atablenaem1,atablename2,atablename3)VALUES($SubjPerform,$somthing2, > $somthing3); > > > # insert stuff in the db > > $dbh->do($query) or die "$DBI::errstr"; To prevent SQL injection, etc. It's strongly recommended that you use place

Re: pushing web form params into mysql table

2007-06-26 Thread shadkeene
On Jun 25, 3:19 pm, [EMAIL PROTECTED] (Ricky Zhou) wrote: > Greg Jetter wrote: > > my $query = "insert into tablename > > (atablenaem1,atablename2,atablename3)VALUES($SubjPerform,$somthing2, > > $somthing3); > > > # insert stuff in the db > > > $dbh->do($query) or die "$DBI::errstr"; > > To preve

Re: pushing web form params into mysql table

2007-06-26 Thread Sean Davis
[EMAIL PROTECTED] wrote: > On Jun 25, 3:19 pm, [EMAIL PROTECTED] (Ricky Zhou) wrote: >> Greg Jetter wrote: >>> my $query = "insert into tablename >>> (atablenaem1,atablename2,atablename3)VALUES($SubjPerform,$somthing2, >>> $somthing3); >>> # insert stuff in the db >>> $dbh->do($query) or die "$DB

Re: pushing web form params into mysql table

2007-06-26 Thread shadkeene
On Jun 25, 3:19 pm, [EMAIL PROTECTED] (Ricky Zhou) wrote: > Greg Jetter wrote: > > my $query = "insert into tablename > > (atablenaem1,atablename2,atablename3)VALUES($SubjPerform,$somthing2, > > $somthing3); > > > # insert stuff in the db > > > $dbh->do($query) or die "$DBI::errstr"; > > To preve

Re: pushing web form params into mysql table

2007-06-28 Thread Sean Davis
> From: /Sean Davis <[EMAIL PROTECTED]>/ > To: /Shad Keene <[EMAIL PROTECTED]>/ > Subject: /Re: pushing web form params into mysql table/ > Date: /Tue, 26 Jun 2007 21:06:47 -0400/ > >Shad Keene wrote: > >> > >>Sean, >

RE: pushing web form params into mysql table

2007-06-29 Thread Aaron Reist
ilt-in.> > Sean> > > > ----------------> > From: /Sean Davis <[EMAIL PROTECTED]>/> > To: /Shad Keene <[EMAIL PROTECTED]>/> > Subject: /Re: pushing web form params into mys

Re: pushing web form params into mysql table

2007-06-29 Thread Sean Davis
Aaron Reist wrote: How I get off this mailing list? I tried the link at the bottom of the message, (many times) but it doesnt seem to work. http://learn.perl.org/faq/beginners-cgi.html#1.2%20%20how%20do%20i%20unsubscribe -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-