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.