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

DevShed:
Database Security Guarding Against SQL Injection
November 11, 2008 @ 07:54:31

DevShed finishes off their series on database security in PHP applications with this look at protecting your application and data from the threat of SQL injections.

In this article we will continue to explore various attacks that can be made on a database and how to prevent these attacks. We will also build the last page of our site.

Their example script is a login for a secured area of the site and contains a possible place for an injection - non-validated user input. With something as simple as making the username a single quote, an attacker could find out more about your database structure and use that to get further into your systems. To avoid it, they recommend validating with the mysql_real_escape_string function as a first line of defense.

0 comments voice your opinion now!
sql injection database security tutorial validate user input mysqlrealescapestring


blog comments powered by Disqus

Similar Posts

Rob Zienert's Blog: Zend_Form Decorators and Composite Elements

IBM developerWorks: Build a Web service with PHP

Courtney Robinson's Blog: Apache Cassandra+PHPcassa+Code Igniter = large scale PHP app in 5 minutes

Jani Hartikainen's Blog: Unit testing 4: Mock objects and testing code which uses the database

Raphael Stolt's Blog: Rolling your own Phing task


Community Events











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


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

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