<script language="javascript">
function createReqObj(){
  brws = navigator.appName;
  if(brws == "Microsoft Internet Explorer")
    rq = new ActiveXObject("Microsoft.XMLHTTP");
  else rq = new XMLHttpRequest(); return rq;
}

rqo = createReqObj();
rqp = createReqObj();

function requesT_B(){
  document.getElementById("save").style.visibility="hidden";
  document.getElementById("save").className="dis";
  document.getElementById("new").style.visibility="visible";
  document.getElementById("new").className="show";
  sentstring="?";
  sentstring=sentstring+"vorname="
  +document.forms["individuals"].elements["vorname"].value;
  sentstring=sentstring+"&name="
  +document.forms["individuals"].elements["name"].value;
  sentstring=sentstring+"&geburtsdatum="
  +document.forms["individuals"].elements["geburtsdatum"].value;
  sentstring=sentstring+"&strasse="
  +document.forms["individuals"].elements["strasse"].value;
  sentstring=sentstring+"&plz="
  +document.forms["individuals"].elements["plz"].value;
  sentstring=sentstring+"&ort="
  +document.forms["individuals"].elements["ort"].value;
  sentstring=sentstring+"&telefon="
  +document.forms["individuals"].elements["telefon"].value;
  sentstring=sentstring+"&telefax="
  +document.forms["individuals"].elements["telefax"].value;
  sentstring=sentstring+"&email="
  +document.forms["individuals"].elements["email"].value;
  sentstring=sentstring+"&ausweisnummer="
  +document.forms["individuals"].elements["ausweisnummer"].value;
  sentstring=sentstring+"&passbild=images/phantom.jpg";
  sentstring=sentstring+"&bemerkung="
  +document.forms["individuals"].elements["bemerkung"].value;
  if(document.forms["individuals"].elements[10].checked==true) {
  geschlecht=0;
  } else {
  geschlecht=1;
  }
  sentstring=sentstring+"&geschlecht="+geschlecht;
  rqo.open('get', 'enter.php'+ sentstring);
  rqp.open('get', 'table.php');
  rqp.onreadystatechange = receivE_B;
  rqo.send(null);
  rqp.send(null);
}

function receivE_B(){
  if(rqp.readyState == 4){
    document.getElementById("liste").innerHTML = rqp.responseText;
    document.getElementById("save").className = "dis";
    document.getElementById("save").style.visibility = "hidden";
    document.getElementById("new").style.visibility = "visible";
    alert('Datensatz wurde gespeichert');
  }
  return
}

function requesT_C(id){
  document.getElementById("new").className="show";
  document.getElementById("new").style.visibility="visible";
  document.getElementById("kill").className="dis";
  document.getElementById("kill").style.visibility="hidden";
  ob_kill=confirm('Datensatz wirklich loeschen?');
  if(ob_kill==true){
    rqo.open('get', 'delete.php?id='+ id);
    rqp.open('get', 'table.php');
    rqp.onreadystatechange = receivE_C;
    rqo.send(null);
    rqp.send(null);
  }else{
    return
  }
}

function receivE_C(){
  if(rqp.readyState == 4){
    alert('Datemsatz wurde geloescht.')
    document.getElementById("liste").innerHTML = rqp.responseText;
    for (i=0; i<13 ; i++ ) {
      document.forms["individuals"].elements[i].value='';
    }
  document.forms["individuals"].elements[10].checked = false;
  document.forms["individuals"].elements[11].checked = false;
  document.images[0].src="images/phantom.jpg";
  document.getElementById("save").className="show";
  document.getElementById("save").style.visibility="visible";
  }
  return
}

function requesT_A(id){
  document.getElementById("new").className="dis";
  document.getElementById("new").style.visibility="hidden";
  document.getElementById("save").className="dis";
  document.getElementById("save").style.visibility="hidden";
  document.getElementById("kill").className="show";
  document.getElementById("kill").style.visibility="visible";
  document.forms["individuals"].elements['selected'].value=id;
  rqo.open('get', 'show.php?id='+ id);
  rqo.onreadystatechange = receivE_A;
  rqo.send(null);
}

