PHP Extensions needed for Magento 2.0

These are the PHP extensions that are required to install Magento 2.0

  • PHP Extension curl.
  • PHP Extension dom.
  • PHP Extension mcrypt.
  • PHP Extension simplexml.
  • PHP Extension spl.
  • PHP Extension xsl.
  • PHP Extension intl.
  • PHP Extension mbstring.
  • PHP Extension ctype.
  • PHP Extension hash.
  • PHP Extension openssl.
  • PHP Extension zip.
  • PHP Extension xmlwriter.
  • PHP Extension gd.
  • PHP Extension iconv.

How to install in Ubuntu 16.04

apt-get install php-curl php-dom php-mcrypt php-simplexml php-spl php-xsl php-intl php-mbstring php-ctype php-hash php-openssl php-zip php-xmlwriter php-gd php-iconv 

random number in MySQL with range

I am creating a prototype that needs to simulate adding IDs from 1-7. Since i’m lazy i updated the new column with a random numnber.

SELECT FLOOR(RAND()*7)+1

MySQL has a rand() function which will give you a floating point, multiply it by the range you need and add 1.

Note: this post serves as a note for future reference