hola, tengo un formulario para enviar los datos a la base pero no lo puedo hacer funcionar, ya que me agrega un valor mas en la base pero con los datos en blanco, aqui los codigos:
Código HTML:
Ver original<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <!--
body {
background-color: #000066;
}
body,td,th {
color: #FFFFFF;
}
.Estilo3 {font-family: Georgia, "Times New Roman", Times, serif; font-weight: bold; }
.Estilo4 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 10px;
}
.Estilo6 {font-family: Georgia, "Times New Roman", Times, serif; font-weight: bold; font-size: 12px; }
-->
<table width="100%" height="100%" border="0"> <td height="30" colspan="5"><div align="center" class="Estilo3"><img src="img/12.jpg" width="283" height="61"></div></td> <form action="ingreso.php" method="post"> <td width="216" height="30" align="right" valign="middle"><span class="Estilo6">Nombre
</span></td> <td width="34" height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <input name="nombre" type="text" size="30" maxlength="30"> <td width="158" height="30"> </td> <td width="216" height="30" align="right" valign="middle"><span class="Estilo6">Apellido
</span></td> <td width="34" height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <input name="apellido" type="text" id="apellido" size="30" maxlength="30"> <td width="158" height="30"> </td> <td height="30" align="right" valign="middle"><span class="Estilo6">Direcci
ón
</span></td> <td height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"><input name="direccion" type="text" size="50" maxlength="50"></td> <td height="30"> </td> <td height="30" align="right" valign="middle"><span class="Estilo6">Tel
éfono
</span></td> <td height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <input name="telefono" type="text" size="15" maxlength="15"> <td height="30"> </td> <td height="30" align="right" valign="middle"><span class="Estilo6">M
óvil
</span></td> <td height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <input name="movil" type="text" size="15" maxlength="15"> <td height="30"> </td> <td height="30" align="right" valign="middle"><span class="Estilo6">Otro
</span></td> <td height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <input name="otro" type="text" size="15" maxlength="15"> <td height="30"> </td> <td height="30" align="right" valign="middle"><span class="Estilo6">e-mail
</span></td> <td height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <input name="email" type="text" size="40" maxlength="40"> <td height="30"> </td> <td height="30" align="right" valign="middle"><span class="Estilo6">e-mail2
</span></td> <td height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <input name="email2" type="text" id="email2" size="40" maxlength="40"> <td height="30"> </td> <td height="30" align="right" valign="middle"><span class="Estilo6">Tipo
</span></td> <td height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <td height="30"> </td> <td height="30" align="right" valign="middle"><span class="Estilo6">Inmueble
</span></td> <td height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <input name="operacion" type="text" size="50" maxlength="50"> <td height="30"> </td> <td height="30" align="right" valign="middle"><span class="Estilo6">Monto
</span></td> <td height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <input name="monto" type="text" size="30" maxlength="30"> <td height="30"> </td> <td height="30" align="right" valign="middle"><span class="Estilo6">Fecha de Operaci
ón
</span></td> <td height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <input name="fecha" type="text" size="10" maxlength="10"> <td height="30"> </td> <td height="30" align="right" valign="middle"><span class="Estilo6">Compartida
</span></td> <td height="30" align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <input name="compartida" type="text" size="50" maxlength="50"> <td height="30"> </td> <td height="30" align="right" valign="middle"><span class="Estilo6">Observaciones
</span></td> <td align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> <td height="30"> </td> <td height="30" align="right" valign="top"> </td> <td align="right" valign="middle"> </td> <td height="30" colspan="2" align="left" valign="middle"> </td> <td height="30"> </td> <td height="30" align="right" valign="middle"><div align="center"> <td align="right" valign="middle"> </td> <td width="258" height="30" align="left" valign="middle"> <input type=submit value=Guardar> <td width="284" align="left" valign="middle"> <input type=reset value=Limpiar> <td height="30"><input name="INICIO" type="BUTTON" id="INICIO" onClick="location.href = 'index.html'" value=" Inicio "></td>
Código PHP:
Ver original<title>Clientes</title>
<?
include "conexion.php";
$result=mysql_query ("INSERT INTO clientes(nombre, apellido, direccion, telefono, movil, otro, email, email2, estado, operacion, monto, fecha, compartida, observaciones, usuario) VALUES ('$nombre','$apellido','$direccion','$telefono','$movil','$otro','$email','$email2','$estado','$operacion','$monto','$fecha','$compartida','$observaciones','$usuario')");
?>
<style type="text/css">
<!--
body {
background-color: #000066;
}
body,td,th {
color: #FFFFFF;
}
.Estilo1 {font-family: Georgia, "Times New Roman", Times, serif}
-->
</style>
<table width="100%" height="100%" border="0">
<tr>
<td height="63" colspan="4"><div align="center"><img src="img/11.jpg" width="400" height="40"></div></td>
</tr>
<tr>
<td width="182" height="25"> </td>
<td width="272"> </td>
<td width="263"> </td>
<td width="197"> </td>
</tr>
<tr>
<td height="26"> </td>
<td><form>
<div align="center">
<input name="INICIO" type="BUTTON" id="INICIO" onClick="location.href = 'index.html'" value=" Inicio ">
</div>
</form></td>
<td><form>
<div align="center">
<input type="button" value="Ingresar otro" onClick="location.href = 'clientes.php' ">
</div>
</form></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</html>
Código PHP:
Ver original<?php
$dbhost="localhost"; // host del MySQL (generalmente localhost)
$dbusuario="root"; // aqui debes ingresar el nombre de usuario
// para acceder a la base
$dbpassword="*********"; // password de acceso para el usuario de la
// linea anterior
$db="2019"; // Seleccionamos la base con la cual trabajar
?>
por qué razon no se envian los datos ingresados en el formulario?
gracias!!!