News Feed
Sections




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

Mark Kimsal's Blog:
Addslashes() don't call it a comeback
June 12, 2008 @ 13:36:20

As Michael Kimsal points out, there's a new posting on his brother Mark's blog talking about alternatives to addslashes() in your applications.

I've seen a lot of people talking about mysql_real_escape_string() vs addslashes() vs addcslashes(). There seems to be a lot of real confusion about what these functions do (even with the php.net manual around), especially when it comes to character sets. [...] So, I've decided to lay it all out in a few charts so there is no confusion about what each function does and how each can help protect against SQL injection attacks.

He ran some tests based on what the function does to see if it helps with certain things like "escapes with single quotes instead of backslash" and "prevents multi-byte attacks". He compares the speed and testability of the functions as well as provides a multi-byte breakdown oh how the mysql_real_escape_string function works with different character sets.

0 comments voice your opinion now!
addslashes compare escape string mysql addcslashes multibyte


blog comments powered by Disqus

Similar Posts

Job Posting: Varien Seeks PHP/MySQL Programmers (Los Angeles, CA)

SitePoint PHP Blog: How to Create a Unique 64bit Integer from String

Martynas Jusevicius' Blog: Calculating great-circle distance in MySQL and Propel

DevShed: Introduction to the CodeIgniter PHP Framework

DevShed: Updating and Deleting Database Records with the Active Record Pattern


Community Events

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


symfony2 api podcast performance voicesoftheelephpant library series application part2 laravel opinion framework php7 introduction community release configure example conference interview

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