function receivE_A(){
  if(rqo.readyState == 4){

    my_string=rqo.responseText;

    suche = my_string.indexOf(";");
    vorname = my_string.substring(0, suche);
    my_string = my_string.substring(suche+1,1000);
    document.forms["individuals"].elements['vorname'].value = vorname;

    suche = my_string.indexOf(";");
    name = my_string.substring(0, suche);
    my_string = my_string.substring(suche+1,1000);
    document.forms["individuals"].elements['name'].value = name;

    suche = my_string.indexOf(";");
    ausweisnummer = my_string.substring(0, suche);
    my_string = my_string.substring(suche+1,1000);
    document.forms["individuals"].elements['ausweisnummer'].value = ausweisnummer;

    suche = my_string.indexOf(";");
    geburtsdatum = my_string.substring(0, suche);
    my_string = my_string.substring(suche+1,1000);
    document.forms["individuals"].elements['geburtsdatum'].value = geburtsdatum;

    suche = my_string.indexOf(";");
    strasse = my_string.substring(0, suche);
    my_string = my_string.substring(suche+1,1000);
    document.forms["individuals"].elements['strasse'].value = strasse;

    suche = my_string.indexOf(";");
    plz = my_string.substring(0, suche);
    my_string = my_string.substring(suche+1,1000);
    document.forms["individuals"].elements['plz'].value = plz;

    suche = my_string.indexOf(";");
    ort = my_string.substring(0, suche);
    my_string = my_string.substring(suche+1,1000);
    document.forms["individuals"].elements['ort'].value = ort;

    suche = my_string.indexOf(";");
    telefon = my_string.substring(0, suche);
    my_string = my_string.substring(suche+1,1000);
    document.forms["individuals"].elements['telefon'].value = telefon;

    suche = my_string.indexOf(";");
    telefax = my_string.substring(0, suche);
    my_string = my_string.substring(suche+1,1000);
    document.forms["individuals"].elements['telefax'].value = telefax;

    suche = my_string.indexOf(";");
    email = my_string.substring(0, suche);
    my_string = my_string.substring(suche+1,1000);
    document.forms["individuals"].elements['email'].value = email;

    suche = my_string.indexOf(";");
    geschlecht = my_string.substring(0, suche);
    my_string = my_string.substring(suche+1,1000);
    if(geschlecht==1) {
      document.forms["individuals"].elements[10].checked = false;
      document.forms["individuals"].elements[11].checked = true;
    } else {
      document.forms["individuals"].elements[10].checked = true;
      document.forms["individuals"].elements[11].checked = false;
    }

    suche = my_string.indexOf(";");
    passbild = my_string.substring(0, suche);
    my_string = my_string.substring(suche+1,1000);
    document.images[0].src=passbild;

    suche = my_string.indexOf(";");
    bemerkung = my_string.substring(0, suche);
    document.forms["individuals"].elements['bemerkung'].value = bemerkung;

  }
  return
}

function new_data() {
  for (i=0; i<document.forms["individuals"].length -4 ; i++ ) {
    document.forms["individuals"].elements[i].value="";
  }
  document.forms["individuals"].elements[0].focus();
  document.forms["individuals"].elements[10].checked = false;
  document.forms["individuals"].elements[11].checked = false;
  document.getElementById("save").className="show";
  document.getElementById("save").style.visibility="visible";
  document.getElementById("new").className="dis";
  document.getElementById("new").style.visibility="hidden";
  document.getElementById("kill").className="dis";
  document.getElementById("kill").style.visibility="hidden";
  document.images[0].src="images/phantom.jpg";
return
}

</script>

<?php
$i = 0;

$con = mysql_connect("host","datenbank","passwort");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("datenbank", $con);
$result = mysql_query("SELECT * FROM einwohner limit 1");
$row = mysql_fetch_array($result);

$vorname       = $row['vorname'];
$name          = $row['name'];
$geburtsdatum  = $row['geburtsdatum'];
$strasse       = $row['strasse'];
$plz           = $row['plz'];
$ort           = $row['ort'];
$telefon       = $row['telefon'];
$telefax       = $row['telefax'];
$email         = $row['email'];
$ausweisnummer = $row['ausweisnummer'];
$passbild      = $row['passbild'];
$geschlecht    = $row['geschlecht'];
$bemerkung     = $row['bemerkung'];

mysql_close($con);

?>

<link href="style.css" rel="stylesheet" type="text/css">

</head>
<body>
<table align="center" width="100%">
  <tr>

    </td>

    <td style="padding:20px;">
    <div class="main_right">

