24 lines
703 B
PHP
24 lines
703 B
PHP
<?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";
|
|
}
|
|
?>
|