From: kangtk at 163 dot com Operating system: windowXP PHP version: 4.3.9 PHP Bug Type: MSSQL related Bug description: Can not deal with symbol such as ' or " or \
Description: ------------ I use PHP with sql server 2000 databse. when I use like this: $query = "select * from userinfo where Name='".$name."'"; $result = mssql_query($query,$db); But if the $name has the symbol such as ' or " or \,It will be error. Such as $name = " 'name" "; How can I deal with this? Thanks. -- Edit bug report at http://bugs.php.net/?id=32271&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32271&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=32271&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=32271&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=32271&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=32271&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=32271&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=32271&r=needscript Try newer version: http://bugs.php.net/fix.php?id=32271&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=32271&r=support Expected behavior: http://bugs.php.net/fix.php?id=32271&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=32271&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=32271&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=32271&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32271&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=32271&r=dst IIS Stability: http://bugs.php.net/fix.php?id=32271&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=32271&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=32271&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=32271&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=32271&r=mysqlcfg