54 lines
2.2 KiB
PHP
54 lines
2.2 KiB
PHP
<?php
|
|
// Symulacja dbDelta — tworzymy tabelę bezpośrednio
|
|
$conn = new mysqli('host117523.hostido.net.pl', 'host117523_wyszynskiego12pagedevpl', 'yZs52KdErtTk9KmZ8XGq', 'host117523_wyszynskiego12pagedevpl');
|
|
if ($conn->connect_error) { die('Blad polaczenia: ' . $conn->connect_error); }
|
|
|
|
$conn->set_charset('utf8mb4');
|
|
|
|
$sql = "CREATE TABLE IF NOT EXISTS wp_price_history (
|
|
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
post_id BIGINT UNSIGNED NOT NULL,
|
|
price VARCHAR(50) NOT NULL DEFAULT '',
|
|
price_m2 VARCHAR(50) NOT NULL DEFAULT '',
|
|
floor_space VARCHAR(50) NOT NULL DEFAULT '',
|
|
recorded_at DATE NOT NULL,
|
|
PRIMARY KEY (id),
|
|
UNIQUE KEY unique_daily (post_id, recorded_at),
|
|
KEY idx_post_id (post_id)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;";
|
|
|
|
if ($conn->query($sql)) {
|
|
echo "OK: Tabela wp_price_history utworzona lub juz istnieje.\n";
|
|
} else {
|
|
echo "BLAD: " . $conn->error . "\n";
|
|
}
|
|
|
|
// Sprawdz czy tabela istnieje
|
|
$r = $conn->query("SHOW TABLES LIKE 'wp_price_history'");
|
|
echo "Tabela w bazie: " . ($r->num_rows > 0 ? "TAK" : "NIE") . "\n";
|
|
|
|
// Opisz strukturę
|
|
$r2 = $conn->query("DESCRIBE wp_price_history");
|
|
echo "\nStruktura tabeli:\n";
|
|
while ($row = $r2->fetch_assoc()) {
|
|
echo " " . $row['Field'] . " | " . $row['Type'] . " | " . $row['Key'] . "\n";
|
|
}
|
|
|
|
// Test INSERT IGNORE z danymi apartamentu 203
|
|
$today = date('Y-m-d');
|
|
$conn->query("INSERT IGNORE INTO wp_price_history (post_id, price, price_m2, floor_space, recorded_at) VALUES (203, '677 920', '19 000', '35,68', '$today')");
|
|
echo "\nINSERT IGNORE dla apt 203 (dzisiaj): affected_rows=" . $conn->affected_rows . "\n";
|
|
|
|
// Powtorzenie — powinno byc 0 (IGNORE)
|
|
$conn->query("INSERT IGNORE INTO wp_price_history (post_id, price, price_m2, floor_space, recorded_at) VALUES (203, '677 920', '19 000', '35,68', '$today')");
|
|
echo "Powtorny INSERT IGNORE (powinno byc 0): affected_rows=" . $conn->affected_rows . "\n";
|
|
|
|
// Pokaz rekordy
|
|
$r3 = $conn->query("SELECT * FROM wp_price_history LIMIT 5");
|
|
echo "\nRekordy w tabeli:\n";
|
|
while ($row = $r3->fetch_assoc()) {
|
|
echo " ID=" . $row['id'] . " | post_id=" . $row['post_id'] . " | price=" . $row['price'] . " | date=" . $row['recorded_at'] . "\n";
|
|
}
|
|
|
|
$conn->close();
|