this is the first file :
Code: Select all
<html>
<head>
<title>Actualiza Status de Guias</title>
</head>
<body bgcolor="white">
<form method="POST" action="modifica1.php">
<table>
<col span="1" align="right">
<tr>
<td><font color="blue" size="1" face="Verdana, Arial, Helvetica, sans-serif">Número
de Guia a Actualizar:</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="numguia" type="text" id="numguia" size=100>
</font></td>
</tr>
<tr>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="submit" value="Consulta Guia">
</font></td>
</tr>
</table>
</form>
</body>
</html>And then here is modifica1.php ...
Code: Select all
<?php
foreach($HTTP_POST_VARS as $varname => $value)
$formVars[$varname]=$value;
$db1=mysql_connect(localhost, user, passwd);
mysql_select_db("mydatabase");
$query="SELECT * FROM datos WHERE numguia = \"".$formVars["numguia"]."\"";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$formVars = array();
$formVars["numguia"]=$row["numguia"];
$formVars["origenpais"]=$row["origenpais"];
$formVars["origenestado"]=$row["origenestado"];
$formVars["origenciudad"]=$row["origenciudad"];
mysql_close($db1);
?>
<html>
<head>
<title>Actualización de Guias</title>
</head>
<body bgcolor="white">
<font size="1" face="Verdana, Arial, Helvetica, sans-serif"><form method="post" action="modifica2.php"> <table>
</font>
<col span="1" align="right">
<tr>
<td><font color="blue" size="1" face="Verdana, Arial, Helvetica, sans-serif">Número
de Guia:</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="numguia"
value="<? echo $formVars["numguia"]; ?>" size=100>
</font></td>
</tr>
<tr>
<td><font color="blue" size="1" face="Verdana, Arial, Helvetica, sans-serif">Pais
de Origen:</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="model"
value="<? echo $formVars["origenpais"]; ?>" size=100>
</font></td>
</tr>
<tr>
<td><font color="blue" size="1" face="Verdana, Arial, Helvetica, sans-serif">Estado
de Origen:</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="addr"
value="<? echo $formVars["origenestado"]; ?>" size=100>
</font></td>
</tr>
<tr>
<td><font color="blue" size="1" face="Verdana, Arial, Helvetica, sans-serif">Ciudad
de Origen:</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="zip"
value="<? echo $formVars["origenciudad"]; ?>" size=100>
</font></td>
</tr>
<tr>
<td> </td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> </font><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
</font></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="submit" value="Submit">
</font></td>
</tr>
</body>
</html>And finally here is modifica2.php
Code: Select all
<html>
<head>
<title>Actualización de Guias</title>
</head>
<body bgcolor="white">
<?php
foreach($HTTP_POST_VARS as $varname => $value)
$formVars[$varname]=$value;
$db1=mysql_connect(localhost, user, password);
mysql_select_db("mydatabase");
echo "Record updated<br><a href=\"modifica.php\">click here</a> to update another record<br>";
$query="UPDATE tablename set ".
"numguia= \"".$formVars["numguia"]."\",".
"origenpais= \"".$formVars["origenpais"]."\",".
"origenestado= \"".$formVars["origenestado"]."\",".
"origenciudad= \"".$formVars["origenciudad"]."\",".
"\" WHERE numguia = \"".$formVars["numguia"]."\"";
mysql_query($query);
mysql_close($db1);
?>
</body>
</html>Thanks a lot !!
greetings