Gecko [ dp-client.com ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
inc	[ DIR ]	drwxr-xr-x
page	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
add-blog-category-child.php	4.49 KB	-rw-r--r--
add-blog-category.php	3.58 KB	-rw-r--r--
add-blog-post.php	6.97 KB	-rw-r--r--
add-product.php	2.73 KB	-rw-r--r--
auth-login.php	3.71 KB	-rw-r--r--
blog-category-dashboard.php	5.25 KB	-rw-r--r--
blog-post-celebrity-style.php	5.98 KB	-rw-r--r--
blog-post-dashboard.php	4.73 KB	-rw-r--r--
blog-post-preferences.php	6.01 KB	-rw-r--r--
delete-category.php	667 B	-rw-r--r--
delete-post.php	656 B	-rw-r--r--
delete-product.php	650 B	-rw-r--r--
delete-subscriber.php	662 B	-rw-r--r--
edit-category.php	5.59 KB	-rw-r--r--
edit-post.php	7.61 KB	-rw-r--r--
edit-product.php	3.58 KB	-rw-r--r--
index.html	131 B	-rw-r--r--
index.php	758 B	-rw-r--r--
logout.php	102 B	-rw-r--r--
products.php	4.61 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x
save-category.php	1.61 KB	-rw-r--r--
save-child-category.php	1.69 KB	-rw-r--r--
save-post.php	2.43 KB	-rw-r--r--
save-preferences-must-read.php	1 KB	-rw-r--r--
save-preferences-style-prefere...	1.01 KB	-rw-r--r--
save-product.php	1.53 KB	-rw-r--r--
subscribers.php	3.81 KB	-rw-r--r--
update-category.php	2.23 KB	-rw-r--r--
update-post.php	2.94 KB	-rw-r--r--
update-product.php	1.67 KB	-rw-r--r--
uploadImage.php	120 B	-rw-r--r--

Code Editor : update-post.php

<?php
require_once "../includes/start.php";
require_once "../includes/config.php";
$connection = mysqli_connect('localhost', 'dpclient_itailor', 'dAm#VbbjzoYxdAm#VbbjzoYxdAm#VbbjzoYxdAm#VbbjzoYx', 'dpclient_itailor');
if ($_SERVER["REQUEST_METHOD"] === "POST") {
    extract($_POST);

$cat_uri = mysqli_real_escape_string($connection, cleanVal($cat_uri));

$name = mysqli_real_escape_string($connection, cleanVal($name));

$target_dir = '../upload/media/';

if ($_FILES["thumbnail"]["error"] === UPLOAD_ERR_OK) {
        $thumbnailFileName = uniqid("thumbnail_") . "_" . $_FILES["thumbnail"]["name"];
        move_uploaded_file($_FILES["thumbnail"]["tmp_name"], $target_dir . $thumbnailFileName);
        $thumbnailUrl = "upload/media/" . $thumbnailFileName;
    }

// Handle Cover Upload
    if ($_FILES["cover"]["error"] === UPLOAD_ERR_OK) {
        $coverFileName = uniqid("cover_") . "_" . $_FILES["cover"]["name"];
        move_uploaded_file($_FILES["cover"]["tmp_name"], $target_dir . $coverFileName);
        $coverUrl = "upload/media/" . $coverFileName;
    }

// debug($thumbnailUrl);
    // debug($coverUrl, true);

$uri = s2u($name);
    $summery = mysqli_real_escape_string($connection, $summery);
    $content = mysqli_real_escape_string($connection, $editor);
    $title = mysqli_real_escape_string($connection, cleanVal($title));
    $description = mysqli_real_escape_string($connection, cleanVal($description));
    $keywords = mysqli_real_escape_string($connection, cleanVal($keywords));

// SQL query to update the values in the "blog_cat" table

if ($_FILES["thumbnail"]["error"] === UPLOAD_ERR_OK || $_FILES["cover"]["error"] === UPLOAD_ERR_OK) {
        $sql = "UPDATE blog_post SET 
            cat_uri = '$cat_uri', 
            thumbnail = '$thumbnailUrl', 
            cover = '$coverUrl', 
            name = '$name',
            uri = '$uri',
            summery = '$summery',
            content = '$content',
            seo_title = '$title',
            seo_description = '$description',
            seo_keywords = '$keywords'
        WHERE id = '$id'";
    } else {
        $sql = "UPDATE blog_post SET 
            cat_uri = '$cat_uri',
            name = '$name',
            uri = '$uri',
            summery = '$summery',
            content = '$content',
            seo_title = '$title',
            seo_description = '$description',
            seo_keywords = '$keywords'
        WHERE id = '$id'";
    }

// Execute the query
    if (mysqli_query($connection, $sql)) {
        setMsg('success', 'Post Updated!', 'The post has been updated successfully.');
    } else {
        setMsg('error', 'Error Occurred!', 'Unable to process the request!');
    }
    // Close the database connection
    mysqli_close($connection);
    header("location: blog-post-dashboard.php");

} else {
    // The form has not been submitted
    echo "Form not submitted.";
}
?>

${this.title}

Code Editor : update-post.php