Ir para conteúdo
Fórum Script Brasil
  • 0

(Resolvido) Formulario insert

shelter

Perguntado por shelter,

 Share

Pergunta

shelter

shelter

Postado
Postado

Boa galera,

Estou com um formulário de cadastro e tenho necessidade de que quando o formulário seja concluído o insert, o usuário seja direcionado para uma nova pagina. Estou fazendo assim mais estou recebendo este erro abaixo:

Warning: Cannot modify header information - headers already sent by (output started at C:\AppServ\www\siteBairro\g\galeria\admin\albuns\criar_anuncio_autos5.php:3) in C:\AppServ\www\siteBairro\g\galeria\admin\albuns\criar_anuncio_autos5.php on line 147.

<?php require_once('../../../Connections/conection.php'); ?>

<?php
$con = mysql_connect("localhost", "root", "1272");
mysql_select_db("Cadastro");
?>

<?php require_once('../../../ScriptLibrary/incPureUpload.php'); ?>
<?php require_once('../../../ScriptLibrary/incResize.php'); ?>
<?php require_once('../../../ScriptLibrary/incPUAddOn.php'); ?>




<?php
// Pure PHP Upload 2.1.2
if (isset($HTTP_GET_VARS['GP_upload'])) {
    $ppu = new pureFileUpload();
    $ppu->path = "../../imagens/capa";
    $ppu->extensions = "GIF,JPG,JPEG,BMP,PNG";
    $ppu->formName = "fm_criaalbum";
    $ppu->storeType = "file";
    $ppu->sizeLimit = "1000";
    $ppu->nameConflict = "uniq";
    $ppu->requireUpload = "true";
    $ppu->minWidth = "";
    $ppu->minHeight = "";
    $ppu->maxWidth = "";
    $ppu->maxHeight = "";
    $ppu->saveWidth = "";
    $ppu->saveHeight = "";
    $ppu->timeout = "600";
    $ppu->progressBar = "fileCopyProgress.htm";
    $ppu->progressWidth = "300";
    $ppu->progressHeight = "100";
    $ppu->checkVersion("2.1.2");
    $ppu->doUpload();
}
$GP_uploadAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  if (!eregi("GP_upload=true", $HTTP_SERVER_VARS['QUERY_STRING'])) {
        $GP_uploadAction .= "?".$HTTP_SERVER_VARS['QUERY_STRING']."&GP_upload=true";
    } else {
        $GP_uploadAction .= "?".$HTTP_SERVER_VARS['QUERY_STRING'];
    }
} else {
  $GP_uploadAction .= "?"."GP_upload=true";
}

// Rename Uploaded Files Addon 1.0.3
if (isset($HTTP_GET_VARS['GP_upload'])) {
  $ruf = new renameUploadedFiles($ppu);
  $ruf->renameMask = "capa_album.jpg";
  $ruf->checkVersion("1.0.3");
  $ruf->doRename();
}

