Página alteração dados: Dados não aparecem no formulário

fredebsb · Abril 22, 2009

Boa noite pessoal.

Estou fazendo um sistema em php de cadastro de encomendas. Estou seguindo aquela apostila "Dreamweaver 8 - a bíblia". Segui todos os passos para fazer a página de alteração de dados. Tudo funciona, exceto que os dados não aparecem no formulário de alteração. Abaixo seguem os códigos php das páginas:

Página de busca:

<?php require_once('Connections/ConnImasters.php'); ?>

<?php

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

if ((isset($_POST['codigo'])) && ($_POST['codigo'] != "") && (isset($_GET['codigo']))) {

$deleteSQL = sprintf("DELETE FROM encomendas WHERE codigo=%s",

GetSQLValueString($_POST['codigo'], "int"));

mysql_select_db($database_ConnImasters, $ConnImasters);

$Result1 = mysql_query($deleteSQL, $ConnImasters) or die(mysql_error());

$deleteGoTo = "index.html";

if (isset($_SERVER['QUERY_STRING'])) {

$deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";

$deleteGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $deleteGoTo));

}

$colname_Recordset_busca_encomenda = "-1";

if (isset($_GET['cliente'])) {

$colname_Recordset_busca_encomenda = (get_magic_quotes_gpc()) ? $_GET['cliente'] : addslashes($_GET['cliente']);

}

mysql_select_db($database_ConnImasters, $ConnImasters);

$query_Recordset_busca_encomenda = sprintf("SELECT * FROM encomendas WHERE cliente LIKE '%%%s%%'", $colname_Recordset_busca_encomenda);

$Recordset_busca_encomenda = mysql_query($query_Recordset_busca_encomenda, $ConnImasters) or die(mysql_error());

$row_Recordset_busca_encomenda = mysql_fetch_assoc($Recordset_busca_encomenda);

$totalRows_Recordset_busca_encomenda = mysql_num_rows($Recordset_busca_encomenda);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Area do administrador</title>

<!--

body {

margin-right: 0px;

}

.style4 {

font-size: 11px;

font-family: Geneva, Arial, Helvetica, sans-serif;

}

.style5 {

font-family: Geneva, Arial, Helvetica, sans-serif;

font-size: 12px;

}

#Layer1 {

position:absolute;

left:87px;

top:15px;

width:777px;

height:60px;

z-index:1;

}

#Layer2 {

position:absolute;

left:10px;

top:72px;

width:2px;

height:2px;

z-index:2;

}

#Layer3 {

position:absolute;

width:853px;

height:61px;

z-index:1;

left: 11px;

top: 16px;

}

#Layer4 {

position:absolute;

width:200px;

height:297px;

z-index:2;

top: 77px;

}

#Layer5 {

position:absolute;

width:1px;

height:1px;

z-index:3;

}

#Layer6 {

position:absolute;

width:437px;

height:115px;

z-index:4;

top: 374px;

left: 213px;

}

#Layer7 {

position:absolute;

left:215px;

top:376px;

width:531px;

height:107px;

z-index:4;

}

-->

</style>

<!--

function MM_goToURL() { //v3.0

var i, args=MM_goToURL.arguments; document.MM_returnValue = false;

for (i=0; i<(args.length-1); i+=2) eval(args+".location='"+args[i+1]+"'");

}

//-->

</script>

</head>

<body>

<table width="914" border="0" align="left">

<tr>

<td width="1104" height="441" valign="top">

<table width="150" border="0" align="right">

</table>

<div align="left">

<table width="699" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

<td colspan="3" align="left" valign="top" bgcolor="#FF0000"><div align="center">Área do administrador</div></td>

</tr>

<tr>

<td align="left" valign="top" bgcolor="#CCCCCC"><table width="546" border="0" cellspacing="0" cellpadding="0">

<tr>

<td width="109"><div align="left"></div></td>

<td width="102"><div align="left"></div></td>

<td width="215"><div align="left"><span class="style4">Encomendas</span></div></td>

<td width="11"><div align="left"></div></td>

</tr>

</table></td>

<td align="left" valign="top" bgcolor="#CCCCCC"> </td>

<td><div align="right"><a href="">Logout</a></div></td>

</tr>

<tr>

<td width="579" align="left" valign="top"><div align="center">

<table width="545" border="0" cellspacing="0" cellpadding="0">

