Search and display of results 2 tables mysqli/php

Question

I wanted to do a search in 2 tables (news and photos) and then display the results of this query below. But the fields I have in each table are different and I’m not able to elaborate a way to display the results because of this.

Fields from the news table: Title, photo, description, content, date

Fields of table photos: Title, photo, date, location

Ex:

1. Search the term "test"...
2. Query in the two tables and brings all the results found.

The search result wanted to look like the image:

Note: The layout of the image is just an example, what I am not able to do is the code that generates the result. If it was the result of a table only displaying results only of it I can do, but displaying results of 2 tables together and merged I could not.

Answer 1

You need to match the fields of the two tables, so the amount and name of the returned columns will be equal.

SELECT `titulo`, `foto`, `descricao`, `conteudo`, `data`, '' as `local`
FROM `noticia` WHERE [sua pesquisa]
UNION
SELECT `titulo`, `foto`, '' as `descricao`, '' as `conteudo`, `data`, `local`
FROM `fotos` WHERE [sua pesquisa];

And when displaying you validate if the field is not empty to be displayed.

if (isset($query['campo']) && !empty($query['campo'])) {
     echo $query['campo'];
}