3v4l.org

run code in 300+ PHP versions simultaneously
<?php $db= new class{ public function real_escape_string(string $str):string{return $str;} }; $db=new $db; //var_dump($db); $search='Samsung Galaxy A7 (2017) 32gb'; $split=preg_split('/\s+/u',$search); $query='SELECT * FROM tbl WHERE '; foreach($split as $str){ $query.='`name` LIKE \'%'.$db->real_escape_string($str).'%\' AND '; } $query=substr($query,0,-strlen(' AND ')); var_dump($query);

preferences:
40.88 ms | 406 KiB | 5 Q