Hola,
Bueno quiero crear un formulario desde el cual pueda actualizar mi base de datos MYSQL.
FUNCIONA:
Bueno el formulario llama a todas las entradas de MYSQL perfectamente
FALTA:
No atualiza los datos
Muchas gracias si alguien me puede dar una mano!
Código PHP:
<?php require_once('../Connections/conn_newland.php'); ?>
<?php
mysql_select_db($database_conn_newland, $conn_newland);
$query_Recordset1 = "SELECT * FROM tbl_instructores";
$Recordset1 = mysql_query($query_Recordset1, $conn_newland) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
//$totalRows_Recordset1 = mysql_num_rows($Recordset1);
if ((isset($_POST["Update"])) && ($_POST["Update"] == "UpForm")) {
for ($i = 0; $i < count($_POST['ID']); $i++)
{
$updateSQL = sprintf("UPDATE tbl_instructores Firstname='".$_POST['Firstname'][$i]."', item_order='".$_POST['item_order'][$i]."' WHERE ID='".$_POST['ID'][$i]."' ");
mysql_select_db($database_conn_newland, $conn_newland);
$Result1 = mysql_query($updateSQL, $conn_newland) or die(mysql_error());
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php do { ?>
<form method="post" name="UpForm" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="hidden" name="Update" value="UpForm">
<table border='1'>
<tr valign="top">
<td nowrap align="center">ID:</td>
<td nowrap align="center">First Name:</td>
<td nowrap align="center">First Name UPDATE :</td>
<td nowrap align="center">Item_order:</td>
</tr>
<input type="hidden" name="ID[]" value="<?php echo $row_Recordset1['ID']; ?>">
<tr valign="top">
<td><?php echo $row_Recordset1['ID']; ?></td>
<td><?php echo $row_Recordset1['Firstname']; ?></td>
<td><input type="text" name="Firstname[]" value="<?php echo $row_Recordset1['Firstname']; ?>"></td>
<td><input type="text" name="textfield"></td>
</tr>
<tr valign="top">
<td><?php echo $row_Recordset1['ID']; ?></td>
<td><?php echo $row_Recordset1['Fisrtname']; ?></td>
<td><input type="text" name="level[]" value="<?php echo $row_Recordset1['Firstname']; ?>" size="6"></td>
<td><input type="text" name="item_order[]" value="<?php echo $row_Recordset1['Firstname']; ?>" size="6"></td>
</tr>
</table>
<td><input type="submit" value="GO"></td>
</form>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
<p> </p>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>