Amigos: por favor ayudenme a resolver este problema, les cuento:
Tengo un formulario, donde hay cajas de texto, que el usuario las completa y luego preciona el boton y debiera insertar los datos, para peor y me da rabia, los datos estan en una pura tabla, y no puedo.......Ayuda plissss..
dejo el codigo del formulario:
<?php
include("config.php");
$query = "INSERT INTO cliente (nombre, rut, dv, fecha_ingreso, giro, telefono1, telefono2, direccion, fax1, fax2, region, pagina_web, provincia, comentario, comuna)
values ('{$_POST['txt_nomcli']}','{$_POST['txt_rutcli']}','{$_POST['txt_dvcli']}','{$_POST['txt_campo_fecha']}','{$_POST['txt_girocli']}','{$_POST['txt_telecli1']}','{$_POST['txt_telecli2']}','{$_POST['txt_direcli']}','{$_POST['txt_faxcli']}','{$_POST['txt_faxcli2']}','{$_POST['txt_regicli']}','{$_POST['txt_pwcli']}','{$_POST['txt_provicli']}','{$_POST['txt_comencli']}','{$_POST['txt_comucli']}')";
$response = mysql_query($query, $conn);
?>
<html>
<head>
</head>
<body>
<form id="insertar" name="fvalida" method="post" action="">
<table width="750" border="1">
<tr>
<td colspan="2" class="Estilo3"> Empresa de Bellesas</td>
</tr>
<tr>
<td colspan="2" align="center"><b><i>Ingreso Nuevos Clientes</b></i> </td>
</tr>
<tr>
<td height="40" colspan="2">Nombre del Cliente :
<input name="txt_nomcli" type="text" id="txt_nomcli" size="50" maxlength='100' align="middle"
value="<?php print (isset($_POST['txt_nomcli']))?$_POST['txt_nomcli']:'';?>"
onFocus="foco(this);"
onBlur="no_foco(this);"
style="border:1px solid #CCCCCC"/>
</td>
</tr>
<tr>
<td width="375">R.U.T :
<input name="txt_rutcli" type="text" id="txt_rutcli" size='7' maxlength='8' align="middle"
value="<?php print (isset($_POST['txt_rutcli']))?$_POST['txt_rutcli']:'';?>"
onFocus="foco(this);"
onBlur="no_foco(this);"
style="border:1px solid #CCCCCC"/>
-
<input name="txt_dvcli" type="text" id="txt_dvcli" size='1' maxlength='1' align="middle"
value="<?php print (isset($_POST['txt_dvcli']))?$_POST['txt_dvcli']:'';?>"
onFocus="foco(this);"
onBlur="no_foco(this);"
style="border:1px solid #CCCCCC"/>
</td>
<td width="375">Fecha de Ingreso :
<input type="text" name="campo_fecha" id="campo_fecha" size="8"
onFocus="foco(this);"
onBlur="no_foco(this);"
style="border:1px solid #CCCCCC"/>
<input style="cursor:pointer" type="button" id="lanzador" value="...">
<!-- script que define y configura el calendario-->
<script type="text/javascript">
Calendar.setup({
inputField : "campo_fecha", // id del campo de texto
ifFormat : "%d/%m/%Y", // formato de la fecha, cuando se escriba en el campo de texto
button : "lanzador", // el id del botón que lanzará el calendario
});
</script>
<!-- Fin Calendario -->
</td>
</tr>
<tr>
<td height="40">Giro de la Empresa :
<input name="txt_girocli" type="text" id="txt_girocli" size='20' maxlength='100' align="middle"
value="<?php print (isset($_POST['txt_girocli']))?$_POST['txt_girocli']:'';?>"
onFocus="foco(this);"
onBlur="no_foco(this);"
style="border:1px solid #CCCCCC"/>
</td>
<td>Telefono 1:
<select name="Codigo_Area" id="codigoarea" class="cortisimo">
<option value=""></option>
<option value="02">02</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="45">45</option>
<option value="51">51</option>
<option value="52">52</option>
<option value="53">53</option>
<option value="55">55</option>
<option value="57">57</option>
<option value="58">58</option>
<option value="61">61</option>
<option value="63">63</option>
<option value="64">64</option>
<option value="65">65</option>
<option value="67">67</option>
<option value="71">71</option>
<option value="72">72</option>
<option value="73">73</option>
<option value="75">75</option>
</select>
<input name="txt_telecli" type="text" id="txt_telecli" size='11' maxlength='15' align="middle"
value="<?php print (isset($_POST['txt_telecli']))?$_POST['txt_telecli']:'';?>"
onFocus="foco(this);"
onBlur="no_foco(this);"
style="border:1px solid #CCCCCC"/><BR>
Telefono 2:
<select name="Codigo_Area2" id="codigoarea2" class="cortisimo">
<option value=""></option>
<option value="02">02</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="45">45</option>
<option value="51">51</option>
<option value="52">52</option>
<option value="53">53</option>
<option value="55">55</option>
<option value="57">57</option>
<option value="58">58</option>
<option value="61">61</option>
<option value="63">63</option>
<option value="64">64</option>
<option value="65">65</option>
<option value="67">67</option>
<option value="71">71</option>
<option value="72">72</option>
<option value="73">73</option>
<option value="75">75</option>
</select>
<input name="txt_tele2cli" type="text" id="txt_tele2cli" size='10' maxlength='15' align="middle" value="<?php print (isset($_POST['txt_tele2cli']))?$_POST['txt_tele2cli']:'';?>"/>
</td>
</tr>
<tr>
<td height="40">Direccion Of. Central :
<input name="txt_direcli" type="text" id="txt_direcli" size='20' maxlength='100' align="middle"
value="<?php print (isset($_POST['txt_direcli']))?$_POST['txt_direcli']:'';?>"
onFocus="foco(this);"
onBlur="no_foco(this);"
style="border:1px solid #CCCCCC"/>
</td>
<td>Fax 1:
<input name="txt_faxcli" type="text" id="txt_faxcli" size='10' maxlength='15' align="middle"
value="<?php print (isset($_POST['txt_faxcli']))?$_POST['txt_faxcli']:'';?>"/>
Fax 2 :
<input name="txt_fax2cli" type="text" id="txt_fax2cli" size='10' maxlength='15' align="middle"
value="<?php print (isset($_POST['txt_fax2cli']))?$_POST['txt_fax2cli']:'';?>"/>
</td>
</tr>
<tr>
<td>Pagina Web :
<input name="txt_pwcli" type="text" id="txt_pwcli" size='20' maxlength='100' align="middle"
value="<?php print (isset($_POST['txt_pwcli']))?$_POST['txt_pwcli']:'';?>"/>
</td>
</tr>
<tr>
<td align="center" rowspan="2">Comentario Sobre el Cliente:<BR>
<textarea name="txt_comencli" id="txt_comencli"rows="4" cols="30"></textarea>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="button" name="crear" value="Enviar" class="Estilo3" onClick="valida_envia()">
<input type="RESET" name="limpiar" class="Estilo3" value="Limpiar">
</td>
</tr>
</table>
</form>
************************************************** *************
Y este es mi archivo config.php, que llamo al principio:
<?
$mybase ='prueba';
$myip ='localhost';
$myuser ='javierita';
$mypass ='1234';
$dbi = mysql_connect($myip,$myuser,$mypass)or die ('Ha fallado la conexión: '.mysql_error()); // conexion a motor mysql
mysql_select_db($mybase)or die ('Error al seleccionar la Base de Datos: '.mysql_error()); // seleccion de base de datos a usar
?>
</body>
</html>