Alert appearing at the wrong time

Question

Alert appearing at the wrong time

Asked 6 years, 10 months ago

Viewed 104 times

0

I made a php code where the first part of it is to go through the login.php page. and for this I put an Alert to warn when the login and password are incorrect. for that I put an If and an Lse and I left the Alert inside the Else, but when entering the page the first thing that makes is to show the window of the Alert with the massage that I put and whenever I update the page the window of the Alert appear, and I want to make Alert appear only when the login or password is incorrect. below follows the codes used.

Login.php

<html>
<head>
	<meta charset="UTF-8">
    <script>
var modal = document.getElementById('id01');

window.onclick = function(event) {
    if (event.target == modal) {
        modal.style.display = "none";
    }
}
var modal = document.getElementById('id02');


window.onclick = function(event) {
    if (event.target == modal) {
        modal.style.display = "none";
    }
}

function funcao(x) {
    x.style.background = "#B22222";
}
</script>

</head>
<body id="imgpos">
    <center>
  <h2 title="nao fique parado!">Sistema Controle de Produtos</h2>

<button onclick="document.getElementById('id01').style.
display='block'" style="width:auto;">Login</button>
<button onclick="document.getElementById('id02').style.
display='block'" style="width:auto;">Cadastro</button>
</center>
	<div id="id01" class="modal">
  
  <form class="modal-content animate" action ="" method = "post" >
    <div class="imgcontainer">
      <span onclick="document.getElementById('id01').style.display='none'" class="close" title="fechar">&times;</span>
     <img src="4ad.png" alt="Avatar" class="avatar">
    </div>
    <div class="container">
      <label><b>Login:</b></label>
      <input type="text" placeholder="Digite seu usuario" name="login" required onfocus ="funcao(this)">

      <label><b>Senha:</b></label>
      <input type="password" placeholder="Digite sua senha" name="senha" required required minlength="8" maxlength="8" onfocus ="funcao(this)">
        
      <button type="submit">Entrar!</button>
    </div>

    <div class="container" style="background-color:#7FFFD4">
      <center>
      <button type="button" onclick="document.getElementById('id01').style.display='none'" class="cancelbtn">Cancel</button>
      </center>
    </div>
  </form>
</div>
<div id="id02" class="modal">
  
  <form class="modal-content animate" action ="evento2.php?cadastro=true" method = "post" >
    <div class="imgcontainer">
      <span onclick="document.getElementById('id02').style.display='none'" class="close" title="voltar">&times;</span>
     <img src="25.png" alt="Avatar" class="avatar">
    </div>
    <div class="container">
      <label><b>Login:</b></label>
      <input type="text" placeholder="Digite o usuario desejado" name="login1" required onfocus ="funcao(this)">

      <label><b>Senha:</b></label>
      <input type="password" placeholder="Digite a senha desejada" name="senha1" required minlength="8" maxlength="8" onfocus ="funcao(this)">
        
      <button type="submit">Cadastrar!</button>
    </div>

    <div class="container" style="background-color:#7FFFD4">
      <center>
      <button type="button" onclick="document.getElementById('id02').style.display='none'" class="cancelbtn">voltar</button>
      </center>
    </div>
  </form>
</div>
<h3 align="center">&copy Amem!</h3>
<?php
include_once "conexao.php";
if(isset($_POST['login']))$login = $_POST['login'];
if(isset($_POST['senha']))$senha = $_POST['senha'];
$sql="select * from funcionario where nome='$login' and senha='$senha'";
$result=mysql_query($sql,$con);
$res=mysql_num_rows($result);
if($res){
	$linha=mysql_fetch_array($result);
	session_start();
	$_SESSION['id']=$linha['id_funcionario'];
	$_SESSION['nome']=$linha['nome'];
	echo "<script> window.location='index.php'</script>";		
}else{
    echo "<script>alert('Login ou Senha invalidos')</script>";
}
?>
</body>
</html>

index php.

<?php
 session_start();
 if(isset($_SESSION['id'])==0 and isset($_SESSION['nome'])==0){
  echo "<script> window.location='login.php'</script>";
}else{
  $nome=$_SESSION['nome'];
  echo "<h3>usuario: $nome <a href='login.php'>sair</a></h3>";
}
?>
<HTML>
  <HEAD>
    <script type="text/javascript">
function valida_preco() {
   var num = document.getElementById('preco').value;
   if ( isNaN( num ) ) { // isNaN = is not a number
      alert('Não é um número!');
      return false;
   }
   return true; // prossegue o envio
}
</script>
    <meta charset="utf-8">
     <TITLE>Cadastros</TITLE>

 <script type="text/javascript" src="jquery-3.2.1.js"></script>
 <script src="jquery.maskMoney.js" type="text/javascript"></script>
