22 lines
1015 B
PHP
22 lines
1015 B
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 z ceną ===\n";
|
|
$sql = "SELECT p.ID, p.post_title,
|
|
MAX(CASE WHEN pm.meta_key = 'information_price' THEN pm.meta_value END) as price,
|
|
MAX(CASE WHEN pm.meta_key = 'information_price_m2' THEN pm.meta_value END) as price_m2,
|
|
MAX(CASE WHEN pm.meta_key = 'information_floor_space' THEN pm.meta_value END) as floor_space
|
|
FROM wp_posts p
|
|
JOIN wp_postmeta pm ON p.ID = pm.post_id
|
|
WHERE p.post_type = 'apartamenty'
|
|
AND p.post_status = 'publish'
|
|
GROUP BY p.ID, p.post_title
|
|
ORDER BY p.post_title LIMIT 10";
|
|
$r = $conn->query($sql);
|
|
while($row = $r->fetch_assoc()) {
|
|
echo $row['ID'] . ' | ' . $row['post_title'] . ' | price: ' . $row['price'] . ' | price_m2: ' . $row['price_m2'] . ' | m2: ' . $row['floor_space'] . "\n";
|
|
}
|
|
|
|
$conn->close();
|