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>