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

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

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

mysql_select_db ("test019", $handle);

mysql_query ("INSERT INTO abc VALUES (\"003\", \"004\")", $handle);

$result = mysql_query ("SELECT * FROM abc", $handle);
while ($row = mysql_fetch_row ($result)) 
    echo $row [0] . " " . $row [1] ."<br>\n";
$result = mysql_query ("SELECT * FROM abc JOIN def", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["abc01"] . " " . $row ["abc02"] . " " . $row ["def01"] . " " . $row ["def02"] . "<br>\n";
$result = mysql_query ("SELECT * FROM abc INNER JOIN def WHERE abc.abc01 = def.def01", $handle);
while ($row = mysql_fetch_row ($result))
    echo $row [0] . " " . $row [1] . " " . $row [2] . " " . $row [3] . "<br>\n";
$result = mysql_query ("SELECT * FROM abc LEFT JOIN def ON abc.abc01 = def.def01", $handle);
while ($row = mysql_fetch_row ($result))
    echo $row [0] . " " . $row [1] . " " . $row [2] . " " . $row [3] . "<br>\n";

mysql_close ($handle);
?>