connect_error) { die("Connection failed: " . $conn->connect_error); } // Handle table selection $tableName = isset($_GET['table']) ? $conn->real_escape_string($_GET['table']) : null; // Handle editing a row if (isset($_POST['edit'])) { $id = $conn->real_escape_string($_POST['id']); $updateValues = []; foreach ($_POST as $key => $value) { if (strpos($key, 'value_') === 0) { $column = str_replace('value_', '', $key); $updateValues[] = "`$column` = '" . $conn->real_escape_string($value) . "'"; } } if (!empty($updateValues)) { $updateSql = "UPDATE `$tableName` SET " . implode(', ', $updateValues) . " WHERE id = $id"; if ($conn->query($updateSql) === TRUE) { echo "

Record updated successfully

"; } else { echo "

Error updating record: " . $conn->error . "

"; } } else { echo "

No values to update.

"; } } // Handle deletion of a row if (isset($_POST['delete'])) { $id = $conn->real_escape_string($_POST['id']); $deleteSql = "DELETE FROM `$tableName` WHERE id = $id"; if ($conn->query($deleteSql) === TRUE) { echo "

Record deleted successfully

"; } else { echo "

Error deleting record: " . $conn->error . "

"; } } // Handle insertion of a new row if (isset($_POST['insert'])) { $columns = []; $values = []; foreach ($_POST as $key => $value) { if (strpos($key, 'new_value_') === 0) { $column = str_replace('new_value_', '', $key); $columns[] = "`$column`"; $values[] = "'" . $conn->real_escape_string($value) . "'"; } } if (!empty($columns) && !empty($values)) { $insertSql = "INSERT INTO `$tableName` (" . implode(', ', $columns) . ") VALUES (" . implode(', ', $values) . ")"; if ($conn->query($insertSql) === TRUE) { echo "

Record inserted successfully

"; } else { echo "

Error inserting record: " . $conn->error . "

"; } } else { echo "

No values to insert.

"; } } // Handle export if (isset($_POST['export'])) { $selectedColumns = isset($_POST['columns']) ? $_POST['columns'] : []; if (!empty($selectedColumns)) { $columnsList = implode(', ', array_map([$conn, 'real_escape_string'], $selectedColumns)); $exportSql = "SELECT $columnsList FROM `$tableName`"; $result = $conn->query($exportSql); if ($result && $result->num_rows > 0) { $filename = $tableName . '_export_' . date('Ymd') . '.csv'; header('Content-Type: text/csv'); header('Content-Disposition: attachment;filename="' . $filename . '"'); $output = fopen('php://output', 'w'); fputcsv($output, $selectedColumns); while ($row = $result->fetch_assoc()) { fputcsv($output, array_intersect_key($row, array_flip($selectedColumns))); } fclose($output); exit; } else { echo "

No data found for export

"; } } else { echo "

No columns selected for export.

"; } } // Query to get table names $tablesResult = $conn->query("SHOW TABLES"); if ($tableName) { $dataResult = $conn->query("SELECT * FROM `$tableName`"); if (!$dataResult) { die("

Error retrieving data: " . $conn->error . "

"); } } ?> Database Table Editor

Database Table Editor

num_rows > 0) { while($row = $tablesResult->fetch_array()) { $table = $row[0]; echo ""; } } else { echo ""; } ?>

Table Name
" . htmlspecialchars($table) . "
No tables found

Data for Table:

fetch_fields(); foreach ($fields as $field) { echo ""; } echo ""; ?> data_seek(0); // Reset pointer to the beginning while ($row = $dataResult->fetch_assoc()) { echo ""; $id = $row['id']; // Assuming 'id' is the primary key foreach ($row as $column => $value) { echo ""; } echo ""; echo ""; } ?>

" . htmlspecialchars($field->name) . "	Action

Insert New Record

Export Table Data

close(); ?>