# composer.json file:
# {
#   "name": "drupal/drupal",
#    ..... 
#   "require": {
#           "drupal/core": "^8.6.0",
#    .....
#  }
# Update Drupal core
composer update drupal/core webflo/drupal-core-require-dev --with-dependencies

# `soft` flag and `HEAD^` will drop last commit and keep changes.
git reset --soft HEAD^

# `hard` flag and `HEAD^` will drop last commit but it won't keep changes.
git reset --hard HEAD^

// Import \Drupal\Component\Utility\SortArray class
use Drupal\Component\Utility\SortArray;

// Then applied it manually
uasort($result, function($a, $b) {
  return SortArray::sortByKeyString($a, $b, 'ARRAY_KEY_TO_SORT');
});

// Also It's possible to use without a closure function
uasort($form['elements'], [
  '\Drupal\Component\Utility\SortArray',
  'sortByWeightProperty'
]);

/** @var Drupal\Core\Utility\LinkGenerator $linkGenerator */
$linkGenerator = \Drupal::service('link_generator');

/** @var Drupal\Core\Url $installerUrl */
$installerUrl = Drupal\Core\Url::fromUri('base://core/install.php');

/** @var Drupal\Core\Url $installerLink */
$installerLink = $linkGenerator->generate('Install', $installerUrl);

// Print variable or invoke `__toString` magic method directly:  { "<a href="/core/install.php">Install</a>" }
var_dump($installerLink->__toString());

/** @var Drupal\Core\Url $externalUrl */
$externalUrl = D

/** @var array $field_items */
$field_items = field_get_items('node', $node, 'FIELD_MACHINE_NAME');

/** @var array $field_value */
$field_value = (!empty($field_items)) ? reset($field_items) : [];

// On the page node/%node, the router loads the %node object
if($node = menu_get_object()) {
  echo '<pre>' . print_r($node, 1); 
}

// Retrieve vocabulary based on its machine name
$vocabulary = taxonomy_vocabulary_machine_name_load('tags');

// Load whole taxonomies related to given vocabulary
$tree = taxonomy_get_tree($vocabulary->vid);

-- Create fresh database
CREATE DATABASE drupal7_db;

-- Create a new MySQL user with specific password
CREATE USER drupal7_dbuser@localhost IDENTIFIED BY 'a2NUpXBffCYUHP6a';

-- Give full access to new MySQL user to new database just created
GRANT ALL PRIVILEGES ON drupal7_db.* TO 'drupal7_dbuser'@'localhost';

-- Rebuild privileges to make persistent those changes
FLUSH PRIVILEGES;

-- Retrive current sequence value
SELECT last_value FROM <sequence_name>;

-- Update sequence value
SELECT setval('sequence_name',1000);

-- Retrieve site name stored into variable table directly from SQL
SELECT name, CONVERT (value USING utf8) 
FROM `variable` 
WHERE name = 'site_name'