setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->exec("CREATE TABLE IF NOT EXISTS notes (
id INTEGER PRIMARY KEY AUTOINCREMENT,
msg TEXT NOT NULL,
created_at TEXT NOT NULL
)");
$count = (int)$pdo->query("SELECT COUNT(*) FROM notes")->fetchColumn();
if ($count === 0) {
$stmt = $pdo->prepare("INSERT INTO notes (msg, created_at) VALUES (?, datetime('now'))");
$stmt->execute(["Hello from Hugging Face Space"]);
}
$rows = $pdo->query("SELECT id, msg, created_at FROM notes ORDER BY id DESC LIMIT 10")
->fetchAll(PDO::FETCH_ASSOC);
?>
PHP + SQLite on Hugging Face
PHP + SQLite (Hugging Face Docker Space)
DB Path:
prepare("INSERT INTO notes (msg, created_at) VALUES (?, datetime('now'))");
$stmt->execute([$m]);
header("Location: " . $_SERVER["REQUEST_URI"]);
exit;
}
}
?>
Son 10 kayıt
Not: Free tier’da disk ephemeraldir; restart/stop sonrasi DB sıfırlanabilir.