Jump to content


Photo

Ajuda


  • Faça o login para participar
Nenhuma resposta neste tópico

#1 Akio

Akio

    Novato no fórum

  • Usuários
  • 3 posts
  • Sexo:Não informado

Posted 22/04/2009, 00:05

<?php require_once('Connections/conexaoo.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
	case "text":
	  $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
	  break;	
	case "long":
	case "int":
	  $theValue = ($theValue != "") ? intval($theValue) : "NULL";
	  break;
	case "double":
	  $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
	  break;
	case "date":
	  $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
	  break;
	case "defined":
	  $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
	  break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO cadastro (cad_id, cad_empresa, cad_telefone, cad_contato, salvar, aniversario, celular, email, site, obs, razao_social, cnpj, i_e, ramo_atv, endereco, cep, cidade, estado, bairro, t_t, rs, est, terc, historico, pro_contato, visita, contato, inc_vaga) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
					   GetSQLValueString($_POST['cad_id'], "text"),
					   GetSQLValueString($_POST['cad_empresa'], "text"),
					   GetSQLValueString($_POST['cad_telefone'], "text"),
					   GetSQLValueString($_POST['cad_contato'], "text"),
					   GetSQLValueString($_POST['salvar'], "text"),
					   GetSQLValueString($_POST['aniversario'], "date"),
					   GetSQLValueString($_POST['celular'], "text"),
					   GetSQLValueString($_POST['email'], "text"),
					   GetSQLValueString($_POST['site'], "text"),
					   GetSQLValueString($_POST['obs'], "text"),
					   GetSQLValueString($_POST['razao_social'], "text"),
					   GetSQLValueString($_POST['cnpj'], "text"),
					   GetSQLValueString($_POST['i_e'], "text"),
					   GetSQLValueString($_POST['ramo_atv'], "text"),
					   GetSQLValueString($_POST['endereco'], "text"),
					   GetSQLValueString($_POST['cep'], "double"),
					   GetSQLValueString($_POST['cidade'], "text"),
					   GetSQLValueString($_POST['estado'], "int"),
					   GetSQLValueString($_POST['bairro'], "text"),
					   GetSQLValueString($_POST['t_t'], "text"),
					   GetSQLValueString($_POST['rs'], "text"),
					   GetSQLValueString($_POST['est'], "text"),
					   GetSQLValueString($_POST['terc'], "text"),
					   GetSQLValueString($_POST['historico'], "text"),
					   GetSQLValueString($_POST['pro_contato'], "date"),
					   GetSQLValueString(isset($_POST['visita']) ? "true" : "", "defined","'Y'","'N'"),
					   GetSQLValueString(isset($_POST['contato']) ? "true" : "", "defined","'Y'","'N'"),
					   GetSQLValueString(isset($_POST['inc_vaga']) ? "true" : "", "defined","'Y'","'N'"));

  mysql_select_db($database_conexaoo, $conexaoo);
  $Result1 = mysql_query($insertSQL, $conexaoo) or die(mysql_error());

  $insertGoTo = "cadastro_ok.php";
  if (isset($_SERVER['QUERY_STRING'])) {
	$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
	$insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>




  
  
  
  <meta http-equiv="content-type" content="text/html; charset=UTF-8">



  


  
  
  
  
  
  <title>NEO RH</title>
  <script language="JavaScript" type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
  </script>
  
  
  
  <link href="style.css" rel="stylesheet" type="text/css">
</head>


<body>




<table style="background: transparent url(images/bg.gif) repeat-y scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; width: 776px;" align="center">




  <tbody>




	<tr>




	  <td style="background: transparent url(images/bg-top2.jpg) no-repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; height: 345px;">
	  
	  
	  
	  <table>




		<tbody>




		  <tr>




			<td style="width: 287px;"> <a href="index.html"><img alt="" src="logo.jpg" style="border: 0px solid; margin-left: 28px; margin-top: 13px; width: 244px; height: 47px;"></a><br>




			
			
			
			<div style="margin-left: 17px; margin-top: 49px;"><a href="index.html"><img style="border: 0px solid; width: 219px; height: 33px;" alt="" src="images/l1.jpg" name="r1"></a><a href="#" onMouseOut="MM_swapImgRestore()"><img alt="" src="images/l2.jpg" name="r2" style="border: 0px solid; margin-top: 3px; width: 219px; height: 32px;"></a><a href="pesquisa02.html"><img alt="" src="images/l3.jpg" name="r3" style="border: 0px solid; margin-top: 4px; width: 219px; height: 32px;"></a><a href="#"><img alt="" src="images/l4.jpg" name="r4" style="border: 0px solid; margin-top: 4px; width: 219px; height: 32px;"></a><a href="www.neorh.com.br"><img alt="" src="images/l5.jpg" name="r5" style="border: 0px solid; margin-top: 4px; width: 219px; height: 32px;"></a><a href="#"><img alt="" src="images/l6.jpg" name="r6" style="border: 0px solid; margin-top: 4px; width: 219px; height: 26px;"></a></div>




			</td>




			<td style="width: 489px;"> <br style="line-height: 35px;">




			<br>




			<br>




			</td>




		  </tr>




		
		
		
		</tbody>
	  
	  
	  
	  </table>




	  </td>




	</tr>




	<tr>




	  <td style="height: 385px;">
	  
	  
	  
	  <table>




		<tbody>




		  <tr>




			<td style="background: transparent url(images/bg-k.gif) no-repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; width: 22px;"></td>




			<td style="background: rgb(45, 45, 45) url(images/bg-k.gif) repeat-x scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; width: 732px;" class="m_text">
			
			
			
			<table>




			  <tbody>




				<tr>




				  <td style="width: 230px;">
				  
				  
				  
				  <div style="margin: 24px 0px 0pt 34px;"><br>




				  </div>




				  <strong></strong><br>




				  <br style="line-height: 13px;">




				  <br>




				  </td>




				  <td style="width: 502px;">
				  
				  
				  
				  <div style="margin: 21px 25px 0pt 15px;">
					<form method="post" name="form1" action="<?php echo $editFormAction; ?>">
					  <table align="center">
						<tr valign="baseline">
						  <td width="57%" align="right" nowrap><div align="left"></div></td>
						  <td width="43%">&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left">Empresa<strong>:</strong>
							  <input type="text" name="cad_empresa" value="" size="32">
						  </div></td>
						  <td>Telefone:
							<input type="text" name="cad_telefone" value="" size="32"></td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left">Contato:
							  <input type="text" name="cad_contato" value="" size="32">
						  </div></td>
						  <td>Aniversário:
							<label>
							<div align="center">
							  <select name="aniversario2" id="aniversario">
								<option>01</option>
								<option>02</option>
								<option>03</option>
								<option>04</option>
								<option>05</option>
								<option>06</option>
								<option>07</option>
								<option>08</option>
								<option>09</option>
								<option>10</option>
								<option>11</option>
								<option>12</option>
								<option>13</option>
								<option>14</option>
								<option>15</option>
								<option>16</option>
								<option>17</option>
								<option>18</option>
								<option>19</option>
								<option>20</option>
								<option>21</option>
								<option>22</option>
								<option>23</option>
								<option>24</option>
								<option>25</option>
								<option>26</option>
								<option>27</option>
								<option>28</option>
								<option>29</option>
								<option>30</option>
								<option>31</option>
							  </select>
							  <br>
							  <br>	 
							  <select name="aniversario3" id="aniversario2">
								<option>Janeiro</option>
								<option>Feveiro</option>
								<option>Març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>
							</div>
							</label></td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left"></div></td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left">Celular:
							<input type="text" name="celular" value="" size="32">
						  </div></td>
						  <td>Email<strong>:</strong>
							<input type="text" name="email" value="" size="32"></td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left">Site:
							<input type="text" name="site" value="" size="32">
						  </div></td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td height="32" align="right" nowrap><div align="left">Obs:
							  <textarea name="obs" cols="32"></textarea>
						  </div></td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left">Razao social:
							<input type="text" name="razao_social" value="" size="32">
						  </div></td>
						  <td>Cnpj: 
							<input type="text" name="cnpj" value="" size="32"></td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left"></div></td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left">I.E:
							<input type="text" name="i_e" value="" size="32">
						  </div></td>
						  <td>Ramo.atv:
							<input type="text" name="ramo_atv" value="" size="25"></td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left">Endereço:
							<input type="text" name="endereco" value="" size="32">
						  </div></td>
						  <td>Cep:
							<label>
							<input name="cep" type="text" id="cep" size="10" maxlength="5">
							</label>
							<label>- 
							<input name="cep2" type="text" id="cep2" size="6" maxlength="3">
							</label></td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left">Cidade:
							<input type="text" name="cidade" value="" size="32">
						  </div></td>
						  <td>Estado:<span style="font-weight: bold;">
							<select name="Estado" id="Estado">
							  <option>AC</option>
							  <option>AL</option>
							  <option>AM</option>
							  <option>BA</option>
							  <option>CE</option>
							  <option>DF</option>
							  <option>GO</option>
							  <option>ES</option>
							  <option>MA</option>
							  <option>MT</option>
							  <option>MS</option>
							  <option>MG</option>
							  <option>PA</option>
							  <option>PB</option>
							  <option>PR</option>
							  <option>PE</option>
							  <option>PI</option>
							  <option>RJ</option>
							  <option>RN</option>
							  <option>RS</option>
							  <option>RO</option>
							  <option>RR</option>
							  <option>SP</option>
							  <option>SC</option>
							  <option>SE</option>
							  <option>TO</option>
							  <option></option>
							</select>
						  </span></td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left">Bairro: 
							<input type="text" name="bairro" value="" size="32">
						  </div></td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left">T.T: 
							<label>
							<input name="t_t" type="text" id="t_t" size="10" maxlength="10">
							</label>
						  R.S: 
						  <input name="rs" type="text" value="" size="10" maxlength="10">
						   Est:
						   <label>
						   <input name="es" type="text" id="es" size="10">
						   </label>
						  </div></td>
						  <td>Terc:
							<input name="terc" type="text" value="" size="10" maxlength="10"></td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="center">Histórico:</div></td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><input type="text" name="historico" value="" size="49">
							:</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td><label></label></td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right"><div align="left">Prox.contato:<label><span style="font-weight: bold;"> &nbsp;</span><span style="font-weight: bold;"> <br>
							<select name="1">
							  <option>1</option>
							  <option>2</option>
							  <option>3</option>
							  <option>4</option>
							  <option>5</option>
							  <option>6</option>
							  <option>7</option>
							  <option>8</option>
							  <option>9</option>
							  <option>10</option>
							  <option>11</option>
							  <option>12</option>
							  <option>13</option>
							  <option>14</option>
							  <option>15</option>
							  <option>16</option>
							  <option>17</option>
							  <option>18</option>
							  <option>19</option>
							  <option>20</option>
							  <option>21</option>
							  <option>22</option>
							  <option>23</option>
							  <option>24</option>
							  <option>25</option>
							  <option>26</option>
							  <option>27</option>
							  <option>28</option>
							  <option>29</option>
							  <option>30</option>
							  <option>31</option>
							  <option></option>
							</select>
&nbsp;</span><span style="font-weight: bold;">
<select name="check">
  <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>
  <option selected="selected"></option>
</select>
</span>
<select name="ano">
  <option>2009</option>
  <option>2010</option>
  <option>2011</option>
  <option>2012</option>
  <option>2013</option>
  <option></option>
</select>
<br>
							<br>
							Visita:
							<input type="radio" name="radio" id="visita" value="visita">
							Contato: 
							<input type="radio" name="radio" id="contato" value="contato"> 
							Inc.vagas:
							
							<input type="radio" name="radio" id="Inc_vaga" value="Inc_vaga">
						  </label>
						  </div></td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">
							
							  <div align="right">
								<input type="submit" class="c_text" value="salvar">
							  </div></td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>:</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
						<tr valign="baseline">
						  <td nowrap align="right">&nbsp;</td>
						  <td>&nbsp;</td>
						</tr>
					  </table>
					  <input type="hidden" name="MM_insert" value="form1">
					</form>
					<p>&nbsp;</p>
					<br>

&nbsp;<br>
				  <br>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br>




&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp;<br style="line-height: 26px;">
<br>




				  <br>




				  <br>




				  <strong></strong><br>




				  </div>




				  <br style="line-height: 25px;">




				  
				  
				  
				  <table class="no_class">




					<tbody>




					  <tr>




						<td style="width: 259px;"> <br>




						
						
						
						<div style="margin: 27px 20px 0pt 25px;">
						<strong></strong> </div>




						</td>




						<td style="width: 243px;"> </td>




					  </tr>




					
					
					
					</tbody>
				  
				  
				  
				  </table>




				  </td>




				</tr>




			  
			  
			  
			  </tbody>
			
			
			
			</table>




			</td>




			<td style="background: transparent url(images/bg-k.gif) no-repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; width: 22px;"></td>




		  </tr>




		
		
		
		</tbody>
	  
	  
	  
	  </table>




	  </td>




	</tr>




	<tr>




	  <td>
	  
	  
	  
	  <table>




		<tbody>




		  <tr>




			<td style="width: 38px;"></td>




			<td style="background: transparent url(images/bg-bot.gif) repeat-x scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; width: 700px;">
			
			
			
			<div class="c_text" style="margin: 25px 0px 0pt;" align="center"><br>




			<span>neo rh 2009.Todos os direitos reservado.</span>
			</div>




			</td>




			<td style="width: 38px;"></td>




		  </tr>




		
		
		
		</tbody>
	  
	  
	  
	  </table>




	  </td>




	</tr>




  
  
  
  </tbody>
</table>




<script language="JavaScript" src="http://hostingprod.com/js_source/geov2.js"></script>

<script language="javascript">geovisit();</script>
<noscript><img
src="http://visit.webhosting.yahoo.com/visit.gif?us1177707545"
alt="setstats" border="0" width="1" height="1"></noscript>




</body>
</html>

quando clico em salvar aparece isso oo'
Warning: sprintf() [function.sprintf]: Too few arguments in C:\xampp\htdocs\www\site\cadastro.php on line 65
Query was empty?

tem algum erro ?

conexaao.php
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_conexaoo = "localhost";
$database_conexaoo = "cadastro";
$username_conexaoo = "root";
$password_conexaoo = "6394219";
$conexaoo = mysql_pconnect($hostname_conexaoo, $username_conexaoo, $password_conexaoo) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

<?php
error_reporting(E_ALL);
@ini_set('display_errors', '1');
@ini_set('register_globals', '0');
if (version_compare(phpversion(), "4", ">")) {
if (!extension_loaded('mysql')) {
echo( "Nao esta habilitada a dll Mysql" );
exit;
}
}

if(file_exists("funcoes.php")) {
include "funcoes.php";
} else {
echo "Arquivo funcoes.php nao encontrado";
exit;
}

if(file_exists("config.php")) {
include "config.php";

if (!defined("localhost") or !defined("root") or !defined("6394219") or !defined("cadastro")){
echo "Variaveis de conexao nao definidas, configure corretamente o arquivo config.php";
exit;
}
}

$erros[2005] = "Esse servidor nao existe";
$erros[2003] = "Servidor Mysql desligado";
$erros[1045] = "Usuario ou senha invalido";
$erros[1049] = "Banco de dados nao encontrado";
$erros[1146] = "Erro de sql a tabela nao existe";
$erros[1062] = "Erro campo unico na tabela, nao pode cadastrar pois ele ja existe";

function Abre_Conexao() {
global $erros;
@mysql_connect(localhost, root, 6394219);
if(mysql_errno() != 0) {
echo $erros[mysql_errno()];
exit;
}
@mysql_select_db(cadastro);
if(mysql_errno() != 0) {
echo $erros[mysql_errno()];
exit;
}
}

?>


quando entra em listar fala que a tabela de cadastro nao existe

Tabela cadastro

-- phpMyAdmin SQL Dump
-- version 3.1.1
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tempo de Geração: Abr 22, 2009 as 02:16 AM
-- Versão do Servidor: 5.1.30
-- Versão do PHP: 5.2.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Banco de Dados: `cadastro`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `cadastro`
--

CREATE TABLE IF NOT EXISTS `cadastro` (
`cad_empresa` varchar(75) NOT NULL,
`cad_telefone` varchar(50) NOT NULL,
`cad_contato` varchar(50) NOT NULL,
`salvar` varchar(50) NOT NULL,
`aniversario` date NOT NULL,
`celular` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`site` varchar(50) NOT NULL,
`obs` text NOT NULL,
`razao_social` varchar(50) NOT NULL,
`cnpj` varchar(50) NOT NULL,
`i_e` varchar(50) NOT NULL,
`ramo_atv` varchar(50) NOT NULL,
`endereco` varchar(50) NOT NULL,
`cep` decimal(50,0) NOT NULL,
`cidade` varchar(50) NOT NULL,
`estado` tinyint(50) NOT NULL,
`bairro` varchar(50) NOT NULL,
`t_t` varchar(50) NOT NULL,
`rs` varchar(50) NOT NULL,
`est` varchar(50) NOT NULL,
`terc` varchar(50) NOT NULL,
`historico` varchar(50) NOT NULL,
`pro_contato` date NOT NULL,
`visita` varchar(50) NOT NULL,
`contato` varchar(50) NOT NULL,
`inc_vaga` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `cadastro`
--

INSERT INTO `cadastro` (`cad_id`, `cad_empresa`, `cad_telefone`, `cad_contato`, `salvar`, `aniversario`, `celular`, `email`, `site`, `obs`, `razao_social`, `cnpj`, `i_e`, `ramo_atv`, `endereco`, `cep`, `cidade`, `estado`, `bairro`, `t_t`, `rs`, `est`, `terc`, `historico`, `pro_contato`, `visita`, `contato`, `inc_vaga`) VALUES
('', 'aaaaa', 'ss', 'aaaaaaa', '', '0000-00-00', 'aaaaa', 'aaaaaaa', 'aaaaaa', 'aaaaa', 'aaaaaa', 'aaaaaaa', 'aaaaaaaa', 'aaaaaaaaa', 'aaaaaaa', 0, 'aaaaaaa', 0, 'aaaaaaaa', 'aaaaaa', 'aaaa', '', 'aaaaaa', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', '0000-00-00', '', '', ''),
('', 'aaaaa', 'ss', 'aaaaaaa', '', '0000-00-00', 'aaaaa', 'aaaaaaa', 'aaaaaa', 'aaaaa', 'aaaaaa', 'aaaaaaa', 'aaaaaaaa', 'aaaaaaaaa', 'aaaaaaa', 0, 'aaaaaaa', 0, 'aaaaaaaa', 'aaaaaa', 'aaaa', '', 'aaaaaa', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', '0000-00-00', '', '', ''),
('', '02', '02', 'a', '', '0000-00-00', 'a', 'E-mail', 'Neo rh', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', '00', 'aaaaaaa', 'aaaaaaaa', '00', 'Coronel antônio ricardo dos santos', 0, 'aaa', 0, 'aa', 'aa', 'aa', '', 'aa', 'aa', '0000-00-00', '', '', ''),
('', '02', '02', 'a', '', '0000-00-00', 'a', 'E-mail', 'Neo rh', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', '00', 'aaaaaaa', 'aaaaaaaa', '00', 'Coronel antônio ricardo dos santos', 0, 'aaa', 0, 'aa', 'aa', 'aa', '', 'aa', 'aa', '0000-00-00', '', '', '');


Edição feita por: Akio, 22/04/2009, 02:18.





1 user(s) are reading this topic

0 membro(s), 1 visitante(s) e 0 membros anônimo(s)

IPB Skin By Virteq