News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Metapundit.net:
Code Smells II
October 26, 2006 @ 09:14:00

Following up from the previous article on the Metapundit.net blog, there's part two of the "Code Smells" series - a look at bad things to do in your code (to make it "smell").

This (and any subsequent posts in the series) will be more limited in scope - a single bad example and a corresponding solution.

This time, the spotlight is on parameterised queries - inserting the variables directly into a SQL statement string versus filtering them or inserting them via a custom query() function. He points out that there's no need to create this kind of filtering/database handling class on your own, though - there's already been one created by the fine folks of PEAR (using the autoExecute function

0 comments voice your opinion now!
smell parameterised queries sql validation filtering smell parameterised queries sql validation filtering


blog comments powered by Disqus

Similar Posts

Christopher Jones' Blog: Statement caching bug fix to improve performance of OCI8 extension

Zend Developer Zone: Generating and Validating Web Forms With PEAR HTML_QuickForm

Ulrich Kautz: PHP Validation & Sanitization

Bob Majdak: On SQL in PHP

David Coallier's Blog: PEAR::Validate 0.8.0 released...THE release, finally


Community Events











Don't see your event here?
Let us know!


podcast framework component example hack release security unittest opinion series facebook code symfony2 composer hhvm language application install introduction package

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework