This is the revision history for placeholders in <freenode.net:##NULL>
| factoid_id | subject | copula | predicate | author | namespace |
|---|---|---|---|---|---|
| 11109 | placeholders | is | Don't quote or escape, use placeholders! https://metacpan.org/pod/DBI#Placeholders-and-Bind-Values example: my $sth = $db->prepare('INSERT INTO table (a, b) VALUES (?, ?)'); $sth->execute('lol', 'wut'); or just $db->do('INSERT INTO blah VALUES (?,?)', undef, 'lol', 'wut'); | grinnz_ | <*:##NULL> |
| 11108 | placeholders | is | Don't quote or escape, use placeholders! https://metacpan.org/pod/DBI#Placeholders-and-Bind-Values example: my $sth = $db->prepare('INSERT INTO table (a, b) VALUES (?, ?);'); $sth->execute('lol', 'wut'); or just $db->do('INSERT INTO blah VALUES (?,?)', undef, 'lol', 'wut'); | grinnz_ | <*:##NULL> |
| 11106 | placeholders | is | Don't quote or escape, use placeholders! https://metacpan.org/pod/DBI#Placeholders-and-Bind-Values example: my $sth = $db->prepare('INSERT INTO table (a, b) VALUES (?, ?);'); $sth->execute('lol', 'wut'); or just $db->do('INSERT INTO blah VALUES (?,?)', undef, 'lol', 'wut'); | grinnz_ | <*:##NULL> |
| 11096 | placeholders | is | Use placeholders! https://metacpan.org/pod/DBI#Placeholders-and-Bind-Values or perldoc DBI tl;dr: NO! Read the documentation! | popl | <*:##NULL> |
| 10698 | placeholders | is | You want placeholders: http://www.geekuprising.com/create_better_perl_and_sql_with_placeholders tldr: $sth = $db->prepare('INSERT INTO table (a, b) VALUES (?, ?);'); $sth->execute('lol', 'wut'); or just $db->do('INSERT INTO blah VALUES (?,?)', undef, 'lol', 'wut') | altreus | <*:##NULL> |
| 10697 | placeholders | is | You want placeholders: http://www.geekuprising.com/create_better_perl_and_sql_with_placeholders tldr: $sth = $db->prepare('INSERT INTO table (a, b) VALUES (?, ?);'); $sth->execute('lol', 'wut'); or just $sth->do('INSERT INTO blah VALUES (?,?)', undef, 'lol', 'wut') | altreus | <*:##NULL> |
| 10696 | placeholders | is | You want placeholders: http://www.geekuprising.com/create_better_perl_and_sql_with_placeholders tldr: $sth = $db->prepare('INSERT INTO table (a, b) VALUES (?, ?);'); $sth->execute('lol', 'wut'); or just $sth->do('INSERT INTO blah VALUES (?,?)', undef, 'lol', 'wut') | altreus | <*:##NULL> |
| 10695 | placeholders | is | You want placeholders: http://www.geekuprising.com/create_better_perl_and_sql_with_placeholders tldr: $sth = $db->prepare('INSERT INTO table (a, b) VALUES (?, ?);'); $sth->execute('lol', 'wut'); or just do('INSERT INTO blah VALUES (?,?)', undef, 'lol', 'wut') | altreus | <*:##NULL> |
| 8384 | placeholders | is | You want placeholders: http://www.geekuprising.com/create_better_perl_and_sql_with_placeholders tldr: $sth = $db->prepare('INSERT INTO table (a, b) VALUES (?, ?);'); $sth->execute('lol', 'wut'); | altreus | <*:##NULL> |
| 6395 | placeholders | is | You want placeholders: http://www.geekuprising.com/create_better_perl_and_sql_with_placeholders | buu | <*:##NULL> |
| 5927 | placeholders | is | You want placeholders: http://www.geekuprising.com/create_better_perl_and_sql_with_placeholders and http://bobby-tables-with-perl.com | apeiron | <*:##NULL> |
| 3567 | placeholders | is | You want placeholders: http://www.geekuprising.com/create_better_perl_and_sql_with_placeholders | perlbot | <*:##NULL> |