/media/sda-magnetic/david/Dok-15-2023-11-27/informatik/www-intel-compute-stick-2022-06-13/066/database.php

<?php 
include ('/home/david/mysqldata.php');

$handle = mysql_connect ("localhost", $MYSQL_NAME, $MYSQL_PASSWORD);

mysql_select_db ("test066", $handle);

mysql_query ("INSERT INTO b VALUES (2, 2)", $handle);

$result = mysql_query ("SELECT * FROM a INNER JOIN b ON a.n1 = b.n3", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["n1"] . " ". $row ["n2"] . " " . $row ["n3"] . " "  . $row ["n4"] . "<br>\n";
    
$result = mysql_query ("SELECT * FROM a LEFT JOIN b ON a.n2 = b.n4", $handle);
while ($row = mysql_fetch_row ($result)) {
    for ($i = 0;  $i < 4;  $i++) 
        echo $row [$i] . " ";
echo "<br>\n";
}

mysql_close ($handle);
?>