The Challenge
KET4SME required a platform for small and medium enterprises (SMEs) to register, list their technological capabilities, and connect with other European businesses through a custom search filtering system.
Implemented Engineering Solution
- Custom WordPress Plugin: Developed a custom plugin managing SME registration forms, profile editing, and search indexes.
- Custom Database Tables: Created dedicated MySQL database tables for fast query responses while keeping WordPress user credentials secure.
- Frontend Search Interface: Built responsive search forms with AJAX filtering for quick capability matching.
// Custom Plugin Table Query Snippet
ket4sme-plugin/inc/db-query.php
<?php
// Custom Business Search Database Query
global $wpdb;
$table_name = $wpdb->prefix . 'ket4sme_businesses';
$results = $wpdb->get_results(
$wpdb->prepare( "SELECT * FROM {$table_name} WHERE category = %s", $search_cat )
);
?>