PHP

Script language for dynamic web-pages. The syntax and concepts used are similar to Perl

$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname, $dbport) or die ('Error connecting to mysql');

Open database connection

$result = mysqli_query($conn,$query) or die('Error, retrieve failed');

Execute a query on the opened connection

$row = mysqli_fetch_array($result, MYSQLI_ASSOC);

Fetch a row as hash

$row = mysqli_fetch_array($result, MYSQLI_NUM);

Fetch a row as array

Install

On debian (and its derivates)

apt-get install php-fpm php-mysql

Install php7 and mysql support

Fix php security by editing /etc/php/7.0/fpm/php.ini

Uncomment line with cgi.fix_pathinfo and set it to 0