0
What could be wrong? Inserts nothing into the bank.
Form:
<form class="form-horizontal" action="chk-gerente.php?nro_pergunta=<?php echo $nro_pergunta; ?>" method="GET">
<fieldset>
<legend><b>Pergunta <?php echo"$ordem";?> de <?php echo"$totalpergunta";?></b></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 id='button' type="submit" class="btn btn-primary">Responder</button>
</div>
</div>
</fieldset>
</form>
The INSERT
is at the top of the page:
require("conexao.php");
if(isset($_GET['submit'])){
$loja = $_GET ["loja"];
$id_ususario = $_GET ["id_usuario"];
$questionario = $_GET ["questionario"];
$area = $_GET ["area"];
$idpergunta = $_GET ["pergunta"];
$resp = $_GET ["resp"];
$datacad = $_GET ["DataCad"];
$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);
} else {
}
I tried to pass as well and it was not...
include("conexao.php");
if(isset($_GET['submit'])){
$loja = $_GET ["loja"];
$id_ususario = $_GET ["id_usuario"];
$questionario = $_GET ["questionario"];
$area = $_GET ["area"];
$idpergunta = $_GET ["pergunta"];
$resp = $_GET ["resp"];
$datacad = $_GET ["DataCad"];
$sql=" 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'";
} else {
}
Have you tried turning the
Insert
straight to the bank to see if it’s working?– Berriel
It is worth remembering that the functions
mysql_*
is already deprecated in PHP 5.5 (and removed from 7.0)... migrate toMySQLi
orPDO_MySQL
– Berriel
It went right through the bank.
– Chefe Druida
Remove all the@ from the code to see the error message.
– rray
Another thing: this
@mysql_query($sql_insert,$conexao);
would only be correct if$sql_insert
query, but it is the result of a query...– Berriel
@Berriel ,look there please what I added ...
– Chefe Druida
Do the following
mysql_query($sql) or die(mysql_error());
– rray
the way you did has no action, do what @rray said
– Berriel
Would that be it? ,because the screen returned empty without error ... $sql = "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')" mysql_query($sql) or die(mysql_error());
– Chefe Druida
This, some error appears?
– rray
No, the screen is blank even if I put the var_dump($sql); it shows nothing
– Chefe Druida
puts this at the top of the file,
ini_set('display_errors',true); error_reporting(E_ALL);
– rray
Opa,started to improve,I did a test here and if I change: if(isset($_GET['Submit']))' para if(getenv("REQUEST_METHOD") == "GET"){ ele da o Insert,more I noticed if updating the page inserts,and the first one inserts empty,to thinking that something wrong in GET,some hint?
– Chefe Druida
some error appears?
– rray
not in this one,
– Chefe Druida
is that just entering the page already inserts
– Chefe Druida
@Otacio see my answer to know why you are entering just by entering the page, and inserting blank
– Berriel