<tr>

<td width="136"><table width="118" border="0" cellspacing="0" cellpadding="0">

<tr>

<td> </td>

</tr>

</table></td>

<td width="136"> </td>

<td width="97"> </td>

<td width="176"> </td>

</tr>

</table>

</div></td>

<td width="95" align="left" valign="top"> </td>

<td width="43"> <div align="center"></div></td>

</tr>

</table>

<table width="904" border="0" align="left" cellpadding="0" cellspacing="0">

<tr>

<td width="1" rowspan="2" valign="top"><div id="Layer5"></div></td>

<td width="903" valign="top"><table width="761" height="201" border="0" cellpadding="0" cellspacing="0">

<tr>

<td width="436" height="201" valign="top"><table width="755" height="171" border="0" cellpadding="0" cellspacing="0">

<tr>

<td width="755" valign="top"><iframe src="tabela_encomendas.php" name="iframe_tb_encomendas" width="750" height="300" align="left" scrolling="auto"></iframe></td>

</tr>

</table></td>

<td width="325" valign="top"><table width="136" height="297" border="0" cellpadding="0" cellspacing="0" bordercolor="#FF0000">

<tr bordercolor="#FF0000">

<td width="233" height="55" valign="top"><table width="133" height="75" border="0" cellpadding="0" cellspacing="0">

<tr>

<td width="233" height="29" colspan="2"><div align="left">Deletar Encomenda </div></td>

</tr>

<tr>

<td height="46" colspan="2" valign="top"><form id="form_deleta_encomenda" name="form_deleta_encomenda" method="get" action="encomenda_deletada.php">

<table width="130" border="0" cellspacing="0" cellpadding="0">

<tr>

<td> </td>

<td><input name="codigo" type="hidden" id="codigo" value="<?php echo $_GET['codigo']; ?>" /></td>

</tr>

<tr>

<td width="46"><div align="center">Id</div></td>

<td width="84"><label>

<input name="codigo" type="text" id="codigo" value="" size="3" />

<input name="deletar" type="submit" id="deletar" value="Deletar" />

</label></td>

</tr>

</table>

</form> </td>

</tr>

</table>

<table width="133" border="0" cellspacing="0" cellpadding="0">

<tr>

<td> </td>

</tr>

<tr>

<td><div align="center">

</div></td>

</tr>

<tr>

<td> </td>

</tr>

<tr>

<td><div align="center">

<input name="Submit2" type="submit" onclick="MM_goToURL('parent','area_do_administrador.php');return document.MM_returnValue" value="Administrador" />

</div></td>

</tr>

</table>

<p> </p></td>

</tr>

<tr>

<td height="19" valign="top" bgcolor="#FFFFFF"><p align="center"> </p> </td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<tr>

<td height="19" valign="top"><table width="903" border="0" cellspacing="0" cellpadding="0">

<tr>

<td colspan="3" bgcolor="#00FF33"><div align="center">Buscar Encomendas </div></td>

</tr>

<tr>

<td colspan="3"> </td>

</tr>

<tr>

<td colspan="3"> </td>

</tr>

<tr>

<td colspan="3"> </td>

</tr>

<tr>

<td colspan="3">

<form id="form_busca_encomenda" name="form_busca_encomenda" method="get" action="resultado_busca_encomenda2.php">

<table width="257" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

<td width="8"> </td>

<td width="38"><div align="center"> Nome</div></td>

<td width="144"><label>

<input name="cliente" type="text" id="cliente" />

</label></td>

<td width="67"><label>

<input name="buscar" type="submit" id="buscar" value="Buscar" />

</label></td>

</tr>

</table>

</form> </td>

</tr>

<tr>

<td colspan="3"><table width="525" border="0" cellspacing="0" cellpadding="0">

<tr>

<td> </td>

</tr>

<tr>

<td colspan="3"> </td>

</tr>

<tr>

<td colspan="3"> </td>

</tr>

<tr>

<td colspan="3"> </td>

</tr>

<tr>

<td colspan="3"><form id="form1" name="form1" method="post" action="">

<table width="524" border="0" cellspacing="0" cellpadding="0">

<tr>

<td width="104"><label></label></td>

<td width="10"><label></label></td>

<td width="410"><label></label></td>

</tr>

</table>

</form> </td>

</tr>

</table></td>

