<?php
$conn = new mysqli('host117523.hostido.net.pl', 'host117523_wyszynskiego12pagedevpl', 'yZs52KdErtTk9KmZ8XGq', 'host117523_wyszynskiego12pagedevpl');
if ($conn->connect_error) { die('Blad: ' . $conn->connect_error); }

echo "=== APARTAMENTY + ACF price fields ===\n";
$sql = "SELECT p.ID, p.post_title, pm.meta_key, pm.meta_value
    FROM wp_posts p
    JOIN wp_postmeta pm ON p.ID = pm.post_id
    WHERE p.post_type = 'apartamenty'
    AND p.post_status = 'publish'
    AND pm.meta_key = 'information'
    ORDER BY p.post_title LIMIT 5";
$r = $conn->query($sql);
while($row = $r->fetch_assoc()) {
    echo $row['ID'] . ' | ' . $row['post_title'] . "\n";
    $data = maybe_unserialize($row['meta_value']);
    if (is_array($data)) {
        echo "  price: " . ($data['price'] ?? 'brak') . "\n";
        echo "  price_m2: " . ($data['price_m2'] ?? 'brak') . "\n";
    } else {
        echo "  raw: " . substr($row['meta_value'], 0, 300) . "\n";
    }
}

echo "\n=== WSZYSTKIE meta_key dla apartamentu ===\n";
$sql2 = "SELECT DISTINCT pm.meta_key
    FROM wp_posts p
    JOIN wp_postmeta pm ON p.ID = pm.post_id
    WHERE p.post_type = 'apartamenty'
    AND p.post_status = 'publish'
    ORDER BY pm.meta_key";
$r2 = $conn->query($sql2);
while($row = $r2->fetch_row()) { echo $row[0] . "\n"; }

$conn->close();

function maybe_unserialize($data) {
    if (is_serialized($data)) return unserialize($data);
    return $data;
}
function is_serialized($data) {
    if (!is_string($data)) return false;
    $data = trim($data);
    if ('N;' === $data) return true;
    if (strlen($data) < 4) return false;
    if (':' !== $data[1]) return false;
    return (bool) preg_match('/^([adObis]):/', $data);
}