.-.-.-.-.-

<?php
require_once 'wp-load.php';

global $wpdb;

$option_name = 'houzez_options_ar';
$table = $wpdb->options;

echo '<pre>';
echo "TABLE: {$table}\n";
echo "OPTION: {$option_name}\n\n";

$before = get_option($option_name);
echo "BEFORE:\n";
var_dump($before['houzez_subject_free_submission_listing_ar'] ?? null);
var_dump($before['houzez_free_submission_listing_ar'] ?? null);

if (!is_array($before)) {
    $before = array();
}

$before['houzez_subject_free_submission_listing_ar'] = 'اختبار مباشر AR 12345';
$before['houzez_free_submission_listing_ar'] = "هذا اختبار مباشر AR 12345\nعنوان الإعلان: %listing_title\nرابط الإعلان: %listing_url\nمعرّف الإعلان: %listing_id";

$serialized = maybe_serialize($before);

$updated = $wpdb->update(
    $table,
    array(
        'option_value' => $serialized,
    ),
    array(
        'option_name' => $option_name,
    ),
    array('%s'),
    array('%s')
);

wp_cache_delete($option_name, 'options');
wp_cache_delete('alloptions', 'options');

$after = get_option($option_name);

echo "\nDB UPDATE RESULT:\n";
var_dump($updated);

echo "\nAFTER:\n";
var_dump($after['houzez_subject_free_submission_listing_ar'] ?? null);
var_dump($after['houzez_free_submission_listing_ar'] ?? null);

echo "\nRAW DB CHECK:\n";
$raw = $wpdb->get_var(
    $wpdb->prepare(
        "SELECT option_value FROM {$table} WHERE option_name = %s LIMIT 1",
        $option_name
    )
);
echo substr((string) $raw, 0, 500);

echo "\n</pre>";

/home/zoomride2022/public_html/syraqarat.com/force-check-ar.php