demogestionar2.php
Código PHP:
<!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>Demo para gestionar la base de datos</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<?php
require_once("conexion.inc.php");
$conexion = mysql_connect($servidor, $usuario, $passwd);
$db = mysql_select_db($basedatos, $conexion);
if (!$conexion)
{
echo "Error al establecer la conexión con la base de datos: " . mysql_error();
exit();
}
if (!$db)
{
echo "Error seleccionando la base de datos: " . mysql_error();
exit();
}
$subcategoria = $_POST["subcategoria"];
?>
<body bgcolor="#F5F5F5" topmargin="10">
<table width="836" cellpadding="0" cellspacing="0" border="0">
<tr align="right" bgcolor="#FFFFFF">
<form id="boton" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<td colspan=2 width="209"><input name="insertar" type="submit" id="insertar" value="Insertar" /></td>
<td colspan=2 width="209"><input name="modificar" type="submit" id="modificar" value="Modificar" /></td>
<td colspan=2 width="209"><input name="borrar" type="submit" id="borrar" value="Borrar" /></td>
</form>
<td colspan=2 width="209"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="8" width="836" height="16"></td>
</tr>
<?php
if ($_POST["insertar"])
{
echo "<form action=\"confirmargestion.php\" method=\"post\" enctype=\"multipart/form-data\">";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Referencia:</td>";
echo "<td colspan=2 width=209><input name=\"referencia\" type=\"text\" id=\"referencia\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "<td colspan=2 width=209>Código de marcaje:</td>";
echo "<td colspan=2 width=209><input name=\"codigo_marcaje\" type=\"text\" id=\"codigo_marcaje\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Descripción:</td>";
echo "<td colspan=2 width=209><input name=\"descripcion\" type=\"text\" id=\"descripcion\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "<td colspan=2 width=209>Medida de marcaje:</td>";
echo "<td colspan=2 width=209><input name=\"medida_marcaje\" type=\"text\" id=\"medida_marcaje\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Colores:</td>";
echo "<td colspan=2 width=209><input name=\"colores\" type=\"text\" id=\"colores\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "<td colspan=2 width=209>Colores máximos de marcaje:</td>";
echo "<td colspan=2 width=209><input name=\"colores_maximos\" type=\"text\" id=\"colores_maximos\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td>Imagen:</td>";
echo "<td colspan=3 align=\"center\"><input name=\"imagen\" type=\"file\" id=\"imagen\" style=\"background-color:#F5F5F5\" /></td>";
echo "<td colspan=2 width=209>Incremento:</td>";
echo "<td colspan=2 width=209><input name=\"incremento\" type=\"text\" id=\"incremento\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Precio según las unidades:</td>";
echo "<td colspan=2 width=209></td>";
echo "<td colspan=2 width=209></td>";
echo "<td colspan=2 width=209></td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td>25</td>";
echo "<td><input name=\"25\" type=\"text\" id=\"25\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "<td>100</td>";
echo "<td><input name=\"100\" type=\"text\" id=\"100\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "<td>500</td>";
echo "<td><input name=\"500\" type=\"text\" id=\"500\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "<td>5000</td>";
echo "<td><input name=\"5000\" type=\"text\" id=\"5000\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td>50</td>";
echo "<td><input name=\"50\" type=\"text\" id=\"50\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "<td>250</td>";
echo "<td><input name=\"250\" type=\"text\" id=\"250\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "<td>1000</td>";
echo "<td><input name=\"1000\" type=\"text\" id=\"1000\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "<td>10000</td>";
echo "<td><input name=\"10000\" type=\"text\" id=\"10000\" size=\"20\" style=\"background-color:#F5F5F5\" /></td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"16\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=7></td>";
echo "<td align=\"right\" style=\"padding-right:25px\"><input name=\"aceptar\" type=\"submit\" id=\"aceptar\" value=\"Aceptar\" /></td>";
echo "</tr>";
echo "</form>";
}
elseif ($_POST["modificar"])
{
echo "<form action=\"confirmargestion.php\" method=\"post\" enctype=\"multipart/form-data\">";
$resultado = mysql_query("SELECT * FROM " . $subcategoria);
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Referencia:</td>";
echo "<td colspan=2 width=209><select name=\"referencia\">";
while ($fila = mysql_fetch_array($resultado))
{
echo "<option value=\"" . $fila["referencia"] . "\">" . $fila["referencia"] . "</option>";
}
echo "</select></td>";
$producto = mysql_query("SELECT * FROM " . $_POST["subcategoria"] . " WHERE referencia = " . $_POST["referencia"]);
$elProducto = mysql_fetch_array($producto);
echo "<td colspan=2 width=209>Código de marcaje:</td>";
echo "<td colspan=2 width=209><input name=\"codigo_marcaje\" type=\"text\" id=\"codigo_marcaje\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["codigo_marcaje"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Descripción:</td>";
echo "<td colspan=2 width=209><input name=\"descripcion\" type=\"text\" id=\"descripcion\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["descripcion"] . "</td>";
echo "<td colspan=2 width=209>Medida de marcaje:</td>";
echo "<td colspan=2 width=209><input name=\"medida_marcaje\" type=\"text\" id=\"medida_marcaje\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["medida_marcaje"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Colores:</td>";
echo "<td colspan=2 width=209><input name=\"colores\" type=\"text\" id=\"colores\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["colores"] . "</td>";
echo "<td colspan=2 width=209>Colores máximos de marcaje:</td>";
echo "<td colspan=2 width=209><input name=\"colores_maximos\" type=\"text\" id=\"colores_maximos\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["colores_maximos"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td>Imagen:</td>";
echo "<td colspan=3 align=\"center\"><input name=\"imagen\" type=\"file\" id=\"imagen\" style=\"background-color:#F5F5F5\" /></td>";
echo "<td colspan=2 width=209>Incremento:</td>";
echo "<td colspan=2 width=209><input name=\"incremento\" type=\"text\" id=\"incremento\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["incremento"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Precio según las unidades:</td>";
echo "<td colspan=2 width=209></td>";
echo "<td colspan=2 width=209></td>";
echo "<td colspan=2 width=209></td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td>25</td>";
echo "<td><input name=\"25\" type=\"text\" id=\"25\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["25"] . "</td>";
echo "<td>100</td>";
echo "<td><input name=\"100\" type=\"text\" id=\"100\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["100"] . "</td>";
echo "<td>500</td>";
echo "<td><input name=\"500\" type=\"text\" id=\"500\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["500"] . "</td>";
echo "<td>5000</td>";
echo "<td><input name=\"5000\" type=\"text\" id=\"5000\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["5000"] . "</td>";
echo "</tr>";
Sigue abajo.