29 lines
948 B
PHP
29 lines
948 B
PHP
<?php
|
|
require_once __DIR__ . '/db_conn.php';
|
|
header('Content-Type: text/plain; charset=utf-8');
|
|
|
|
$pdo = db_conn();
|
|
$sql = "SELECT rg.goal_code,
|
|
rg.seq,
|
|
rg.title AS rg_title,
|
|
rg.description AS rg_desc,
|
|
c.sort_order,
|
|
c.title AS c_title,
|
|
c.description AS c_desc
|
|
FROM edu_recommended_goals rg
|
|
LEFT JOIN edu_contents c
|
|
ON c.goal_code = rg.goal_code
|
|
AND c.sort_order = rg.seq
|
|
AND c.is_active = '1'
|
|
WHERE rg.is_active = '1'
|
|
ORDER BY rg.goal_code ASC, rg.seq ASC";
|
|
$rows = $pdo->query($sql)->fetchAll(PDO::FETCH_ASSOC);
|
|
foreach ($rows as $r) {
|
|
echo ($r['goal_code'] ?? '') . '#' . ($r['seq'] ?? '')
|
|
. ' | rg_title=' . ($r['rg_title'] ?? '')
|
|
. ' | rg_desc=' . ($r['rg_desc'] ?? '')
|
|
. ' | c_title=' . ($r['c_title'] ?? '')
|
|
. ' | c_desc=' . ($r['c_desc'] ?? '')
|
|
. PHP_EOL;
|
|
}
|