10 lines
545 B
PHP
10 lines
545 B
PHP
<?php
|
|
$pdo = new PDO('mysql:host=baroncs.co.kr;port=3306;dbname=baronhomep;charset=utf8mb4','baronhomep','baron3840!!');
|
|
echo "=== content_url & thumbnail_url 현황 ===\n";
|
|
$rows = $pdo->query("SELECT content_id, content_url, thumbnail_url, is_active, is_offer FROM edu_contents ORDER BY content_id")->fetchAll(PDO::FETCH_ASSOC);
|
|
foreach($rows as $r) {
|
|
echo sprintf("%-20s | is_offer=%-2s | is_active=%-2s | url=%-40s | thumb=%s\n",
|
|
$r['content_id'], $r['is_offer'], $r['is_active'], $r['content_url'], $r['thumbnail_url']
|
|
);
|
|
}
|