</tr>

<tr>

<td width="451"></td>

<td width="451"> </td>

<td width="1"> </tr>

</table></td>

</tr>

</table>

</div> <p align="center"> </p></td>

</tr>

</table>

<table>

</table>

</body>

</html>

<?php

mysql_free_result($Recordset_busca_encomenda);

?>

// fim da página de busca

Página de resultado da busca:

<?php require_once('Connections/ConnImasters.php'); ?>

<?php

$colname_Recordset_resultado_busca_encomenda = "-1";

if (isset($_GET['cliente'])) {

$colname_Recordset_resultado_busca_encomenda = (get_magic_quotes_gpc()) ? $_GET['cliente'] : addslashes($_GET['cliente']);

}

mysql_select_db($database_ConnImasters, $ConnImasters);

$query_Recordset_resultado_busca_encomenda = sprintf("SELECT * FROM encomendas WHERE cliente LIKE '%%%s%%'", $colname_Recordset_resultado_busca_encomenda);

$Recordset_resultado_busca_encomenda = mysql_query($query_Recordset_resultado_busca_encomenda, $ConnImasters) or die(mysql_error());

$row_Recordset_resultado_busca_encomenda = mysql_fetch_assoc($Recordset_resultado_busca_encomenda);

$totalRows_Recordset_resultado_busca_encomenda = mysql_num_rows($Recordset_resultado_busca_encomenda);

?>

<?php require_once('Connections/ConnImasters.php'); ?>

<?php

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

if ((isset($_POST['codigo'])) && ($_POST['codigo'] != "") && (isset($_GET['codigo']))) {

$deleteSQL = sprintf("DELETE FROM encomendas WHERE codigo=%s",

GetSQLValueString($_POST['codigo'], "int"));

mysql_select_db($database_ConnImasters, $ConnImasters);

$Result1 = mysql_query($deleteSQL, $ConnImasters) or die(mysql_error());

$deleteGoTo = "index.html";

if (isset($_SERVER['QUERY_STRING'])) {

$deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";

$deleteGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $deleteGoTo));

}

$colname_Recordset_busca_encomenda = "-1";

if (isset($_GET['cliente'])) {

$colname_Recordset_busca_encomenda = (get_magic_quotes_gpc()) ? $_GET['cliente'] : addslashes($_GET['cliente']);

}

mysql_select_db($database_ConnImasters, $ConnImasters);

$query_Recordset_busca_encomenda = sprintf("SELECT * FROM encomendas WHERE cliente LIKE '%%%s%%'", $colname_Recordset_busca_encomenda);

$Recordset_busca_encomenda = mysql_query($query_Recordset_busca_encomenda, $ConnImasters) or die(mysql_error());

$row_Recordset_busca_encomenda = mysql_fetch_assoc($Recordset_busca_encomenda);

$totalRows_Recordset_busca_encomenda = mysql_num_rows($Recordset_busca_encomenda);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<title>Area do administrador</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<style type="text/css">

<!--

body {

margin-right: 0px;

}

.style4 {

font-size: 11px;

font-family: Geneva, Arial, Helvetica, sans-serif;

}

#Layer1 {

position:absolute;

left:87px;

top:15px;

width:777px;

height:60px;

z-index:1;

}

#Layer2 {

position:absolute;

left:10px;

top:72px;

width:2px;

height:2px;

z-index:2;

}

#Layer3 {

position:absolute;

width:853px;

height:61px;

z-index:1;

left: 11px;

top: 16px;

}

#Layer4 {

position:absolute;

width:200px;

height:297px;

z-index:2;

top: 77px;

}

#Layer5 {

position:absolute;

width:1px;

height:1px;

z-index:3;

}

#Layer6 {

position:absolute;

width:437px;

height:115px;

z-index:4;

top: 374px;

left: 213px;

}

#Layer7 {

position:absolute;

left:215px;

top:376px;

width:531px;

height:107px;

z-index:4;

}

