$search[0] = strtoupper($search[0]);

$query = "
  SELECT * FROM data_magazine
  WHERE UPPER(author_name) LIKE '%".$search[0]."%'
  OR UPPER(author_surname) LIKE '%".$search[0]."%'
  OR UPPER(rubric_title) LIKE '%".$search[0]."%'
  OR UPPER(number_of_magazine) LIKE '%".$search[0]."%'
  OR UPPER(year_of_magazine) LIKE '%".$search[0]."%'

 ";