Untitled

<?PHP
    include('conf.php');
/*
 * conf.php :
 * $HOST = "YOUR_MYSQL_HOST";
 * $USER = "YOUR_MYSQL_USER";
 * $PASS = "$USER_PASSWORD";
 * $DATA = "YOUR_DATABASE_NAME";
 * $TEST = "TEST_TABLE_NAME";
 * $UMLA = array("ü","ö","ä","Ü","Ö","Ä","ß"); //characters to replace with:
 * $REPL = array("&uuml;","&ouml;","&auml;","&Uuml;","&Ouml;","&Auml;","&szlig"); //herpderp
 *
 */
?>
<!DOCTYPE html>
<html>
<head>
<title>MCITP WITH MySQL SHIZNIZ</title>
</head>
<body>
<?PHP

$query="SELECT * FROM ".$TEST." ORDER BY question_ID ASC";
$LOC = 'mysql:dbname='.$DATA.';host='.$HOST;
//try
//{
    $DBCON = new PDO($LOC, $USER, $PASS);
    $RES=$DBCON->prepare($query);
    $RES->execute();
    $resarr=$RES->fetchAll();
//}
//catch(PDOException $e)
//{
    //var_dump($resarr);
    //echo(count($resarr));
//}


    /*
    mysql_connect($HOST,$USER,$PASS) or die("cant connect to".$HOST);
    mysql_select_db($DATA) or die("cant select database ".$DATA);
    $result=mysql_query($query) or die("fucker cant query brah");
    */
    $retcount=count($resarr);
    echo('<form name="questions" action="checkanswers.php" method="POST">'."\r\n".'
          <input type="hidden" name="test" value="'.$TEST.'" />'."\r\n".'
          <input type="hidden" name="retcount" value="'.$retcount.'" />'."\r\n");
    while ($resarr = mysql_fetch_assoc($result)){
        $question=str_replace($UMLA,$REPL,$resarr['question']);
        echo("Frage ".$resarr['question_ID']."<br /><br />\r\n".
             $question."<br />\r\n");
        $x=1;
        $a_n_s="answer".$x;
        while(strlen($resarr[$a_n_s])>0){
            if(strlen($resarr[$a_n_s])>0){
                $resarr[$a_n_s]=str_replace($UMLA,$REPL,$resarr[$a_n_s]);
                if(strlen($resarr['correct'])<2){
                    echo('<input type="radio" name="'.$resarr['question_ID'].'" value="'.chr($x+64).'" /> '.chr($x+64).': '.$resarr[$a_n_s].'<br />'."\r\n");
                }else{
                    echo('  <input type="checkbox" name="'.$resarr['question_ID'].'[]" value="'.chr($x+64).'" /> '.chr($x+64).': '.$resarr['answer1'].'<br />'."\r\n");
                }
            }
            $x++;
            $a_n_s="answer".$x;
        }
        echo("<br /><br />");
    }
    echo('<input type="submit" name="submit" />');
?>
</body>
</html>