<script type="text/javascript">
  $(document).ready(function(){
$("#horario tbody tr:odd").addClass("zebraum");
});
  $(document).ready(function(){
$("#horario tbody tr:even").addClass("zebradois");
});
    $(function(){
        $("#valor").maskMoney();
    })
</script>
</HEAD>
<BODY id="imgpos">
<center>
  <h2 title="nao fique parado!">Controle de Estoque!</h2>

<button onclick="document.getElementById('id01').style.
display='block'" style="width:auto;">Cadastra-se</button>
<button onclick="document.getElementById('id02').style.
display='block'" style="width:auto;">Registros</button>
</center>
<div id="id01" class="modal">
  
  <form class="modal-content animate" action ="evento.php?cadastro=true" method = "post" >
    <div class="imgcontainer">
      <span onclick="document.getElementById('id01').style.display='none'" class="close" title="fechar">&times;</span>
     <img src="5534.jpg" alt="Avatar" class="avatar">
    </div>
    <div class="container">
      <label><b>Produto:</b></label>
      <input type="text" placeholder="Digite o nome do Produto" name="produto" required onfocus ="funcao(this)">

      <label><b>Preço:</b></label>
      <input type="text" id="valor" placeholder="R$..." name="preco" required onfocus ="funcao(this)">
        
      <button type="submit">Cadastrar!</button>
    </div>

    <div class="container" style="background-color:#7FFFD4">
      <center>
      <button type="button" onclick="document.getElementById('id01').style.display='none'" class="cancelbtn">Cancel</button>
      </center>
    </div>
  </form>
</div>
    <div id="id02" class="modal">

    <form class="modal-content animate" action ="evento.php?cadastro=true" method = "post" >
        <div class="imgcontainer">
      <span onclick="document.getElementById('id02').style.display='none'" class="close" title="Voltar">&times;</span>

    </div>

    <div class="container">
      
    <div class="container" style="background-color:#7FFFD4">
      <center> <h2>Lista de Produtos 
</h2></center>
 <table border="2" id='horario'>
 <thead>
<tr>
  <th>id</th>
  <th>Produto</th>
  <th>Preço</th>
  <th>Funcionário</th>
  <th>Alterar</th>
  <th>Excluir</th>
</tr>
<style type="text/css">
  tbody tr:hover{background-color:#555} 

</style>
</thead>
<tfoot>
    <tr>
        <td colspan="6"><center><script language=javascript type="text/javascript">
    dayName = new Array ("domingo", "segunda", "terça", "quarta", "quinta", "sexta", "sábado")
monName = new Array ("janeiro", "fevereiro", "março", "abril", "maio", "junho", "agosto", "outubro", "novembro", "dezembro")
now = new Date
document.write (" Hoje é " + dayName[now.getDay() ] + ", " + now.getDate () + " de " + monName [now.getMonth() ]   +  " de "  +     now.getFullYear () + "   ")
document.write ( + now.getHours() + ":" + now.getMinutes() + ":" + now.getSeconds() )
</script></center></td>
    </tr>
</tfoot>
<center>
 <?php
            include_once "conexao.php";
            $sql = "select p.codigo, p.nome as np, p.preco, c.nome as nf from funcionario as c join produto as p on
            c.id_funcionario=p.id_funcionario";
            $result = mysql_query($sql,$con);
            if($result){
            while($linha = mysql_fetch_array($result)){
?>

<tbody id="horario">
       <tr>
           <td id='p3'> <?php  echo $linha['codigo'];?></td>
           <td> <?php echo $linha['np'];?></td>
           <td id='p4'> <?php echo "R$". $linha['preco'];?></td>
           <td> <?php echo $linha['nf'];?></td>       
           <td> <?php echo "<a id='p1' href = editar.php?editar=".$linha['codigo']." >editar </a>";?></td>
           <td> <?php echo "<a id='p2' href = evento.php?deletar=".$linha['codigo'].">excluir</a>";?></td>
       </tr>
</tbody>

<?php
          }//fim do while
          }//fim do if  
          mysql_close($con);
?>
</table> 
    <center>
      <button type="button" onclick="document.getElementById('id02').style.display='none'" class="cancelbtn">voltar</button>
       </center>
    </div>
  </form>
</div>
<script>
var modal = document.getElementById('id01');

window.onclick = function(event) {
    if (event.target == modal) {
        modal.style.display = "none";
    }
}
var modal = document.getElementById('id02');


window.onclick = function(event) {
    if (event.target == modal) {
        modal.style.display = "none";
    }
}

function funcao(x) {
    x.style.background = "#B22222";
}
</script>
<h3 align="center">&copy Amem!</h3>
<BR>

</BODY>
</HTML>

php connection.

<HTML>
<HEAD>
 <TITLE>Conexao</TITLE>
</HEAD>
<BODY>
<?php
  $host="localhost";
  $login="root";
  $senha="";
  $banco="controle_de_estoque";

  $con=mysql_connect($host,$login,$senha)or die("Erro ao conecta!".mysql_error());
  $sql="create database if not exists ".$banco;
  mysql_query($sql,$con);
  mysql_select_db($banco,$con);
  $sql = "create table if not exists funcionario(
  id_funcionario int(8) auto_increment,
  nome varchar(100) not null,
  senha varchar(50) not null,
  primary key(id_funcionario))";
  mysql_query($sql,$con);
  $sql="create table if not exists produto(codigo int(8) auto_increment,
  nome varchar(100) not null, preco varchar(15) not null, id_funcionario int(8) not null,
  primary key(codigo), foreign key(id_funcionario) references funcionario(id_funcionario))";
  mysql_query($sql);