.style8 {color: #00FF33}

-->

</style>

<script type="text/JavaScript">

<!--

function MM_goToURL() { //v3.0

var i, args=MM_goToURL.arguments; document.MM_returnValue = false;

for (i=0; i<(args.length-1); i+=2) eval(args+".location='"+args[i+1]+"'");

}

//-->

</script>

</head>

<body>

<table width="4411" border="0" align="left">

<tr>

<td width="4411" height="441" valign="top">

<table width="150" border="0" align="right">

</table>

<div align="left">

<table width="776" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

<td colspan="3" align="left" valign="top" bgcolor="#FF0000"><div align="center">Área do administrador</div></td>

</tr>

<tr>

<td align="left" valign="top" bgcolor="#CCCCCC"><table width="546" border="0" cellspacing="0" cellpadding="0">

<tr>

<td width="109"><div align="left"></div></td>

<td width="102"><div align="left"></div></td>

<td width="215"><div align="left"><span class="style4">Encomendas</span></div></td>

<td width="11"><div align="left"></div></td>

</tr>

</table></td>

<td align="left" valign="top" bgcolor="#CCCCCC"> </td>

<td><div align="right"><a href="">Logout</a></div></td>

</tr>

<tr>

<td width="594" align="left" valign="top"><div align="center">

<table width="545" border="0" cellspacing="0" cellpadding="0">

<tr>

<td width="136"><table width="118" border="0" cellspacing="0" cellpadding="0">

<tr>

<td> </td>

</tr>

</table></td>

<td width="136"> </td>

<td width="97"> </td>

<td width="176"> </td>

</tr>

</table>

</div></td>

<td width="131" align="left" valign="top"> </td>

<td width="101"> <div align="center"></div></td>

</tr>

</table>

<table width="752" border="0" align="left" cellpadding="0" cellspacing="0">

<tr>

<td width="1" rowspan="2" valign="top"><div id="Layer5"></div></td>

<td width="741" valign="top"><table width="761" height="201" border="0" cellpadding="0" cellspacing="0">

<tr>

<td width="436" height="201" valign="top"><table width="755" height="171" border="0" cellpadding="0" cellspacing="0">

<tr>

<td width="750" valign="top"><iframe src="tabela_encomendas.php" name="iframe_tb_encomendas" width="750" height="300" align="left" scrolling="auto"></iframe></td>

</tr>

</table></td>

<td width="325" valign="top"><table width="166" height="297" border="0" cellpadding="0" cellspacing="0" bordercolor="#FF0000">

<tr bordercolor="#FF0000">

<td width="153" height="55" valign="top"><table width="133" height="75" border="0" cellpadding="0" cellspacing="0">

<tr>

<td width="233" height="29" colspan="2"><div align="left">Deletar Encomenda </div></td>

</tr>

<tr>

<td height="46" colspan="2" valign="top"><form id="form_deleta_encomenda" name="form_deleta_encomenda" method="get" action="encomenda_deletada.php">

<table width="130" border="0" cellspacing="0" cellpadding="0">

<tr>

<td> </td>

<td><input name="codigo" type="hidden" id="codigo" value="<?php echo $_GET['codigo']; ?>" /></td>

</tr>

<tr>

<td width="46"><div align="center">Id</div></td>

<td width="84"><label>

<input name="codigo" type="text" id="codigo" value="" size="3" />

<input name="deletar" type="submit" id="deletar" value="Deletar" />

</label></td>

</tr>

</table>

</form> </td>

</tr>

</table>

<table width="132" border="0" cellspacing="0" cellpadding="0">

<tr>

<td> </td>

</tr>

<tr>

</tr>

<tr>

<td> </td>

</tr>

<tr>

<td><input name="Submit2" type="submit" onclick="MM_goToURL('parent','area_do_administrador.php');return document.MM_returnValue" value="Administrador" /></td>

</tr>

</table> <p> </p></td>

</tr>

<tr>

<td height="19" valign="top" bgcolor="#FFFFFF"><p align="center"> </p> </td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<tr>

<td height="19" valign="top"><table width="1051" border="0" cellspacing="0" cellpadding="0">

<tr>

<td colspan="3" bgcolor="#FFFFFF"> </td>

</tr>

<tr>

<td colspan="3" bgcolor="#00FF33"><div align="left">Resultado da Busca: <span class="style8">....</span> <?php echo $row_Recordset_resultado_busca_encomenda['cliente']; ?></div></td>

</tr>

<tr>

<td colspan="3"><table width="571" border="0" cellspacing="0" cellpadding="0">

<tr>

<td> </td>

</tr>

</table></td>

</tr>

<tr>

<td colspan="3"> </td>

</tr>

<tr>

<td colspan="3"> </td>

</tr>

<tr>

<td colspan="3">

<form id="form_busca_encomenda" name="form_busca_encomenda" method="get" action="resultado_busca_encomenda2.php">

<table width="245" border="0" cellspacing="0" cellpadding="0">

<tr>

<td width="40"> </td>

<td width="144"> </td>

<td width="131"> </td>

</tr>

</table>

</form> </td>

</tr>

<tr>

<td colspan="3"><table width="525" border="0" cellspacing="0" cellpadding="0">

<tr>

<td> </td>

</tr>

<tr>

<td colspan="3"> </td>

</tr>

<tr>

<td colspan="3"> </td>

</tr>

<tr>

<td colspan="3">

<table width="647" border="1" cellspacing="0" cellpadding="0">

<tr bgcolor="#00FFCC">

<td width="36"><div align="center">Cód Enc. </div></td>

<td width="65"><div align="center">Cliente</div></td>

<td width="77"><div align="center">Produtos</div></td>

<td width="24"><div align="center">Qtd</div></td>

<td width="65"><div align="center">Data pedido </div></td>

<td width="67"><div align="center">Data entrega </div></td>

<td width="62"><div align="center">Tel Fixo </div></td>

<td width="65"><div align="center">E-mail</div></td>

<td width="65"><div align="center">Tel Cel </div></td>

<td width="21"><div align="center">Uf</div></td>

<td width="76"><div align="center">Cidade</div></td>

</tr>

<tr>

<td> </td>

</tr>

<tr>

<?php do { ?>

<td><div align="center"><?php echo $row_Recordset_resultado_busca_encomenda['cliente']; ?></div></td>

<td><div align="center"><?php echo $row_Recordset_resultado_busca_encomenda['produtos']; ?></div></td>

<td><div align="center"><?php echo $row_Recordset_resultado_busca_encomenda['quantidade']; ?></div></td>

<td><div align="center"><?php echo $row_Recordset_resultado_busca_encomenda['datadopedido']; ?></div></td>

<td><div align="center"><?php echo $row_Recordset_resultado_busca_encomenda['prazoentrega']; ?></div></td>

<td><div align="center"><?php echo $row_Recordset_resultado_busca_encomenda['telfixo']; ?></div></td>

<td><div align="center"><?php echo $row_Recordset_resultado_busca_encomenda['email']; ?></div></td>

<td><div align="center"><?php echo $row_Recordset_resultado_busca_encomenda['telcelular']; ?></div></td>

<td><div align="center"><?php echo $row_Recordset_resultado_busca_encomenda['estado']; ?></div></td>

<td><div align="center"><?php echo $row_Recordset_resultado_busca_encomenda['cidade']; ?></div></td>

<?php } while ($row_Recordset_resultado_busca_encomenda = mysql_fetch_assoc($Recordset_resultado_busca_encomenda)); ?></tr>

</table> </td>

</tr>

<tr>

<td colspan="3"> </td>

</tr>

<tr>

<td colspan="3">

</td>

</tr>

<tr>

<td colspan="3"> </td>

</tr>

<tr>

<td colspan="3"><form id="form1" name="form1" method="post" action="">

<table width="524" border="0" cellspacing="0" cellpadding="0">

<tr>

<td width="104"><label></label></td>

<td width="10"><label></label></td>

<td width="410"><label></label></td>

</tr>

</table>

</form> </td>

</tr>

</table></td>

</tr>

<tr>

<td width="525"></td>

<td width="525"> </td>

<td width="1"> </tr>

</table></td>

</tr>

</table>

</div> <p align="center"> </p></td>

</tr>

</table>

<table>

</table>

</body>

</html>

<?php

mysql_free_result($Recordset_busca_encomenda);

?>

// Fim da página de busca de encomenda

Página de alteracao de encomenda:

<html>

<form method="post" name="form1" action="<?php echo $editFormAction; ?>">

<table align="center">

<tr valign="baseline">

<td nowrap align="right">Codigo:</td>

<td><?php echo $row_Recordset1['codigo']; ?></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Cliente:</td>

<td><input type="text" name="cliente" value="<?php echo $row_Recordset1['cliente']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Telfixo:</td>

<td><input type="text" name="telfixo" value="<?php echo $row_Recordset1['telfixo']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Telcelular:</td>

<td><input type="text" name="telcelular" value="<?php echo $row_Recordset1['telcelular']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Endereco:</td>

<td><input type="text" name="endereco" value="<?php echo $row_Recordset1['endereco']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Bairro:</td>

<td><input type="text" name="bairro" value="<?php echo $row_Recordset1['bairro']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Cidade:</td>

<td><input type="text" name="cidade" value="<?php echo $row_Recordset1['cidade']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Estado:</td>

<td><input type="text" name="estado" value="<?php echo $row_Recordset1['estado']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Cep:</td>

<td><input type="text" name="cep" value="<?php echo $row_Recordset1['cep']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Email:</td>

<td><input type="text" name="email" value="<?php echo $row_Recordset1['email']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Produtos:</td>

<td><input type="text" name="produtos" value="<?php echo $row_Recordset1['produtos']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Datadopedido:</td>

<td><input type="text" name="datadopedido" value="<?php echo $row_Recordset1['datadopedido']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Prazoentrega:</td>

<td><input type="text" name="prazoentrega" value="<?php echo $row_Recordset1['prazoentrega']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right">Quantidade:</td>

<td><input type="text" name="quantidade" value="<?php echo $row_Recordset1['quantidade']; ?>" size="32"></td>

</tr>

<tr valign="baseline">

<td nowrap align="right"> </td>

<td><input type="submit" value="Update record"></td>

</tr>

</table>

<input type="hidden" name="MM_update" value="form1">

<input type="hidden" name="codigo" value="<?php echo $row_Recordset1['codigo']; ?>">

</form>

<p> </p>

<?php require_once('Connections/ConnImasters.php'); ?>

<?php

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {

$updateSQL = sprintf("UPDATE encomendas SET cliente=%s, telfixo=%s, telcelular=%s, endereco=%s, bairro=%s, cidade=%s, estado=%s, cep=%s, email=%s, produtos=%s, datadopedido=%s, prazoentrega=%s, quantidade=%s WHERE codigo=%s",

GetSQLValueString($_POST['cliente'], "text"),

GetSQLValueString($_POST['telfixo'], "int"),

GetSQLValueString($_POST['telcelular'], "text"),

GetSQLValueString($_POST['endereco'], "text"),

GetSQLValueString($_POST['bairro'], "text"),

GetSQLValueString($_POST['cidade'], "text"),

GetSQLValueString($_POST['estado'], "text"),

GetSQLValueString($_POST['cep'], "text"),

GetSQLValueString($_POST['email'], "text"),

GetSQLValueString($_POST['produtos'], "text"),

GetSQLValueString($_POST['datadopedido'], "date"),

GetSQLValueString($_POST['prazoentrega'], "text"),

GetSQLValueString($_POST['quantidade'], "int"),

GetSQLValueString($_POST['codigo'], "int"));

mysql_select_db($database_ConnImasters, $ConnImasters);

$Result1 = mysql_query($updateSQL, $ConnImasters) or die(mysql_error());

$updateGoTo = "encomenda_alterada.php";

if (isset($_SERVER['QUERY_STRING'])) {

$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";

$updateGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $updateGoTo));

}

$colname_Recordset1 = "-1";

if (isset($_GET['pegaCod'])) {

$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['pegaCod'] : addslashes($_GET['pegaCod']);

}

mysql_select_db($database_ConnImasters, $ConnImasters);

$query_Recordset1 = sprintf("SELECT * FROM encomendas WHERE codigo = %s", $colname_Recordset1);

$Recordset1 = mysql_query($query_Recordset1, $ConnImasters) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);

mysql_free_result($Recordset1);

?>

</html>

// fim da pagina de alteracao de encomenda

Alguém sabe me dizer porque os dados não aparecem no formulário da página "alteracao de encomenda"?

alebae · Abril 23, 2009

Bom, estava observando o value do seu input, não "busca" o registro procurado:

Exemplo, está assim:

<input name="codigo" type="text" id="codigo" value="" size="3" />

No value coloque o

<?php echo $_GET['codigo']; ?>" />

Entrar

Arquivado

Página alteração dados: Dados não aparecem no formulário

Recommended Posts

fredebsb 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

alebae 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

Estou criando uma calculadora de m2 e litros de tinta

Cruzamento de Bases

Consulta sem duplicação

Este projeto é apoiado pelas empresas

Fóruns

Tempo Real

Informação importante