snipt

Ctrl+h for KB shortcuts

PHP

check keyword in string : strpos()

1
2
3
4
5
6
<?php
// © 2012-2013, [ Abstract Codify ] Abstractcodify.com All Rights Reserved.
if ( strpos( $all_string , 'keyword' ) !== false ) 
{
	echo 'true ';
}
https://snipt.net/embed/7d2d9604d04d99c86a277981437e7546/
https://snipt.net/raw/7d2d9604d04d99c86a277981437e7546/
7d2d9604d04d99c86a277981437e7546
php
PHP
6
2016-09-28T11:57:42
True
False
True
Aug 27, 2013 at 12:06 AM
/api/public/snipt/77238/
check-keyword-in-string-strpos
<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></pre></div></td><td class="code"><div class="highlight"><pre><span id="L-1"><a name="L-1"></a><span class="cp">&lt;?php</span> </span><span id="L-2"><a name="L-2"></a><span class="c1">// © 2012-2013, [ Abstract Codify ] Abstractcodify.com All Rights Reserved.</span> </span><span id="L-3"><a name="L-3"></a><span class="k">if</span> <span class="p">(</span> <span class="nb">strpos</span><span class="p">(</span> <span class="nv">$all_string</span> <span class="p">,</span> <span class="s1">&#39;keyword&#39;</span> <span class="p">)</span> <span class="o">!==</span> <span class="k">false</span> <span class="p">)</span> </span><span id="L-4"><a name="L-4"></a><span class="p">{</span> </span><span id="L-5"><a name="L-5"></a> <span class="k">echo</span> <span class="s1">&#39;true &#39;</span><span class="p">;</span> </span><span id="L-6"><a name="L-6"></a><span class="p">}</span> </span></pre></div> </td></tr></table>
change, replace, string

MySQL

Calculate the difference between dates in on column within the same table

1
2
3
4
SELECT DATEDIFF(
 (SELECT DATE(date_field) FROM table WHERE id = '1' AND status_id = '2' ORDER BY date_field DESC LIMIT 1),
 (SELECT DATE(date_field) FROM table WHERE id = '1' AND status_id = '1' ORDER BY date_field DESC LIMIT 1)
	) AS difference
https://snipt.net/embed/92c1f8bbeb80a7a6033d40cae85dcd24/
https://snipt.net/raw/92c1f8bbeb80a7a6033d40cae85dcd24/
92c1f8bbeb80a7a6033d40cae85dcd24
mysql
MySQL
4
2016-09-27T13:23:16
True
False
False
/api/public/snipt/14227/
calculate-the-difference-between-dates-in-one-columns-within-the-same-table
<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></pre></div></td><td class="code"><div class="highlight"><pre><span id="L-1"><a name="L-1"></a><span class="k">SELECT</span> <span class="nf">DATEDIFF</span><span class="p">(</span> </span><span id="L-2"><a name="L-2"></a> <span class="p">(</span><span class="k">SELECT</span> <span class="kt">DATE</span><span class="p">(</span><span class="n">date_field</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">table</span> <span class="k">WHERE</span> <span class="n">id</span> <span class="o">=</span> <span class="s1">&#39;1&#39;</span> <span class="k">AND</span> <span class="n">status_id</span> <span class="o">=</span> <span class="s1">&#39;2&#39;</span> <span class="k">ORDER</span> <span class="k">BY</span> <span class="n">date_field</span> <span class="k">DESC</span> <span class="k">LIMIT</span> <span class="mi">1</span><span class="p">),</span> </span><span id="L-3"><a name="L-3"></a> <span class="p">(</span><span class="k">SELECT</span> <span class="kt">DATE</span><span class="p">(</span><span class="n">date_field</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">table</span> <span class="k">WHERE</span> <span class="n">id</span> <span class="o">=</span> <span class="s1">&#39;1&#39;</span> <span class="k">AND</span> <span class="n">status_id</span> <span class="o">=</span> <span class="s1">&#39;1&#39;</span> <span class="k">ORDER</span> <span class="k">BY</span> <span class="n">date_field</span> <span class="k">DESC</span> <span class="k">LIMIT</span> <span class="mi">1</span><span class="p">)</span> </span><span id="L-4"><a name="L-4"></a> <span class="p">)</span> <span class="k">AS</span> <span class="n">difference</span> </span></pre></div> </td></tr></table>
change, date, datediff, difference, mysql, status, subquery

Text only

change mac address of interface

1
2
3
4
ifconfig <interface> down
ifconfig <interface> hw ether 00:80:48:BA:d1:30
ifconfig <interface> up
ifconfig <interface> |grep HWaddr
https://snipt.net/embed/472f163420b38d816fc75eff141f188c/
https://snipt.net/raw/472f163420b38d816fc75eff141f188c/
472f163420b38d816fc75eff141f188c
text
Text only
4
2016-09-22T13:31:51
True
False
False
/api/public/snipt/13675/
change-mac-address-of-interface
<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></pre></div></td><td class="code"><div class="highlight"><pre><span id="L-1"><a name="L-1"></a>ifconfig &lt;interface&gt; down </span><span id="L-2"><a name="L-2"></a>ifconfig &lt;interface&gt; hw ether 00:80:48:BA:d1:30 </span><span id="L-3"><a name="L-3"></a>ifconfig &lt;interface&gt; up </span><span id="L-4"><a name="L-4"></a>ifconfig &lt;interface&gt; |grep HWaddr </span></pre></div> </td></tr></table>
change, interface, macaddress
Copyrighted, illegal, or inappropriate content? Email support@snipt.net.