SkillPath-AI/seed_questions_full.php at main · ayuryntii/SkillPath-AI · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
<?php
require_once 'config/database.php';

$questions = [
    // Laravel (ID: 3)
    [3, "Apa perintah artisan untuk membuat controller baru?", "make:controller", "create:controller", "generate:controller", "new:controller", "a", "basic"],
    [3, "File mana yang digunakan untuk mendefinisikan route web di Laravel 8+?", "routes.php", "web.php", "api.php", "routes/web.php", "d", "basic"],
    [3, "Apa kegunaan Eloquent dalam Laravel?", "Templating Engine", "ORM (Object-Relational Mapper)", "Dependency Injection", "Database Migration", "b", "basic"],
    [3, "Middleware di Laravel digunakan untuk...", "Database seeding", "Filtering HTTP requests", "Frontend styling", "API documentation", "b", "basic"],

    // Data Analysis with Pandas (ID: 5)
    [5, "Fungsi mana yang digunakan untuk membaca file CSV di Pandas?", "read_file()", "read_csv()", "load_csv()", "open_csv()", "b", "basic"],
    [5, "Apa itu DataFrame dalam Pandas?", "Array 1D", "Struktur data 2D seperti tabel", "Dictionary 3D", "Graph data structure", "b", "basic"],
    [5, "Metode mana yang digunakan untuk melihat 5 baris pertama data?", "show()", "first()", "head()", "top()", "c", "basic"],

    // Machine Learning (ID: 6)
    [6, "Manakah yang merupakan algoritma Supervised Learning?", "K-Means", "Linear Regression", "PCA", "DBSCAN", "b", "basic"],
    [6, "Apa tujuan dari 'Training Data' dalam Machine Learning?", "Mengevaluasi model", "Mengajar model mengenali pola", "Menyimpan hasil prediksi", "Visualisasi data", "b", "basic"],
    [6, "Library Python mana yang paling populer untuk traditional ML?", "TensorFlow", "Scikit-Learn", "PyTorch", "Keras", "b", "basic"],

    // Deep Learning (ID: 7)
    [7, "Apa unit dasar dari Neural Network?", "Node / Neuron", "Layer", "Weight", "Bias", "a", "basic"],
    [7, "Activation function mana yang sering digunakan untuk hidden layers?", "Linear", "ReLU", "Step", "Sine", "b", "basic"],
    [7, "Apa kegunaan Optimizer dalam training Neural Network?", "Inisialisasi beban", "Memperbarui beban untuk meminimalkan loss", "Meningkatkan jumlah epoch", "Normalisasi data", "b", "basic"],

    // Problem Solving (ID: 8)
    [8, "Apa itu Big O Notation?", "Waktu eksekusi program dalam detik", "Kompleksitas algoritma", "Jumlah baris kode", "Kecepatan internet", "b", "basic"],
    [8, "Manakah yang merupakan struktur data LIFO?", "Queue", "Stack", "Linked List", "Tree", "b", "basic"],
    [8, "Algoritma sorting mana yang memiliki average case O(n log n)?", "Bubble Sort", "Insertion Sort", "Quick Sort", "Selection Sort", "c", "basic"],

    // Cloud Computing (ID: 9)
    [9, "Apa kepanjangan dari SaaS?", "Software as a Server", "Software as a Service", "System as a Service", "Storage as a Service", "b", "basic"],
    [9, "Manakah yang merupakan layanan Cloud dari Amazon?", "Azure", "GCP", "AWS", "DigitalOcean", "c", "basic"],
    [9, "Apa itu Virtualization dalam Cloud?", "Membuat simulasi hardware", "Menghapus server fisik", "Meningkatkan kecepatan RAM", "Backup data otomatis", "a", "basic"],

    // Cyber Security Fundamentals (ID: 10)
    [10, "Apa itu Phishing?", "Serangan fisik ke server", "Penipuan untuk mencuri informasi sensitif", "Proses enkripsi data", "Uji coba penetrasi", "b", "basic"],
    [10, "Apa kepanjangan dari SQLi?", "SQL Integration", "SQL Injection", "SQL Interaction", "SQL Implementation", "b", "basic"],
    [10, "Manakah yang merupakan metode Multi-Factor Authentication?", "Password saja", "Password + Kode OTP", "Username saja", "Captcha saja", "b", "basic"],

    // Mobile App Development (ID: 11)
    [11, "Bahasa pemrograman utama untuk Flutter adalah...", "Swift", "Dart", "Kotlin", "Java", "b", "basic"],
    [11, "Framework mana yang dikembangkan oleh Facebook untuk Mobile cross-platform?", "Flutter", "React Native", "Ionic", "Xamarin", "b", "basic"],
    [11, "Apa itu APK?", "Format aplikasi iOS", "Format aplikasi Android", "Script database", "Bahasa styling mobile", "b", "basic"],

    // Java Programming (ID: 12)
    [12, "Keyword mana yang digunakan untuk membuat object di Java?", "create", "new", "make", "instanceof", "b", "basic"],
    [12, "Apa output dari print 10 + 20 + \"Java\"?", "30Java", "1020Java", "Error", "Java30", "a", "basic"],
    [12, "Manakah access modifier yang paling ketat di Java?", "public", "protected", "private", "default", "c", "basic"]
];

echo "Seeding additional questions...\n";

foreach ($questions as $q) {
    $skill_id = $q[0];
    $text = mysqli_real_escape_string($conn, $q[1]);
    $oa = mysqli_real_escape_string($conn, $q[2]);
    $ob = mysqli_real_escape_string($conn, $q[3]);
    $oc = mysqli_real_escape_string($conn, $q[4]);
    $od = mysqli_real_escape_string($conn, $q[5]);
    $correct = $q[6];
    $diff = $q[7];

    $check = mysqli_query($conn, "SELECT id FROM skill_questions WHERE question_text = '$text' AND skill_id = $skill_id");
    if (mysqli_num_rows($check) == 0) {
        $insert = "INSERT INTO skill_questions (skill_id, question_text, option_a, option_b, option_c, option_d, correct_option, difficulty)
                   VALUES ($skill_id, '$text', '$oa', '$ob', '$oc', '$od', '$correct', '$diff')";
        mysqli_query($conn, $insert);
    }
}

echo "All questions seeded successfully!\n";
?>