Insert GET mode

Navigation
-1

Good morning,  This is the form of a form of my questions: 

<form class="form-horizontal" action="chk-gerente.php?nro_pergunta=<?php  echo $nro_pergunta; ?>" method="GET">
      <fieldset>
          <legend>Pergunta <?php echo"$ordem";?>/<?php echo"$totalpergunta";?></legend>
        <div class="form-group">
          <center><h3><label><?php echo"$descpergunta";?></label></h3></center>
          <div class="col-lg-10">
            <div class="radio"><label><input type="radio" name="resp" id="optionsRadios1" value="5">OTIMO        </label></div>
            <div class="radio"><label><input type="radio" name="resp" id="optionsRadios2" value="3">REGULAR      </label></div>
            <div class="radio"><label><input type="radio" name="resp" id="optionsRadios3" value="1">RUIM         </label></div>
            <div class="radio"><label><input type="radio" name="resp" id="optionsRadios4" value="0">NAO APLICADO </label></div>
          </div>
        </div>
        <?php
         $timestamp            = @mktime(date("H")-4, date("i"),date("s"),date("m"),date("d"),date("Y"),0);
         $DataCad              = gmdate("Y-m-d", $timestamp); // Gravar $DataCad no BD
         echo"<input type='hidden' name='loja'         id='loja'         value='$loja'>";
         echo"<input type='hidden' name='id_usuario'   id='id_usuario'   value='$id_usuario'>";
         echo"<input type='hidden' name='questionario' id='questionario' value='$questionario'>";
         echo"<input type='hidden' name='area'         id='area'         value='$area'>";
         echo"<input type='hidden' name='nro_pergunta' id='nro_pergunta' value='$nro_pergunta'>";     
         echo"<input type='hidden' name='DataCad'      id='DataCad'      value='$DataCad'>";
         echo"<input type='hidden' name='pergunta'     id='pergunta'     value='$idpergunta'>";
        ?>
        <div class="form-group">
          <div class="col-lg-10 col-lg-offset-2">
            <button type="submit" class="btn btn-primary">Responder</button>
           </div>
        </div>
      </fieldset>
     </form>

As I'm passing a command in action, how could my insert be in db?  I tried to make the top of the page with GET more unsuccessful, any tips?

    
asked by anonymous 13.02.2016 / 04:43

1 answer

0

Solved.  I passed it as follows: 

 if(isset($_GET['submit'])){
    $loja         = $_GET ["loja"];
    $id_usuario  = $_GET ["id_usuario"]; 
    $questionario = $_GET ["questionario"];
    $area         = $_GET ["area"];
    $idpergunta   = $_GET ["pergunta"];   
    $resp         = $_GET ["resp"]; 
    $datacad      = $_GET ["data_cad"]; 

  $sql_insert = mysql_query("INSERT INTO respostas 
  (resp_id,resp_loja,resp_usuario,resp_questionario,resp_area,resp_subgrupo,resp_pergunta_id,resp_resposta,resp_data,resp_status)
  VALUES 
  ('','$loja','$id_usuario','$questionario','$area','1','$idpergunta','$resp','$datacad','1')") 
   or die (mysql_error());
    mysql_query($sql_insert,$conexao); }

Thank you.

    
13.02.2016 / 15:52
JasperReports, Document Contains No Pages? Chart for weeks