Por un lado tengo un formulario en el cual doy de alta un comercio.
Este es el PHP
Código PHP:
<FORM METHOD="POST" ACTION="insert_comercio.php">
<table align="center" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="54%" id="AutoNumber1" height="195">
<tr bgcolor="#CCCCCC">
<td height="19" colspan="6"><span class="style2"><font face="Verdana" size="1">
REGISTRO DE COMERCIO:</font></span></td>
</tr>
<tr>
<td height="19" colspan="6"> </td>
</tr>
<tr>
<td width="25%" height="24"><font face="Verdana" size="1">Razon Social </font></td>
<td width="1%" height="24"> </td>
<td width="28%" height="24"><INPUT NAME="razon_social" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="24"><font face="Verdana" size="1">Responsable:</font></td>
<td width="1%" height="24"> </td>
<td width="33%" height="24"><INPUT NAME="responsable" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Dirección:</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="direccion" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="19"><font face="Verdana" size="1">C.U.I.T.:</font></td>
<td width="1%" height="19"> </td>
<td width="33%" height="19">
<label>
<INPUT NAME="cuit" MAXLENGTH="100" TYPE="TEXT" VALUE="">
</label> </td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Teléfono:</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="telefono" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="19"><font face="Verdana" size="1">Celular:</font></td>
<td width="1%" height="19"> </td>
<td width="33%" height="19"><INPUT NAME="celular" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Ciudad:</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="ciudad" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="19"><font face="Verdana" size="1">Mail:</font></td>
<td width="1%" height="19"> </td>
<td width="33%" height="19"><INPUT NAME="mail" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Cod. Postal:</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="cod_postal" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="19"><font face="Verdana" size="1">Estado:</font></td>
<td width="1%" height="19"> </td>
<td width="33%" height="19"><select name="estado">
<option value="0">SI</option>
<option value="1">NO</option>
</select></td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Observaciones:</font></td>
<td width="1%" height="19"> </td>
<td height="19" colspan="4">
<label>
<textarea name="observaciones" cols="50"></textarea>
</label> </td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Usuario:</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="usuario" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="19"><font face="Verdana" size="1">Password:</font></td>
<td width="1%" height="19"> </td>
<td width="33%" height="19"><INPUT NAME="password" MAXLENGTH="100" TYPE="password" VALUE=""></td>
</tr>
<tr>
<td height="19" colspan="6"> </td>
</tr>
<tr>
<td height="19" colspan="6"><div align="center">
<input name="Reset" type="RESET" Value="Limpiar Datos">
<INPUT NAME="boton" TYPE="SUBMIT" VALUE="Grabar Datos">
</div></td>
</tr>
</table>
</form>
Código PHP:
<?php
$con = mysql_connect("localhost","USER","PASS");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("BASE DE DATOS", $con);
$sql="INSERT INTO comercio (razon_social,responsable,direccion,cuit,telefono,celular,ciudad,mail,cod_postal,estado,observaciones,usuario,password)
VALUES
('$_POST[razon_social]','$_POST[responsable]','$_POST[direccion]','$_POST[cuit]','$_POST[telefono]','$_POST[celular]','$_POST[ciudad]','$_POST[mail]','$_POST[cod_postal]','$_POST[estado]','$_POST[observaciones]','$_POST[usuario]','$_POST[password]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
//echo "1 record added";
mysql_close($con);
header ("Location: index.php");
?> Código PHP:
-- Estructura de tabla para la tabla `comercio`
--
CREATE TABLE `comercio` (
`id_comercio` int(50) NOT NULL auto_increment,
`razon_social` varchar(100) NOT NULL,
`responsable` varchar(100) NOT NULL,
`direccion` varchar(100) NOT NULL,
`cuit` varchar(100) NOT NULL,
`telefono` varchar(100) NOT NULL,
`celular` varchar(100) NOT NULL,
`ciudad` varchar(100) NOT NULL,
`mail` varchar(100) NOT NULL,
`cod_postal` varchar(100) NOT NULL,
`observaciones` varchar(100) NOT NULL,
`usuario` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
`estado` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id_comercio`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
Pero la verdad no me esta funcionando, sigue igual me logueo de cualquier forma. Alguien puede darme una mano y ayudarme a ver en que puedo estar fallando.
Saludos y Gracias
