Starting to stop SQL injections#
In a lot of examples about PHP, strings are concatenated before a database query is executed as below. Some examples advise to use PHP-functions mysql_real_escape_string() and/or addslashes() to make database query safe against SQL-injections. But this isn’t really a solution as when using addslashes() also requires the use of stripslashes() after retrieving data from a database. Some sites show the lack of proper implementation and show the famous ' string on a website.
<?php $sth = $dbh->prepare('select userid from accounts where username = "'.$form_username.'"'); $sth->execute();
Like in Perl with DBI, also PHP has PDO that allows for variables to be parameterized while executing a query as in the example below. This removes the need for homemade solutions that don’t cover all use-cases and allows for a way to provide a stable and more secure interface for your applications when communicating with databases.
<?php $sth = $dbh->prepare('select userid from accounts where username = ?'); $sth->execute(array($form_username));
This doesn’t stop the need for sanitizing variables like input from users.