// Smart Image Processor 1.0.3
if (isset($HTTP_GET_VARS['GP_upload'])) {
  $sip = new resizeUploadedFiles($ppu);
  $sip->component = "GD";
  $sip->resizeImages = "true";
  $sip->aspectImages = "true";
  $sip->maxWidth = "300";
  $sip->maxHeight = "300";
  $sip->quality = "300";
  $sip->makeThumb = "false";
  $sip->pathThumb = "";
  $sip->aspectThumb = "true";
  $sip->naming = "suffix";
  $sip->suffix = "_small";
  $sip->maxWidthThumb = "";
  $sip->maxHeightThumb = "";
  $sip->qualityThumb = "70";
  $sip->checkVersion("1.0.3");
  $sip->doResize();
}

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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 = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if (isset($editFormAction)) {
  if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
      if (!eregi("GP_upload=true", $HTTP_SERVER_VARS['QUERY_STRING'])) {
        $editFormAction .= "&GP_upload=true";
        }
  } else {
    $editFormAction .= "?GP_upload=true";
  }
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "fm_criaalbum")) {
  $insertSQL = sprintf("INSERT INTO Anuncio_Autos (Data_anuncio, Capa, Fabricante, Fabricante_modelo, Modelo, Ano, Combustivel, Bairro, Valor, Parcelamento, Telefone_Fixo, Telefone_Celular, Site, Email, Contato, `Descricao`) VALUES (now(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s  )",
                       GetSQLValueString($HTTP_POST_VARS['Capa'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['categoria'], "text"),
                       GetSqlValueString($HTTP_POST_VARS['subcategoria'],"text"),
                       GetSqlValueString($HTTP_POST_VARS['Modelo'],"text"),
                       GetSqlValueString($HTTP_POST_VARS['Ano'],"text"),
                       GetSqlValueString($HTTP_POST_VARS['Combustivel'],"text"),
                       GetSqlValueString($HTTP_POST_VARS['Bairro'],"text"),
                       GetSqlValueString($HTTP_POST_VARS['Valor'],"text"),
                       GetSqlValueString($HTTP_POST_VARS['Parcelamento'],"text"),
                       GetSqlValueString($HTTP_POST_VARS['Telefone_Fixo'],"text"),
                       GetSqlValueString($HTTP_POST_VARS['Telefone_Celular'],"text"),
                       GetSqlValueString($HTTP_POST_VARS['Site'],"text"),
                       GetSqlValueString($HTTP_POST_VARS['Email'],"text"),
                       GetSqlValueString($HTTP_POST_VARS['Contato'],"text"),
                       GetSqlValueString($HTTP_POST_VARS['Descricao'],"text"));


  mysql_select_db($database_conection, $conection);
  $Result1 = mysql_query($insertSQL, $conection) or die(mysql_error());

//local que direciona pagina apos insert
  $insertGoTo = "editar_albuns.php";
  if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
?>
<!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=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style5 {
        font-family: Arial, Helvetica, sans-serif;
        font-size: 12px;
}

.style6 {
        font-family: Arial, Helvetica, sans-serif;
        color:#999999;
        font-size: 11px;
}


.TituloFieldset {
        font-family:Arial, Helvetica, sans-serif;
        font-size: 16px;
        color:#FF0000;

}




.fieldset {
         border: solid #CCCCCC 1px;
         width: 600px;
         
}
-->
</style>
<script language='javascript' src='../../../ScriptLibrary/incPureUpload.js'></script>
<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationSelect.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationTextarea.js" type="text/javascript"></script>

<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryValidationTextarea.css" rel="stylesheet" type="text/css" />

<!-- script ajax-->
<script language="javascript">function list_dados( valor )
{
http.open("GET", "result_passeio.php?id=" + valor, true);
http.onreadystatechange = handleHttpResponse;
http.send(null);
}

function handleHttpResponse()
{
campo_select = document.forms[0].subcategoria;
if (http.readyState == 4) {    campo_select.options.length = 0;
results = http.responseText.split(",");
for( i = 0; i < results.length; i++ )    {       string = results[i].split( "|" );
campo_select.options[i] = new Option( string[0], string[1] );
}
}
}



function getHTTPObject()
{var req; try { if (window.XMLHttpRequest) {  req = new XMLHttpRequest();
if (req.readyState == null) {   req.readyState = 1;
req.addEventListener("load", function () {   req.readyState = 4;
if (typeof req.onReadyStateChange == "function")    req.onReadyStateChange();
}, false);
}   return req;
}  if (window.ActiveXObject) {  var prefixes = ["MSXML2", "Microsoft", "MSXML", "MSXML3"];
for (var i = 0; i < prefixes.length; i++) {
try {    req = new ActiveXObject(prefixes[i] + ".XmlHttp");    return req;   } catch (ex) {};   } }} catch (ex) {} alert("XmlHttp Objects not supported by client browser");}var http = getHTTPObject();// Logo aps fazer a verificao,  chamada a funo e passada // o valor  varivel global http.


</script>





</head>

<body>
<fieldset class="fieldset">
<legend  class="TituloFieldset">Cadastrar anúncio de autos</legend>
  
    <form action="<?php echo $editFormAction; ?>" method="post" enctype="multipart/form-data" name="fm_criaalbum" id="fm_criaalbum" >
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        
        
        
        <tr>
          <td align="right">&nbsp;</td>
          <td>&nbsp;</td>
          <td><span class="style6">* Arquivos de fotos suportados:</span></td>
        </tr>
        <tr>
          <td width="140" align="right"><span class="style5">Foto Capa do Anúncio:</span></td>
          <td width="10">&nbsp;</td>
          <td><input name="Capa" type="file" id="Capa" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG',true,1000,'','','','','','')" size="40" /></td>
        </tr>
        
        <!-- menu TIPO -->
        <tr>
          <td width="140" align="right"><span class="style5">Fabricante:</span></td>
          <td width="10">&nbsp;</td>
          <td><span id="spryselect3">
            <label>
          <select name="categoria" style="width:150px" onChange="list_dados( this.value )">


            <?php $consulta = mysql_query("SELECT * FROM tbl_categorias where tipo = 'Passeio' ORDER BY nome ASC");
                    while( $row = mysql_fetch_assoc($consulta) )
                    {
                    echo "<option value=\"{$row['codigo']}\">{$row['nome']}</option>\n";}?>
            </select>

            </label>

            <span class="selectRequiredMsg">Obrigatório!</span></span></td>
        </tr>
       <!-- fim menu TIPO -->
       


        <!-- fabricante -->
         <tr>
          <td width="140" align="right"><span class="style5">Modelo fabricante:</span></td>
          <td width="10">&nbsp;</td>
          <td><span id="spryselect1">
            <label>

            <select name="subcategoria" style="width:150px">
            </select>
            </label>
            <span class="selectRequiredMsg">Obrigatório!</span></span></td>
        </tr>
          

        <!-- Marca modelo -->

        <tr>
          <td width="140" align="right"><span class="style5">Modelo:</span></td>
          <td width="10">&nbsp;</td>
          <td><span id="sprytextfield2">
            <input name="Modelo" type="text" id="Modelo" size="19" />
          <span class="textfieldRequiredMsg">Obrigatório!</span></span></td>
        </tr>
         
           <!-- Ano fabricação -->
          <tr>
          <td width="140" align="right"><span class="style5">Ano fabricação:</span></td>
          <td width="10">&nbsp;</td>
           <td><span id="spryselect2">
            <select name="Ano" id="Ano" style="width:150px">
              <option selected="selected"></option>
              <option value="1960">1960</option>
              <option value="1961">1961</option>
              <option value="1962">1962</option>
              <option value="1963">1963</option>
              <option value="1964">1964</option>
              <option value="1965">1965</option>
              <option value="1966">1966</option>
              <option value="1967">1967</option>
              <option value="1968">1968</option>
              <option value="1969">1969</option>
              <option value="1970">1970</option>
              <option value="1971">1971</option>
              <option value="1972">1972</option>
              <option value="1973">1973</option>
              <option value="1974">1974</option>
              <option value="1975">1975</option>
              <option value="1976">1976</option>
              <option value="1977">1977</option>
              <option value="1978">1978</option>
              <option value="1979">1979</option>
              <option value="1980">1980</option>
              <option value="1981">1981</option>
              <option value="1982">1982</option>
              <option value="1983">1983</option>
              <option value="1984">1984</option>
              <option value="1985">1985</option>
              <option value="1986">1986</option>
              <option value="1987">1987</option>
              <option value="1988">1988</option>
              <option value="1989">1989</option>
              <option value="1990">1990</option>
              <option value="1991">1991</option>
              <option value="1992">1992</option>
              <option value="1993">1993</option>
              <option value="1994">1994</option>
              <option value="1995">1995</option>
              <option value="1996">1996</option>
              <option value="1997">1997</option>
              <option value="1998">1998</option>
              <option value="1999">1999</option>
              <option value="2000">2000</option>
              <option value="2001">2001</option>
              <option value="2002">2002</option>
              <option value="2003">2003</option>
              <option value="2004">2004</option>
              <option value="2005">2005</option>
              <option value="2006">2006</option>
              <option value="2007">2007</option>
              <option value="2008">2008</option>
              <option value="2009">2009</option>
            </select>
            <span class="selectRequiredMsg">Obrigatório!</span></span></td>
        </tr>
          
          <!-- Esta com erro -->
          <!-- Combustivel -->
           <tr>
             <td align="right"><span class="style5">Combustível:</span></td>
             <td>&nbsp;</td>
             <td><span id="spryselect7">
               <label>
               <select name="Combustivel" id="Combustivel" style="width:150px">

               <option selected="selected"></option>
              <option value="Alcool">Alcool</option>
              <option value="Diesel">Diesel</option>
              <option value="Flex">Flex</option>
              <option value="Gasolina">Gasolina</option>
              <option value="Gasolina/GNV">Gasolina/GNV</option>
               </select>
               </label>
             <span class="selectRequiredMsg">Obrigatório!</span></span></td>
           </tr>


           <!-- Bairro -->
           <tr>
          <td width="140" align="right"><span class="style5">Bairro:</span></td>
          <td width="10">&nbsp;</td>
        <td><span id="spryselect4">
            <select name="Bairro" id="Bairro" style="width:150px">
              <option selected="selected"></option>
              <option value="bangu">Bangu</option>
              <option value="barra de guaratiba">Barra de Guaratiba</option>
              <option value="campo grande">Campo Grande</option>
              <option value="ilha de guaratiba">Ilha de Guaratiba</option>
              <option value="magarça">Magarça</option>
              <option value="padre miguel">Padre Miguel</option>
              <option value="pedra de guaratiba">Pedra de Guaratiba</option>
              <option value="realengo">Realengo</option>
              <option value="santa cruz">Santa Cruz</option>
              <option value="sulacap">Sulacap</option>
            </select>
            <span class="selectRequiredMsg">Obrigatório!</span></span></td>
           </tr>
           
        <!-- Valor -->
        <tr>
          <td width="140" align="right"><span class="style5">Valor R$:</span></td>
          <td width="10">&nbsp;</td>
          <td><span id="sprytextfield3">
          <input name="Valor" type="text" id="Valor" size="19" />
          <span class="textfieldRequiredMsg">Obrigatório!</span><span class="textfieldInvalidFormatMsg">*Separar centavos por ponto Ex.:1000.30</span></span></td>
          </tr>
         <tr>
          <td width="140" align="right"><span class="style5">Condições & Parcelamentos:</span></td>
          <td width="10">&nbsp;</td>
      <td><span id="spryselect5">
          <select name="Parcelamento" id="Parcelamento" style="width:280px">
            <option selected="selected"></option>
            <option value="A Vista">À vista</option>
            <option value="Em até 12X">Parcelamos em até 12X</option>
            <option value="Em até 18X">Parcelamos em até 18X</option>
            <option value="Em até 24X">Parcelamos em até 24X</option>
            <option value="Em até 36X">Parcelamos em até 36X</option>
            <option value="Em até 48X">Parcelamos em até 48X</option>
            <option value="Em até 60X">Parcelamos em até 60X</option>
            <option value="Consulte">Consulte outros parcelamentos</option>
          </select>
          <span class="selectRequiredMsg">Obrigatório.</span></span></td>
        </tr>
        
        
        
        
        <!-- telefone -->
        <tr>
          <td width="140" align="right"><span class="style5">Telefone:</span></td>
          <td width="10">&nbsp;</td>
        <td><span id="sprytextfield4">
        <input name="Telefone_Fixo" type="text" id="Telefone_Fixo" size="19" />
        <span class="textfieldRequiredMsg">Obrigatório!</span><span class="textfieldInvalidFormatMsg">Inválido, Ex.:2222-2222!</span></span></td>
        </tr>

        <!-- Celular -->
        <tr>
          <td width="140" align="right"><span class="style5">Celular:</span></td>
          <td width="10">&nbsp;</td>
          <td><span id="sprytextfield7">
          <input name="Telefone_Celular" type="text" id="Telefone_Celular" size="19" />
          <span class="textfieldInvalidFormatMsg">Inválido, Ex.:2222-2222!</span></span></td>
          </tr>
          
          <!-- Site -->
          <tr>
          <td width="140" align="right"><span class="style5">Site:</span></td>
          <td width="10">&nbsp;</td>
          <td><span id="sprytextfield8">
            <input name="Site" type="text" id="Site" size="40" />
          <span class="textfieldRequiredMsg">Obrigatório!</span><span class="textfieldInvalidFormatMsg">Inválido! Ex. http://www.tonobairro.com.br</span></span></td>
        </tr>

        <!-- email -->
        <tr>
          <td width="140" align="right"><span class="style5">E-mail:</span></td>
          <td width="10">&nbsp;</td>
          <td><span id="sprytextfield9">
          <input name="Email" type="text" id="Email" size="40" />
          <span class="textfieldRequiredMsg">Obrigatório!.</span><span class="textfieldInvalidFormatMsg">E-mail inválido!</span></span></td>
           </tr>
          
          <!-- Contato -->
          <tr>
          <td width="140" align="right"><span class="style5">Contato:</span></td>
          <td width="10">&nbsp;</td>
        <td><span id="sprytextfield5">
            <input name="Contato" type="text" id="Contato" size="40" />
        <span class="textfieldRequiredMsg">Obrigatório!</span></span></td>
          </tr>
          

          <!-- descrição -->
          <tr>
            <td align="right">&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td align="right">&nbsp;</td>
            <td>&nbsp;</td>
            <td><span class="style6">* Espaço reservado para descrição de acessórios e outros.</span></td>
          </tr>
          <tr>
          <td width="140" align="right"><span class="style5">Descrição:</span></td>
          <td width="10">&nbsp;</td>
          <td><span id="sprytextfield5"><span id="sprytextarea1">
        <label>
        <textarea name="Descricao" id="Descricao" cols="50" rows="5"></textarea>
        <span id="countsprytextarea1">&nbsp;</span>        <span class="textareaMinCharsMsg">Descrição mínima com 20 caracter!</span> <span class="textareaMaxCharsMsg">Máxímo de caracter 250.</span></label>
            </span>            <span class="textfieldRequiredMsg">Obrigatório!</span></span></td>
          </tr>
        
          <tr>
            <td align="right">&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
        <tr>
          <td width="140" align="right"><span class="style6"></span></td>
          <td width="10">&nbsp;</td>
          <td><input type="submit" name="btn_criaalbum" id="btn_criaalbum" value="Enviar Anúncio" />
          <label></label></td>
        </tr>
        <tr>
          <td align="right">&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
      </table>
      <input type="hidden" name="MM_insert" value="fm_criaalbum">
    </form>
   </fieldset>
<script type="text/javascript">
<!--
var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1", "none", {validateOn:["blur"]});
var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2", "none", {validateOn:["blur"]});
var spryselect1 = new Spry.Widget.ValidationSelect("spryselect1", {validateOn:["blur"]});
var spryselect2 = new Spry.Widget.ValidationSelect("spryselect2", {validateOn:["blur"]});
var spryselect3 = new Spry.Widget.ValidationSelect("spryselect3", {validateOn:["blur"]});
var spryselect4 = new Spry.Widget.ValidationSelect("spryselect4", {validateOn:["blur"]});
var sprytextfield3 = new Spry.Widget.ValidationTextField("sprytextfield3", "currency", {validateOn:["blur"]});
var sprytextfield4 = new Spry.Widget.ValidationTextField("sprytextfield4", "phone_number", {validateOn:["blur"], format:"phone_custom", pattern:"0000-0000"});
var sprytextfield5 = new Spry.Widget.ValidationTextField("sprytextfield5", "none", {validateOn:["blur"]});
var sprytextfield5 = new Spry.Widget.ValidationTextField("sprytextfield6", "none", {validateOn:["blur"]});
var spryselect5 = new Spry.Widget.ValidationSelect("spryselect5", {validateOn:["blur"]});
var sprytextfield7 = new Spry.Widget.ValidationTextField("sprytextfield7", "phone_number", {format:"phone_custom", pattern:"0000-0000", validateOn:["blur"], isRequired:false});
var sprytextfield8 = new Spry.Widget.ValidationTextField("sprytextfield8", "url", {validateOn:["blur"], isRequired:false});
var sprytextfield9 = new Spry.Widget.ValidationTextField("sprytextfield9", "email", {validateOn:["blur"], isRequired:false});
var sprytextarea1 = new Spry.Widget.ValidationTextarea("sprytextarea1", {isRequired:false, minChars:20, maxChars:250, counterId:"countsprytextarea1", counterType:"chars_count", validateOn:["blur"]});
var spryselect6 = new Spry.Widget.ValidationSelect("spryselect6", {validateOn:["blur"]});
var spryselect7 = new Spry.Widget.ValidationSelect("spryselect7", {validateOn:["blur"]});
//-->
</script>
</body>
</html>

Grato

Abraços

Valmir Lopes

Link para o comentário
Compartilhar em outros sites

2 respostass a esta questão

Posts Recomendados

Participe da discussão

Você pode postar agora e se registrar depois. Se você já tem uma conta, acesse agora para postar com sua conta.

Visitante
Responder esta pergunta...

×   Você colou conteúdo com formatação.   Remover formatação

  Apenas 75 emoticons são permitidos.

×   Seu link foi incorporado automaticamente.   Exibir como um link em vez disso

×   Seu conteúdo anterior foi restaurado.   Limpar Editor

×   Você não pode colar imagens diretamente. Carregar ou inserir imagens do URL.

×
 Share
Ir para lista de Perguntas


  • Estatísticas dos Fóruns

    • Tópicos
      152,3k
    • Posts
      652,6k
×
×
  • Criar Novo...