PHP

Determine if it is the last day of the month with PHP

// 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)

Embed
Copy

4 tags

402 views
1 fav

PHP

Escape data for SQL Server: mssql_real_escape_string

<?
function mssql_real_escape_string($s) {
	if(get_magic_quotes_gpc()) {
		$s = stripslashes($s);
	}
	$s = str_replace("'","''",$s);
	return $s;
}
?>

Expand Collapse (9 lines)

Embed
Copy

4 tags

4,437 views
0 favs

HTML

Add a border to <TR>

<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)

Embed
Copy

2 tags

227 views
0 favs

PHP

Generate UPS or FedEX tracking link

<?
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;
}
?>

JavaScript

Strip non-numeric characters from field on form submit

// 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)

Embed
Copy

2 tags

469 views
0 favs

<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><a name="L-1"></a>// Found a function to strip non-numeric chars on the web, I combined this with some jQuery magic. <a name="L-2"></a> <a name="L-3"></a>// stripNonNumeric function found here: <a name="L-4"></a>// http://javascript.internet.com/forms/number-formatting.html <a name="L-5"></a> <a name="L-6"></a>function stripNonNumeric( str ){ <a name="L-7"></a> str += ''; <a name="L-8"></a> var rgx = /^\d|\.|-$/; <a name="L-9"></a> var out = ''; <a name="L-10"></a> for( var i = 0; i < str.length; i++ ){ <a name="L-11"></a> if( rgx.test( str.charAt(i) ) ){ <a name="L-12"></a> if( !( ( str.charAt(i) == '.' && out.indexOf( '.' ) != -1 ) || <a name="L-13"></a> ( str.charAt(i) == '-' && out.length != 0 ) ) ){ <a name="L-14"></a> out += str.charAt(i); <a name="L-15"></a> } <a name="L-16"></a> } <a name="L-17"></a> } <a name="L-18"></a> return out; <a name="L-19"></a>} <a name="L-20"></a> <a name="L-21"></a> <a name="L-22"></a>// a little jQuery Magic <a name="L-23"></a> <a name="L-24"></a>$(function() { <a name="L-25"></a> $("#formID").submit(function(){ <a name="L-26"></a> $(".className").each( <a name="L-27"></a> function() { <a name="L-28"></a> $(this).val(stripNonNumeric( $(this).val() )); <a name="L-29"></a> }); <a name="L-30"></a> }); <a name="L-31"></a>}) </pre></div> </td></tr></table>

Text only

Installing Webmin from Virtualman Repository on Ubuntu 8.04LTS

# 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)

Embed
Copy

3 tags

1,152 views
0 favs

PHP

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

<?
function convertDate($date) {
	$date = preg_replace('/\D/','/',$date);
	return date('Y-m-d',strtotime($date));
}

print convertDate('11/05/1996'); //prints 1996-11-05
?>

Embed
Copy

3 tags

8,130 views
0 favs

CSS

CSS Text Reset

1	body {font: 62.5% Arial, Helvetica, sans-serif;}

Embed
Copy

4 tags

273 views
0 favs

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

Embed
Copy

4 tags

227 views
1 fav

JavaScript

Alternate row colors / zebra striping w/ jQuery

// 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)

<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><a name="L-1"></a>// jQuery <a name="L-2"></a>$(function(){ <a name="L-3"></a> $("tr.stripe:even").css("background-color", "#D0D0D0"); <a name="L-4"></a> $("tr.stripe:odd").css("background-color", "#E5E5E5"); <a name="L-5"></a>}); <a name="L-6"></a> <a name="L-7"></a> <a name="L-8"></a>// HTML <a name="L-9"></a><table> <a name="L-10"></a> <tr class="stripe"> <a name="L-11"></a> <td>Col 1</td> <a name="L-12"></a> <td>Col 2</td> <a name="L-13"></a> <td>Col 3</td> <a name="L-14"></a> </tr> <a name="L-15"></a> <tr class="stripe"> <a name="L-16"></a> <td>Col 1</td> <a name="L-17"></a> <td>Col 2</td> <a name="L-18"></a> <td>Col 3</td> <a name="L-19"></a> </tr> <a name="L-20"></a> <tr class="stripe"> <a name="L-21"></a> <td>Col 1</td> <a name="L-22"></a> <td>Col 2</td> <a name="L-23"></a> <td>Col 3</td> <a name="L-24"></a> </tr> <a name="L-25"></a></table> </pre></div> </td></tr></table>

Key	Function
<ctrl-h>	Show / hide keyboard shortcuts
/	Focus search field
esc	Unfocus search field / deselect snipt
j	Next snipt
k	Previous snipt
o / return	Go to snipt
u	Go to snipt's author
e	Expand / collapse snipt
v	Embed snipt
c	Copy snipt
<ctrl-e>	Edit snipt
<ctrl-delete> or <ctrl-backspace>	Delete snipt
<ctrl-n> or <alt+n>	Add new snipt
<ctrl-s>	Save snipt
<ctrl-c>	Save snipt and close
n	Next page
p	Previous page

Copy “Determine if it is the last day of the month with PHP”

(Text is selected. +C to copy.)

Embed “Determine if it is the last day of the month with PHP”

(Text is selected. +C to copy.)

Copy “Escape data for SQL Server: mssql_real_escape_string”

(Text is selected. +C to copy.)

Embed “Escape data for SQL Server: mssql_real_escape_string”

(Text is selected. +C to copy.)

Copy “Add a border to <TR>”

(Text is selected. +C to copy.)

Embed “Add a border to <TR>”

(Text is selected. +C to copy.)

Copy “Generate UPS or FedEX tracking link”

(Text is selected. +C to copy.)

Embed “Generate UPS or FedEX tracking link”

(Text is selected. +C to copy.)

Copy “Strip non-numeric characters from field on form submit”

(Text is selected. +C to copy.)

Embed “Strip non-numeric characters from field on form submit”

(Text is selected. +C to copy.)

Copy “Installing Webmin from Virtualman Repository on Ubuntu 8.04LTS”

(Text is selected. +C to copy.)

Embed “Installing Webmin from Virtualman Repository on Ubuntu 8.04LTS”

(Text is selected. +C to copy.)

Copy “Convert MM/DD/YYYY date to YYYY-MM-DD with PHP”

(Text is selected. +C to copy.)

Embed “Convert MM/DD/YYYY date to YYYY-MM-DD with PHP”

(Text is selected. +C to copy.)

Copy “CSS Text Reset”

(Text is selected. +C to copy.)

Embed “CSS Text Reset”

(Text is selected. +C to copy.)

Copy “Specify 'ORDER BY' order”

(Text is selected. +C to copy.)

Embed “Specify 'ORDER BY' order”

(Text is selected. +C to copy.)

Copy “Alternate row colors / zebra striping w/ jQuery”

(Text is selected. +C to copy.)

Embed “Alternate row colors / zebra striping w/ jQuery”

(Text is selected. +C to copy.)

Keyboard shortcuts