Problemas ao efetuar cadastro: Column count doesn't match value count at row 1.
O que pode ser? Preciso postar o codigo aqui?
Valeu!
Posted 26/10/2003, 21:25
Problemas ao efetuar cadastro: Column count doesn't match value count at row 1.
Posted 27/10/2003, 08:40
Posted 27/10/2003, 20:52
Posted 27/10/2003, 23:26
Posted 30/10/2003, 16:09
Posted 30/10/2003, 21:18
<html>
<head>
<link href="estilo.css" rel="stylesheet" type="text/css">
<title>Cadastro no Sistema</title></head>
<body>
<?
if ($acao=="gravar"){
require_once("dbconfig.php");
/* verifica se os dados obrigatórios foram informados */
if (trim($HTTP_POST_VARS["apelido"]) == "") {
echo "<br><br><center>Problemas ao efetuar cadastro: <b>Apelido</b> é um campo obrigatório!</center>";
exit();
} elseif (trim($HTTP_POST_VARS["email"]) == "") {
echo "<br><br><center>Problemas ao efetuar cadastro: <b>E-MAIL</b> é um campo obrigatório!</center>";
exit();
} elseif(!(ereg ("^.[a-z0-9_-]+@.+\\..+$", $HTTP_POST_VARS["email"]))) {
echo "<br><br><center>Problemas ao efetuar cadastro: <b>E-MAIL</b> possui um formato inválido!</center>";
exit();
} elseif (trim($HTTP_POST_VARS["cidade"]) == "") {
echo "<br><br><center>Problemas ao efetuar cadastro: <b>CIDADE</b> é um campo obrigatório!</center>";
exit();
} elseif (trim($HTTP_POST_VARS["idade"]) == "") {
echo "<br><br><center>Problemas ao efetuar cadastro: <b>Idade</b> é um campo obrigatório!</center>";
exit();
} else {
$sqli = " INSERT INTO
membros
(
codigo,
apelido,
senha,
sexo,
idade,
foto,
estado_civil,
frase,
procuro_por,
nome_completo,
endereco,
bairro,
cidade,
estado,
data_nascimento,
email,
altura,
peso,
olhos,
cabelos,
fisico,
fumo,
bebo,
religiao,
hobbies,
signo,
formacao,
profissao,
filhos,
musica,
filmes,
esportes
)
VALUES
(
'" . addslashes($HTTP_POST_VARS["codigo"]) . "',
'" . addslashes($HTTP_POST_VARS["apelido"]) . "',
'" . addslashes($HTTP_POST_VARS["senha"]) . "',
'" . addslashes($HTTP_POST_VARS["sexo"]) . "',
'" . addslashes($HTTP_POST_VARS["idade"]) . "',
'" . addslashes($HTTP_POST_VARS["foto"]) . "',
'" . addslashes($HTTP_POST_VARS["estado_civil"]) . "',
'" . addslashes($HTTP_POST_VARS["frase"]) . "',
'" . addslashes($HTTP_POST_VARS["procuro_por"]) . "',
'" . addslashes($HTTP_POST_VARS["nome_completo"]) . "',
'" . addslashes($HTTP_POST_VARS["endereco"]) . "',
'" . addslashes($HTTP_POST_VARS["bairro"]) . "',
'" . addslashes($HTTP_POST_VARS["cidade"]) . "',
'" . addslashes($HTTP_POST_VARS["estado"]) . "',
'" . addslashes($HTTP_POST_VARS["data_nascimento"]) . "'
'" . addslashes($HTTP_POST_VARS["email"]) . "',
'" . addslashes($HTTP_POST_VARS["altura"]) . "',
'" . addslashes($HTTP_POST_VARS["peso"]) . "',
'" . addslashes($HTTP_POST_VARS["olhos"]) . "',
'" . addslashes($HTTP_POST_VARS["cabelos"]) . "',
'" . addslashes($HTTP_POST_VARS["fisico"]) . "',
'" . addslashes($HTTP_POST_VARS["fumo"]) . "',
'" . addslashes($HTTP_POST_VARS["bebo"]) . "',
'" . addslashes($HTTP_POST_VARS["religiao"]) . "',
'" . addslashes($HTTP_POST_VARS["hobbies"]) . "'
'" . addslashes($HTTP_POST_VARS["signo"]) . "',
'" . addslashes($HTTP_POST_VARS["formacao"]) . "',
'" . addslashes($HTTP_POST_VARS["profissao"]) . "',
'" . addslashes($HTTP_POST_VARS["filhos"]) . "',
'" . addslashes($HTTP_POST_VARS["musica"]) . "',
'" . addslashes($HTTP_POST_VARS["filmes"]) . "'
'" . addslashes($HTTP_POST_VARS["esportes"]) . "'
)
";
/* executa sql */
if (!@mysql_query($sqli)) {
echo "<br><br><center>Problemas ao efetuar cadastro: " . mysql_error() . ".</center>";
exit();
} else {
echo "<br><br><center>Cadastro efetuado com sucesso!</center>
<script>window.location='inserir.php';</script>";
if ($erro == "yes") {
echo "<br><center>A imagem não foi enviada ao servidor.</center>";
}
exit();
}
} }?>
<html>
<head>
<title>Inclui Registros</title>
</head>
<form method="post" action="" enctype="multipart/form-data">
<h1><font face="Verdana" size="1">Novo Membro do Lovenet.com.br</font>
</h1>
<h1><font face="Verdana" size="1">
</font>
</h1>
<table border="0" cellspacing="0" width="592" height="94">
<tr>
<td width="517" height="1" colspan="3" bgcolor="#000080"><h1 align="center"><font color="#FFFFFF" size="1" face="Verdana">Informações Básicas</font></h1>
</td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">Apelido:</font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="text" name="apelido" size=50 maxlength=80>
</font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">Senha:</font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="password" name="senha" size=6 maxlength=80>
</font></td>
</tr>
<tr>
<td width="361" height="19" bgcolor="#FFFFCC" align="right">
<p><b><font size="1" face="Verdana" color="#000080">Sexo:</font>
</b>
</p>
</td>
<td width="20" height="19" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="19" bgcolor="#FFFFCC"><font face="Verdana" size="1">
<input type="radio" name="sexo" value="masculino" CHECKED>Masculino
<input type="radio" name="sexo" value="feminino">Feminino</font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<font face="Verdana" size="1" color="#000080"><b>Idade:</b></font>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1" color="#000080"><b><input type="text" name="idade" size=15 maxlength=80>
</b>
</font></td>
</tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">Estado Civil:</font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><select size="1" name="estado_civil">
<option selected>Estado Cívil</option>
<option value="solteiro">Solteiro(a)</option>
<option value="casado">Casado(a)</option>
<option value="Divorciado">Divorciado(a)</option>
<option value="Separado">Separado(a)</option>
<option value="Viúvo">Viúvo(a)</option>
</select></font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">Frase:</font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="text" name="frase" size=50 maxlength=80>
</font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">Procuro por:</font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="text" name="procuro_por" size=50 maxlength=80>
</font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">Foto:</font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="text" name="foto" size=30 maxlength=80>
</font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"> </td>
</tr>
<tr>
<td width="575" height="1" bgcolor="#000080" align="right" colspan="3">
<p align="center"><font color="#FFFFFF" size="1" face="Verdana">Informações
Pessoais</font>
</td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<p><b><font size="1" face="Verdana" color="#000080">Nome Completo:</font></b>
</p>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="text" name="nome_completo" size=50 maxlength=80>
</font>
</td>
</tr>
<tr>
<td width="218" height="7" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana" color="#000080">
Endereço:</font></b>
</td>
<td width="14" height="7" bgcolor="#FFFFCC" align="right">
</td>
<td width="356" height="7" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="text" name="endereco" size=50 maxlength=80>
</font>
</td>
</tr>
<tr>
<td width="218" height="7" bgcolor="#FFFFCC" align="right">
<font face="Verdana" size="1" color="#000080"><b>Bairro:</b></font>
</td>
<td width="14" height="7" bgcolor="#FFFFCC" align="right">
</td>
<td width="356" height="7" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="text" name="bairro" size=30 maxlength=80>
</font>
</td>
</tr>
<tr>
<td width="218" height="7" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana" color="#000080">
Cidade:</font></b>
</td>
<td width="14" height="7" bgcolor="#FFFFCC" align="right">
</td>
<td width="356" height="7" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="text" name="cidade" size=50 maxlength=80>
</font>
</td>
</tr>
<tr>
<td width="218" height="7" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana" color="#000080">
Estado:</font></b>
</td>
<td width="14" height="7" bgcolor="#FFFFCC" align="right">
</td>
<td width="356" height="7" bgcolor="#FFFFCC"><font face="Verdana" size="1"><select size="1" name="estado">
<option selected>Estado</option>
<option value=AL>AL - Alagoas</option>
<option value=AM>AM - Amazonas</option>
<option value=AP>AP - Amapá</option>
<option value=BA>BA - Bahia</option>
<option value=CE>CE - Ceará</option>
<option value=DF>DF - Distrito Federal</option>
<option value=ES>ES - Espírito Santo</option>
<option value=GO>GO - Goias</option>
<option value=MA>MA - Maranhão</option>
<option value=MG>MG - Minas Gerais</option>
<option value=MS>MS - Mato Grosso do Sul</option>
<option value=MT>MT - Mato Grosso</option>
<option value=PA>PA - Pará</option>
<option value=PB>PB - Paraiba</option>
<option value=PE>PE - Pernambuco</option>
<option value=PI>PI - Piaui</option>
<option value=PR>PR - Paraná</option>
<option value=RJ>RJ - Rio de Janeiro</option>
<option value=RN>RN - Rio Grande do Norte</option>
<option value=RO>RO - Rondônia</option>
<option value=RR>RR - Roraima</option>
<option value=RS>RS - Rio Grande do Sul</option>
<option value=SC>SC - Santa Catarina</option>
<option value=SE>SE - Sergipe</option>
<option value=SP>SP - São Paulo</option>
<option value=TO>TO - Tocantins</option>
</select>
</font>
</td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">Data Nascimento:</font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="text" name="data_nascimento" size=12 maxlength=80><i>Ex:
10/10/1990</i></font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">E-mail:</font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="text" name="email" size=50 maxlength=80></font></td>
</tr>
<tr>
<td width="575" height="1" bgcolor="#FFFFCC" align="right" colspan="3">
</td>
</tr>
<tr>
<td width="575" height="1" bgcolor="#000080" align="right" colspan="3">
<p align="center"><font size="1" color="#FFFFFF" face="Verdana">Informações Físicas</font>
</td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">Altura:</font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="text" name="altura" size=20 maxlength=80></font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">Peso:</font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><input type="text" name="peso" size=20 maxlength=80></font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">Olhos:</font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><select size="1" name="olhos">
<option>Olhos...</option>
<option value="Castanhos">Castanhos</option>
</select>
</font>
</td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">Cabelos:</font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><select size="1" name="cabelos">
<option>Cabelos...</option>
<option value="Castanhos">Castanhos</option>
</select>
</font>
</td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b>
<font size="1" face="Verdana" color="#000080">Físico: </font>
</b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font face="Verdana" size="1"><select size="1" name="fisico">
<option>Físico...</option>
<option value="Normal">Normal</option>
<option value="Magro">Magro(a)</option>
<option value="Gordinho">Gordinho(a)</option>
<option value="Forte">Forte</option>
<option value="Saradao">Saradão</option>
</select>
</font>
</td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"> </td>
</tr>
<tr>
<td width="575" height="1" bgcolor="#000080" align="right" colspan="3">
<p align="center"><font size="1" color="#FFFFFF" face="Verdana">Informações Gerais</font>
</td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana">
Se fumo?</font></b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font size="1" face="Verdana"><select size="1" name="fumo">
<option>Se fumo?</option>
<option value="sim">Sim</option>
<option value="nao">Não</option>
<option value="nunca">Nunca</option>
</select>
</font>
</td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana">
Se bebo?</font></b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font size="1" face="Verdana"><select size="1" name="bebo">
<option>Se bebo?</option>
<option value="sim">Sim</option>
<option value="nao">Não</option>
<option value="moderadamente">Moderadamente</option>
<option value="socialmente">Socialmente</option>
<option value="constantemente">Constantemente</option>
</select>
</font>
</td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana">
Religião:</font></b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font size="1" face="Verdana"><input type="text" name="religiao" size=50 maxlength=80></font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana">Hobbies:</font></b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font size="1" face="Verdana"><input type="text" name="hobbies" size=50 maxlength=80></font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana">
Signo:</font></b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font size="1" face="Verdana"><select class="MenuEsqTxt2" name="signo" size="1">
<option selected>Escolha</option>
<option value="Áries">Áries</option>
<option value="Aquário">Aquário</option>
<option value="Câncer">Câncer</option>
<option value="Capricórnio">Capricórnio</option>
<option value="Escorpião">Escorpião</option>
<option value="Gêmeos">Gêmeos</option>
<option value="Leão">Leão</option>
<option value="Libra">Libra</option>
<option value="Peixes">Peixes</option>
<option value="Sagitário">Sagitário</option>
<option value="Touro">Touro</option>
<option value="Virgem">Virgem</option>
</select></font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana">Formação Acadêmica:</font></b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font size="1" face="Verdana"><input type="text" name="formacao" size=50 maxlength=80></font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana">Profissão:</font></b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font size="1" face="Verdana"><input type="text" name="profissao" size=50 maxlength=80></font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana">Se tenho Filhos?</font></b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font size="1" face="Verdana"><select size="1" name="filhos">
<option selected>Se tenho Filhos?</option>
<option value="sim">Sim</option>
<option value="nao">Não</option>
</select>
</font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana">Estilo Musical:</font></b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font size="1" face="Verdana"><input type="text" name="musica" size=30 maxlength=80></font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana">Filmes:</font></b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font size="1" face="Verdana"><input type="text" name="filmes" size=30 maxlength=80></font></td>
</tr>
<tr>
<td width="361" height="1" bgcolor="#FFFFCC" align="right">
<b><font size="1" face="Verdana">Esportes:</font></b>
</td>
<td width="20" height="1" bgcolor="#FFFFCC" align="right">
</td>
<td width="215" height="1" bgcolor="#FFFFCC"><font size="1" face="Verdana"><input type="text" name="esportes" size=30 maxlength=80></font></td>
</tr>
<tr>
<td width="596" height="1" bgcolor="#FFFFCC" align="right" colspan="3">
<p align="left">
</td>
</tr>
<tr>
<td width="596" height="1" bgcolor="#FFFFCC" align="right" colspan="3">
</td>
</tr>
</table>
<td align="center" colspan="2">
<input type="hidden" name="acao" value="gravar">
<input type="Submit" name="salvar" value="Salvar Cadastro">
<input type="Reset" name="limpar" value="Limpar Formulário">
</td>
</tr>
</table>
</form>
</body>
</html>
0 membro(s), 1 visitante(s) e 0 membros anônimo(s)