Gecko [ www.utparral.edu.mx ]

Name	Size	Permission
css	[ DIR ]	drwxrwxr-x
fotos	[ DIR ]	drwxrwxr-x
buscar.php	2.47 KB	-rwxrwxr-x
config.php	328 B	-rwxrwxr-x
credenciales.sql	330.25 KB	-rwxrwxr-x

Code Editor : buscar.php

<?php 
 $mysqli= new mysqli("localhost","root","admin","credenciales");

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

$salida="";
$query = "SELECT * FROM alumnos ORDER BY nc desc limit 50";

if(isset($_POST['consulta'])){
    $q = $mysqli->real_escape_string($_POST['consulta']);
    $query = "SELECT * FROM alumnos WHERE ";
    $query.="nc like '%".$q."%'";
    $query.="  or apellidos like '%".$q."%'";
    $query.="  or nombre like '%".$q."%'";

}

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

if ($resultado->num_rows>0){
    $salida.="<table class='tabla_datos table table-striped  table-hover table-borderless'>
             <thead>
                  <tr>
                      <th>Número de control</th>
                      <th>Nombre</th>
                      <th>Apellidos</th>
                      <th>Especialidad</th>
                      <th>Grupo</th>
                      <th>Foto</th>
                      <th>Opciones
                      </th>
                      
                      
             </thead>
             <tbody>";
       while($fila = $resultado->fetch_assoc()){
           $salida.="<tr>
                   <td>".$fila['nc']."</td>
                    <td>".$fila['nombre']."</td>
                    <td>".$fila['apellidos']."</td>
                    <td>".$fila['especialidad']."</td>
                    <td>".$fila['grupofinal']."</td>
                    <td><img src='fotos/".$fila['nc'].".jpg'/></td>
                    <td>
                    
                    <a href='imprimir.php?control=".$fila['nc']."'><img src='img/imprimir.png' alt='Imprimir' style='width:auto; height:50px;' ></span></a>
                    
                    <a href='javascript:void(0)'><img src='img/editar.png' alt='Editar' style='width:auto; height:50px;'  data-toggle='modal'  data-target='#modalcambios'></span></a>
                    
                    
                    
                     <a id='eliminar' valor='".$fila['nc']."'  href='javascript:void(0)' data-toggle='modal' data-target='#modaleliminar'><img src='img/eliminar.png' alt='Eliminar' style='width:auto; height:50px;' ></span></a>
                 
                    
                    
                    </td>

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

}else{
    $salida.="no hay datos :(";
}

echo $salida;

$mysqli->close();

${this.title}

Code Editor : buscar.php