<?php
session_start();
include "functions.php";
include "config.php";
$codigo=($_GET["codigo"]);
$queryClientes = mysql_query("SELECT * FROM empresas WHERE usuario_id='$codigo'") or die(mysql_error());
while ($rowCliente = mysql_fetch_array($queryClientes)) {
$id=$rowCliente['usuario_id'];
$nome=$rowCliente['nome'];
$dia=$rowCliente['dia'];
$mes=$rowCliente['mes'];
$ano=$rowCliente['ano'];
$email=$rowCliente['email'];
$email2=$rowCliente['email2'];
$obs=$rowCliente['obs'];
}
?>
<html>
<head><title>Aleterar</title></head>
<body>
<table width="100%" border="0">
<tr>
<td><form action="alt_cli_db.php" name="alt_cli_db" method="post">
<table width="100%" border="0">
<tr>
<td>ID:<? echo $id;?>Nome:</td>
<td colspan="2"><input name="nome" type="text" id="nome" size="100" value="<? echo $nome;?>" /></td>
</tr>
<tr>
<td>Data:</td>
<td>dia
<input name="dia" type="text" id="dia" value="<? echo $dia;?>" size="2" /></td>
<td>mes
<input name="mes" type="text" id="mes" value="<? echo $mes;?>" size="2" /></td>
<td>ano
<input name="ano" type="text" id="ano" value="<? echo $ano;?>" size="4" /></td>
</tr>
<tr>
<td>Emails</td>
<td><input name="email" type="text" id="email" value="<? echo $email;?>" /></td>
<td>Email Alternativo</td>
<td><input name="email2" type="text" id="email2" value="<? echo $email2;?>" /></td>
</tr>
<tr>
<td>Observação</td>
<td colspan="2"><textarea name="obs" id="obs"><? echo $obs;?></textarea></td>
</tr>
<tr>
<td><input type="submit" name="Submit" value="Enviar" /></td>
<td><input name="voltar" type="button" onClick="javascript:history.go(-1)" value="voltar" /></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>
[
<?php
session_start();
include "functions.php";
include "config.php";
$id = trim($_POST['id']);
$nome = trim($_POST['nome']);
$dia = trim($_POST['dia']);
$mes = trim($_POST['mes']);
$ano = trim($_POST['ano']);
$email = trim($_POST['email']);
$email2 = trim($_POST['email2']);
$obs = trim($_POST['obs']);
$altera = mysql_query("UPDATE empresas SET nome = '$nome',
dia = '$dia',
mes = '$mes',
ano = '$ano',
email = '$email',
email2 = '$email2',
obs = '$obs' WHERE usuario_id = '$id'") or die(mysql_error());
if($altera){
echo "<script>location.href='perfil_cli.php?codigo=$id';</script>";
}
?>