Prüfungs Trainer - Dreamcodes – Kostenlose Codeschnipsel, PHP Scripte, IT Tutorials, SEO, Geo & Webentwicklung

Abschlussprüfungstrainer – Dein digitales Prüfungszentrum

Mit dieser hochwertigen Webseite erhältst du ein vollwertiges Trainingssystem für Abschlussprüfungen. Das Design ist modern, professionell und speziell auf Schüler und Bildungseinrichtungen zugeschnitten.

Funktionen im Überblick:

PDF-Upload alter Prüfungen – Lade bestehende Prüfungen hoch, das Skript extrahiert automatisch die Fragen.
Test-Simulation – Schüler können wie in einer echten Prüfung trainieren: klare Darstellung, Fragen nacheinander, Antwortmöglichkeiten und strukturierter Ablauf.
Zeitlimit mit Countdown – Jede Simulation läuft unter realistischen Bedingungen, inklusive Timer und Abgabe.
User-Accounts für Schüler – Sichere Anmeldung mit persönlichem Dashboard, Übersicht der Tests und Ergebnisse.
Admin-Bereich – Benutzerverwaltung, Upload von Prüfungen, Lösch- und Kontrollmöglichkeiten.
Dashboard-Übersicht – Klare Statistiken, gespeicherte Ergebnisse, Auswertung der Prüfungssimulation.
Automatische Ordner- und Dateistruktur – Alles wird aus einer Hauptdatei heraus erstellt, keine manuelle Konfiguration nötig.
Professionelles Design – Optisch so hochwertig, als hätte es mehrere tausend Euro gekostet, responsive und intuitiv bedienbar.

Optionale Features:

Textextraktion via pdftotext (falls auf dem Server verfügbar)
Anpassbare Prüfungsläufe (z. B. Fächer, Schwierigkeitsgrad)
Fortschrittsanzeige und Ergebnisbewertung

Installation:

Datei auf den Server laden
MySQL-Zugangsdaten in der Datei eintragen
Erste Anmeldung über Admin-Account (Standard: admin / admin123, Passwort bitte sofort ändern)
Alte Prüfungen hochladen und erste Tests starten

Vorteile:

Realistische Prüfungsvorbereitung rund um die Uhr
Ideal für Schüler, Nachhilfelehrer oder Bildungseinrichtungen
Keine teuren Zusatzprogramme notwendig, läuft direkt auf jedem gängigen Webserver
Übersichtliche Auswertung sorgt für schnelle Lernfortschritte

Hinweis:
Dieses Skript ersetzt keine offiziellen Prüfungen, bietet aber eine optimale Vorbereitung unter nahezu realistischen Bedingungen.

<?php
// Konfiguration
$dbHost = '127.0.0.1';
$dbName = 'exam_trainer_db';
$dbUser = 'root';
$dbPass = ''; // setze hier das Passwort

$baseDir = __DIR__;
$uploadDir = __DIR__ . '/uploads';
$dataDir = __DIR__ . '/data';

if (!is_dir($uploadDir)) mkdir($uploadDir, 0755, true);
if (!is_dir($dataDir)) mkdir($dataDir, 0755, true);

