skills.rest
claudioborja
claudioborjaCOMMUNITY
Explore all skills by this author →
GitHub

skill-php-search

Implements MariaDB-backed full-text search with facets and autocomplete in PHP.

Updated Apr 11, 2026
Search Tags:#php#search#library#autocomplete#mariadb#facets#fulltext
One-click install
npx skills add https://github.com/claudioborja/biblioteca --skill skill-php-search
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: skill-php-search
Source: https://github.com/claudioborja/biblioteca/tree/main/.agents/skills/skill-php-search
Command: npx skills add https://github.com/claudioborja/biblioteca --skill skill-php-search

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a robust search layer for library catalogs using MariaDB's built-in full-text search, enabling fast and scalable query results without relying on external search services.

Core Features & Use Cases

  • Full-text search across title, author, publisher, and description with relevance ranking
  • Autocomplete and live suggestions via lightweight endpoints
  • Faceted filtering (category, year, language, availability) and search history
  • Fallback to LIKE search when FULLTEXT yields no results, preserving user experience

Quick Start

Install dependencies and integrate the SearchService into your PHP app to start querying the catalog.

Frequently Asked Questions about skill-php-search

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I implement full-text search in a PHP library catalog using MariaDB?▼

Full-text search in a PHP library catalog is implemented by querying title, author, publisher, and description fields using MariaDB's built-in boolean mode. A LIKE fallback ensures reliable results when full-text yields nothing.

What is the best way to add autocomplete and faceted filtering to a MariaDB catalog?▼

Autocomplete and faceted filtering are added via lightweight endpoints that return live suggestions and category, year, language, and availability facets. This provides fast, scalable query results without external search services.

Can I use MariaDB full-text search instead of an external search service for a PHP application?▼

Yes, MariaDB full-text search can be used instead of an external search service for PHP applications. It provides fast, scalable query results with relevance ranking, popularity tracking, and search history directly within your database.

How do I handle MariaDB full-text search returning zero results in PHP?▼

When MariaDB full-text search returns zero results, a LIKE search fallback is triggered automatically. This preserves the user experience by ensuring the catalog still returns relevant records when full-text matching fails.

Does PHP search with MariaDB support safe query logging and popularity tracking?▼

PHP search with MariaDB supports safe query logging and popularity tracking as part of its production-grade service. It securely logs queries and tracks search popularity to improve catalog relevance ranking over time.

Related Skills

Explore More Software Engineering Skills→
Impertio-StudioImpertio-Studio
2

mariadb-syntax-indexing

Guide MariaDB indexing strategies with EXPLAIN analysis and index type selection.

Official
Advanced
h617265630h617265630

search

Generate a full-stack search feature with backend API and frontend components.

Community
Advanced
CobaltSatoCobaltSato

backend-patterns

Standardize backend architecture patterns for Node.js, Express, and Next.js applications.

Community
Advanced
personamanagmentlayerpersonamanagmentlayer
41

elasticsearch-expert

Manage Elasticsearch indexes, queries, and aggregations with Python.

Official
Advanced