Help-full scripts to quick copy and paste

LEFT JOIN ON | Using SQL relation to show query

SELECT c.name, o.product
FROM costumers c 
LEFT JOIN orders o
ON c.id = o.costumers_id;

PHP | mySQL | Synology MariaDB 10 test db connect script

<?php
$dbname = 'dbname';
$dbuser = 'root';
$dbpass = 'password';
$dbhost = 'HOST:3307';
$connect = mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to connect to '$dbhost'");
mysql_select_db($dbname) or die("Could not open the database '$dbname'");
$result = mysql_query("SELECT * FROM `zzz`");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf("ID: %s  Name: %s <br>", $row[0], $row[1]);
}
?>