snipt

Ctrl+h for KB shortcuts

PHP

Escape data for SQL Server: mssql_real_escape_string

1
2
3
4
5
6
7
8
9
<?
function mssql_real_escape_string($s) {
	if(get_magic_quotes_gpc()) {
		$s = stripslashes($s);
	}
	$s = str_replace("'","''",$s);
	return $s;
}
?>
https://snipt.net/embed/5abceb7cbe2918efd59f29a2e3df3f19/
/raw/5abceb7cbe2918efd59f29a2e3df3f19/
5abceb7cbe2918efd59f29a2e3df3f19
php
PHP
9
2019-05-23T02:54:53
True
False
False
/api/public/snipt/17135/
mssql_real_escape_string
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a> <a href="#L-6">6</a> <a href="#L-7">7</a> <a href="#L-8">8</a> <a href="#L-9">9</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="cp">&lt;?</span> </span><span id="L-2"><a name="L-2"></a><span class="k">function</span> <span class="nf">mssql_real_escape_string</span><span class="p">(</span><span class="nv">$s</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-3"><a name="L-3"></a> <span class="k">if</span><span class="p">(</span><span class="nb">get_magic_quotes_gpc</span><span class="p">())</span> <span class="p">{</span> </span><span id="L-4"><a name="L-4"></a> <span class="nv">$s</span> <span class="o">=</span> <span class="nb">stripslashes</span><span class="p">(</span><span class="nv">$s</span><span class="p">);</span> </span><span id="L-5"><a name="L-5"></a> <span class="p">}</span> </span><span id="L-6"><a name="L-6"></a> <span class="nv">$s</span> <span class="o">=</span> <span class="nb">str_replace</span><span class="p">(</span><span class="s2">&quot;&#39;&quot;</span><span class="p">,</span><span class="s2">&quot;&#39;&#39;&quot;</span><span class="p">,</span><span class="nv">$s</span><span class="p">);</span> </span><span id="L-7"><a name="L-7"></a> <span class="k">return</span> <span class="nv">$s</span><span class="p">;</span> </span><span id="L-8"><a name="L-8"></a><span class="p">}</span> </span><span id="L-9"><a name="L-9"></a><span class="cp">?&gt;</span><span class="x"></span> </span></pre></div> </td></tr></table>
"escape sql", "sql server", mssql, php