Guillaume Voisin guillaumevoisin

guillaumevoisin / couverts-remaining

Last active January 2, 2018 13:23

guillaumevoisin / php-cs-fixer-git-files

Created June 18, 2015 10:05

PHP-CS-Fixer on modified files

git diff --name-only --cached --diff-filter=ACMRTUXB | while read filename; do php-cs-fixer --level=symfony fix $filename; done;

guillaumevoisin / st3_settings

Last active August 29, 2015 14:11

Sublime Text Configuration

	Sur Ubuntu:

	Keyboard

	[
	{ "keys": ["ctrl+keypad_divide"], "command": "toggle_comment", "args": { "block": false } },
	{ "keys": ["ctrl+shift+keypad_divide"], "command": "toggle_comment", "args": { "block": true } },
	]

	Settings

guillaumevoisin / search_field_in_database

Created October 16, 2014 09:21

To get all tables with columns 'columnA' or 'ColumnB' in the database 'YourDatabase'

	SELECT DISTINCT TABLE_NAME
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE COLUMN_NAME IN ('columnA','ColumnB')
	AND TABLE_SCHEMA='YourDatabase';

guillaumevoisin / truncate_all_tables

Created October 16, 2014 09:19

Truncate all tables of a database

mysql -Nse 'show tables' DATABASE_NAME | while read table; do mysql -e "truncate table $table" DATABASE_NAME; done

guillaumevoisin / WordPress: get post attachments

Created August 27, 2012 08:42

WordPress: Get post attachments

	// place inside loop
	$args = array(
	'post_type' => 'attachment',
	'numberposts' => null,
	'post_status' => null,
	'post_parent' => $post->ID
	);
	$attachments = get_posts($args);
	if ($attachments) {
	foreach ($attachments as $attachment) {

guillaumevoisin / gist:2888792

Created June 7, 2012 13:22

PHP: List files within a directory

	if ($handle = opendir('/path/to/files')) {
	echo "Directory handle: $handle\n";
	echo "Entries:\n";

	/* This is the correct way to loop over the directory. */
	while (false !== ($entry = readdir($handle))) {
	echo "$entry\n";
	}

	closedir($handle);

guillaumevoisin / gist:2777217

Created May 23, 2012 19:22 — forked from ebonical/gist:464566

CSS: Clearfix

guillaumevoisin / gist:2774824

Created May 23, 2012 11:53

CSS: Image Replacement

	.ir {
	border:0;
	font: 0/0 a;
	text-shadow: none;
	color: transparent;
	background-color: transparent;
	}

guillaumevoisin / gist:2774786

Created May 23, 2012 11:49

HTML: Starting Template

	<!doctype html>
	<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

	<title></title>
	<meta name="description" content="">
	<meta name="author" content="">

	<meta name="viewport" content="width=device-width,initial-scale=1">