| // returns true if it is the last day of the current month
<?
function is_last_day_of_month() {
$cur_day = date('j');
$max_days = date('t');
$output = $cur_day == $max_days ? true : false;
return $output;
}
?>
|
Expand
Collapse
(9 lines)
https://snippets.siftie.com/embed/ed5c708d9f04c22120494613b75a60b3/
/raw/ed5c708d9f04c22120494613b75a60b3/
ed5c708d9f04c22120494613b75a60b3
php
PHP
9
2019-02-02T07:55:36
True
False
False
/api/public/snipt/29601/
determine-if-it-is-the-last-day-of-the-month-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>
<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="x">// returns true if it is the last day of the current month</span>
</span><span id="L-2"><a name="L-2"></a><span class="cp"><?</span>
</span><span id="L-3"><a name="L-3"></a><span class="k">function</span> <span class="nf">is_last_day_of_month</span><span class="p">()</span> <span class="p">{</span>
</span><span id="L-4"><a name="L-4"></a> <span class="nv">$cur_day</span> <span class="o">=</span> <span class="nb">date</span><span class="p">(</span><span class="s1">'j'</span><span class="p">);</span>
</span><span id="L-5"><a name="L-5"></a> <span class="nv">$max_days</span> <span class="o">=</span> <span class="nb">date</span><span class="p">(</span><span class="s1">'t'</span><span class="p">);</span>
</span><span id="L-6"><a name="L-6"></a> <span class="nv">$output</span> <span class="o">=</span> <span class="nv">$cur_day</span> <span class="o">==</span> <span class="nv">$max_days</span> <span class="o">?</span> <span class="k">true</span> <span class="o">:</span> <span class="k">false</span><span class="p">;</span>
</span><span id="L-7"><a name="L-7"></a> <span class="k">return</span> <span class="nv">$output</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">?></span><span class="x"></span>
</span></pre></div>
</td></tr></table>
"last day", date, month, php
| <?
function mssql_real_escape_string($s) {
if(get_magic_quotes_gpc()) {
$s = stripslashes($s);
}
$s = str_replace("'","''",$s);
return $s;
}
?>
|
Expand
Collapse
(9 lines)
https://snippets.siftie.com/embed/5abceb7cbe2918efd59f29a2e3df3f19/
/raw/5abceb7cbe2918efd59f29a2e3df3f19/
5abceb7cbe2918efd59f29a2e3df3f19
php
PHP
9
2017-01-01T10:45:40
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"><?</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">"'"</span><span class="p">,</span><span class="s2">"''"</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">?></span><span class="x"></span>
</span></pre></div>
</td></tr></table>
"escape sql", "sql server", mssql, php
| <style type="text/css">
#table_bdr {border-collapse:collapse;}
tr.border {border: 2px solid red;}
</style>
...
<table id="table_bdr">
<tr>
<td>Data1</td>
<td>Data2</td>
<td>Data3</td>
<td>Data4</td>
</tr>
</table>
|
Expand
Collapse
(13 lines)
https://snippets.siftie.com/embed/fa951d8b1a92ac5b95665e66ac487905/
/raw/fa951d8b1a92ac5b95665e66ac487905/
fa951d8b1a92ac5b95665e66ac487905
html
HTML
13
2016-12-26T17:51:43
True
False
False
/api/public/snipt/15799/
add-a-border-to-tr
<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>
<a href="#L-10">10</a>
<a href="#L-11">11</a>
<a href="#L-12">12</a>
<a href="#L-13">13</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="p"><</span><span class="nt">style</span> <span class="na">type</span><span class="o">=</span><span class="s">"text/css"</span><span class="p">></span>
</span><span id="L-2"><a name="L-2"></a><span class="nn">#table_bdr</span> <span class="p">{</span><span class="nb">border-collapse</span><span class="o">:</span><span class="nb">collapse</span><span class="p">;}</span>
</span><span id="L-3"><a name="L-3"></a><span class="nt">tr</span><span class="nc">.border</span> <span class="p">{</span><span class="nb">border</span><span class="o">:</span> <span class="m">2px</span> <span class="nb">solid</span> <span class="nb">red</span><span class="p">;}</span>
</span><span id="L-4"><a name="L-4"></a><span class="p"></</span><span class="nt">style</span><span class="p">></span>
</span><span id="L-5"><a name="L-5"></a>...
</span><span id="L-6"><a name="L-6"></a><span class="p"><</span><span class="nt">table</span> <span class="na">id</span><span class="o">=</span><span class="s">"table_bdr"</span><span class="p">></span>
</span><span id="L-7"><a name="L-7"></a> <span class="p"><</span><span class="nt">tr</span><span class="p">></span>
</span><span id="L-8"><a name="L-8"></a> <span class="p"><</span><span class="nt">td</span><span class="p">></span>Data1<span class="p"></</span><span class="nt">td</span><span class="p">></span>
</span><span id="L-9"><a name="L-9"></a> <span class="p"><</span><span class="nt">td</span><span class="p">></span>Data2<span class="p"></</span><span class="nt">td</span><span class="p">></span>
</span><span id="L-10"><a name="L-10"></a> <span class="p"><</span><span class="nt">td</span><span class="p">></span>Data3<span class="p"></</span><span class="nt">td</span><span class="p">></span>
</span><span id="L-11"><a name="L-11"></a> <span class="p"><</span><span class="nt">td</span><span class="p">></span>Data4<span class="p"></</span><span class="nt">td</span><span class="p">></span>
</span><span id="L-12"><a name="L-12"></a> <span class="p"></</span><span class="nt">tr</span><span class="p">></span>
</span><span id="L-13"><a name="L-13"></a><span class="p"></</span><span class="nt">table</span><span class="p">></span>
</span></pre></div>
</td></tr></table>
"row border", "table border"
| <?
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
2016-12-31T13:09:41
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"><?</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">"http://www.fedex.com/Tracking?tracknumbers="</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">"http://wwwapps.ups.com/etracking/tracking.cgi?tracknum="</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">'/1z/i'</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">?></span><span class="x"></span>
</span></pre></div>
</td></tr></table>
"package tracking", "tracking number", fedex, ups
| // Found a function to strip non-numeric chars on the web, I combined this with some jQuery magic.
// stripNonNumeric function found here:
// http://javascript.internet.com/forms/number-formatting.html
function stripNonNumeric( str ){
str += '';
var rgx = /^\d|\.|-$/;
var out = '';
for( var i = 0; i < str.length; i++ ){
if( rgx.test( str.charAt(i) ) ){
if( !( ( str.charAt(i) == '.' && out.indexOf( '.' ) != -1 ) ||
( str.charAt(i) == '-' && out.length != 0 ) ) ){
out += str.charAt(i);
}
}
}
return out;
}
// a little jQuery Magic
$(function() {
$("#formID").submit(function(){
$(".className").each(
function() {
$(this).val(stripNonNumeric( $(this).val() ));
});
});
})
|
Expand
Collapse
(31 lines)
https://snippets.siftie.com/embed/e28120edc59444a38b67e209ed76133b/
/raw/e28120edc59444a38b67e209ed76133b/
e28120edc59444a38b67e209ed76133b
js
JavaScript
31
2016-12-29T15:58:38
True
False
False
/api/public/snipt/14514/
strip-non-numeric-characters-on-submit
<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>
<a href="#L-10">10</a>
<a href="#L-11">11</a>
<a href="#L-12">12</a>
<a href="#L-13">13</a>
<a href="#L-14">14</a>
<a href="#L-15">15</a>
<a href="#L-16">16</a>
<a href="#L-17">17</a>
<a href="#L-18">18</a>
<a href="#L-19">19</a>
<a href="#L-20">20</a>
<a href="#L-21">21</a>
<a href="#L-22">22</a>
<a href="#L-23">23</a>
<a href="#L-24">24</a>
<a href="#L-25">25</a>
<a href="#L-26">26</a>
<a href="#L-27">27</a>
<a href="#L-28">28</a>
<a href="#L-29">29</a>
<a href="#L-30">30</a>
<a href="#L-31">31</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="c1">// Found a function to strip non-numeric chars on the web, I combined this with some jQuery magic.</span>
</span><span id="L-2"><a name="L-2"></a>
</span><span id="L-3"><a name="L-3"></a><span class="c1">// stripNonNumeric function found here:</span>
</span><span id="L-4"><a name="L-4"></a><span class="c1">// http://javascript.internet.com/forms/number-formatting.html</span>
</span><span id="L-5"><a name="L-5"></a>
</span><span id="L-6"><a name="L-6"></a><span class="kd">function</span> <span class="nx">stripNonNumeric</span><span class="p">(</span> <span class="nx">str</span> <span class="p">){</span>
</span><span id="L-7"><a name="L-7"></a> <span class="nx">str</span> <span class="o">+=</span> <span class="s1">''</span><span class="p">;</span>
</span><span id="L-8"><a name="L-8"></a> <span class="kd">var</span> <span class="nx">rgx</span> <span class="o">=</span> <span class="sr">/^\d|\.|-$/</span><span class="p">;</span>
</span><span id="L-9"><a name="L-9"></a> <span class="kd">var</span> <span class="nx">out</span> <span class="o">=</span> <span class="s1">''</span><span class="p">;</span>
</span><span id="L-10"><a name="L-10"></a> <span class="k">for</span><span class="p">(</span> <span class="kd">var</span> <span class="nx">i</span> <span class="o">=</span> <span class="mi">0</span><span class="p">;</span> <span class="nx">i</span> <span class="o"><</span> <span class="nx">str</span><span class="p">.</span><span class="nx">length</span><span class="p">;</span> <span class="nx">i</span><span class="o">++</span> <span class="p">){</span>
</span><span id="L-11"><a name="L-11"></a> <span class="k">if</span><span class="p">(</span> <span class="nx">rgx</span><span class="p">.</span><span class="nx">test</span><span class="p">(</span> <span class="nx">str</span><span class="p">.</span><span class="nx">charAt</span><span class="p">(</span><span class="nx">i</span><span class="p">)</span> <span class="p">)</span> <span class="p">){</span>
</span><span id="L-12"><a name="L-12"></a> <span class="k">if</span><span class="p">(</span> <span class="o">!</span><span class="p">(</span> <span class="p">(</span> <span class="nx">str</span><span class="p">.</span><span class="nx">charAt</span><span class="p">(</span><span class="nx">i</span><span class="p">)</span> <span class="o">==</span> <span class="s1">'.'</span> <span class="o">&&</span> <span class="nx">out</span><span class="p">.</span><span class="nx">indexOf</span><span class="p">(</span> <span class="s1">'.'</span> <span class="p">)</span> <span class="o">!=</span> <span class="o">-</span><span class="mi">1</span> <span class="p">)</span> <span class="o">||</span>
</span><span id="L-13"><a name="L-13"></a> <span class="p">(</span> <span class="nx">str</span><span class="p">.</span><span class="nx">charAt</span><span class="p">(</span><span class="nx">i</span><span class="p">)</span> <span class="o">==</span> <span class="s1">'-'</span> <span class="o">&&</span> <span class="nx">out</span><span class="p">.</span><span class="nx">length</span> <span class="o">!=</span> <span class="mi">0</span> <span class="p">)</span> <span class="p">)</span> <span class="p">){</span>
</span><span id="L-14"><a name="L-14"></a> <span class="nx">out</span> <span class="o">+=</span> <span class="nx">str</span><span class="p">.</span><span class="nx">charAt</span><span class="p">(</span><span class="nx">i</span><span class="p">);</span>
</span><span id="L-15"><a name="L-15"></a> <span class="p">}</span>
</span><span id="L-16"><a name="L-16"></a> <span class="p">}</span>
</span><span id="L-17"><a name="L-17"></a> <span class="p">}</span>
</span><span id="L-18"><a name="L-18"></a> <span class="k">return</span> <span class="nx">out</span><span class="p">;</span>
</span><span id="L-19"><a name="L-19"></a><span class="p">}</span>
</span><span id="L-20"><a name="L-20"></a>
</span><span id="L-21"><a name="L-21"></a>
</span><span id="L-22"><a name="L-22"></a><span class="c1">// a little jQuery Magic</span>
</span><span id="L-23"><a name="L-23"></a>
</span><span id="L-24"><a name="L-24"></a><span class="nx">$</span><span class="p">(</span><span class="kd">function</span><span class="p">()</span> <span class="p">{</span>
</span><span id="L-25"><a name="L-25"></a> <span class="nx">$</span><span class="p">(</span><span class="s2">"#formID"</span><span class="p">).</span><span class="nx">submit</span><span class="p">(</span><span class="kd">function</span><span class="p">(){</span>
</span><span id="L-26"><a name="L-26"></a> <span class="nx">$</span><span class="p">(</span><span class="s2">".className"</span><span class="p">).</span><span class="nx">each</span><span class="p">(</span>
</span><span id="L-27"><a name="L-27"></a> <span class="kd">function</span><span class="p">()</span> <span class="p">{</span>
</span><span id="L-28"><a name="L-28"></a> <span class="nx">$</span><span class="p">(</span><span class="k">this</span><span class="p">).</span><span class="nx">val</span><span class="p">(</span><span class="nx">stripNonNumeric</span><span class="p">(</span> <span class="nx">$</span><span class="p">(</span><span class="k">this</span><span class="p">).</span><span class="nx">val</span><span class="p">()</span> <span class="p">));</span>
</span><span id="L-29"><a name="L-29"></a> <span class="p">});</span>
</span><span id="L-30"><a name="L-30"></a> <span class="p">});</span>
</span><span id="L-31"><a name="L-31"></a><span class="p">})</span>
</span></pre></div>
</td></tr></table>
jquery, numbers
| # Add this to /etc/sources.list
deb http://software.virtualmin.com/gpl/ubuntu virtualmin-hardy main
#run the following commands as root (sudo)
wget --quiet http://software.virtualmin.com/lib/RPM-GPG-KEY-virtualmin -O - | sudo apt-key add -
wget --quiet http://software.virtualmin.com/lib/RPM-GPG-KEY-webmin -O - | sudo apt-key add -
apt-get update
apt-get install webmin
|
Expand
Collapse
(10 lines)
https://snippets.siftie.com/embed/33a081840f393c0484ac13b712d7a339/
/raw/33a081840f393c0484ac13b712d7a339/
33a081840f393c0484ac13b712d7a339
text
Text only
10
2016-12-30T16:44:02
True
False
False
/api/public/snipt/14232/
installing-webmin-from-virtualman-repository-on-ubuntu-804lts
<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>
<a href="#L-10">10</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a># Add this to /etc/sources.list
</span><span id="L-2"><a name="L-2"></a>deb http://software.virtualmin.com/gpl/ubuntu virtualmin-hardy main
</span><span id="L-3"><a name="L-3"></a>
</span><span id="L-4"><a name="L-4"></a>#run the following commands as root (sudo)
</span><span id="L-5"><a name="L-5"></a>wget --quiet http://software.virtualmin.com/lib/RPM-GPG-KEY-virtualmin -O - | sudo apt-key add -
</span><span id="L-6"><a name="L-6"></a>
</span><span id="L-7"><a name="L-7"></a>wget --quiet http://software.virtualmin.com/lib/RPM-GPG-KEY-webmin -O - | sudo apt-key add -
</span><span id="L-8"><a name="L-8"></a>
</span><span id="L-9"><a name="L-9"></a>apt-get update
</span><span id="L-10"><a name="L-10"></a>apt-get install webmin
</span></pre></div>
</td></tr></table>
"webmin ubuntu", ubuntu, webmin
| <?
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-02-16T21:10:25
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"><?</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">'/\D/'</span><span class="p">,</span><span class="s1">'/'</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">'Y-m-d'</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">'11/05/1996'</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">?></span><span class="x"></span>
</span></pre></div>
</td></tr></table>
convert, date, iso
| body {font: 62.5% Arial, Helvetica, sans-serif;}
|
https://snippets.siftie.com/embed/f453712d29c53b87d381f4168695f4da/
/raw/f453712d29c53b87d381f4168695f4da/
f453712d29c53b87d381f4168695f4da
css
CSS
1
2019-02-04T11:12:51
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
| // 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
2016-12-31T09:48:48
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">'text1'</span> <span class="k">desc</span><span class="p">,</span> <span class="n">col</span><span class="o">=</span><span class="s1">'text2'</span> <span class="k">desc</span><span class="p">,</span> <span class="n">col</span><span class="o">=</span><span class="s1">'text3'</span> <span class="k">desc</span>
</span></pre></div>
</td></tr></table>
"order by", mysql, sorting, sql
| // jQuery
$(function(){
$("tr.stripe:even").css("background-color", "#D0D0D0");
$("tr.stripe:odd").css("background-color", "#E5E5E5");
});
// HTML
<table>
<tr class="stripe">
<td>Col 1</td>
<td>Col 2</td>
<td>Col 3</td>
</tr>
<tr class="stripe">
<td>Col 1</td>
<td>Col 2</td>
<td>Col 3</td>
</tr>
<tr class="stripe">
<td>Col 1</td>
<td>Col 2</td>
<td>Col 3</td>
</tr>
</table>
|
Expand
Collapse
(25 lines)
https://snippets.siftie.com/embed/9cfc4b84648192f429c6b57e355b9be7/
/raw/9cfc4b84648192f429c6b57e355b9be7/
9cfc4b84648192f429c6b57e355b9be7
js
JavaScript
25
2019-02-04T10:44:23
True
False
False
/api/public/snipt/14228/
alternate-row-colors-zebra-striping-with-jquery
<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>
<a href="#L-10">10</a>
<a href="#L-11">11</a>
<a href="#L-12">12</a>
<a href="#L-13">13</a>
<a href="#L-14">14</a>
<a href="#L-15">15</a>
<a href="#L-16">16</a>
<a href="#L-17">17</a>
<a href="#L-18">18</a>
<a href="#L-19">19</a>
<a href="#L-20">20</a>
<a href="#L-21">21</a>
<a href="#L-22">22</a>
<a href="#L-23">23</a>
<a href="#L-24">24</a>
<a href="#L-25">25</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="c1">// jQuery</span>
</span><span id="L-2"><a name="L-2"></a><span class="nx">$</span><span class="p">(</span><span class="kd">function</span><span class="p">(){</span>
</span><span id="L-3"><a name="L-3"></a> <span class="nx">$</span><span class="p">(</span><span class="s2">"tr.stripe:even"</span><span class="p">).</span><span class="nx">css</span><span class="p">(</span><span class="s2">"background-color"</span><span class="p">,</span> <span class="s2">"#D0D0D0"</span><span class="p">);</span>
</span><span id="L-4"><a name="L-4"></a> <span class="nx">$</span><span class="p">(</span><span class="s2">"tr.stripe:odd"</span><span class="p">).</span><span class="nx">css</span><span class="p">(</span><span class="s2">"background-color"</span><span class="p">,</span> <span class="s2">"#E5E5E5"</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><span id="L-8"><a name="L-8"></a><span class="c1">// HTML</span>
</span><span id="L-9"><a name="L-9"></a><span class="o"><</span><span class="nx">table</span><span class="o">></span>
</span><span id="L-10"><a name="L-10"></a> <span class="o"><</span><span class="nx">tr</span> <span class="kr">class</span><span class="o">=</span><span class="s2">"stripe"</span><span class="o">></span>
</span><span id="L-11"><a name="L-11"></a> <span class="o"><</span><span class="nx">td</span><span class="o">></span><span class="nx">Col</span> <span class="mi">1</span><span class="o"><</span><span class="err">/td></span>
</span><span id="L-12"><a name="L-12"></a> <span class="o"><</span><span class="nx">td</span><span class="o">></span><span class="nx">Col</span> <span class="mi">2</span><span class="o"><</span><span class="err">/td></span>
</span><span id="L-13"><a name="L-13"></a> <span class="o"><</span><span class="nx">td</span><span class="o">></span><span class="nx">Col</span> <span class="mi">3</span><span class="o"><</span><span class="err">/td></span>
</span><span id="L-14"><a name="L-14"></a> <span class="o"><</span><span class="err">/tr></span>
</span><span id="L-15"><a name="L-15"></a> <span class="o"><</span><span class="nx">tr</span> <span class="kr">class</span><span class="o">=</span><span class="s2">"stripe"</span><span class="o">></span>
</span><span id="L-16"><a name="L-16"></a> <span class="o"><</span><span class="nx">td</span><span class="o">></span><span class="nx">Col</span> <span class="mi">1</span><span class="o"><</span><span class="err">/td></span>
</span><span id="L-17"><a name="L-17"></a> <span class="o"><</span><span class="nx">td</span><span class="o">></span><span class="nx">Col</span> <span class="mi">2</span><span class="o"><</span><span class="err">/td></span>
</span><span id="L-18"><a name="L-18"></a> <span class="o"><</span><span class="nx">td</span><span class="o">></span><span class="nx">Col</span> <span class="mi">3</span><span class="o"><</span><span class="err">/td></span>
</span><span id="L-19"><a name="L-19"></a> <span class="o"><</span><span class="err">/tr></span>
</span><span id="L-20"><a name="L-20"></a> <span class="o"><</span><span class="nx">tr</span> <span class="kr">class</span><span class="o">=</span><span class="s2">"stripe"</span><span class="o">></span>
</span><span id="L-21"><a name="L-21"></a> <span class="o"><</span><span class="nx">td</span><span class="o">></span><span class="nx">Col</span> <span class="mi">1</span><span class="o"><</span><span class="err">/td></span>
</span><span id="L-22"><a name="L-22"></a> <span class="o"><</span><span class="nx">td</span><span class="o">></span><span class="nx">Col</span> <span class="mi">2</span><span class="o"><</span><span class="err">/td></span>
</span><span id="L-23"><a name="L-23"></a> <span class="o"><</span><span class="nx">td</span><span class="o">></span><span class="nx">Col</span> <span class="mi">3</span><span class="o"><</span><span class="err">/td></span>
</span><span id="L-24"><a name="L-24"></a> <span class="o"><</span><span class="err">/tr></span>
</span><span id="L-25"><a name="L-25"></a><span class="o"><</span><span class="err">/table></span>
</span></pre></div>
</td></tr></table>
alternate, background, color, jquery, row, striping, zebra