This is the revision history for placeholders in <matrix.org:#rAnyijhRxzFRfdjSHl:matrix.org>

factoid_idsubjectcopulapredicateauthornamespace
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>