Guillaume Voisin guillaumevoisin

## couverts-remaining
219869,4442
221049,4406
221919,2961
222501,4231
222647,3497
223785,1473
223983,2935
229281,4237
234299,2724
237097,3404

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

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

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

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

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

## gist:2888792
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);

## gist:2777217
.clear:after {
	content: ".";
	display: block;
	height: 0;
	clear: both;
	visibility: hidden;
}

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

## gist:2774786
<!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">
	219869,4442
	221049,4406
	221919,2961
	222501,4231
	222647,3497
	223785,1473
	223983,2935
	229281,4237
	234299,2724
	237097,3404
	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
	SELECT DISTINCT TABLE_NAME
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE COLUMN_NAME IN ('columnA','ColumnB')
	AND TABLE_SCHEMA='YourDatabase';
	// 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) {
	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);
	.clear:after {
	content: ".";
	display: block;
	height: 0;
	clear: both;
	visibility: hidden;
	}
	.ir {
	border:0;
	font: 0/0 a;
	text-shadow: none;
	color: transparent;
	background-color: transparent;
	}
	<!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">