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
pdfs	[ DIR ]	drwxrwxr-x
recibos	[ DIR ]	drwxrwxr-x
subir	[ DIR ]	drwxrwxr-x
subir2	[ DIR ]	drwxrwxr-x
tabladinamica	[ DIR ]	drwxrwxr-x
actualiza.php	530 B	-rwxrwxr-x
admin.php	2.15 KB	-rwxrwxr-x
buscar.php	2.37 KB	-rwxrwxr-x
cabecera.php	1.08 KB	-rwxrwxr-x
conexion.php	220 B	-rwxrwxr-x
crear.php	649 B	-rwxrwxr-x
funciones.php	1.79 KB	-rwxrwxr-x
index.php	321 B	-rwxrwxr-x
login.php	3 KB	-rwxrwxr-x
nomina.12.2019.pdf	563.46 KB	-rwxrwxr-x
respaldofunciones.php	2.85 KB	-rwxrwxr-x
sample.html	604.89 KB	-rwxrwxr-x
sample.pdf	563.46 KB	-rwxrwxr-x
sample.xml	455.67 KB	-rwxrwxr-x
subir.php	529 B	-rwxrwxr-x
super.php	38 B	-rwxrwxr-x
usuario.php	3.43 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.=" anio ='$a'";
    $query.=" and rfc= '$r'";

}

if(isset($_POST['quincena'])){
    $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.="<div class='container-fluid'><table class='tabla_datos table table-striped  table-hover table-sm table-condensed'>
             <thead>
                  <tr>
                 
                      <th>Año</th>
                      <th>Quincena</th>
                      <th>Fecha de expedición</th>
                      <th></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['anio']."</td>
                    <td>".$fila['quincena']."</td>
                    <td>".$fila['fecha']."</td>
                    
                    
                    
                    <td><a href='".$vinculo."' download='".$descarga."'><button class='btn btn-primary btn-sm'><img src='img/descargar.png' style='height:30px;'></button></a></td>

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

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

echo $salida;

$mysqli->close();

${this.title}

Code Editor : buscar.php