This is the revision history for placeholders in <matrix.org:#rAnyijhRxzFRfdjSHl:matrix.org>
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> |