0

Erro ao gravar dados do formulario no mysql

criado por eduardo ripoll em 14/10/2011 3:26pm
Ola pessoal,

Sou iniciante em PHP. Gostaria de ajuda neste problema.
Estou tentando gravar os dados do formulario.php no banco de dados mysql, mas nao funciona. Ja tentei diversos códigos / scripts e nada funciona. Segue o codigo abaixo para alguem tentar me ajudar:

config.php
_______________
<?php
$host = "localhost"; //Servidor do mysql
$user = "login"; //Usuario do banco de dados
$senha = "senha"; //senha do banco de dados
$db = "sistem"; //banco de dados
$nome_site = "Testando Site"; //Nome do site
$email = "xxx@gmail.com"; //E-mail do administrador
$site = "http://www.dominio.com.br"; //Seu site n se esuqece de bota o http://

mysql_connect($host, $user, $senha) or die (mysql_error());
mysql_select_db($db) or die (mysql_error());
?>
-------------------------------------- fim -----------------------------

cadastro.php (este é para cadastrar os dados do formulario)

<html>
<head>
<title> inserindo</title>
<meta http-equiv="Content-Type" content"text/html; charset=iso-8859-1">
</head>
<body>
<?php
require("config.php")

$nome = $_POST ['nome'];
$documento = $_POST ['documento'];
$sexo = $_POST ['sexo'];
$estado_civil = $_POST ['estado_civil'];
$data_nascimento = $_POST ['data_nascimento'];
$rg = $_POST ['rg'];
$orgao_expedidor= $_POST ['orgao_expedidor'];
$nome_mae = $_POST ['nome_mae'];
$profissao = $_POST ['profissao'];
$fone_residencial = $_POST ['fone_residencial'];
$fone_celular = $_POST ['fone_celular'];
$fone_comercial = $_POST ['fone_comercial'];
$endereco = $_POST ['endereco'];
$numero = $_POST ['numero'];
$complemento = $_POST ['complemento'];
$bairro = $_POST ['bairro'];
$estado = $_POST ['estado'];
$cidade = $_POST ['cidade'];
$cep = $_POST ['cep'];
$ponto_referencia = $_POST ['ponto_referencia'];
$pacotes = $_POST ['pacotes'];
$planos = $_POST ['planos'];
$promo = $_POST ['promo'];
$degust = $_POST ['degust'];
$canais_adicionais = $_POST ['canais_adicionais'];
$ponto_adicional = $_POST ['ponto_adicional'];
$ponto_escravo = $_POST ['ponto_escravo'];
$banco = $_POST ['banco'];
$agencia = $_POST ['agencia'];
$conta_corrente = $_POST ['conta_corrente'];
$data_vencimento = $_POST ['data_vencimento'];
$mes_venda = $_POST ['mes_venda'];
$data_venda = $_POST ['data_venda'];
$nr_proposta = $_POST ['nr_proposta'];
$nr_contrato = $_POST ['nr_contrato'];
$tec_hab = $_POST ['tec_hab'];
$data_agenda = $_POST ['data_agenda'];
$turno_agenda = $_POST ['turno_agenda'];
$instalado = $_POST ['instalado'];
$decoder_hab = $_POST ['decoder_hab'];
$smart_hab = $_POST ['smart_hab'];
$status_venda = $_POST ['status_venda'];
$observacoes = $_POST ['observacoes'];

$sqlinsert = "INSERT INTO clientes (id_cliente,nome,documento,sexo,estado_civil,data_nascimento,rg,orgao_expedidor,nome_mae,profissao,fone_residencial,fone_celular,fone_comercial,email,numero,complemento,bairro,estado,
cidade,cep,ponto_referencia,pacotes,planos,promo,degust,canais_adicionais,ponto_adicional,ponto_escravo,banco,agencia,conta_corrente,data_vencimento,mes_venda,
data_venda,nr_proposta,nr_contrato,tec_hab,data_agenda,turno_agenda,instalado,decoder_hab,smart_hab,status_venda,observacoes) VALUES (null,'$nome','$documento','$sexo','$estado_civil','$data_nascimento','$rg','$orgao_expedidor','$nome_mae','$profissao','$fone_residencial','$fone_celular','$fone_comercial',
'$email','$endereco','$numero','$complemento','$bairro','$estado','$cidade','$cep','$ponto_referencia','$pacote','$plano','$promo','$degust','$canais_adicionais',
'$ponto_adicional','$ponto_escravo','$banco','$agencia','$conta_corrente','$data_vencimento','$mes_venda','$data_venda','$nr_proposta','$nr_contrato','$tec_hab',
'$data_agenda','$turno_agenda','$instalado','$decoder_hab','$smart_hab','$status_venda','$observacoes')";

