 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
I ran one of my database front-ends that worked great in PHP3, under PHP4 and found that back-slashes started poping up like rabbits on fertility hormones. After a little research into the problem, I found out what it was: mysql_escape_string, a function not availble in PHP3 was implemented "transparently" in PHP4 and (unfortunately) was installed "backwards": It escapes the result set, which is not how string escaping was intended. The fix: I've made a fix called mysql_unescape_string. You won't find an analog of it at www.mysql.com because its a bastard function specifically for taking care of the PHP4 implementation problem. See the example section for usage of it... (Also, see the "mysql_escape_string" function in this same section for my original fix for string escaping in MySQL) <?php function mysql_unescape_string($s) { $sl=strlen($s); for ($a=0;$a<$sl;$a++) { $c=substr($s,$a,1); if ($c=="\\") { switch(substr($s,$a+1,1)) { case "0": $c="\0"; break; case "n": $c="\n"; break; case "t": $c="\t"; break; case "r": $c="\r"; break; case "b": $c="\b"; break; case "\'": $c="'"; break; case "\"": $c="\""; break; case "\\": $c="\\"; break; case "%": $c="\%"; break; case "_": $c="_"; break; default: echo("unhandled exception!"); } // advance the counter because we are pealing off the char after the scanned \ $a++; } $s2.=$c; } return $s2; } ?> Example : ======== In PHP3, the code: ... $row=mysql_fetch_row($res); $fielddata=strval($row[0]); .... becomes (in PHP4): .... $row=mysql_fetch_row($res); $fielddata=mysql_unescape_string(strval($row[0])); | |||||
| Related Code Examples | |||||
