<html> <style type="text/css"> .tg {border-collapse:collapse;border-spacing:0;} .tg td{font-family:Arial; font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;} .tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;} .tg .tg-5392{font-size:12px;font-family:"Lucida Console", Monaco, monospace !important;;background-color:#000000;color:#ffffff;text-align:center} .tg .tg-ek65{font-size:12px; background-color:#ffffff;color:#000000} </style> <div> <form name="busquedas" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST" id="css"> <table> <td>Numero de serie </td><td><input type="text" name="Num_serie" /><td></tr> <tr><td><input type="submit" value="Modificar" name="modificar" /></td></tr> </table> </form> </div> </html> <?php if( isset($_POST["modifik"]) ) { echo "<script>"; echo "alert ('Numero de serie vacio')"; echo "</script>"; } ?> <?php $codigo=""; echo $_SERVER['PHP_SELF']= $codigo; ?> <?php $mysqli = new mysqli("localhost", "root", "", "inventario"); if ($mysqli->connect_errno) { exit('Hay un error en la conexion de la base de datos'); } $sql="SELECT * FROM limpio_salas WHERE (origen = 'Almacen Limpio' )"; if(!$result = $mysqli->query($sql)){ exit('La consulta ha fallado'); } if($mysqli->affected_rows < 1){ exit('No se han encontrado registros'); } echo"<table class='tg'>"; echo"<tr>"; echo"<th width='100' class='tg-5392'>Num. Serie</th>"; echo"<th width='100' class='tg-5392'>Nombre del Equipo</th>"; echo"<th width='100' class='tg-5392'>Categoria</th>"; echo"<th width='100' class='tg-5392'>FIDI</th>"; echo"<th width='100' class='tg-5392'>Marca</th>"; echo"<th width='100' class='tg-5392'>Modelo</th>"; echo"<th width='100' class='tg-5392'>Propietario</th>"; echo"<th width='100' class='tg-5392'>Area y Responsables</th>"; echo"<th width='100' class='tg-5392'>Nombre y Num. de Proyecto</th>"; echo"<th width='100' class='tg-5392'>Fecha Ingreso</th>"; echo"<th width='50' class='tg-5392'>Periodo</th>"; echo"<th width='100' class='tg-5392'>obs. Ingreso</th>"; echo"<th width='50' class='tg-5392'>Estante</th>"; echo"<th width='50' class='tg-5392'>Posicion</th>"; echo"<th width='100' class='tg-5392'>Fecha Salida</th>"; echo"<th width='100' class='tg-5392'>Obs. Salida</th>"; echo"<tr>"; while ($fila = $result->fetch_array(MYSQLI_ASSOC)) { echo "<form name='pruebita' action='$codigo' method='POST' id='css'>"; echo "<td class='tg-ek65'>"; echo $fila ["serie"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["nom_equipo"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["categoria"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["fidi"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["marca"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["modelo"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["propietario"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["area"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["nom_proyecto"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["ingreso"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["periodo_dias"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["obs_ingreso"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["ubica_estante"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["ubica_posicion"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["salida"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo $fila ["obs_salida"]; echo "</td>"; echo "<td class='tg-ek65'>"; echo "<input type='submit' name='Modificar' value='Modificar' /></form></td>"; echo "</tr>"; } echo"</table>"; ?>