typesafe typesafer

typesafer / le_trigger_default_varchar

Last active August 29, 2015 13:57

Trigger With Default Varchar Value Ref http://dev.mysql.com/doc/refman/5.6/en/stored-program-variables.html

	delimiter $$
	CREATE TRIGGER le_trigger
	AFTER INSERT ON inbox
	FOR EACH ROW
	BEGIN
	declare last_inserted_number varchar(100) DEFAULT '0800100200';
	declare last_inserted_message varchar(100) DEFAULT 'Lorem Ipsum';

	set last_inserted_number = NEW.in_number;
	set last_inserted_message = NEW.in_message;

typesafer / le_trigge.sql

Created March 18, 2014 15:25

An example of a mysql trigger

	delimiter $$
	CREATE TRIGGER le_trigger
	AFTER INSERT ON inbox
	FOR EACH ROW
	BEGIN

	declare last_inserted_number varchar(100);
	declare last_inserted_message varchar(100);

	set last_inserted_number = NEW.in_number;

typesafer / Select Regex 0-9 - Numbers Only

Last active August 29, 2015 13:57

expect only 0-9 in select

select * from test WHERE one REGEXP '^[0-9]+$'

typesafer / select exists

Last active August 29, 2015 13:57

Check if a record exists in mysql

SELECT EXISTS(SELECT * FROM errors WHERE id=7)

typesafer / gist:6398861

Created August 31, 2013 15:18 — forked from da1nonly/gist:2057532

	<?php

	add_action('admin_init', 'add_meta_boxes', 1);
	function add_meta_boxes() {
	add_meta_box( 'repeatable-fields', 'Audio Playlist', 'repeatable_meta_box_display', 'post', 'normal', 'high');
	}

	function repeatable_meta_box_display() {
	global $post;

typesafer / editor_plugin.js

Created August 25, 2013 15:02 — forked from dnaber-de/editor_plugin.js

typesafer / gist:5658289

Created May 27, 2013 17:51

why-are-static-variables-considered-evil

	var javaStaticVar = {
	solink: 'http://stackoverflow.com/questions/7026507/why-are-static-variables-considered-evil',
	two: 'are..',
	theStatics :function(){
	return this.solink;
	}
	}
	alert(javaStaticVar.theStatics());

typesafer / gist:3330734

Created August 12, 2012 08:49 — forked from luetkemj/wp-query-ref.php

WP: Query $args

	<?php
	/**
	* WordPress Query Comprehensive Reference
	* Compiled by luetkemj - luetkemj.com
	*
	* CODEX: http://codex.wordpress.org/Class_Reference/WP_Query
	* Source: http://core.trac.wordpress.org/browser/tags/3.3.1/wp-includes/query.php
	*/

	$args = array(