<?php
$keywords = ['Paso', 'Robles'];
$columns = ['ID', 'StorageArea', 'Size', 'Winery', 'Brand', 'Appellation', 'ReleaseYear', 'Varietal', 'Status', 'CountryName'];
$where = 'WHERE ' . implode("\nAND ", array_map(function ($keyword) use ($columns) {
$keyword = str_replace("'", "''", $keyword);
return "\n(" . implode(' OR ', array_map(function ($column) use ($keyword) {
return "\n`$column` LIKE '%$keyword%'";
}, array_filter($columns, function ($column) {
return $column !== 'ID';
}))) . "\n)";
}, $keywords));
echo $where;
preferences:
25.02 ms | 402 KiB | 5 Q