Ajuda UPDATE com checkbox

[rodrigobuch]

Pessoal preciso de ajuda para resolver um problema preciso fazer um update usando checkbox , o usuario faz uma consulta no banco que retorna uma tabela com os dados dos fornecedores até ai estatudo ok , agora não sei como fazer para selecionar determinado fornecedor e enviar para a pagina de UPDATE. estou usando dreamweaver 8

//codigo pagina resultado da consulta//

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

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

<?php

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Recordset1 = 100;

$pageNum_Recordset1 = 0;

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

$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];

}

$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$colname_Recordset1 = "-1";

if (isset($_POST['forneced'])) {

$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_POST['forneced'] : addslashes($_POST['forneced']);

}

mysql_select_db($database_fornecedor, $fornecedor);

$query_Recordset1 = sprintf("SELECT * FROM tab_fornec WHERE forneced LIKE '%%%s%%' ORDER BY forneced ASC", $colname_Recordset1);

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);

$Recordset1 = mysql_query($query_limit_Recordset1, $fornecedor) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

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

$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];

} else {

$all_Recordset1 = mysql_query($query_Recordset1);

$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);

}

$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

$queryString_Recordset1 = "";

if (!empty($_SERVER['QUERY_STRING'])) {

$params = explode("&", $_SERVER['QUERY_STRING']);

$newParams = array();

foreach ($params as $param) {

if (stristr($param, "pageNum_Recordset1") == false &&

stristr($param, "totalRows_Recordset1") == false) {

array_push($newParams, $param);

}

}

if (count($newParams) != 0) {

$queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));

}

}

$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);

?>

<table border=1" align="left" cellpadding="0" cellspacing="0" bordercolor="#000000" bgcolor="#000000" id="alter">

<tr>

<td bgcolor="#306090"><span class="style1">Código</span></td>

<td bgcolor="#306090"><span class="style1">Fornecedor</span></td>

<td bgcolor="#306090"><span class="style1">Serviços</span></td>

<td bgcolor="#306090"> </td>

</tr>

<form action="resultforneced.php" method="post" name="form1" target="_parent">

<?php do { ?>

<tr class="dif">

<td height="26"><span class="style3"><?php echo $row_Recordset1['cod]; ?></span></td>

<td><span class="style3"><?php echo $row_Recordset1['forneced']; ?></span></td>

<td><span class=style3"><?php echo $row_Recordset1['servicos]; ?></span></td>

<td><input name="" type="checkbox" value=""><input name="" type="submit" value="alterar">

</td>

</tr>

<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></form>

</table>

</body>

</html>

<?php

mysql_free_result($Recordset1);

?>

[ESerra]

Se você só for selecionar um usuário use RADIO, em vez de checkbox, se você for selecionar vários, ai pode usar a idéia de que eu passei no último post deste tópico.

[rodrigobuch]

é para selecionar um fornecedor por vez

[ESerra]

Então troca pra radio, e coloca no value o id do usuário...

[rodrigobuch]

mudei radio coloquei 'cod' no value e ele não traz na pagina de UPDATE as informação para alteração

[ESerra]

Posta o script, como ele está atualmente.

[rodrigobuch]

<form action="resultforneced.php" method="post" name="form1" target="_parent">

<?php do { ?>

<tr class="dif">

<td height="26"><span class="style3">

<label></label>

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

<td><span class=style3"><?php echo $row_Recordset1['forneced]; ?></span></td>

<td><span class="style3"><?php echo $row_Recordset1['servicos']; ?></span></td>

<td><label></label>

<input type="submit" value="alterar">

</td>

</tr>

<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></form>

</table>

</body>

</html>

<?php

mysql_free_result($Recordset1);

?>

o resto continua igual

[ESerra]

Cadê o radio?

[rodrigobuch]

Opa foi mal

<form action="resultforneced.php" method="post" name="form1" target="_parent">

<?php do { ?>

<tr class="dif">

<td height="26"><span class="style3">

<label></label>

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

<td><span class=style3"><?php echo $row_Recordset1['forneced]; ?></span></td>

<td><span class="style3"><?php echo $row_Recordset1['servicos']; ?></span></td>

<td><label></label>

<label>

<input name="radiobutton" type="radio" value="cod">

</label>

<input type="submit" value="alterar">

</td>

</tr>

<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></form>

</table>

[ESerra]

cod é o que? Se for a coluna do BD que guarda a chave primária, então o correto é:

<input name="radiobutton" type="radio" value="<?php echo $row_Recordset1['cod']; ?>">

[rodrigobuch]

Cara já havia feito isso ... ele vai para a pagina do update e não carrega os dados do campo selecionado

[ESerra]

Então coloca a página de update pra gente ver...

[rodrigobuch]

Olha ai galera

<?php require_once('../../../Connections/fornecedor.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"] == "form2")) {

$updateSQL = sprintf("UPDATE tab_fornec SET forneced=%s, servicos=%s, cnpj=%s, contato=%s, fone=%s, cel=%s, fax=%s, email=%s, homepage=%s, endereco=%s, bairro=%s, cep=%s WHERE cod=%s",

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

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

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

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

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

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

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

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

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

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

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

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

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

mysql_select_db($database_fornecedor, $fornecedor);

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

$updateGoTo = "consulta.php";

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

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

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

}

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

}

?>

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

<?php

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Recordset1 = 100;

$pageNum_Recordset1 = 0;

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

$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];

}

$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$colname_Recordset1 = "-1";

if (isset($_POST['forneced'])) {

$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_POST['forneced'] : addslashes($_POST['forneced']);

}

mysql_select_db($database_fornecedor, $fornecedor);

$query_Recordset1 = sprintf("SELECT * FROM tab_fornec WHERE forneced LIKE '%%%s%%' ORDER BY forneced ASC", $colname_Recordset1);

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);

$Recordset1 = mysql_query($query_limit_Recordset1, $fornecedor) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

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

$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];

} else {

$all_Recordset1 = mysql_query($query_Recordset1);

$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);

}

$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

$queryString_Recordset1 = "";

if (!empty($_SERVER['QUERY_STRING'])) {

$params = explode("&", $_SERVER['QUERY_STRING']);

$newParams = array();

foreach ($params as $param) {

if (stristr($param, "pageNum_Recordset1") == false &&

stristr($param, "totalRows_Recordset1") == false) {

array_push($newParams, $param);

}

}

if (count($newParams) != 0) {

$queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));

}

}

$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);

?>

<table border=1" align="left" cellpadding="0" cellspacing="0" bordercolor="#000000" bgcolor="#000000" id="alter">

<tr>

<td bgcolor="#306090">&nbsp;</td>

</tr>

<?php do { ?>

<tr class="dif">

<td height="26"><form name="form1" method="post" action="">

</form>

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

<table align="center">

<tr valign="baseline">

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

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

</tr>

<tr valign="baseline">

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

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

</tr>

<tr valign="baseline">

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

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

</tr>

<tr valign="baseline">

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

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

</tr>

<tr valign="baseline">

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

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

</tr>

<tr valign="baseline">

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

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

</tr>

<tr valign="baseline">

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

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

</tr>

<tr valign="baseline">

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

<td><input type="text" name="fax" value="<?php echo $row_Recordset1['fax']; ?>" 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">Homepage:</td>

<td><input type="text" name="homepage" value="<?php echo $row_Recordset1['homepage']; ?>" 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">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">&nbsp;</td>

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

</tr>

</table>

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

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

</form>

<p>&nbsp;</p></td>

</tr>

<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

</table>

</body>

</html>

<?php

mysql_free_result($Recordset1);

?>