query("PRAGMA table_info($table)");
while ($row = $columnsResult->fetchArray(SQLITE3_ASSOC)) {
$columns[] = $row['name'];
}
$stmt = $db->prepare("SELECT * FROM $table WHERE id = :id");
$stmt->bindValue(':id', $id, SQLITE3_INTEGER);
$result = $stmt->execute();
if ($result) {
$row = $result->fetchArray(SQLITE3_ASSOC);
} else {
$row = null;
}
if (isset($_POST['save_changes'])) {
foreach ($columns as $column) {
$value = $_POST[$column] ?: null;
if ($column == 'date' && empty($value)) {
$value = date('Y-m-d H:i:s');
}
if ($table == 'content' && $column == 'custom_html') {
$value = $value ? 1 : 0;
}
$stmt = $db->prepare("UPDATE $table SET $column = :value WHERE id = :id");
$stmt->bindValue(':value', $value, SQLITE3_TEXT);
$stmt->bindValue(':id', $id, SQLITE3_INTEGER);
$stmt->execute();
}
header("Location: edit_database.php?table=$table");
exit();
}
?>
Edit Row
Edit Row in Table:
Back to Table