verify_migration.php

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

// Clean up old assessment data to ensure fresh testing
$user_id = 1; // Assuming user_id 1 is the test student
mysqli_query($conn, "DELETE FROM assessment WHERE user_id = $user_id");
mysqli_query($conn, "DELETE FROM assessment_answers WHERE user_id = $user_id");
mysqli_query($conn, "DELETE FROM rekomendasi WHERE user_id = $user_id");

// Verify skills
$res = mysqli_query($conn, "SELECT COUNT(*) as count FROM skills");
$row = mysqli_fetch_assoc($res);
echo "Total Skills: " . $row['count'] . "\n";

// Verify questions
$res = mysqli_query($conn, "SELECT skill_id, COUNT(*) as count FROM skill_questions GROUP BY skill_id");
while($row = mysqli_fetch_assoc($res)) {
    echo "Skill ID {$row['skill_id']} has {$row['count']} questions\n";
}

echo "Cleanup and verification complete.\n";
?>