sql_like_function.php

<?php

        public function prepare_sql_like($table, $cells, $words) {
            $words = strlen($words) ? explode(' ', trim($words)) : [];
            $like_expr = [];
            $cells_expr = [];

            if (count($words) > 0) {
                for ($i = 0; $i < count($words); $i++) {
                    $word = trim($words[$i]);
                    if ((strlen($word) > 0) && (count($cells) > 0) && (strlen($table) > 0)) {
                        foreach ($cells as $cell) {
                            $like_expr[$i][] = "`$table`.`$cell` LIKE '%$word%'";
                        }
                        $cells_expr[] = '(' . implode(' OR ', $like_expr[$i]) . ')';
                    }
                }
                $this -> sql_like_str = '(' . implode(' AND ', $cells_expr) . ')';
            } else {
                $this -> sql_like_str = '';
            }

        }

?>