How can I generate a php report that is not a table?

Asked

Viewed 20 times

0

I need to create a report/form from a query in php. I have a membership database for a leisure activity club. From this query:

SELECT DISTINCT utilizador.nome, utilizador.data_nascimento,
                utilizador.nif, morada.rua,morada.numero_porta, morada.andar,
                morada.codigo_postal1, morada.codigo_postal2, 
                morada.localidade, socio.numero_socio

FROM socioonix, utilizador, morada
WHERE socio.idutilizador = utilizador.idutilizador
AND socio.aprovado = 'Pendente'
AND utilizador.idmorada = morada.idmorada
order by utilizador.nome asc;

This query returns a table of members who are in the pending state.

But what I want to do is create for each partner something like:

"name of the partner" with the "nif" resident in "address" with the "membership number" you are authorized to attend the Club.

signatures of guardians of education

How is that possible? I’m sorry if it’s a very Oob question, but my knowledge only goes so far as to generate queries and print out tables.

  • To begin I recommend that you use this library, it supplies your needs:

  • To start I recommend that you use this library, it meets your needs: https://github.com/geekcom/phpjasper

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.