con mysqli:
Código PHP:
Ver original<?php
$db = new mysqli(tu host, tu user, tu pass, tu base);
$search = '';
if (isset($_POST['search'])){ $search = $_POST['search'];
}
$consulta = $db->query("SELECT * FROM alumnos WHERE nombre = '$search'") ;
?>
<?php if ($resultado>0 && $search!='') {?>
<h2>REGISTROS</h2>
<?php
echo "<table>";
echo "<tr>";
echo "<th>Nombre</th>";
echo "<th>edad</th>";
echo "<th>Pais</th>";
echo "</tr>";
while ($fila = $resultado -> fetch_array()){
echo "<tr>";
echo "<td>".$fila['nombre']."</td>";
echo "<td>".$fila['apellido']."</td>";
echo "<td>".$fila['nit']."</td>";
echo "</tr>";
}
echo "</table>"; ?>
<?php } ?>