fork(1) download
copy 
  1. <?php
  2.  
  3. $query = 'SELECT * FROM `tabela`';
  4. $field = 'tresc';
  5. $likes = array();
  6.  
  7. $search = 'jakiś tekst do wyszukania';
  8.  
  9. $arr = explode(' ', $search);
  10. $arr = array_filter($arr);
  11.  
  12. foreach($arr as $a)
  13. {
  14. 	$likes[] = "`$field` LIKE '%$a%'";
  15. }
  16.  
  17. if(count($likes) > 0)
  18. {
  19. 	$query .= ' WHERE ';
  20. 	$query .= implode(' OR ', $likes);
  21. }
  22.  
  23. echo $query;
Success #stdin #stdout 0.02s 24448KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
SELECT * FROM `tabela` WHERE `tresc` LIKE '%jakiś%' OR `tresc` LIKE '%tekst%' OR `tresc` LIKE '%do%' OR `tresc` LIKE '%wyszukania%'
https://ideone.com/WtI3id
language:
PHP (php 7.3.5)
created:
10 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!