Gecko [ www.utparral.edu.mx ]

Name	Size	Permission
css	[ DIR ]	drwxrwxr-x
ftp	[ DIR ]	drwxrwxr-x
img	[ DIR ]	drwxrwxr-x
js	[ DIR ]	drwxrwxr-x
leerpdf	[ DIR ]	drwxrwxr-x
pdf	[ DIR ]	drwxrwxr-x
recibos	[ DIR ]	drwxrwxr-x
subir	[ DIR ]	drwxrwxr-x
admin.php	38 B	-rwxrwxr-x
buscar.php	1.92 KB	-rwxrwxr-x
cabecera.php	973 B	-rwxrwxr-x
conexion.php	220 B	-rwxrwxr-x
funciones.php	1.79 KB	-rwxrwxr-x
index.php	378 B	-rwxrwxr-x
login.php	3 KB	-rwxrwxr-x
respaldofunciones.php	2.49 KB	-rwxrwxr-x
sample.html	604.89 KB	-rwxrwxr-x
sample.pdf	563.46 KB	-rwxrwxr-x
super.php	38 B	-rwxrwxr-x
usuario.php	1.79 KB	-rwxrwxr-x

Code Editor : buscar.php

<?php 
 $mysqli= new mysqli("www.utparral.edu.mx","webamaster","Maestrodelweb2017","recibos");

$mysqli->query("SET NAMES 'utf8'");

$salida="";
$r = $mysqli->real_escape_string($_POST['rfc']);
$query = "SELECT * FROM recibos where rfc='$r' order by anio,quincena";

if(isset($_POST['anio'])){
    $a = $mysqli->real_escape_string($_POST['anio']);
    $r = $mysqli->real_escape_string($_POST['rfc']);
    $q = $mysqli->real_escape_string($_POST['quincena']);
    
    $query = "SELECT * FROM recibos WHERE ";
     
    $query.="  (quincena = '$q' ";
    $query.="  and anio ='$a')";
    $query.=" and rfc= '$r'";

}

$resultado = $mysqli->query($query);

if ($resultado->num_rows>0){
    $salida.="<table class='tabla_datos table table-striped  table-hover '>
             <thead>
                  <tr>
                      <th>RFC</th>
                      <th>Año</th>
                      <th>Quincena</th>
                      <th>Descargar</th>
                      
                      
             </thead>
             <tbody>";
       while($fila = $resultado->fetch_assoc()){
           $vinculo="recibos/".$fila['rfc'].".".$fila['quincena'].".".$fila['anio'].".pdf";
           $descarga=$fila['rfc'].".".$fila['quincena'].".".$fila['anio'].".pdf";
           $salida.="<tr>
                   <td>".$fila['rfc']."</td>
                    <td>".$fila['anio']."</td>
                    <td>".$fila['quincena']."</td>
                    
                    
                    
                    <td><a href='".$vinculo."' download='".$descarga."'><button class='btn btn-primary'><span >Descargar</span></button></a></td>

</tr>";
           
       }   
    $salida.="</tbody></table>";

}else{
    $salida.="Ningun recibo coinside con tu busqueda";
}

echo $salida;

$mysqli->close();

${this.title}

Code Editor : buscar.php