3v4l.org

run code in 300+ PHP versions simultaneously
<?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