25 lines
810 B
PHP
25 lines
810 B
PHP
<?php
|
|
header('Content-Type: application/json; charset=utf-8');
|
|
|
|
// db_conn.php 로드 전에 IP 확인
|
|
$dbIp = gethostbyname('db');
|
|
|
|
// main_data.php 를 통한 실제 변수 확인
|
|
require_once __DIR__ . '/bbs/main_data.php';
|
|
|
|
// main_data.php 실행 후 실제 연결된 DB 확인
|
|
try {
|
|
$pdo2 = db_conn();
|
|
$connInfo = $pdo2->query("SELECT @@hostname h, CONNECTION_ID() cid,
|
|
(SELECT GROUP_CONCAT(keyword_name ORDER BY created_at DESC) FROM user_keywords WHERE member_id='U001') as all_kw")->fetch();
|
|
} catch (Exception $e) {
|
|
$connInfo = ['error' => $e->getMessage()];
|
|
}
|
|
|
|
echo json_encode([
|
|
'db_resolved_ip' => $dbIp,
|
|
'conn_info' => $connInfo,
|
|
'myKeywords' => $myKeywords,
|
|
'myKwJson' => json_decode($myKwJson),
|
|
], JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT);
|