query("DESCRIBE " . $dbTable); $columnNames = $stmt->fetchAll(PDO::FETCH_COLUMN); // Get detailed column schema for validation $stmt = $pdo->prepare("SELECT COLUMN_NAME, IS_NULLABLE, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = :dbName AND TABLE_NAME = :tableName"); $stmt->execute([':dbName' => $dbName, ':tableName' => $dbTable]); $schemaResult = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($schemaResult as $col) { $columnSchema[$col['COLUMN_NAME']] = [ 'is_nullable' => ($col['IS_NULLABLE'] === 'YES'), 'data_type' => $col['DATA_TYPE'], 'max_length' => $col['CHARACTER_MAXIMUM_LENGTH'] ]; } } catch (Exception $e) { error_log("Error fetching database schema: " . $e->getMessage()); // Fallback if schema fetch fails: assume all columns are nullable text if (empty($columnNames) && !empty($rows)) { $columnNames = array_keys($rows[0]); } foreach ($columnNames as $colName) { $columnSchema[$colName] = ['is_nullable' => true, 'data_type' => 'text', 'max_length' => null]; } } // Filter out columns that should NOT be in the add/edit form (e.g., auto-increment ID on add, timestamps) $formEditableColumns = array_filter($columnNames, function($col) use ($primaryKeyColumn) { return $col !== 'created_at' && $col !== 'updated_at' && $col !== $primaryKeyColumn; // Exclude PK for add form }); foreach ($columnNames as $col) { if ($col === 'created_at') { $columnSchema[$col]['is_readonly_add'] = true; // Ensure created_at is readonly $columnSchema[$col]['default_value_add'] = date('Y-m-d H:i:s'); // Default to current date-time } if ($col === 'updated_at') { $columnSchema[$col]['is_readonly_add'] = false; // Allow updated_at to be editable $columnSchema[$col]['default_value_add'] = date('Y-m-d H:i:s'); // Default to current date-time } if ($col === 'tipMod') { $columnSchema[$col]['is_readonly_add'] = true; // Make tipMod readonly $columnSchema[$col]['default_value_add'] = date('Y-m-d H:i:s'); // Set to current date-time } } // Pass default values for add form to JS $jsDefaultValuesAdd = json_encode(array_reduce($columnNames, function($carry, $col) use ($columnSchema) { if (isset($columnSchema[$col]['default_value_add'])) { $carry[$col] = $columnSchema[$col]['default_value_add']; } return $carry; }, [])); // Pass PHP variables to JavaScript $jsTableName = json_encode($dbTable); $jsPrimaryKeyColumn = json_encode($primaryKeyColumn); $jsFormEditableColumns = json_encode(array_values($formEditableColumns)); // Columns for the ADD form $jsAllColumnNames = json_encode(array_values($columnNames)); // All columns for the EDIT form display $jsColumnSchema = json_encode($columnSchema); // Detailed schema for validation $jsDefaultValuesAdd = json_encode(array_reduce($columnNames, function($carry, $col) use ($columnSchema) { if (isset($columnSchema[$col]['default_value_add'])) { $carry[$col] = $columnSchema[$col]['default_value_add']; } return $carry; }, [])); // Helper function (assuming it's not already in connDb.php) if (!function_exists('formatCell')) { function formatCell($value) { if ($value === null) { return 'NULL'; } if (preg_match('/^\d{4}-\d{2}-\d{2}( \d{2}:\d{2}:\d{2})?$/', $value)) { return '' . htmlspecialchars($value) . ''; } if (strlen($value) > 100) { return htmlspecialchars(substr($value, 0, 100)) . '...'; } return htmlspecialchars($value); } } ?> 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