HEX
Server: Apache/2.4.41 (Ubuntu)
System: Linux wordpress-ubuntu-s-2vcpu-4gb-fra1-01 5.4.0-169-generic #187-Ubuntu SMP Thu Nov 23 14:52:28 UTC 2023 x86_64
User: root (0)
PHP: 7.4.33
Disabled: pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
Upload Files
File: /var/www/zaklada/wp-content/plugins/coming-soon/resources/views/importexport.php
<?php
        $post_id = absint($_GET['id']);


        if (!empty($_POST['sp_post_json'])) {
            // update
            global $wpdb;
            $json = json_decode(stripslashes($_POST['sp_post_json']));
            if (json_last_error() !== JSON_ERROR_NONE) {
                wp_die('JSON is NOT valid');
            }
            $json = json_encode($json);
            $tablename = $wpdb->prefix . 'posts';
            $r = $wpdb->update(
                $tablename,
                array(
                'post_content_filtered' => $json,	// string
            ),
                array( 'ID' => $post_id ),
                array(
                '%s',	// value1
            ),
                array( '%d' )
            );
            if ($r === false) {
                echo 'Update error'. PHP_EOL;
            } else {
                echo 'Updated'. PHP_EOL;
            }
        }

        global $wpdb;
        $tablename = $wpdb->prefix . 'posts';
        $sql = "SELECT * FROM $tablename";
        $sql .= " WHERE ID = %s" ;
        $safe_sql = $wpdb->prepare($sql, $post_id);
        $result = $wpdb->get_row($safe_sql);


        $js = json_decode($result->post_content_filtered);
        if (json_last_error() === JSON_ERROR_NONE) {
            echo 'JSON is valid'. PHP_EOL;
        } else {
            echo 'JSON is NOT valid'. PHP_EOL;
        }

    
?>
<form method="post">
<h1>Post JSON</h1>
<textarea name="sp_post_json" style="width:100%; height: 500px;"><?php echo $result->post_content_filtered; ?></textarea>
<input type="submit">
</form>