<center>
<form class="body" name="individuals" style="width:660px">
<table align="center">
  <tr>
    <td colspan=2 align="center" style="border:none;">
    <br><b>Einwohnerdaten</b><br><br>
    </td>
  </tr>
  <tr>
    <td align="right">
    Vorname, Name:
    </td>
    <td>
    <input class="show_t" type="text" name="vorname"
    value="<?php echo $vorname; ?>" style="width:218px"></input>
    <input class="show_t" type="text" name="name"
    value="<?php echo $name; ?>" style="width:218px"></input>
    </td>
  </tr>
  <tr>
    <td align="right">
    Ausweis Nr. / Geburtsdatum:
    </td>
    <td>
    <input class="show_t" type="text" name="ausweisnummer"
    value="<?php echo $ausweisnummer; ?>" style="width:218px"></input>
    <input class="show_t" type="text" name="geburtsdatum"
    value="<?php echo $geburtsdatum; ?>" style="width:218px"></input>
    </td>
  </tr>
  <tr>
    <td align="right">
    Straße:
    </td>
    <td>
    <input class="show_t" type="text" name="strasse"
    value="<?php echo $strasse; ?>" style="width:440px"></input>
    </td>
  </tr>
  <tr>
    <td align="right">
    PLZ / Ort:
    </td>
    <td>
    <input class="show_t" type="text" name="plz"
    value="<?php echo $plz; ?>" style="width:136px"></input>
    <input class="show_t" type="text" name="ort"
    value="<?php echo $ort; ?>" style="width:300px"></input>
    </td>
  </tr>
  <tr>
    <td align="right">
    Telefon / Telefax:
    </td>
    <td>
    <input class="show_t" type="text" name="telefon"
    value="<?php echo $telefon; ?>" style="width:218px"></input>
    <input class="show_t" type="text" name="telefax"
    value="<?php echo $telefax; ?>" style="width:218px"></input>
    </td>
  </tr>
  <tr>
    <td align="right">
    Email:
    </td>
    <td>
    <input class="show_t" type="text" name="email"
    value="<?php echo $email; ?>" style="width:440px"></input>
    </td>
  </tr>
  <tr>
    <td align="right">
    Geschlecht:
    </td>
    <td>
<?php
if($geschlecht==1){
  echo  "Weiblich <input value=0 type='radio' name='geschlecht'
  style='border:none;'></input>    ";
  echo  "Männlich <input value=1 type='radio' name='geschlecht'
  checked style='border:none;'></input>";
  }else{
  echo  "Weiblich <input value=0 type='radio' name='geschlecht'
  checked style='border:none;'></input>    ";
  echo  "Männlich <input value=1 type='radio' name='geschlecht'
  style='border:none;'></input>";
  }
?>
    </td>
  </tr>
  <tr>
    <td style="border:none;"></td>
    <td style="border:none;">
    <br>
    zur Person:
    </td>
  </tr>
  <tr>
    <td valign="top">
    <img src="<?php echo $passbild; ?>">
    </td>
    <td align="left" valign="top">
    <textarea class="show_t" name="bemerkung"
    style="width:440px;height:124px;padding:10px;"
    ><?php echo $bemerkung; ?></textarea>
    <br><br>
    </td>
  </tr>
  <tr>
    <td colspan=2 style="border:none;">
    <div id="liste" style="height:132px; overflow-y:scroll; overflow-x:hidden;
    padding-top:0px;border:1px;border-style:solid;">

<?php
$i = 0;

$con = mysql_connect("host","datenbank","passwort");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("datenbank", $con);

$result = mysql_query("SELECT id, vorname, name, strasse,plz, ort
FROM einwohner order by name");

echo "<table align='center' width='100%'>";
echo "<tr class='c' style='font-weight:bold;'>";
echo "<td>Vorname</td>";
echo "<td>Name</td>";
echo "<td>Staße</td>";
echo "<td>PLZ</td>";
echo "<td>Ort</td>";
echo "</tr>";

while($row = mysql_fetch_array($result))
  {
  $i++;
  if(round($i/2) == $i/2){
    echo "<tr onClick=requesT_A(this.id) id='" . $row['id'] ."'
    class='a' onmouseover=this.className='c' onmouseout=this.className='a'><td>"
     . $row['vorname'] . "</td><td>" . $row['name'] . "</td><td>"
     . $row['strasse'] . "</td><td>" . $row['plz'] . "</td><td>"
     . $row['ort'] . "</td></tr>";
    }else{
    echo "<tr onClick=requesT_A(this.id) id='" . $row['id']
    ."' class='b' onmouseover=this.className='c' onmouseout=this.className='b'><td>"
    . $row['vorname'] . "</td><td>" . $row['name'] . "</td><td>"
    . $row['strasse'] . "</td><td>" . $row['plz'] . "</td><td>"
    . $row['ort'] . "</td></tr>";
  }
  }
echo "</table>";

mysql_close($con);
?>
<br>
     </td>
   </tr>
     </div>
   <tr>
     <td colspan=2 style="border:none;" align="center">
     <br><br>
         <input id="new" onclick='new_data()' type="button"
         value="Neuer Datensatz" class="show" onmouseover="this.className='go'"
         onmouseout="this.className='show'"
         style="width:200px;"></input>    
         <input id="save" type="button" value="Datensatz speichern"
         class="dis" onmouseover="this.className='go'"
         onmouseout="this.className='show'" onclick=requesT_B()
         style="width:200px;"></input>    
         <input id="kill" type="button" value="Datensatz löschen"
         class="dis" onmouseover="this.className='go'" onmouseout="this.className='go'"
         onclick=requesT_C(document.forms["individuals"].elements["selected"].value)
         style="width:200px;"></input>
         <input type="hidden" name="selected" value=0></input>
         <br><br>
     </td>
   </tr>
  </table>
</form>
</center>