Changelog - Baby Name Popularity
================================

[2025-03-18]
- Added: Admin import tool in folder import1975
  - import-baby-names.php: upload Excel (.xlsx), select gender (girl/boy), import into baby_name_yearly_stats
  - db.php: PDO connection with placeholder credentials
  - import-functions.php: sheet parsing, header detection, [x] redaction handling, name normalization
  - Supports sheets Table_1 (girls) and Table_2 (boys); upsert by (name_normalized, gender, year)

[2025-03-18 - Update]
- Removed Composer/PhpSpreadsheet dependency from import1975
- Added xlsx-reader.php: custom lightweight XLSX reader using ZipArchive/SimpleXML
- Updated import-functions.php and import-baby-names.php to use array-based sheet data

[2025-03-18 - Homepage]
- Added: Complete homepage tool (index.php) at site root
  - Hero search: search any baby name by gender, with autocomplete suggestions
  - Name result summary: total count, best rank, latest rank/count, peak year, trend direction, popularity band, plain-English summary
  - Single-name popularity trend chart (Chart.js from CDN)
  - Name comparison tool: compare up to 4 names with side-by-side stats table and multi-line chart
  - Discover/browse section: filter by gender, first letter, rank range, sort order, with pagination
  - Trending names section: fastest rising and falling names for girls and boys
  - Popular names quick list (top 10 girls and boys)
  - Rare names quick list (girls and boys)
  - Autocomplete search suggestions via AJAX
  - URL query parameter support for shareability (?name=, ?compare=, ?browse=)
  - Redacted values handled correctly (NULL, not zero)
  - Mobile responsive design with pale blue/pink theme
  - No frameworks, no package managers, no installs required
  - Uses Chart.js 4.x from CDN as only external dependency

[2025-03-18 - Security]
- Moved database credentials out of index.php and import1975/db.php into .env file
- Added config.php: shared credential loader that reads from .env
- Added .htaccess: blocks public access to .env and config.php
- Both index.php and import1975/db.php now use shared config.php
- No credentials are hardcoded in any PHP file

[2025-03-18 - UI Fix]
- Fixed overlapping rank number and name text in Popular and Rare name lists