query("DESCRIBE " . $dbTable); $columnNames = $stmt->fetchAll(PDO::FETCH_COLUMN); if (!in_array($primaryKeyColumn, $columnNames) && !empty($columnNames)) { $primaryKeyColumn = $columnNames[0]; } } catch (PDOException $e) { error_log("Error describing table for columns: " . $e->getMessage()); $columnNames = []; } } $formEditableColumns = array_filter($columnNames, function($col) use ($primaryKeyColumn) { return $col !== 'created_at' && $col !== 'updated_at'; }); $jsTableName = json_encode($dbTable); $jsPrimaryKeyColumn = json_encode($primaryKeyColumn); $jsFormEditableColumns = json_encode(array_values($formEditableColumns)); $jsAllColumnNames = json_encode(array_values($columnNames)); ?> Data Table Viewer

Tips Table Viewer

No records found and no column information available. Please ensure the table exists or add some data.
No records found. Click "Add New Record" to get started!
Actions
Actions