Maykonn

<code_scheme name="Maykonn-Symfony-4-Code-Style" version="173">
  <PHPCodeStyleSettings>
    <option name="CONCAT_SPACES" value="false" />
  </PHPCodeStyleSettings>
  <codeStyleSettings language="PHP">
    <option name="SPACE_AFTER_TYPE_CAST" value="true" />
  </codeStyleSettings>
</code_scheme>

Maykonn

<?php
/**
 * Twitter Integration: Backend endpoint to request token
 *
 * @author Maykonn Welington Candido<maykonn@outlook.com>
 * @see https://developer.twitter.com/en/docs/basics/authentication/api-reference/request_token
 *
 * @uses This file must be requested by a application passing the callback_url on querystring. Response Content-Type is application/json.
 * @example https://mydomain.com/twitter/request_token.php?callback_url=https://mydomain.com/path-to-redirect-after-request-token
 */

Maykonn

<code_scheme name="maykonn-php-code-style" version="173">
  <PHPCodeStyleSettings>
    <option name="CONCAT_SPACES" value="false" />
  </PHPCodeStyleSettings>
  <codeStyleSettings language="PHP">
    <option name="SPACE_AFTER_TYPE_CAST" value="true" />
  </codeStyleSettings>
</code_scheme>

Maykonn

# EditorConfig for web development
#
# EditorConfig
# https://editorconfig.org
#
# Author: Maykonn Welington Candido

root = true

[*]

Maykonn

# @author Maykonn Welington Candido <maykonn@outlook.com>

# For docker-compose for instance you may do it in order to install the latest version on UNIX:
REPO_PATH=docker/compose
ARTIFACT_NAME=docker-compose-$(uname -s)-$(uname -m)
DOCKER_COMPOSE_VERSION=$(curl --silent "https://api.github.com/repos/$REPO_PATH/releases/latest" | grep -Po '"tag_name": "\K.*?(?=")')
sudo curl -L "https://github.com/$REPO_PATH/releases/download/$DOCKER_COMPOSE_VERSION/$ARTIFACT_NAME" -o /usr/local/bin/docker-compose

# Change the REPO_PATH value by the desired repository path
# Change the ARTIFACT_NAME value by the name of the downloadable artifact, you can see the name on the repository release page

Maykonn

<?php
// Early fatal errors handler, it will be replaced by a full featured one in Controller class
// (given it does not have any parse or fatal errors of its own)
function earlyFatalErrorHandler($unregister = false)
{
	// Functionality for "unregistering" shutdown function
	static $unregistered;
	if ($unregister) $unregistered = true;
	if ($unregistered) return;

Maykonn

/**
 * Retrieves a customer group hierarchy.
 * Change the @root_id value to change the hierarchy root.
 */
SET @root_id = 1;

SELECT  *
FROM (
  SELECT * FROM tbl
    ORDER BY parent_id, id) hiearchy_sorted,

Maykonn

#!/bin/bash

local_mysql_service=mysql
if (( $(ps -ef | grep -v grep | grep ${local_mysql_service} | wc -l) > 0 ))
then
    service ${local_mysql_service} stop
fi
echo "Conflicting local services stopped ($local_mysql_service), continue..."

local_apache_service=apache2

Maykonn

Will return 0 or false:

SELECT "5,18,5,7,9,2" REGEXP "[[:<:]](8)[[:>:]]"

Will return 1 or true:

SELECT "5,18,5,7,9,2" REGEXP "[[:<:]](5)[[:>:]]"

For Redshift you must use ~ instead REGEXP on above statements:

Maykonn

# Install mysql server 5.6 on Ubuntu
apt-get install mysql-server-5.6

# Login into MySQL Server
mysql -uroot -p

# restart mysql server
sudo service mysql start|restart|stop|status

# http://sharadchhetri.com/2014/05/07/install-mysql-server-5-6-ubuntu-14-04-lts-trusty-tahr/