17 lines
600 B
PHP
17 lines
600 B
PHP
<?php
|
|
include 'db.php';
|
|
|
|
$sql = "ALTER TABLE data_unified ADD COLUMN IF NOT EXISTS buka_24jam VARCHAR(10) NULL";
|
|
// Note: MySQL doesn't support IF NOT EXISTS for ADD COLUMN before 8.0. We'll check column existence first.
|
|
$result = $conn->query("SHOW COLUMNS FROM data_unified LIKE 'buka_24jam'");
|
|
if ($result && $result->num_rows > 0) {
|
|
echo "Column buka_24jam already exists\n";
|
|
exit;
|
|
}
|
|
|
|
if ($conn->query("ALTER TABLE data_unified ADD COLUMN buka_24jam VARCHAR(10) NULL") === TRUE) {
|
|
echo "Added column buka_24jam\n";
|
|
} else {
|
|
echo "Error adding column: " . $conn->error . "\n";
|
|
}
|
|
?>
|