<?php
require_once __DIR__ . '/bbs/db_conn.php';

echo "=== edu_contents 컬럼 ===\n";
$rst = db_conn()->query("DESCRIBE edu_contents");
foreach ($rst->fetchAll(PDO::FETCH_ASSOC) as $row) {
  echo $row['Field'] . " - " . $row['Type'] . "\n";
}

echo "\n=== edu_contents 샘플 데이터 ===\n";
$rows = db_conn()->query("SELECT * FROM edu_contents LIMIT 1")->fetchAll(PDO::FETCH_ASSOC);
if (count($rows) > 0) {
  foreach (array_keys($rows[0]) as $col) {
    echo "- " . $col . "\n";
  }
}

echo "\n=== edu_learning_goals 컬럼 ===\n";
$rst = db_conn()->query("DESCRIBE edu_learning_goals");
foreach ($rst->fetchAll(PDO::FETCH_ASSOC) as $row) {
  echo $row['Field'] . " - " . $row['Type'] . "\n";
}
?>