$inserir=mysql_query($comando_sql,$conexao) or die(mysql_error());
?>
</body>
</html>

------------------- fim -----------------------

formulario de cadastro (cadastro_vendas.php)

<?php
include("config.php");
include("restrito.php");

$sql_busca = "SELECT * FROM user WHERE login = '$login_usuario'";
$exe_busca = mysql_query($sql_busca) or die (mysql_error());
$fet_busca = mysql_fetch_assoc($exe_busca);
$query = mysql_query("SELECT pacote FROM pacote");

?>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>ALPHA - Cadastro de Vendas</title>
<script language="JavaScript">
<!--
function mmLoadMenus() {
if (window.mm_menu_1010171106_0) return;
window.mm_menu_1010171106_0 = new Menu("root",169,18,"Verdana, Arial, Helvetica, sans-serif",12,"#FFFFFF","#FFFFFF","#000099","#0066CC","left","middle",3,0,1000,-5,7,true,true,false,0,true,true);
mm_menu_1010171106_0.addMenuItem("Cadastrar&nbsp;Vendas","location='cadastrar_vendas.php'");
mm_menu_1010171106_0.addMenuItem("Consultar&nbsp;Vendas","location='consultar_vendas.php'");
mm_menu_1010171106_0.addMenuItem("Alterar&nbsp;/&nbsp;Excluir&nbsp;Vendas","location='alterar_vendas.php'");
mm_menu_1010171106_0.hideOnMouseOut=true;
mm_menu_1010171106_0.bgColor='#555555';
mm_menu_1010171106_0.menuBorder=1;
mm_menu_1010171106_0.menuLiteBgColor='#FFFFFF';
mm_menu_1010171106_0.menuBorderBgColor='#777777';

window.mm_menu_1010171431_0 = new Menu("root",172,18,"Verdana, Arial, Helvetica, sans-serif",12,"#FFFFFF","#FFFFFF","#000099","#0066CC","left","middle",3,0,1000,-5,7,true,true,false,0,true,true);
mm_menu_1010171431_0.addMenuItem("Cadastar&nbsp;Equipamento","location='cadastro_equipamento.php'");
mm_menu_1010171431_0.addMenuItem("Consultar&nbsp;Estoque","location='consultar_estoque.php'");
mm_menu_1010171431_0.addMenuItem("Alterar&nbsp;/&nbsp;Excluir&nbsp;Estoque","location='alterar_estoque.php'");
mm_menu_1010171431_0.hideOnMouseOut=true;
mm_menu_1010171431_0.bgColor='#555555';
mm_menu_1010171431_0.menuBorder=1;
mm_menu_1010171431_0.menuLiteBgColor='#FFFFFF';
mm_menu_1010171431_0.menuBorderBgColor='#777777';

mm_menu_1010171431_0.writeMenus();
} // mmLoadMenus()
//-->
</script>
<script language="JavaScript" src="mm_menu.js"></script>
</head>


<body bgcolor="#C0C1F8" text="#000000" link="#000000" alink="#000000">
<p>
<script language="JavaScript1.2">mmLoadMenus();</script>
</p>


<form name="form1" id="form1" method="post" action="cadastro.php">
<input type="hidden" name="operacao" value="cadastar_venda" />
<script language="JavaScript" type="text/javascript" src="mascara.js"></script>