?>

</BODY> 
</HTML>

edit.php

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
</head>
    <?php
    include_once 'conexao.php';
    $sql='select * from produto where codigo='.$_GET['editar'];
    $result=mysql_query($sql,$con);
    $linha=mysql_fetch_array($result);
    ?>
    
<script type="text/javascript" src="jquery-3.2.1.js"></script>
 <script src="jquery.maskMoney.js" type="text/javascript"></script>
 <script type="text/javascript">
 $(function(){
        $("#valor").maskMoney();
    })
</script>

<body>
<center>
<div id="id01" class="modal" >
    </center>
  <form class="modal-content animate"<?php echo "<form action= 'evento.php?editar=".$linha['codigo']."'method='post'";?>>
    <div class="imgcontainer">
      <span onclick="window.location='index.php'" class="close" title="fechar">&times;</span>
     <img src="5534.jpg" alt="Avatar" class="avatar">
    </div>
    <div class="container"><br>
      Produto:<br>
         <input type="text" name="produto" value="<?php echo $linha['nome'];?>" required><p></p>
        Preço:<br>
         <input type="text" id="valor" name="preco" value="<?php echo $linha['preco'];?>" required><p></p>
         <br>
      <button type="submit">Editar</button>
    </div>
    <div class="container" style="background-color:#7FFFD4">
        <center>
      <button type="button" onclick="window.location='index.php'" class='cancelbtn'>Cancel</button>
        </center>
    </div>
  </form>
</div>
</body>
</html>

php event.

<?php
session_start();
 if(isset($_SESSION['id'])==0 and isset($_SESSION['nome'])==0){
  echo "<script> window.location='login.php'</script>";
}else{
  $userId=$_SESSION['id'];
  $nome=$_SESSION['nome'];
}

 include_once'conexao.php';
 if(isset($_POST['produto']))$atrProduto = $_POST['produto'];
 if(isset($_POST['preco']))$atrPreco = $_POST['preco'];
 if(isset($_GET['cadastro']))
 {


$sql = sprintf("INSERT INTO `produto` SET `nome` = \"%s\", `preco` = \"%s\", `id_funcionario` = \"%d\";",
    $atrProduto,
    $atrPreco,
    $userId);

 mysql_query($sql,$con);
 echo "<script>alert('Produto cadastrado com sucesso!')</script>";
 }
 if(isset($_GET['deletar'])){
 $sql = "delete from produto where codigo = ".$_GET['deletar'];
 mysql_query($sql,$con);
 echo "<script>alert('Produto deletado com sucesso!')</script>";
 }
 if(isset($_GET['editar'])){
 $sql = "update produto set nome= '".$atrProduto."',preco='".$atrPreco."', id_funcionario=".$userId." where codigo=".$_GET['editar'];
 mysql_query($sql,$con);
 echo"<script> alert('Produto atualizado com sucesso')</script>";
 }
 echo"<script>window.location='index.php'</script>";

Could someone help me find my mistake, why Alert always work as soon as I enter the page.

1 answer

Browser other questions tagged php html alert bdd

You are not signed in. Login or sign up in order to post.

by Thomas Franklin • **286** points · Answer 1 · 2018-01-09T21:12:32+00:00

Dude, make these changes to your code.

if($_POST['login'] && $_POST['senha']){
      $email = $_POST['login'];
      $password = $_POST['senha'];
      $sql="SELECT * FROM funcionario WHERE email='$email' AND senha='$password'";
      $result=mysql_query($sql,$con);
      $res=mysql_num_rows($result);
      if($res){
        $linha=mysql_fetch_array($result);
        session_start();
        $_SESSION['id']=$linha['id_funcionario'];
        $_SESSION['nome']=$linha['nome'];
        echo "<script> window.location='index.php'</script>";   
      }else{
        echo "<script>alert('Login ou Senha invalidos')</script>";
      }
    }