30 lines
1.4 KiB
PHP
30 lines
1.4 KiB
PHP
<?php
|
|
require_once __DIR__ . '/db_conn.php';
|
|
header('Content-Type: text/plain; charset=utf-8');
|
|
|
|
$pdo = db_conn();
|
|
|
|
echo "[COLUMNS]\n";
|
|
$cols = $pdo->query('SHOW COLUMNS FROM edu_contents')->fetchAll(PDO::FETCH_ASSOC);
|
|
foreach ($cols as $c) {
|
|
echo $c['Field'] . '|' . $c['Type'] . PHP_EOL;
|
|
}
|
|
|
|
echo "\n[SAMPLES_WITH_DESC]\n";
|
|
$rows = $pdo->query("SELECT content_id, title, description, goal_code, category_group, category_code, sort_order, is_active
|
|
FROM edu_contents
|
|
WHERE is_active = '1' AND CHAR_LENGTH(TRIM(COALESCE(description, ''))) >= 5
|
|
ORDER BY updated_at DESC, created_at DESC
|
|
LIMIT 20")->fetchAll(PDO::FETCH_ASSOC);
|
|
foreach ($rows as $r) {
|
|
$id = isset($r['content_id']) ? (string)$r['content_id'] : '';
|
|
$title = isset($r['title']) ? (string)$r['title'] : '';
|
|
$desc = isset($r['description']) ? (string)$r['description'] : '';
|
|
$goal = isset($r['goal_code']) ? (string)$r['goal_code'] : '';
|
|
$group = isset($r['category_group']) ? (string)$r['category_group'] : '';
|
|
$cate = isset($r['category_code']) ? (string)$r['category_code'] : '';
|
|
$sort = isset($r['sort_order']) ? (string)$r['sort_order'] : '';
|
|
$active = isset($r['is_active']) ? (string)$r['is_active'] : '';
|
|
echo $id . '|' . $title . '|' . preg_replace('/\s+/', ' ', $desc) . '|goal=' . $goal . '|group=' . $group . '|cate=' . $cate . '|sort=' . $sort . '|active=' . $active . PHP_EOL;
|
|
}
|