Re: Updating a mysql row


The stupid question is the question not asked
	PerlMonks

Re: Updating a mysql row

by imp (Priest)

Log in
Create a new user
The Monastery Gates
Seekers of Perl Wisdom
Meditations
Cool Uses For Perl
Obfuscation
Tutorials
Poetry
Illuminations
Reviews
Perl News
Donate
Recent Threads
Newest Nodes
Super Search
PerlMonks Discussion
What's New

on Feb 22, 2007 at 21:34 UTC ( [id://601649]=note: print w/replies, xml )

Need Help??

in reply to Updating a mysql row

Yes, do it exactly as you suggested... except you really should use bound parameters to avoid SQL injection attacks. Alternately you can use DBI's quote method

Something like this:

my $sql = q{UPDATE now_time SET time= NOW(), location=?, count=count+1
+ WHERE ip=?};

$dbh->do($sql,{}, $ENV{HTTP_REFERER}, $userip)
  or die $dbh->errstr;
[download]