PHP 4.0 Bug #6610 Updated: HTMLSpecialChars parse error

ID: 6610 Updated by: rasmus Reported By: gberenfield@berenfield.com Status: Closed Bug Type: *XML functions Assigned To: Comments: Fixed in CVS Previous Comments: [2000-09-07 13:13:45] gberenfield@berenfield.com I've verified the following problem (at least it was for me!) in 4.0.2 with HTMLSpecialChars(): If parsing a string that contains a single-quote character (the ' character), it now translates it to &#039; which broke a few pages I wrote using ODBCSocketServer. e.g. $sql3="select imitmidx_sql.item_no from imitmidx_sql where (imitmidx_sql.mat_cost_type='DRM') and (imitmidx_sql.item_no>='".$specno."') and (imitmidx_sql.item_no<'".$ends."')"; echo (HTMLSpecialChars($sql3)."n<P>"); This spits out: select imitmidx_sql.item_no from imitmidx_sql where (imitmidx_sql.mat_cost_type=&#039;DRM&#039;) and (imitmidx_sql.item_no&gt;=&#039;&#039;) and (imitmidx_sql.item_no&lt;&#039;&#039;) <P> To the web browser (raw HTML format). Again, this may not be a bug and is actually a fix of the HTMLSpecialChars function but it's breaking SQL calls via ODBCSocketServer 0.92. -Greg --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=6610