Michał Durys mdurys

## is_base64.php
private static function isBase64Encoded(string $text): bool
{
    if (false === $decoded = base64_decode($text, true)) {
        return false;
    }
    // check if decoded text consists only of unicode letters, digits and white space
    if (!preg_match('|^[\p{L}\d\s]+$|u', $decoded)) {
        return false;
    }

## gist:e52c1a87310a065c98d7a9b9776002b7
docker run --rm --interactive --tty --volume $PWD:/app --user $(id -u):$(id -g) composer create-project symfony/skeleton my-api
cd my-api
docker run --rm --interactive --tty --volume $PWD:/app --user $(id -u):$(id -g) composer require --dev phpunit

## pdoattribute
$em
    ->getConnection()
    ->getWrappedConnection()
    ->setAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);

## circular right shift
$shifted = ($value >> $n) | ($value << (30 - $n) & 0x3fffffff);

## gist:ac64f9b0cc9441efeb1f
sort --random-sort customer.csv | split --lines 29175

## gist:994fd6744f5969e08209
SELECT COUNT(*)
FROM customer
WHERE is_active = 1
AND (
	register_phone LIKE '50%'
	OR register_phone LIKE '51%'
	OR register_phone LIKE '53%'
	OR register_phone LIKE '57%'
	OR register_phone LIKE '60%'
	OR register_phone LIKE '66%'

## gist:073044b9285cbc3d1c88
SELECT
	DATE_FORMAT(FROM_UNIXTIME(p.updated_at), '%Y-%m-%d') AS updated_at
FROM product p

## gist:0b0c67a26525ad127fad
iconv -f utf8 -t cp1250 file.txt | sed 's/$'"/`echo \\\r`/" >file_cp1250_crlf.txt
	private static function isBase64Encoded(string $text): bool
	{
	if (false === $decoded = base64_decode($text, true)) {
	return false;
	}
	// check if decoded text consists only of unicode letters, digits and white space
	if (!preg_match('\|^[\p{L}\d\s]+$\|u', $decoded)) {
	return false;
	}
	docker run --rm --interactive --tty --volume $PWD:/app --user $(id -u):$(id -g) composer create-project symfony/skeleton my-api
	cd my-api
	docker run --rm --interactive --tty --volume $PWD:/app --user $(id -u):$(id -g) composer require --dev phpunit
	$em
	->getConnection()
	->getWrappedConnection()
	->setAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
	SELECT COUNT(*)
	FROM customer
	WHERE is_active = 1
	AND (
	register_phone LIKE '50%'
	OR register_phone LIKE '51%'
	OR register_phone LIKE '53%'
	OR register_phone LIKE '57%'
	OR register_phone LIKE '60%'
	OR register_phone LIKE '66%'
	SELECT
	DATE_FORMAT(FROM_UNIXTIME(p.updated_at), '%Y-%m-%d') AS updated_at
	FROM product p