snipt

Ctrl+h for KB shortcuts

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/
/raw/92c1f8bbeb80a7a6033d40cae85dcd24/
92c1f8bbeb80a7a6033d40cae85dcd24
mysql
MySQL
4
2019-08-07T14:49:10
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></span><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

PHP

Prompt user to 'open' or 'save' file when delivering dynamic file data with PHP

1
2
3
4
5
6
7
<?
header("content-type: $mime_type");
header("content-disposition: attachment; filename=$file_name");
header("cache-control: private");
header("pragma: private");
echo $file_data;
?>
https://snipt.net/embed/e107659ef24a3df68f6f7f9e131ae206/
/raw/e107659ef24a3df68f6f7f9e131ae206/
e107659ef24a3df68f6f7f9e131ae206
php
PHP
7
2019-08-09T09:45:49
True
False
False
/api/public/snipt/14226/
prompt-user-to-open-or-save-when-delivering-file-data-stored-in-database-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></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="nb">header</span><span class="p">(</span><span class="s2">&quot;content-type: </span><span class="si">$mime_type</span><span class="s2">&quot;</span><span class="p">);</span> </span><span id="L-3"><a name="L-3"></a><span class="nb">header</span><span class="p">(</span><span class="s2">&quot;content-disposition: attachment; filename=</span><span class="si">$file_name</span><span class="s2">&quot;</span><span class="p">);</span> </span><span id="L-4"><a name="L-4"></a><span class="nb">header</span><span class="p">(</span><span class="s2">&quot;cache-control: private&quot;</span><span class="p">);</span> </span><span id="L-5"><a name="L-5"></a><span class="nb">header</span><span class="p">(</span><span class="s2">&quot;pragma: private&quot;</span><span class="p">);</span> </span><span id="L-6"><a name="L-6"></a><span class="k">echo</span> <span class="nv">$file_data</span><span class="p">;</span> </span><span id="L-7"><a name="L-7"></a><span class="cp">?&gt;</span><span class="x"></span> </span></pre></div> </td></tr></table>
download, file, headers, http, php

Text only

Rollback to previous package version after bad upgrade with Ubuntu 8.04LTS and APT

1
2
3
4
5
This will show all the versions of the package in the cache
apt-cache show [package name] | fgrep Version:

This will install an older version of the package
apt-get install [package name]=[version]
https://snipt.net/embed/c1f36e0159632b9542fc49f098c72381/
/raw/c1f36e0159632b9542fc49f098c72381/
c1f36e0159632b9542fc49f098c72381
text
Text only
5
2019-08-17T14:09:18
True
False
False
/api/public/snipt/14222/
rollback-to-previous-package-version-after-upgrade-with-ubuntu-804lts-and-apt
<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></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>This will show all the versions of the package in the cache </span><span id="L-2"><a name="L-2"></a>apt-cache show [package name] | fgrep Version: </span><span id="L-3"><a name="L-3"></a> </span><span id="L-4"><a name="L-4"></a>This will install an older version of the package </span><span id="L-5"><a name="L-5"></a>apt-get install [package name]=[version] </span></pre></div> </td></tr></table>
apt, package, rollback, ubuntu

CSS

Force a page break when printing a web page

1
2
3
4
5
<style type="text/css">
.pagebreak {page-break-after: always;}
</style>

<br class="pagebreak" />
https://snipt.net/embed/dc37749658f5ad304f88da92b21cba4a/
/raw/dc37749658f5ad304f88da92b21cba4a/
dc37749658f5ad304f88da92b21cba4a
css
CSS
5
2019-08-13T05:29:02
True
False
False
/api/public/snipt/14221/
force-a-page-break-when-printing-a-web-page
<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></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="o">&lt;</span><span class="nt">style</span> <span class="nt">type</span><span class="o">=</span><span class="s2">&quot;text/css&quot;</span><span class="o">&gt;</span> </span><span id="L-2"><a name="L-2"></a><span class="nc">.pagebreak</span> <span class="p">{</span><span class="nb">page-break-after</span><span class="o">:</span> <span class="nb">always</span><span class="p">;}</span> </span><span id="L-3"><a name="L-3"></a><span class="o">&lt;/</span><span class="nt">style</span><span class="o">&gt;</span> </span><span id="L-4"><a name="L-4"></a> </span><span id="L-5"><a name="L-5"></a><span class="o">&lt;</span><span class="nt">br</span> <span class="nt">class</span><span class="o">=</span><span class="s2">&quot;pagebreak&quot;</span> <span class="o">/&gt;</span> </span></pre></div> </td></tr></table>
break, css, page, print, printer