49 lines
1.7 KiB
PHP
49 lines
1.7 KiB
PHP
<?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);
|
|
}
|