23 lines
1.1 KiB
PHP
23 lines
1.1 KiB
PHP
<?php
|
|
try {
|
|
$pdo = new PDO('mysql:host=baroncs.co.kr;port=3306;dbname=baronhomep;charset=utf8mb4', 'baronhomep', 'baron3840!!', [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
|
|
$pdo->exec("SET NAMES utf8mb4");
|
|
|
|
$sql = file_get_contents(__DIR__ . '/../sample_content_keywords.sql');
|
|
$pdo->exec($sql);
|
|
|
|
$cnt = $pdo->query('SELECT COUNT(*) FROM edu_content_keywords')->fetchColumn();
|
|
echo json_encode(['status' => 'ok', 'inserted_total' => (int)$cnt], JSON_UNESCAPED_UNICODE) . PHP_EOL;
|
|
|
|
// 키워드별 매핑 건수 확인
|
|
$rows = $pdo->query('SELECT keyword_code, COUNT(*) as cnt FROM edu_content_keywords GROUP BY keyword_code ORDER BY cnt DESC')->fetchAll(PDO::FETCH_ASSOC);
|
|
echo json_encode($rows, JSON_UNESCAPED_UNICODE) . PHP_EOL;
|
|
|
|
// recommend_keywords 확인
|
|
$rk = $pdo->query('SELECT * FROM edu_recommend_keywords')->fetchAll(PDO::FETCH_ASSOC);
|
|
echo json_encode($rk, JSON_UNESCAPED_UNICODE) . PHP_EOL;
|
|
|
|
} catch (Exception $e) {
|
|
echo json_encode(['status' => 'error', 'message' => $e->getMessage()], JSON_UNESCAPED_UNICODE) . PHP_EOL;
|
|
}
|