<?php

   $con = mysqli_connect("", "root", "", "nachschreibdb");

   $res = mysqli_query($con, "SELECT * FROM schueler;");

   $getvalue = mysqli_query($con, "SELECT Vorname,Nachname,Email,KlassenID FROM schueler WHERE id = '1';");

   $test = mysqli_fetch_assoc($getvalue);

   $counter = 0;

   $vorname = "";

   $nachname = "";

   $klassenr = "";

   $email = "";

   foreach($test as $key => $value){

      if($counter == 0){

         $vorname = $value;

      }

      if($counter == 1){

         $nachname = $value;

      }      

      if($counter == 2){

         $email = $value;

      }

      if($counter == 3){

         $klassenr = $value;

      }   

   $counter = $counter + 1;

   }

   $counter = 0;

   $klasse = mysqli_query($con, "SELECT KlassenKuerzel FROM klassen WHERE id = '$klassenr';");

   $test2 = mysqli_fetch_assoc($klasse);

   foreach($test2 as $key => $value){

      if($counter == 0){

         $klasse = $value;

      }   

   $counter = $counter + 1;

   }

   $counter = 0;

   $facheranzahl = "";

   $facher = mysqli_query($con, "SELECT FachName FROM faecher WHERE KlassenID = '$klassenr';");

   $req_facheranzahl = mysqli_query($con,"SELECT '$facheranzahl'(*) FROM faecher WHERE KlassenID = '$klassenr';");

   $test3 = mysqli_fetch_assoc($facher);

   $test4 = mysqli_fetch_assoc($facher);

   foreach($test3 as $key => $value){

      if($counter == 0){

         $facher = $value;

      }   

   $counter = $counter + 1;

   }

   echo print_r($facheranzahl);

   ?>