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:
– geekcom
To start I recommend that you use this library, it meets your needs: https://github.com/geekcom/phpjasper
– geekcom