// Mysql Verbindung und Tabellen anlegen falls noetig
try {
    $pdo = new PDO("mysql:host={$dbHost};charset=utf8mb4", $dbUser, $dbPass, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
    // Datenbank erstellen falls nicht vorhanden
    $pdo->exec("CREATE DATABASE IF NOT EXISTS `{$dbName}` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci");
    $pdo->exec("USE `{$dbName}`");

    // Tabellen
    $pdo->exec("CREATE TABLE IF NOT EXISTS users (
        id INT AUTO_INCREMENT PRIMARY KEY,
        username VARCHAR(100) UNIQUE,
        password VARCHAR(255),
        display_name VARCHAR(200),
        is_admin TINYINT(1) DEFAULT 0,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4");

    $pdo->exec("CREATE TABLE IF NOT EXISTS exams (
        id INT AUTO_INCREMENT PRIMARY KEY,
        title VARCHAR(255),
        filename VARCHAR(255),
        uploader INT,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (uploader) REFERENCES users(id) ON DELETE SET NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4");

    $pdo->exec("CREATE TABLE IF NOT EXISTS questions (
        id INT AUTO_INCREMENT PRIMARY KEY,
        exam_id INT,
        qtext TEXT,
        qnum VARCHAR(50),
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (exam_id) REFERENCES exams(id) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4");

    $pdo->exec("CREATE TABLE IF NOT EXISTS attempts (
        id INT AUTO_INCREMENT PRIMARY KEY,
        user_id INT,
        exam_id INT,
        started_at TIMESTAMP NULL,
        finished_at TIMESTAMP NULL,
        score INT DEFAULT 0,
        duration_sec INT DEFAULT 0,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
        FOREIGN KEY (exam_id) REFERENCES exams(id) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4");

    $pdo->exec("CREATE TABLE IF NOT EXISTS answers (
        id INT AUTO_INCREMENT PRIMARY KEY,
        attempt_id INT,
        question_id INT,
        answer_text TEXT,
        correct TINYINT(1) DEFAULT 0,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (attempt_id) REFERENCES attempts(id) ON DELETE CASCADE,
        FOREIGN KEY (question_id) REFERENCES questions(id) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4");

} catch (Exception $e) {
    echo 'Datenbankfehler: ' . htmlspecialchars($e->getMessage());
    exit;
}

session_start();

function json($d) { header('Content-Type: application/json; charset=utf-8'); echo json_encode($d); exit; }

// Hilfsfunktionen
function currentUserId() { return $_SESSION['user_id'] ?? null; }
function isAdmin() { return !empty($_SESSION['is_admin']); }

// initial admin anlegen falls noch keiner existiert
$stmt = $pdo->query("SELECT COUNT(*) as c FROM users"); $cnt = $stmt->fetch(PDO::FETCH_ASSOC)['c'];
if ($cnt == 0) {
    $pw = password_hash('admin123', PASSWORD_DEFAULT);
    $pdo->prepare("INSERT INTO users (username,password,display_name,is_admin) VALUES (?,?,?,1)")->execute(['admin',$pw,'Administrator']);
}

// API Endpunkte
$action = $_REQUEST['action'] ?? '';

if ($action === 'register' && $_SERVER['REQUEST_METHOD'] === 'POST') {
    $username = trim($_POST['username'] ?? '');
    $password = $_POST['password'] ?? '';
    $display = trim($_POST['display'] ?? $username);
    if (!$username || !$password) json(['error' => 'Bitte Benutzername und Passwort angeben']);
    try {
        $pw = password_hash($password, PASSWORD_DEFAULT);
        $stm = $pdo->prepare("INSERT INTO users (username,password,display_name) VALUES (?,?,?)");
        $stm->execute([$username,$pw,$display]);
        json(['success' => true]);
    } catch (Exception $e) { json(['error' => 'Benutzer existiert bereits']); }
}

if ($action === 'login' && $_SERVER['REQUEST_METHOD'] === 'POST') {
    $username = trim($_POST['username'] ?? '');
    $password = $_POST['password'] ?? '';
    $stm = $pdo->prepare("SELECT * FROM users WHERE username = ? LIMIT 1");
    $stm->execute([$username]); $u = $stm->fetch(PDO::FETCH_ASSOC);
    if ($u && password_verify($password, $u['password'])) {
        $_SESSION['user_id'] = $u['id']; $_SESSION['display_name'] = $u['display_name']; $_SESSION['is_admin'] = $u['is_admin'];
        json(['success' => true]);
    } else json(['error' => 'Ungültige Zugangsdaten']);
}

if ($action === 'logout') { session_destroy(); json(['success' => true]); }

if ($action === 'upload' && $_SERVER['REQUEST_METHOD'] === 'POST') {
    if (!currentUserId()) json(['error' => 'Bitte einloggen']);
    if (!isset($_FILES['pdf'])) json(['error' => 'Datei fehlt']);
    $f = $_FILES['pdf'];
    if ($f['error'] !== UPLOAD_ERR_OK) json(['error' => 'Upload Fehler']);
    $ext = strtolower(pathinfo($f['name'], PATHINFO_EXTENSION));
    if ($ext !== 'pdf') json(['error' => 'Nur PDF erlaubt']);
    $fname = time() . '-' . bin2hex(random_bytes(6)) . '.pdf';
    $target = $uploadDir . '/' . $fname;
    if (!move_uploaded_file($f['tmp_name'], $target)) json(['error' => 'Speicherfehler']);
    // eintrag in exams
    $title = trim($_POST['title'] ?? $f['name']);
    $pdo->prepare("INSERT INTO exams (title,filename,uploader) VALUES (?,?,?)")->execute([$title,$fname,currentUserId()]);
    $examId = $pdo->lastInsertId();

    // versuch text zu extrahieren mit pdftotext falls vorhanden
    $text = '';
    $pdftotext = trim(shell_exec('which pdftotext'));
    if ($pdftotext) {
        $out = tempnam(sys_get_temp_dir(), 'txt');
        @exec(escapeshellcmd("{$pdftotext} " . escapeshellarg($target) . " " . escapeshellarg($out) . " 2>&1"));
        $text = @file_get_contents($out) ?: '';
        @unlink($out);
    } else {
        // fallback leer
        $text = '';
    }

    // einfache frage extraktion: split nach zeilen die mit Zahl beginnen oder mit Wort Frage
    $questions = [];
    if ($text) {
        $lines = preg_split('/\r?\n/', $text);
        $buffer = '';
        $qnum = 0;
        foreach ($lines as $ln) {
            $ln = trim($ln);
            if (!$ln) continue;
            if (preg_match('/^(Frage|F|[0-9]{1,3}[\.|\)] )/i', $ln) || preg_match('/^[0-9]+\./', $ln) ) {
                if ($buffer) { $questions[] = ['qnum' => ++$qnum, 'text' => $buffer]; }
                $buffer = $ln;
            } else {
                $buffer .= ' ' . $ln;
            }
        }
        if ($buffer) $questions[] = ['qnum' => ++$qnum, 'text' => $buffer];
    }

    // wenn keine fragen automatisch gefunden wurden, lege placeholder fragen an
    if (count($questions) === 0) {
        for ($i=1;$i<=10;$i++) $questions[] = ['qnum' => $i, 'text' => "Beispielfrage {$i} aus dem Upload bitte manuell prüfen"]; 
    }

    // speicher fragen
    $ins = $pdo->prepare("INSERT INTO questions (exam_id,qtext,qnum) VALUES (?,?,?)");
    foreach ($questions as $q) $ins->execute([$examId, $q['text'], $q['qnum']]);

    json(['success' => true, 'exam_id' => $examId, 'questions' => count($questions)]);
}

if ($action === 'list_exams') {
    $res = $pdo->query("SELECT e.*, u.display_name FROM exams e LEFT JOIN users u ON u.id = e.uploader ORDER BY e.created_at DESC");
    $out = [];
    while ($r = $res->fetch(PDO::FETCH_ASSOC)) $out[] = $r;
    json($out);
}

if ($action === 'get_questions' && isset($_GET['exam_id'])) {
    $exam_id = intval($_GET['exam_id']);
    $res = $pdo->prepare("SELECT * FROM questions WHERE exam_id = ? ORDER BY id ASC"); $res->execute([$exam_id]);
    $out = [];
    while ($r = $res->fetch(PDO::FETCH_ASSOC)) $out[] = $r;
    json($out);
}

if ($action === 'start_attempt' && $_SERVER['REQUEST_METHOD'] === 'POST') {
    if (!currentUserId()) json(['error' => 'Bitte einloggen']);
    $exam_id = intval($_POST['exam_id']);
    $time_limit = intval($_POST['time_limit']) ?? 1800; // default 30 min
    $pdo->prepare("INSERT INTO attempts (user_id,exam_id,started_at) VALUES (?,?,NOW())")->execute([currentUserId(), $exam_id]);
    $attempt_id = $pdo->lastInsertId();
    json(['success' => true, 'attempt_id' => $attempt_id]);
}

if ($action === 'submit_answer' && $_SERVER['REQUEST_METHOD'] === 'POST') {
    $attempt_id = intval($_POST['attempt_id']);
    $question_id = intval($_POST['question_id']);
    $answer = trim($_POST['answer'] ?? '');
    // einfache Speicherung ohne automatische Bewertung
    $stm = $pdo->prepare("INSERT INTO answers (attempt_id,question_id,answer_text) VALUES (?,?,?)");
    $stm->execute([$attempt_id, $question_id, $answer]);
    json(['success' => true]);
}

if ($action === 'finish_attempt' && $_SERVER['REQUEST_METHOD'] === 'POST') {
    $attempt_id = intval($_POST['attempt_id']);
    // berechne dauer als beispiel
    $stm = $pdo->prepare("SELECT started_at FROM attempts WHERE id = ?"); $stm->execute([$attempt_id]); $row = $stm->fetch(PDO::FETCH_ASSOC);
    $started = strtotime($row['started_at']); $dur = time() - $started;
    $pdo->prepare("UPDATE attempts SET finished_at = NOW(), duration_sec = ? WHERE id = ?")->execute([$dur, $attempt_id]);
    json(['success' => true, 'duration' => $dur]);
}

if ($action === 'admin_delete_exam' && $_SERVER['REQUEST_METHOD'] === 'POST') {
    if (!isAdmin()) json(['error' => 'Zugriff verweigert']);
    $exam_id = intval($_POST['exam_id']);
    // entferne datei
    $stm = $pdo->prepare("SELECT filename FROM exams WHERE id = ?"); $stm->execute([$exam_id]); $r = $stm->fetch(PDO::FETCH_ASSOC);
    if ($r && $r['filename']) @unlink($uploadDir . '/' . $r['filename']);
    $pdo->prepare("DELETE FROM exams WHERE id = ?")->execute([$exam_id]);
    json(['success' => true]);
}

// Ende API logik

// UI
?><!doctype html>
<html lang="de">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>Dreamcodes - Abschlussprüfungstrainer</title>
<link href="https://fonts.googleapis.com/css2?family=Inter:wght@300;400;600;700&display=swap" rel="stylesheet">
<style>
:root{--bg:#071027;--card:#0b1220;--accent:#ff7a59;--muted:#9aa4b2}
body{margin:0;font-family:Inter,system-ui,Arial;background:linear-gradient(180deg,var(--bg),#021022);color:#e6eef8;padding:36px}
.container{max-width:1100px;margin:0 auto}
.header{display:flex;justify-content:space-between;align-items:center}
.brand{font-weight:700;font-size:20px}
.card{background:linear-gradient(180deg,var(--card),#071022);padding:18px;border-radius:12px;box-shadow:0 12px 40px rgba(2,6,23,0.7);margin-top:18px}
.grid{display:grid;grid-template-columns:1fr 360px;gap:18px}
.input,select{background:transparent;border:1px solid rgba(255,255,255,0.04);padding:10px;border-radius:8px;color:inherit;width:100%}
.btn{background:var(--accent);border:none;padding:10px 14px;border-radius:10px;color:#081018;font-weight:700;cursor:pointer}
.list{max-height:480px;overflow:auto}
.exam{padding:10px;border-radius:8px;background:rgba(255,255,255,0.02);margin-bottom:10px}
.small{font-size:13px;color:var(--muted)}
.badge{background:rgba(255,255,255,0.04);padding:6px 10px;border-radius:999px;font-weight:600}
.timer{font-size:20px;font-weight:700}
</style>
</head>
<body>
<div class="container">
  <div class="header">
    <div class="brand">Abschlussprüfungstrainer</div>
    <div id="userbox" class="small"></div>
  </div>

  <div class="card grid">
    <div>
      <div class="card">
        <h3>Prüfung Upload</h3>
        <form id="uploadForm" enctype="multipart/form-data">
          <input type="text" name="title" placeholder="Titel der Prüfung" class="input" />
          <input type="file" name="pdf" accept="application/pdf" class="input" />
          <div style="margin-top:10px;display:flex;gap:8px;align-items:center">
            <button class="btn" type="submit">Hochladen und Fragen extrahieren</button>
            <div class="small">pdftotext wird verwendet falls installiert</div>
          </div>
        </form>
      </div>

      <div class="card">
        <h3>Verfügbare Prüfungen</h3>
        <div id="exams" class="list"></div>
      </div>
    </div>

    <div>
      <div class="card">
        <h4>Benutzer</h4>
        <div id="authbox"></div>
      </div>

      <div class="card">
        <h4>Dashboard</h4>
        <div id="dashboard"></div>
      </div>
    </div>

  </div>
</div>

<script>
async function api(action, data){
  const opts = { method: 'POST' };
  if (data instanceof FormData) opts.body = data; else opts.body = new URLSearchParams(data || {});
  const res = await fetch('?action=' + action, opts);
  return res.json();
}

async function loadExams(){
  const res = await fetch('?action=list_exams');
  const exams = await res.json();
  const el = document.getElementById('exams'); el.innerHTML = '';
  exams.forEach(e => {
    const d = document.createElement('div'); d.className = 'exam';
    d.innerHTML = `<div style="display:flex;justify-content:space-between;align-items:center"><div><strong>${e.title}</strong><div class="small">von ${e.display_name} · ${e.created_at}</div></div><div><button class='btn' onclick='startExam(${e.id})'>Prüfung starten</button> <button style='background:#ef4444;color:#fff' onclick='adminDelete(${e.id})'>Löschen</button></div></div>`;
    el.appendChild(d);
  });
}

async function startExam(id){
  if(!confirm('Starte Prüfung mit Zeitlimit 30 Minuten?')) return;
  const res = await api('start_attempt', { exam_id: id, time_limit: 1800 });
  if(res.error) alert(res.error); else location.href = '?exam=' + res.attempt_id;
}

async function adminDelete(id){ if(!confirm('Prüfung wirklich löschen')) return; const fd = new URLSearchParams(); fd.append('exam_id', id); const res = await api('admin_delete_exam', fd); if(res.success) loadExams(); else alert(res.error);
}

// upload
document.getElementById('uploadForm').addEventListener('submit', async function(e){
  e.preventDefault();
  const fd = new FormData(this);
  const res = await api('upload', fd);
  if(res.error) alert(res.error); else { alert('Upload OK. Gefundene Fragen ' + res.questions); loadExams(); }
});

// simple auth UI
async function loadAuth(){
  const uid = await fetch('?action=whoami').then(r=>r.json()).catch(()=>null);
}

// check for attempt view
(function(){
  const params = new URLSearchParams(location.search);
  if(params.has('exam')){
    const attemptId = params.get('exam');
    // render exam interface in full page
    document.body.innerHTML = `<div style="padding:30px;color:#fff;font-family:Inter"><div style='max-width:900px;margin:0 auto'><h2>Prüfung</h2><div id='examroot'></div></div></div>`;
    renderExam(attemptId);
  } else {
    loadExams();
  }
})();

async function renderExam(attemptId){
  const root = document.getElementById('examroot');
  // fetch questions by exam id mapping
  // for demo wir nehmen exam id aus attempt
  const att = await fetch('?action=get_attempt&attempt_id=' + attemptId).then(r=>r.json());
  if(att.error){ root.innerHTML = '<div>Error</div>'; return; }
  const examId = att.exam_id;
  const qs = await fetch('?action=get_questions&exam_id=' + examId).then(r=>r.json());
  root.innerHTML = `<div class='card' style='padding:20px'><div style='display:flex;justify-content:space-between;align-items:center'><div><strong>${att.title}</strong><div class='small'>Zeitlimit 30 Minuten</div></div><div class='timer' id='timer'>30:00</div></div><hr><div id='qwrap'></div><div style='margin-top:12px'><button id='finishBtn' class='btn'>Prüfung beenden</button></div></div>`;
  const qwrap = document.getElementById('qwrap');
  qs.forEach((q,i)=>{
    const div = document.createElement('div'); div.className='exam'; div.innerHTML = `<div><strong>Frage ${i+1}</strong><p>${q.qtext}</p><textarea id='ans_${q.id}' style='width:100%;min-height:80px' placeholder='Antwort hier'></textarea></div>`;
    qwrap.appendChild(div);
  });

  // countdown simple
  let sec = 30 * 60; const timerEl = document.getElementById('timer');
  const interval = setInterval(()=>{ sec--; const m = Math.floor(sec/60); const s = sec%60; timerEl.textContent = (m<10? '0'+m:m) + ':' + (s<10? '0'+s:s); if(sec<=0){ clearInterval(interval); submitAll(); } },1000);

  async function submitAll(){
    for(const q of qs){ const ans = document.getElementById('ans_'+q.id).value; const fd = new URLSearchParams(); fd.append('attempt_id', attemptId); fd.append('question_id', q.id); fd.append('answer', ans); await api('submit_answer', fd); }
    const fd2 = new URLSearchParams(); fd2.append('attempt_id', attemptId); const res = await api('finish_attempt', fd2); alert('Prüfung beendet Dauer Sek ' + res.duration); location.href = './'; }

  document.getElementById('finishBtn').addEventListener('click', async ()=>{ if(confirm('Prüfung wirklich beenden')){ submitAll(); }});
}
</script>
<div class="footer" style="text-align:center;color:#9aa4b2;margin-top:20px;font-size:13px;">
    Powered by <a href="https://www.dreamcodes.net" target="_blank" style="color:#06b6d4;">Dreamcodes</a>
</div>
</body>
</html>

Dreamcodes

Zum Newsletter anmelden

Movies

TV Shows

Music

Celebrity

Scandals

Drama

Lifestyle

Health

Technology

Company