<table width="1024" border="0" align="center" bgcolor="#FFFFFF" id="container">
<tr>
<td width="197" height="15"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><img src="logo_parceiro.png" width="122" height="75" /></font></td>
<td width="233"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
<td width="203"><div align="center"></div></td>
<td colspan="2"><p align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="logout.php"></a><img src="logo_embratel.png" width="122" height="75" /></font></p></td>
</tr>
<tr>
<td height="21"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
<td colspan="2"><div align="right">
<script language="JavaScript1.2" type="text/JavaScript1.2">mmLoadMenus();</script>
</div></td>
</tr>
<tr>
<td height="21" colspan="5"><img src="menu.png" name="image1" width="1024" height="25" border="0" usemap="#MapMap" id="image1" /></td>
</tr>
<tr>
<td height="21"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
<td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
</tr>
<tr>
<td rowspan="15"><div align="left"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><img src="menu_vert.png" width="150" height="300" border="0" align="top" usemap="#Map2" /></font><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></div></td>
<td height="21" colspan="4"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Cadastro
de Vendas
</font></div></td>
</tr>
<tr>
<td height="21" colspan="4"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
</tr>
<tr>
<td height="21" colspan="4" bgcolor="#B9C0F4"> <div align="center"><font color="#000066" size="2" face="Verdana, Arial, Helvetica, sans-serif">Dados
Cliente:
</font></div></td>
</tr>
<tr>
<td height="21"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Nome
do Cliente </font></div></td>
<td colspan="3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="nome" id="nome" size="50"/>
<span class="style1"><font color="#FF0000">*</font></span></font></td>
</tr>
<tr>
<td height="21"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">CPF
/ CNPJ</font></div></td>
<td colspan="3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="documento" id="documento" />
<span class="style1"><font color="#FF0000">*</font></span> <font color="#333333" size="1">*Somente
N&uacute;meros (sem tra&ccedil;os, barras ou pontos)</font></font></td>
</tr>
<tr>
<td height="21">
<div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Sexo</font></div></td>
<td colspan="3"><font color="#FF0000" size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="sexo" id="sexo">
<option>Feminino</option>
<option>Masculino</option>
</select>
</font><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><span class="style1"><font color="#FF0000">*</font></span></font></td>
</tr>
<tr>
<td height="21"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Estado
Civil</font></div></td>
<td colspan="3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="estado_civil" id="estado_civil">
<option>Casado(a)</option>
<option>Solteiro(a)</option>
<option>Separado(a)</option>
<option>Viuvo(a)</option>
</select>
&nbsp;</font></td>
</tr>
<tr>
<td height="21"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Data
Nascimento</font></div></td>
<td colspan="3"><input type="text" name="data_nascimento" id="data_nascimento" onKeyPress="MascaraData(form1.data);"
maxlength="10" onBlur= "ValidaDataform1.data);"> <font color="#FF0000"><span class="style1">*</span></font>
<font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font color="#333333" size="1">*Somente
N&uacute;meros (sem tra&ccedil;os, barras ou pontos)</font></font> </tr>
<tr>
<td height="21"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">RG&nbsp;</font></div></td>
<td colspan="3"><input type="text" name="rg" id="rg" /> <span class="style1"><font color="#FF0000">*</font>
</span><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font color="#333333" size="1">*Somente
N&uacute;meros (sem tra&ccedil;os, barras ou pontos)</font></font></td>
</tr>
<tr>
<td height="21"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Org&atilde;o
Expedidor</font></div></td>
<td colspan="3"><input type="text" name="orgao_expedidor" id="orgao_expedidor" />
<span class="style1"><font color="#FF0000">*</font></span></td>
</tr>
<tr>
<td height="21"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Nome
da M&atilde;e</font></div></td>
<td colspan="3"><input type="text" name="nome_mae" id="nome_mae" size="50"/>
<span class="style1"><font color="#FF0000">*</font></span></td>
</tr>
<tr>
<td height="21"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Profiss&atilde;o</font></div></td>
<td colspan="3"><input type="text" name="profissao" id="profissao" size"50" />
<span class="style1"><font color="#FF0000">*</font></span></td>
</tr>
<tr>
<td height="21"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Fone
Residencial</font></div></td>
<td colspan="3"><input type="text" name="fone_residencial" id="fone_residencial" onKeyPress="MascaraTelefone(form1.tel);"
maxlength="14" onBlur="ValidaTelefone(form1.tel);"> <span class="style1"><font color="#FF0000">*</font></span>
<font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font color="#333333" size="1">*Somente
N&uacute;meros (sem tra&ccedil;os, barras ou pontos)</font></font></td>
</tr>
<tr>
<td height="21"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Fone
Celular</font></div></td>
<td colspan="3"><input type="text" name="fone_celular" id="fone_celular" onkeypress="MascaraTelefone(form1.tel);"
maxlength="14" onblur="ValidaTelefone(form1.tel);" /> <span class="style1"><font color="#FF0000">*</font></span>
<font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font color="#333333" size="1">*Somente
N&uacute;meros (sem tra&ccedil;os, barras ou pontos)</font></font></td>
</tr>
<tr>
<td height="21"> <div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Fone
Comercial </font></div></td>
<td colspan="3"><input type="text" name="fone_comercial" id="fone_comercial" onkeypress="MascaraTelefone(form1.tel);"
maxlength="14" onblur="ValidaTelefone(form1.tel);" /> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font color="#333333" size="1">*Somente
N&uacute;meros (sem tra&ccedil;os, barras ou pontos)</font></font></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Email</font></div></td>
<td colspan="3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="email" id="email" size="50"/>
</font></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"></font></div></td>
<td colspan="3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td colspan="4" bgcolor="#B9C0F4"> <div align="center"><font color="#000066"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Endere&ccedil;o
de Instala&ccedil;&atilde;o:</font>
</font><font color="#000066" size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></div></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td> <div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Endere&ccedil;o</font></div></td>
<td colspan="3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="endereco" id="endereco" size="50"/>
<span class="style1"><font color="#FF0000">*</font></span> </font></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Numero</font></div></td>
<td><input type="text" name="numero" id="numero" /> <span class="style1"><font color="#FF0000">*</font></span></td>
<td width="118"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Complemento</font></div></td>
<td width="255"><input type="text" name="complemento" id="complemento" size="35" /></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Bairro</font></div></td>
<td><input type="text" name="bairro" id="bairro" /> <span class="style1"><font color="#FF0000">*</font></span></td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Estado</font></div></td>
<td><select name="estados" id="estados" class="textBox">
<option>AC - Acre</option>
<option>AL - Alagoas</option>
<option>AP - Amap&aacute;</option>
<option>AM - Amazonas</option>
<option>BA - Bahia</option>
<option>CE - Cear&aacute;</option>
<option>DF - Distrito Federal</option>
<option>ES - Espirito Santo</option>
<option>GO - Goias</option>
<option>MA - Maranh&atilde;o</option>
<option>MT - Mato Grosso</option>
<option>MS - Mato Grosso do Sul</option>
<option>MG - Minas Gerais</option>
<option>PA - Par&aacute;</option>
<option>PB - Para&iacute;ba</option>
<option>PR - Paran&aacute;</option>
<option>PE - Pernambuco</option>
<option>PI - Piau&iacute;</option>
<option>RN - Rio Grande do Norte</option>
<option>RS - Rio Grande do Sul</option>
<option>RJ - Rio de Janeiro</option>
<option>RO - Rond&ocirc;nia</option>
<option>RR - Roraima</option>
<option>SC - Santa Catarina</option>
<option>SP - S&atilde;o Paulo</option>
<option>SE - Sergipe</option>
<option>TO - Tocantins</option>
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Cidade</font></div></td>
<td><input type="text" name="cidade" id="cidade" /></td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">CEP</font></div></td>
<td><input type="text" name="cep" id="cep" onKeyPress="MascaraCep(form1.cep);"
maxlength="10" onBlur="ValidaCep(form1.cep)"> <font color="#FF0000"><span class="style1">*</span></font></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Ponto
de Refer&ecirc;ncia</font></div></td>
<td colspan="3"><input type="text" name="ponto_referencia" id="ponto_referencia" size="50" /></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"></font></div></td>
<td colspan="3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td colspan="4" bgcolor="#B9C0F4"> <div align="center"><font color="#000066" size="2" face="Verdana, Arial, Helvetica, sans-serif">Dados
do Produto Contratado
</font></div></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Pacote
Contratado </font></div></td>
<td colspan="3"><select name="pacotes" id="pacotes">
<?php while($prod = mysql_fetch_array($query)) { ?>
<option value="<?php echo $prod['pacote'] ?>"><?php echo $prod['pacote'] ?></option>
<?php } ?>
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Plano
Contratado </font></div></td>
<td colspan="3"><select name="planos" id="planos">
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Promo&ccedil;&atilde;o</font></div></td>
<td colspan="3"><select name="promo" id="promo">
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Degusta&ccedil;&atilde;o</font></div></td>
<td colspan="3"><select name="degust" id="degust">
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Canais
Adicionais </font></div></td>
<td colspan="3"><select name="canais_adicionais" id="canais_adicionais">
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Cliente
deseja Ponto Adicional?</font></div></td>
<td colspan="3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="ponto_adicional" id="ponto_adicional">
<option>Selecione</option>
<option>SIM</option>
<option>N&Atilde;O</option>
</select>
</font></td>
</tr>
<tr>
<td height="27">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Cliente
deseja Ponto Escravo?</font></div></td>
<td colspan="3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="ponto_escravo" id="ponto_escravo">
<option>Selecione</option>
<option>SIM</option>
<option>N&Atilde;O</option>
</select>
</font></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"></font></div></td>
<td colspan="3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td colspan="4" bgcolor="#B9C0F4"> <div align="center"><font color="#000066" size="2" face="Verdana, Arial, Helvetica, sans-serif">Dados
Banc&aacute;rios
</font><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></div></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Forma
de Pagamento</font></div></td>
<td colspan="3"><select name="forma_pagamento" id="forma_pagamento">
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Banco</font></div></td>
<td colspan="3"><select name="banco" id="banco"\>
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Ag&ecirc;ncia</font></div></td>
<td colspan="3"><input type="text" name="agencia" id="agencia" /></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif">Conta
Corrente</font></font></div></td>
<td colspan="3"><input type="text" name="conta_corrente" id="conta_corrente" /></td>
</tr>
<tr>
<td height="27">&nbsp;</td>
<td><div align="right"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif">Data
Vencimento </font></font></div></td>
<td colspan="3"><select name="data_vencimento" id="data_vencimento">
<option>1</option>
<option>4</option>
<option>6</option>
<option>8</option>
<option>10</option>
<option>12</option>
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">M&ecirc;s
da Venda</font></div></td>
<td colspan="3"><select name="mes_venda" id="mes_venda">
<option>Selecione</option>
<option>JANEIRO</option>
<option>FEVEREIRO</option>
<option>MAR&Ccedil;O</option>
<option>ABRIL</option>
<option>MAIO</option>
<option>JUNHO</option>
<option>JULHO</option>
<option>AGOSTO</option>
<option>SETEMBRO</option>
<option>OUTUBRO</option>
<option>NOVEMBRO</option>
<option>DEZEMBRO</option>
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif">Data
da Venda</font></font></div></td>
<td colspan="3"><input type="text" name="data_venda" id="data_venda" onKeyPress="MascaraData(form1.data);"
maxlength="10" onBlur= "ValidaDataform1.data);"> <span class="style1"><font color="#FF0000">*</font></span></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Vendedor</font></div></td>
<td colspan="3"><select name="funcionarios" id="funcionarios">
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></div></td>
<td colspan="3">&nbsp;</td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td colspan="4" bgcolor="#B9C0F4"> <div align="center"><font size="2"><font color="#000066" face="Verdana, Arial, Helvetica, sans-serif">Dados
da Instala&ccedil;&atilde;o
</font></font></div></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">N&ordm;
Proposta </font></div></td>
<td colspan="3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="nr_proposta" id="nr_proposta" />
</font></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">N&ordm;
Contrato </font></div></td>
<td colspan="3"><input type="text" name="nr_contrato" id="nr_contrato" /></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Georgia, Times New Roman, Times, serif"><font face="Verdana, Arial, Helvetica, sans-serif">T&eacute;cnico</font></font></font></font></font></div></td>
<td colspan="3"><select name="tec_hab" id="tec_hab">
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Georgia, Times New Roman, Times, serif"><font face="Verdana, Arial, Helvetica, sans-serif">Data
Agenda </font></font></font></font></font></div></td>
<td><input type="text" name="data_agenda" id="data_agenda" onKeyPress="MascaraData(form1.data);"
maxlength="10" onBlur= "ValidaDataform1.data);"></td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Turno</font></div></td>
<td><select name="turno_agenda" id="turno_agenda">
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Georgia, Times New Roman, Times, serif"><font face="Verdana, Arial, Helvetica, sans-serif">Instalado
por </font></font></font></font></font></div></td>
<td colspan="3"><select name="instalado" id="instalado">
<option>Selecione</option>
<option>MASTER</option>
<option>PR&Oacute;PRIA</option>
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Georgia, Times New Roman, Times, serif"><font face="Verdana, Arial, Helvetica, sans-serif">Decoder</font></font></font></font></font></div></td>
<td><input type="text" name="decoder_hab" id="decoder_hab" /></td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Smart
Card </font></div></td>
<td><input type="text" name="smart_hab" id="smart_hab" /></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Georgia, Times New Roman, Times, serif"><font face="Verdana, Arial, Helvetica, sans-serif">Status
da Instala&ccedil;&atilde;o</font></font></font></font></font></div></td>
<td colspan="3"><select name="status_venda" id="status_venda">
</select></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Georgia, Times New Roman, Times, serif"><font face="Verdana, Arial, Helvetica, sans-serif">Observa&ccedil;&otilde;es</font></font></font></font></font></div></td>
<td colspan="3"><textarea name="observacoes" id="observacoes" cols="70"></textarea></td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td><div align="right"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Georgia, Times New Roman, Times, serif"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></font></font></div></td>
<td colspan="3">&nbsp;</td>
</tr>
<tr>
<td height="21">&nbsp;</td>
<td>&nbsp;</td>
<td colspan="3"><label>
<input type="submit" name="Submit" value="Cadastrar Venda"/>
</label> <font color="#FF0000" size="1" face="Verdana, Arial, Helvetica, sans-serif">*
Cadastro Obrigat&oacute;rio</font> </td>
</tr>
</table>
<map name="MapMap" id="Map2">
<area shape="rect" coords="98,1,179,24" href="#" onmouseover="MM_showMenu(window.mm_menu_1010171106_0,98,24,null,'image1')" onmouseout="MM_startTimeout();" />
<area shape="rect" coords="302,-1,373,24" href="#" onmouseover="MM_showMenu(window.mm_menu_1010171431_0,303,25,null,'image1')" onmouseout="MM_startTimeout();" />
<area shape="rect" coords="476,1,573,24" href="manutencao.php" />
<area shape="rect" coords="704,1,773,25" href="relatorios.php" />
<area shape="rect" coords="899,0,943,25" href="logout.php" />
</map>
</form>
<p>&nbsp;</p>
<p></p>
<p>&nbsp;</p>
<a href="logout.php"> </a>
<map name="Map" id="Map">
<area shape="rect" coords="98,1,179,24" href="#" onmouseover="MM_showMenu(window.mm_menu_1010171106_0,98,24,null,'image1')" onmouseout="MM_startTimeout();" />
<area shape="rect" coords="302,0,373,25" href="#" onmouseover="MM_showMenu(window.mm_menu_1010171431_0,303,25,null,'image1')" onmouseout="MM_startTimeout();" />
<area shape="rect" coords="476,1,573,24" href="manutencao.php" />
<area shape="rect" coords="704,1,773,25" href="relatorios.php" />
<area shape="rect" coords="899,0,943,25" href="logout.php" />
</map>
<map name="Map2" id="Map2">
<area shape="rect" coords="4,45,146,64" href="cadastrar_vendas.php" />
<area shape="rect" coords="2,79,147,99" href="consultar_vendas.php" />
<area shape="rect" coords="2,112,147,133" href="alterar_vendas.php" />
</map>
</body>
</html>

