snipt

Ctrl+h for KB shortcuts

PHP

Generate UPS or FedEX tracking link

1
2
3
4
5
6
7
8
<?
function get_tracking_link($num) {
	$fedex	= "http://www.fedex.com/Tracking?tracknumbers=";
	$ups	= "http://wwwapps.ups.com/etracking/tracking.cgi?tracknum=";
	preg_match('/1z/i',$num) ? $output = $ups.$num : $output = $fedex.$num;
	return $output;
}
?>
https://snippets.siftie.com/embed/3b58c121b6e5cf94f837e0678948e022/
/raw/3b58c121b6e5cf94f837e0678948e022/
3b58c121b6e5cf94f837e0678948e022
php
PHP
8
2019-04-16T03:51:10
True
False
False
/api/public/snipt/14855/
generate-ups-fedex-tracking-link
<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></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">get_tracking_link</span><span class="p">(</span><span class="nv">$num</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-3"><a name="L-3"></a> <span class="nv">$fedex</span> <span class="o">=</span> <span class="s2">&quot;http://www.fedex.com/Tracking?tracknumbers=&quot;</span><span class="p">;</span> </span><span id="L-4"><a name="L-4"></a> <span class="nv">$ups</span> <span class="o">=</span> <span class="s2">&quot;http://wwwapps.ups.com/etracking/tracking.cgi?tracknum=&quot;</span><span class="p">;</span> </span><span id="L-5"><a name="L-5"></a> <span class="nb">preg_match</span><span class="p">(</span><span class="s1">&#39;/1z/i&#39;</span><span class="p">,</span><span class="nv">$num</span><span class="p">)</span> <span class="o">?</span> <span class="nv">$output</span> <span class="o">=</span> <span class="nv">$ups</span><span class="o">.</span><span class="nv">$num</span> <span class="o">:</span> <span class="nv">$output</span> <span class="o">=</span> <span class="nv">$fedex</span><span class="o">.</span><span class="nv">$num</span><span class="p">;</span> </span><span id="L-6"><a name="L-6"></a> <span class="k">return</span> <span class="nv">$output</span><span class="p">;</span> </span><span id="L-7"><a name="L-7"></a><span class="p">}</span> </span><span id="L-8"><a name="L-8"></a><span class="cp">?&gt;</span><span class="x"></span> </span></pre></div> </td></tr></table>
"package tracking", "tracking number", fedex, ups

PHP

Convert MM/DD/YYYY date to YYYY-MM-DD with PHP

1
2
3
4
5
6
7
8
<?
function convertDate($date) {
	$date = preg_replace('/\D/','/',$date);
	return date('Y-m-d',strtotime($date));
}

print convertDate('11/05/1996'); //prints 1996-11-05
?>
https://snippets.siftie.com/embed/2325e463da0114ccc684fbc7ba9e2a00/
/raw/2325e463da0114ccc684fbc7ba9e2a00/
2325e463da0114ccc684fbc7ba9e2a00
php
PHP
8
2019-04-22T10:29:55
True
False
False
/api/public/snipt/14231/
convert-date-to-yyyy-mm-dd-with-php
<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></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">convertDate</span><span class="p">(</span><span class="nv">$date</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-3"><a name="L-3"></a> <span class="nv">$date</span> <span class="o">=</span> <span class="nb">preg_replace</span><span class="p">(</span><span class="s1">&#39;/\D/&#39;</span><span class="p">,</span><span class="s1">&#39;/&#39;</span><span class="p">,</span><span class="nv">$date</span><span class="p">);</span> </span><span id="L-4"><a name="L-4"></a> <span class="k">return</span> <span class="nb">date</span><span class="p">(</span><span class="s1">&#39;Y-m-d&#39;</span><span class="p">,</span><span class="nb">strtotime</span><span class="p">(</span><span class="nv">$date</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><span id="L-7"><a name="L-7"></a><span class="k">print</span> <span class="nx">convertDate</span><span class="p">(</span><span class="s1">&#39;11/05/1996&#39;</span><span class="p">);</span> <span class="c1">//prints 1996-11-05</span> </span><span id="L-8"><a name="L-8"></a><span class="cp">?&gt;</span><span class="x"></span> </span></pre></div> </td></tr></table>
convert, date, iso

CSS

CSS Text Reset

body {font: 62.5% Arial, Helvetica, sans-serif;}
https://snippets.siftie.com/embed/f453712d29c53b87d381f4168695f4da/
/raw/f453712d29c53b87d381f4168695f4da/
f453712d29c53b87d381f4168695f4da
css
CSS
1
2019-04-18T20:17:56
True
False
False
/api/public/snipt/14230/
css-text-reset
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="nt">body</span> <span class="p">{</span><span class="nb">font</span><span class="o">:</span> <span class="m">62.5%</span> <span class="n">Arial</span><span class="o">,</span> <span class="n">Helvetica</span><span class="o">,</span> <span class="nb">sans-serif</span><span class="p">;}</span> </span></pre></div> </td></tr></table>
"'text reset'", body, css, text

MySQL

Specify 'ORDER BY' order

1
2
3
// you would use something like this to specify the order in which you want the results returned

SELECT * FROM tablename ORDER BY col='text1' desc, col='text2' desc, col='text3' desc
https://snippets.siftie.com/embed/41bc7f9ad7a6d63347e267cc355fa771/
/raw/41bc7f9ad7a6d63347e267cc355fa771/
41bc7f9ad7a6d63347e267cc355fa771
mysql
MySQL
3
2019-04-14T19:16:25
True
False
False
/api/public/snipt/14229/
specify-order-by-order
<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></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="o">//</span> <span class="n">you</span> <span class="n">would</span> <span class="k">use</span> <span class="n">something</span> <span class="k">like</span> <span class="n">this</span> <span class="k">to</span> <span class="n">specify</span> <span class="n">the</span> <span class="k">order</span> <span class="k">in</span> <span class="n">which</span> <span class="n">you</span> <span class="n">want</span> <span class="n">the</span> <span class="n">results</span> <span class="n">returned</span> </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a><span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">tablename</span> <span class="k">ORDER</span> <span class="k">BY</span> <span class="n">col</span><span class="o">=</span><span class="s1">&#39;text1&#39;</span> <span class="k">desc</span><span class="p">,</span> <span class="n">col</span><span class="o">=</span><span class="s1">&#39;text2&#39;</span> <span class="k">desc</span><span class="p">,</span> <span class="n">col</span><span class="o">=</span><span class="s1">&#39;text3&#39;</span> <span class="k">desc</span> </span></pre></div> </td></tr></table>
"order by", mysql, sorting, sql