Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $mysqli = NEW MySQLi('localhost','root','','server');
- $sqlFatura = $mysqli->query("SELECT login as NOME,fatura AS
- Fatura, Emissao, Vcto, group_concat(reserva) AS RESERVAS
- FROM usuarios INNER JOIN faturas,anexos WHERE
- usuarios.ID=IDlogin AND faturas.ID=IDfatura AND login='".
- mysql_real_escape_string($_SESSION['login'])."' GROUP BY fatura");
- if($sqlFatura->num_rows > 0){
- while($rows = $sqlFatura->fetch_assoc()){
- $fatura = $rows['Fatura'];
- $loc = $fatura .".pdf";
- $stur = $rows['RESERVAS'];
- $emissao = $rows['Emissao'];
- $vcto = $rows['Vcto'];
- echo "<p> Fatura $fatura Emitida dia $emissao Vencimento
- $vcto=><a href='$loc' target='_blank'>DOWNLOAD</a> ANEXO: $stur<br></p>";
- }
- }else{
- echo "SEM FATURAS.";
- }
- ?>
- echo "<p> Fatura $fatura Emitida dia $emissao Vencimento
- $vcto=><a href='$loc' target='_blank'>DOWNLOAD</a>
- ANEXO:<a href='url_stur' target='_blank'>$stur</a><br></p>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement