remibreton’s gists

remibreton / HTML: IE conditional tags

Last active December 16, 2015 07:19

HTML IE conditional tags

	<!--[if lt IE 7]> <html class="no-js ie6 ie" lang="en"> <![endif]-->
	<!--[if IE 7]> <html class="no-js ie7 ie" lang="en"> <![endif]-->
	<!--[if IE 8]> <html class="no-js ie8 ie" lang="en"> <![endif]-->
	<!--[if IE 9]> <html class="no-js ie9 ie" lang="en"> <![endif]-->
	<!--[if gt IE 9]> <!--> <html class="no-js modern" lang="en"> <!--<![endif]-->

remibreton / HTML: Head tags

Last active December 16, 2015 07:19

Social media friendly head tags

	<!-- Prefetching -->
	<link rel="dns-prefetch" href="//fonts.googleapis.com">
	<link rel="dns-prefetch" href="//ajax.googleapis.com">
	<link rel="dns-prefetch" href="//googlecode.com">

	<!-- Stylesheets -->
	<link rel="stylesheet" href="http://site.com/style.css">

	<!-- Meta -->
	<title>Page title - Site name</title>

remibreton / MySQL: Search and replace

Last active December 16, 2015 23:29

UPDATE table SET field = REPLACE(field, 'string', 'anothervalue') WHERE field LIKE '%string%';

remibreton / JavaScript: Email validation

Last active December 17, 2015 02:29

/^(([^<>()[\]\\.,;:\s@\"]+(\.[^<>()[\]\\.,;:\s@\"]+)*)|(\".+\"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$/.test('[email protected]');

remibreton / MySQL: Update with left join

Last active December 17, 2015 02:59

UPDATE t1 LEFT JOIN t2 ON t2.id = t1.id SET t1.col1 = newvalue WHERE t2.id IS NULL

remibreton / JavaScript: Phone number validation

Last active December 17, 2015 03:29

/(1)?( |-)?($)?(\d{3})($)?( |-)?(\d{3})( |-)?(\d{4})/.test('123 456 7890');

remibreton / MySQL: Find duplicates

Created May 15, 2013 13:09

SELECT field, count(*) FROM table GROUP BY field HAVING count(*) > 1

remibreton / JavaScript: Input date type support

Last active December 17, 2015 09:59

	function inputDateSupport(){
	var i = document.createElement("input");
	i.setAttribute("type", "date");
	return i.type == "date";
	}

remibreton / JavaScript: Array shuffle

Last active December 17, 2015 18:29

	function shuffle(o){
	for(var j, x, i = o.length; i; j = parseInt(Math.random() * i), x = o[--i], o[i] = o[j], o[j] = x);
	return o;
	};

remibreton / JavaScript: Mobile detection

Created May 29, 2013 20:16

(function(a){return (/(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows (ce|phone)|xda|xiino/i.test(a)||/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|l

Rémi Breton remibreton