-------------- fim ---------------------

Alguem pode me dizer onde esta o erro?

Obrigado

Lista de Respostas:

0
17/10/2011 3:54pm
(~7 anos atrás)
Jayme A. C. Gimenez respondeu:
Eita, é código demais para olharmos num simples forum!

Dê umas dicas, pelo menos: que tipo de erro está dando? Aparece algum erro na tela?

0
18/10/2011 1:37am
(~7 anos atrás)
eduardo ripoll respondeu:
na verdade ja tentei todos os codigos q achei na web mas nada funciona.
preciso q os dados que coloco no form, seja gravado no mysql. No arquivo PHP aparece q os dados foram salvos, mas no BD nao aparece o registro.
O que pode ser?

0
18/10/2011 4:24am
(~7 anos atrás)
Jayme A. C. Gimenez respondeu:
Bom, numa olhada rápida, isto aqui parece estar errado. Veja se resolve:

No cadastro.php:

Ao invés de $inserir=mysql_query($comando_sql,$conexao) or die(mysql_error());

Faça $inserir=mysql_query($sqlinsert,$conexao) or die(mysql_error());

Ou só $inserir=mysql_query($sqlinsert) or die(mysql_error()); já que parece que a conexão já estará feita pelo config.php .

E, como vc já deve saber, PHP e banco de dados não são tão fáceis quanto HMTL. Tem que estudar um pouco para que a coisa não fique uma tortura sem fim.

Nova Resposta:

(Você pode usar tags como <b>, <i> ou <code>. URLs serão convertidas para links automaticamente.)