Kovah/LinkAce

Case-Insensitive Search

Open

#993 创建于 2025年8月29日

在 GitHub 查看
 (3 评论) (1 反应) (0 负责人)PHP (1,761 star) (111 fork)batch import
EnhancementHelp wanted

描述

Summary

Searching in LinkAce appears to be case-sensitive. For example; searching for abc does not return results for links titled ABC01. This behavior has confused some users who expect searches to be case-insensitive by default.

Proposed Solution

  • Implement case-insensitive search by default for the /search page
  • Optionally provide a checkbox to enable case-sensitive search filter if needed.

Contribution

I am willing to implement this feature myself. I’d like to confirm with the maintainer:

  • Should case-insensitive search be the default behavior, with case-sensitive as an optional toggle?
  • Or do you prefer a different approach?

Additional Context

Example scenario:

  • Link: ABC01.com
  • Search query: abc01
  • Current behavior: No results.
  • Desired behavior: ABC01.com should be returned.

贡献者指南

技术栈
phpsql
领域
backendsearch
议题类型
feature
难度面向新贡献者的预计实现难度，1 表示很小改动，5 表示专家级工作。
2
预计时间有经验贡献者完成调查、实现、测试并准备 pull request 的粗略时间范围。
1-3 hours
活动状态议题当前的可参与程度：新鲜、活跃、陈旧、阻塞或等待维护者输入。
needs maintainer response
清晰度议题是否清楚说明期望改动、验收标准和下一步。
clear
前置要求
Basic PHPSQL
新手友好度1-100 的估计分数，表示该议题对首次贡献者的友好程度。
70
研究方向
The search functionality is implemented in the backend, likely in a controller or repository class. Look for the method handling search queries, possibly in a file like 'SearchController.php' or a model. The change involves modifying the database query to be case insensitive, e.g., using LOWER() on both the column and the search term. Consider using LOWER(column) LIKE LOWER(:query) with wildcards. After implementing, ensure existing tests pass and add a test for case insensitive search. Also, implement an optional toggle for case sensitive search if required.