Category Debug Tool
1. Categories in Database:
| Category (exact) | Count | First Few Chars Hex |
|---|
| Fiction | 48 | 46696374696f6e |
| Technology | 45 | 546563686e6f6c6f6779 |
| Classic | 43 | 436c6173736963 |
| Fantasy | 36 | 46616e74617379 |
| Sci-Fi | 36 | 5363692d4669 |
| Thriller | 35 | 546872696c6c6572 |
| Self-Help | 33 | 53656c662d48656c70 |
| Business | 33 | 427573696e657373 |
| Romance | 33 | 526f6d616e6365 |
| Biography | 28 | 42696f677261706879 |
| Mystery | 28 | 4d797374657279 |
| History | 25 | 486973746f7279 |
| Science | 23 | 536369656e6365 |
| Philosophy | 22 | 5068696c6f736f706879 |
| Non-Fiction | 21 | 4e6f6e2d46696374696f |
| Children | 5 | 4368696c6472656e |
| Mythology | 3 | 4d7974686f6c6f6779 |
| Memoir | 2 | 4d656d6f6972 |
| Psychology | 1 | 50737963686f6c6f6779 |
2. Test Category Filter:
Testing 'Fiction': Exact=48, Case-insensitive=48 ✅
Testing 'fiction': Exact=48, Case-insensitive=48 ✅
Testing 'FICTION': Exact=48, Case-insensitive=48 ✅
Testing 'Fantasy': Exact=36, Case-insensitive=36 ✅
Testing 'Science': Exact=23, Case-insensitive=23 ✅
Testing 'Programming': Exact=0, Case-insensitive=0 ✅
3. Check get_books.php:
✅ get_books.php has case-insensitive matching