MAINHACK

Viewing / Editing File: save_group_results.php

<?php
require_once '../config/database.php';

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $competition_id = $_POST['competition_id'];
    $results = json_decode($_POST['results'], true);
    
    try {
        $pdo->beginTransaction();
        
        foreach ($results as $result) {
            foreach ($result['students'] as $student) {
                $stmt = $pdo->prepare("
                    INSERT INTO game_results (competition_id, student_name, group_name, final_score, game_type, completed_at)
                    VALUES (?, ?, ?, ?, 'group', NOW())
                ");
                $stmt->execute([
                    $competition_id,
                    $student,
                    $result['group_name'],
                    $result['score']
                ]);
            }
        }
        
        $pdo->commit();
        echo json_encode(['success' => true]);
        
    } catch (Exception $e) {
        $pdo->rollBack();
        echo json_encode(['success' => false, 'error' => $e->getMessage()]);
    }
} else {
    echo json_encode(['success' => false, 'error' => 'Invalid request method']);
}
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: save_group_results.php

Server Info

System Features

User Info