Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Bom Dia a todos, estou tentando inserir alguns registros no meu banco de dados, mas todas vez que clico no botao que envia as informações, apresenta somente a mensagem de erro.
segue código da página em que está o formulário
<html>
<head>
<meta http-equiv="Content-Language" content="pt-br">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>PESQUISA DE SATISFAÇÃO DO CLIENTE</title>
<style>
.barra{
scrollbar-face-color: #ffffff;
scrollbar-shadow-color: #ffffff;
scrollbar-highlight-color: #ffffff;
scrollbar-3dlight-color: #ffffff;
scrollbar-darkshadow-color: #ffffff;
scrollbar-track-color: #ffffff;
scrollbar-arrow-color: #ffffff;
background-color: #ffffff;
}
</style>
</head>
<body>
<form action="grava.php" method="POST" >
<div align="center">
<table border="0" cellpadding="0" style="border-collapse: collapse" width="700" background="images/fundo_tabela1.jpg" height="228">
<tr>
<td width="700" height="30">
<p align="center"><font face="Tahoma" size="4" color="#808080">
PESQUISA DE SATISFAÇÃO DO CLIENTE</font></td>
</tr>
<tr>
<td width="700">
<div align="center">
<table border="0" cellpadding="2" style="border-collapse: collapse" width="100%" cellspacing="2">
<tr>
<td align="right" colspan="3">
<p align="center">
<font face="Arial" size="4">Por Favor Preencha os Dados para a Pesquisa</font></td>
</tr>
<tr>
<td align="right" colspan="3">
<p align="center"><font color="#ff0000" face="Calibri">Campos
marcados com * são obrigatórios</font></td>
</tr>
<tr>
<td width="34%" align="right">
<font face="Tahoma" size="2">
Nome Empresa / Cliente:</font></td>
<td colspan="2"><font face="Tahoma" size="3">
<font color="#FF0000">*</font><input name="nome" size="51" style="border:1px solid #FFFFFF; font-family:Tahoma; font-size:10pt"></font></td>
</tr>
<tr>
<td width="34%" align="right">
<font face="Tahoma" size="2">
Nome do Responsável pela pesquisa:</font></td>
<td colspan="2">
<font color="#FF0000" face="Tahoma" size="3">*</font><font face="Tahoma" size="3"><input name="responsavel" size="51" style="border:1px solid #FFFFFF; font-family:Tahoma; font-size:10pt"></font></td>
</tr>
<tr>
<td width="34%" align="right">
</td>
<td colspan="2">
</td>
</tr>
<tr>
<td width="34%" align="right">
</td>
<td width="49%">
<p align="right">
<a href="[http://www.sumsoftware.com.br/site/index.php">](http://www.sumsoftware.com.br/site/index.php)
<img border="0" src="images/seta.png" width="31" height="31" alt="Voltar ao Site"></a></td>
<td width="14%">
<p align="center"><font face="Tahoma" size="2">
<a target="_top" href="sumsoftware.com.br">
<span style="text-decoration: none"><font color="#000000">
<a target="_top" href="[http://www.sumsoftware.com.br/site/index.php">](http://www.sumsoftware.com.br/site/index.php)
<span style="text-decoration: none"><font color="#000000">Voltar ao
Site</font></span></a></font></span></a></font></td>
</tr>
</table>
</div>
</td>
</tr>
</table>
<div align="center">
<br>
<table border="0" cellpadding="0" style="border-collapse: collapse" width="700" background="images/fundo_tabela.jpg" height="228">
<tr>
<td height="39">
<p align="left"><font face="Tahoma" size="2">
1 - Assinale qual
o conceito que melhor expressa a sua satisfação em relação ao
SOFTWARE da SUM :</font></td>
</tr>
<tr>
<td>
<div align="center">
<table border="0" cellpadding="0" style="border-collapse: collapse" width="100%">
<tr>
<td align="center" width="153"> </td>
<td align="left" width="37%">
</td>
<td align="left" width="5%">
</td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">A)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">* </font>
<font face="Tahoma" size="2">Ótimo</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Ótimo" name="software" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">B)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><font face="Tahoma" size="2"> Bom</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Bom" name="software" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">C)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><strong style="font-weight: 400"><span style="font-family: Tahoma"><font size="2"> Regular</font></span></strong></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Regular" name="software" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">D)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><strong style="font-weight: 400"><span style="font-family: Tahoma"><font size="2"> Ruim</font></span></strong></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Ruim" name="software" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">E)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><font face="Tahoma" size="2"> Péssimo</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Péssimo" name="software" style="font-weight: 700"></font></td>
<td> </td>
</tr>
</table>
</div>
</td>
</tr>
</table><br>
<table border="0" cellpadding="0" style="border-collapse: collapse" width="700" background="images/fundo_tabela.jpg" height="228">
<tr>
<td height="39">
<p align="left"><font face="Tahoma" size="2">
2 - Assinale qual
o conceito que melhor expressa a sua satisfação em relação à
DOCUMENTAÇÃO dos sistemas : </font></td>
</tr>
<tr>
<td>
<div align="center">
<table border="0" cellpadding="0" style="border-collapse: collapse" width="100%">
<tr>
<td align="center" width="153"> </td>
<td align="left" width="37%">
</td>
<td align="left" width="5%">
</td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">A)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">* </font>
<font face="Tahoma" size="2">Ótimo</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Ótimo" name="documentacao" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">B)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><font face="Tahoma" size="2"> Bom</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Bom" name="documentacao" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">C)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><strong style="font-weight: 400"><span style="font-family: Tahoma"><font size="2"> Regular</font></span></strong></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Regular" name="documentacao" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">D)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><strong style="font-weight: 400"><span style="font-family: Tahoma"><font size="2"> Ruim</font></span></strong></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Ruim" name="documentacao" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">E)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><font face="Tahoma" size="2"> Péssimo</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Péssimo" name="documentacao" style="font-weight: 700"></font></td>
<td> </td>
</tr>
</table>
</div>
</td>
</tr>
</table><br>
<table border="0" cellpadding="0" style="border-collapse: collapse" width="700" background="images/fundo_tabela.jpg" height="228">
<tr>
<td height="39">
<p align="left"><font face="Tahoma" size="2">
3 - Assinale qual o conceito que melhor expressa a sua
satisfação em relação ao atendimento do SUPORTE :</font></td>
</tr>
<tr>
<td>
<div align="center">
<table border="0" cellpadding="0" style="border-collapse: collapse" width="100%">
<tr>
<td align="center" width="153"> </td>
<td align="left" width="37%">
</td>
<td align="left" width="5%">
</td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">A)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">* </font>
<font face="Tahoma" size="2">Ótimo</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Ótimo" name="suporte" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">B)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><font face="Tahoma" size="2"> Bom</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Bom" name="suporte" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">C)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><strong style="font-weight: 400"><span style="font-family: Tahoma"><font size="2"> Regular</font></span></strong></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Regular" name="suporte" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">D)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><strong style="font-weight: 400"><span style="font-family: Tahoma"><font size="2"> Ruim</font></span></strong></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Ruim" name="suporte" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">E)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><font face="Tahoma" size="2"> Péssimo</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Péssimo" name="suporte" style="font-weight: 700"></font></td>
<td> </td>
</tr>
</table>
</div>
</td>
</tr>
</table><br>
<table border="0" cellpadding="0" style="border-collapse: collapse" width="700" background="images/fundo_tabela.jpg" height="228">
<tr>
<td height="39">
<p align="left"><font face="Tahoma" size="2">
4 - De acordo com todos serviços prestados pela SUM, diga qual
conceito expressa seu nível de satisfação :</font></td>
</tr>
<tr>
<td>
<div align="center">
<table border="0" cellpadding="0" style="border-collapse: collapse" width="100%">
<tr>
<td align="center" width="153"> </td>
<td align="left" width="37%">
</td>
<td align="left" width="5%">
</td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">A)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">* </font>
<font face="Tahoma" size="2">Ótimo</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Ótimo" name="servicos" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">B)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><font face="Tahoma" size="2"> Bom</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Bom" name="servicos" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">C)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><strong style="font-weight: 400"><span style="font-family: Tahoma"><font size="2"> Regular</font></span></strong></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Regular" name="servicos" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">D)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><strong style="font-weight: 400"><span style="font-family: Tahoma"><font size="2"> Ruim</font></span></strong></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Ruim" name="servicos" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">E)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><font face="Tahoma" size="2"> Péssimo</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Péssimo" name="servicos" style="font-weight: 700"></font></td>
<td> </td>
</tr>
</table>
</div>
</td>
</tr>
</table>
<br>
<table border="0" cellpadding="0" style="border-collapse: collapse" width="700" background="images/fundo_tabela.jpg" height="228">
<tr>
<td height="39">
<p align="left"><font face="Tahoma" size="2">
5 - Você indicaria a Sum Software para informatizar a empresa de
um amigo seu?</font></td>
</tr>
<tr>
<td>
<div align="center">
<table border="0" cellpadding="0" style="border-collapse: collapse" width="100%">
<tr>
<td align="center" width="153"> </td>
<td align="left" width="37%">
</td>
<td align="left" width="5%">
</td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">A)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">* </font>
<font face="Tahoma" size="2">Sim</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Sim" name="indicacao" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">B)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><font face="Tahoma" size="2">
Não</font></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Não" name="indicacao" style="font-weight: 700"></font></td>
<td> </td>
</tr>
<tr>
<td align="center" width="153">
<font face="Tahoma" size="2">C)</font></td>
<td align="left" width="37%">
<font color="#FF0000" face="Tahoma" size="2">*</font><strong style="font-weight: 400"><span style="font-family: Tahoma"><font size="2">
Talvez</font></span></strong></td>
<td align="left" width="5%">
<font face="Tahoma" size="3">
<input type="radio" value="Talvez" name="indicacao" style="font-weight: 700"></font></td>
<td> </td>
</tr>
</table>
</div>
</td>
</tr>
</table><br>
<table border="0" cellpadding="0" style="border-collapse: collapse" width="700" background="images/fundo_tabela.jpg" height="228">
<tr>
<td height="39">
<p align="left"><font face="Tahoma" size="2">
6 - Relacione os pontos positivos da SUM SOFTWARE :</font></td>
</tr>
<tr>
<td>
<p align="center">
<textarea class="barra" rows="8" name="positivos" cols="107" style="font-family: Tahoma; font-size: 10pt; border: 1px solid #AEBEEF"></textarea></td>
</tr>
</table><br>
<table border="0" cellpadding="0" style="border-collapse: collapse" width="700" background="images/fundo_tabela.jpg" height="228">
<tr>
<td height="39">
<p align="left"><font face="Tahoma" size="2">
7 - Relacione os pontos negativos da SUM SOFTWARE :</font></td>
</tr>
<tr>
<td>
<p align="center">
<textarea class="barra" rows="8" name="negativos" cols="107" style="font-family: Tahoma; font-size: 10pt; border: 1px solid #AEBEEF"></textarea></td>
</tr>
</table><br>
<table border="0" cellpadding="0" style="border-collapse: collapse" width="700" background="images/fundo_tabela.jpg" height="228">
<tr>
<td height="39">
<p align="left"><font face="Tahoma" size="2">
8 - Sugestões de melhorias para a SUM SOFTWARE :</font></td>
</tr>
<tr>
<td>
<p align="center">
<textarea class="barra" rows="8" name="melhorias" cols="107" style="font-family: Tahoma; font-size: 10pt; border: 1px solid #AEBEEF"></textarea></td>
</tr>
</table>
<p align="center">
<input type="image" src="images/enviar.jpg" value="Botão" name="enviar" alt="Enviar informações"></p>
<p align="center"> </p>
<p> </p>
<br>
</div>
</div>
</form>
</body>
</html>Página que o formulário envia:
<?
include ("conexao.php");
$id = $_POST["id"];
$nome = $_POST["nome"];
$responsavel = $_POST["responsavel"];
$software = $_POST["software"];
$documentacao = $_POST["documentacao"];
$suporte = $_POST["suporte"];
$servicos = $_POST["servicos"];
$indicacao = $_POST["indicacao"];
$positivos = $_POST["positivos"];
$negativos = $_POST["negativos"];
$melhorias = $_POST["melhorias"];{
$insere = mysql_query("INSERT INTO pesquisa (nome, responsavel, software, documentacao, suporte, servicos, indicacao, positivos, negativos, melhorias) VALUES ('$nome', '$responsavel', '$software', '$documentacao', '$suporte', '$servicos', '$indicacao', '$positivos', '$negativos', '$melhorias')") or die ("Não Foi Possível Enviar seus Dados!");
}
?>
<script></script>
<meta HTTP-EQUIV = "Refresh" CONTENT = "0; URL = index.php">Carregando comentários...