diff options
Diffstat (limited to 'phpBB/docs/coding-guidelines.html')
| -rw-r--r-- | phpBB/docs/coding-guidelines.html | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/phpBB/docs/coding-guidelines.html b/phpBB/docs/coding-guidelines.html index 5dd70928fd..8fd904e7c0 100644 --- a/phpBB/docs/coding-guidelines.html +++ b/phpBB/docs/coding-guidelines.html @@ -780,6 +780,23 @@ $sql = 'SELECT * <p>In other words use single quotes where no variable substitution is required or where the variable involved shouldn't appear within double quotes. Otherwise use double quotes.</p> + <h3>Avoid DB specific SQL: </h3> + <p>The "not equals operator", as defined by the SQL:2003 standard, is "<>"</p> + + <p class="bad">// This is wrong.</p> + <blockquote><pre> +$sql = 'SELECT * + FROM ' . SOME_TABLE . ' + WHERE a != 2'; + </pre></blockquote> + + <p class="good">// This is right. </p> + <blockquote><pre> +$sql = 'SELECT * + FROM ' . SOME_TABLE . ' + WHERE a <> 2'; + </pre></blockquote> + <h3>Common DBAL methods: </h3> <h3>sql_escape():</h3> |