22 lines
637 B
PHP
22 lines
637 B
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_recommended_goals')->fetchAll(PDO::FETCH_ASSOC);
|
|
foreach ($cols as $c) {
|
|
echo $c['Field'] . '|' . $c['Type'] . PHP_EOL;
|
|
}
|
|
|
|
echo "\n[SAMPLES]\n";
|
|
$rows = $pdo->query('SELECT * FROM edu_recommended_goals ORDER BY 1 ASC LIMIT 30')->fetchAll(PDO::FETCH_ASSOC);
|
|
foreach ($rows as $r) {
|
|
$pairs = [];
|
|
foreach ($r as $k => $v) {
|
|
$pairs[] = $k . '=' . str_replace(["\r", "\n"], ' ', (string)$v);
|
|
}
|
|
echo implode(' | ', $pairs) . PHP_EOL;
|
|
}
|