11 lines
730 B
PHP
11 lines
730 B
PHP
<?php
|
|
$pdo = new PDO('mysql:host=baroncs.co.kr;port=3306;dbname=baronhomep;charset=utf8mb4','baronhomep','baron3840!!');
|
|
echo "=== edu_contents category_code 현황 ===\n";
|
|
$rows = $pdo->query("SELECT content_id, category_code, category_group, title FROM edu_contents ORDER BY content_id")->fetchAll(PDO::FETCH_ASSOC);
|
|
foreach($rows as $r) {
|
|
echo $r['content_id'].' | cat='.$r['category_code'].' | grp='.$r['category_group'].' | '.$r['title']."\n";
|
|
}
|
|
echo "\n=== edu_content_keywords 현황 (첫 20개) ===\n";
|
|
$rows2 = $pdo->query("SELECT content_id, keyword_code FROM edu_content_keywords ORDER BY content_id LIMIT 20")->fetchAll(PDO::FETCH_ASSOC);
|
|
foreach($rows2 as $r) echo $r['content_id'].' | '.$r['keyword_code']."\n";
|