<html>
<head>
<title>Inimeste andmed</title>
<link href="style.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1257"><style type="text/css">
<!--
body {
background-image: url(taust.gif);
}
-->
</style></head>
<body>
<?php
mysql_connect("localhost", "peeter", "");
mysql_select_db("peeter");
$lause="select id_i, eesnimi, perenimi, telefon, elukoht, auto from laenutaja, elukohad, autod
WHERE laenutaja.elukohaID=elukohad.id and laenutaja.autoID=autod.id";
$vastus=mysql_query($lause);
echo mysql_error();
?>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><form action="lisamine.php">
<img src="tiitel.gif" width="112" height="12"><br>
<table width="200" border="0" cellpadding="0" cellspacing="2" class="taust">
<tr>
<td>Eesnimi:</td>
<td><div align="left">
<input name="eesnimi" type='text' class="sisend-kastid" />
</div></td>
</tr>
<tr>
<td>Perekonnanimi:</td>
<td><div align="left">
<input name="perenimi" type='text' class="sisend-kastid" />
</div></td>
</tr>
<tr>
<td>Telefon:</td>
<td><div align="left">
<input name="telefon" type='text' class="sisend-kastid" />
</div></td>
</tr>
<tr>
<td>Elukoht:</td>
<td><div align="left">
<select name="elukoht" class="sisend-kastid">
<?php
$lause="select id, elukoht from elukohad";
$vastus=mysql_query($lause);
while($rida=mysql_fetch_array($vastus)){
echo "<option value='$rida[id]'>$rida[elukoht]</option>\n";
}
?>
</select>
</div></td>
</tr>
<tr>
<td>Auto mark: </td>
<td><div align="left">
<select name="auto" class="sisend-kastid">
<?php
$lause="select id, auto from autod";
$vastus=mysql_query($lause);
while($rida=mysql_fetch_array($vastus)){
echo "<option value='$rida[id]'>$rida[auto]</option>\n";
}
?>
</select>
</div></td>
</tr>
<tr>
<td> </td>
<td><div align="right">
<input name="submit" type='submit' class="nupp" value="Lisa" />
</div></td>
</tr>
</table>
</form>
<form action="elukoht.php">
<table width="200" border="0" cellpadding="0" cellspacing="2" class="taust">
<tr>
<td><div align="left">Lisa uus elukoht:
</div></td>
<td><div align="right">
</div></td>
</tr>
<tr>
<td><div align="left">
<input name="elukoht" type='text' class="sisend-kastid" />
</div></td>
<td><div align="right">
<input name="submit2" type='submit' class="nupp" value="Lisa" />
</div></td>
</tr>
</table>
</form>
<form action="auto.php">
<div align="left">
<table width="200" border="0" cellpadding="0" cellspacing="2" class="taust">
<tr>
<td>Lisa uus auto mark: </td>
<td><div align="right">
</div></td>
</tr>
<tr>
<td><div align="left">
<input name="auto" type='text' class="sisend-kastid" />
</div></td>
<td><div align="right">
<input name="submit3" type='submit' class="nupp" value="Lisa" />
</div></td>
</tr>
</table>
</div>
</form></td>
</tr>
<tr>
<td>
<?php
$lause="select id_i, eesnimi, perenimi, telefon, elukoht, auto from laenutaja, elukohad, autod
WHERE laenutaja.elukohaID=elukohad.id and laenutaja.autoID=autod.id";
$vastus=mysql_query($lause);
echo "<form action='kustutamine.php'>";
echo "</table><input type='submit' class='nupp' value='Kustuta'>";
echo "<table border='0' cellpadding='0' cellspacing='2' class='taust2'>";
echo "
<tr><th></th>
<th>Eesnimi: </th>\n".
"<th>Perekonnanimi: </th>\n".
"<th>Telefon: </th>\n".
"<th>Elukoht: </th>\n".
"<th>Auto mark: </th></tr>\n";
while ($rida=mysql_fetch_array ($vastus)){
echo "<tr class='valjund-kastid'>
<td><input type='checkbox' name='ruut[]' value='$rida[id_i]'></td>
<td>$rida[eesnimi]</td>
<td>$rida[perenimi]</td>
<td>$rida[telefon]</td>
<td>$rida[elukoht]</td>
<td>$rida[auto]</td></tr>\n";
}
echo"</form>";
mysql_close();
?>
</td>
</tr>
</table>
</body>
</html>