Untitled

first page


<html>
<body>
<form method="POST" action="buscador.php">
<strong>Buscar por:</strong>
<input type="text" name="busca" size="20"><br><br>
<input type="submit" value="Buscar">
</form>


</body>
</html>


second page


<?php
$valor=$_POST['busca'];
$link = mysql_connect("localhost", "root","alecito");
mysql_select_db("usuarios", $link);
$result = mysql_query("SELECT * FROM usuarios WHERE nombre LIKE '%$valor%'", $link);
?>

<html>
<body>


<table border=1>
  <tr>
    <th>ID</th>
    <th>Nombre</th>
    <th>Departamento</th>
    <th>Login_Name</th>
    <th>Clave</th>
    <th>Email1</th>
    <th>Email2</th>
    <th>Email3</th>


  </tr>
  <?php while ($row = mysql_fetch_assoc($result)) { ?>
  <tr>
    <td><?php echo $row['ID']; ?></td>
    <td><?php echo $row['Nombre']; ?></td>
    <td><?php echo $row['Departamento']; ?></td>
    <td><?php echo $row['Login_Name']; ?></td>
    <td><?php echo $row['Clave']; ?></td>
    <td><?php echo $row['email1']; ?></td>
    <td><?php echo $row['email2']; ?></td>
    <td><?php echo $row['email3']; ?></td>
  </tr>
  <?php } ?>
</table>


</body>
</html>