query($check_tempat_sql); if ($result_tempat->num_rows == 0) { // Column doesn't exist, add it $sql = "ALTER TABLE warga ADD COLUMN Tempat_Lahir VARCHAR(100) NOT NULL AFTER Jenis_kelamin"; if ($conn->query($sql) === TRUE) { echo "Column Tempat_Lahir added successfully.
"; } else { echo "Error adding column Tempat_Lahir: " . $conn->error . "
"; } } else { echo "Column Tempat_Lahir already exists.
"; } // Check if Tanggal_Lahir column exists $check_tanggal_sql = "SHOW COLUMNS FROM warga LIKE 'Tanggal_Lahir'"; $result_tanggal = $conn->query($check_tanggal_sql); if ($result_tanggal->num_rows == 0) { // Column doesn't exist, add it $sql = "ALTER TABLE warga ADD COLUMN Tanggal_Lahir DATE NOT NULL AFTER Tempat_Lahir"; if ($conn->query($sql) === TRUE) { echo "Column Tanggal_Lahir added successfully.
"; } else { echo "Error adding column Tanggal_Lahir: " . $conn->error . "
"; } } else { echo "Column Tanggal_Lahir already exists.
"; } // Show all columns in warga table for verification $show_columns_sql = "SHOW COLUMNS FROM warga"; $result_show = $conn->query($show_columns_sql); echo "
Current columns in warga table:
"; if ($result_show->num_rows > 0) { while ($row = $result_show->fetch_assoc()) { echo $row['Field'] . " - " . $row['Type'] . "
"; } } else { echo "No columns found."; } $conn->close(); ?>