Como alterar no banco de dados com informação da Session?

HTML

PHP

05/10/2017

Boa tarde, gostaria de saber como faço pra fazer uma alteração no banco de dados com os dados já inseridos (pois a pessoa tem que logar para fazer a alteração de seus dados) com Session.
No meu código esta passando tudo e dando a mensagem de Alterado com sucesso, porém no banco de dados não há alteração.
Segue meu código abaixo..Abraços

<?php
	session_start();
    $connect = mysql_connect('localhost','root','');

    $db = mysql_select_db('eenemp');
	
	 if (isset( $_POST['login']))
    {

		$emailP  = $_SESSION["logadoProf"];
        $senhaP = $_SESSION["senhaProf"];
		//editados
		$emailEP  = $_POST['EemailP'];	
        $senhaEP = $_POST['EsenhaP'];
		
		$verifica = ("SELECT emailProfessor,senhaProfessor FROM cadastroprofessores WHERE emailProfessor = '$emailP' AND senhaProfessor = '$senhaP'");
		
		$res = mysql_query($verifica);
		
		 if (mysql_num_rows ( $res ) !=1)
      {
                   echo "<script language='javascript' type='text/javascript'>
					alert('Informacoes incorretas');
                    window.location.href='edicaoProfessor.php';</script>";
                    die();
                }

				else{
						mysql_query("UPDATE cadastroprofessores SET emailProfessor ='$emailEP' , senhaProfessor = '$senhaEP' WHERE emailProfessor='$emailEP'");
						echo"<script language='javascript' type='text/javascript'>
  		  				alert('Alteração efetuada com sucesso!!!');
         					window.location.href='logadoProfessor.php';</script>";					
						
             }
              }
?>
<!DOCTYPE HTML>
<html>
<head>
<title>EENEMP/Editar dados</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
<link href="layout/styles/layout.css" rel="stylesheet" type="text/css" media="all">
</head>
<body id="top">
<!-- ################################################################################################ -->
<!-- ################################################################################################ -->
<!-- ################################################################################################ -->
<div class="wrapper row0">
  <div id="topbar" class="hoc clear"> 
    <!-- ################################################################################################ -->
    <div class="fl_left">
      <ul class="faico clear">
        <li><a class="faicon-facebook" href="https://www.facebook.com/Eenemp-123242178273220/"><i class="fa fa-facebook"></i></a></li>
        <li><a class="faicon-google-plus" href="#"><i class="fa fa-google-plus"></i></a></li>
      </ul>
    </div>
    <div class="fl_right">
      <ul class="nospace inline pushright">
        <li><i class="fa fa-phone"></i> +55 (48) 99907 5657</li>
        <li><i class="fa fa-envelope-o"></i> viniegui.satc@gmail.com</li>
      </ul>
    </div>
    <!-- ################################################################################################ -->
  </div>
</div>
<!-- ################################################################################################ -->
<!-- ################################################################################################ -->
<!-- ################################################################################################ -->
<div class="wrapper row1">
  <header id="header" class="hoc clear"> 
    
    <div id="logo" class="fl_left">
      <a href="index.html"><img src="images/demo/Logo/logo1.png"></a>
    </div>
    <!-- ################################################################################################ -->
    <nav id="mainav" class="fl_right">
      <ul class="clear">
		<br>
        <li class="active"><a href="logadoProfessor.php">Home</a></li>
        <li><a class="drop" href="#">Ver no site</a>
          <ul>
				<li><a href="avDeUsuario.php">Avaliação de usúario</a></li>
				<li><a href="duvidasF.php">Enviar uma dúvida</a></li>
            	<li><a href="mostrarDFrequentes">Duvidas frequentes</a></li>
				<li><a href="procurarQuestoes.php">Procurar questões</a></li>
				<li><a href="#">Questões para você</a></li>
				<li><a href="#">Simulados</a></li>
          </ul>
        </li>
      <li><a class="drop" href="#"><?php echo $_SESSION["logadoProf"]; ?></a>
          <ul>
			<li><a href="edicaoProfessor.php">Editar dados</a></li>
            <li><a href="index.html">Sair</a></li>
            </li>
          </ul>
        </li>
      </ul>
    </nav>
    <!-- ################################################################################################ -->
  </header>
</div>
	<div class="cadastro" action="edicaoProfessor.php">
     <form class="formulario" method="POST" action="edicaoProfessor.php">
        <fieldset>
            <h3>Alterar informações</h3>
			
			<input type="text" id="EemailP" name="EemailP" placeholder="Novo email">
            <input type="password" id="EsenhaP" name="EsenhaP" placeholder="Nova senha">

            <input type="submit" name="login" class="login" value="Confirmar">
        </fieldset>
     </form>
       </div>
		<div class="wrapper row4">
  <footer id="footer" class="hoc clear"> 
    <!-- ################################################################################################ -->
    <div class="one_third first">
      <h6 class="title">Informações e contato</h6>
      <ul class="nospace linklist contact">
        <li><i class="fa fa-map-marker"></i>
          <address>
          Criciuma-SC
          </address>
        </li>
        <li><i class="fa fa-phone"></i> +55 (048) 9907 5657<br>
          +55 (048) 9807 3178</li>
        <li><i class="fa fa-envelope-o"></i>vinicius.smelo54@gmail.com<br>
			guiinfosatc@gmail.com</li>
      </ul>
    </div>
    <div class="one_third">
      <h6 class="title">Instituição de Ensino</h6>
      <ul class="nospace linklist contact">
        <li><i class="fa fa-map-marker"></i>
          <address>
          SATC-EDU
		  <BR>
		  R. Pascoal Meler - Universitário, Criciúma - SC, 88805-350
          </address>
      </ul>
    </div>
	 <div class="one_third">
	 <h6 class="title">Dicas e sugestões</h6>
	 <ul class="nospace linklist contact">
	 <li><i class="fa fa-envelope-o"></i> viniegui.satc@gmail.com</li>
		</ul>
			</div>
    <!-- ################################################################################################ -->
  </footer>
</div>
<!-- ################################################################################################ -->
<!-- ################################################################################################ -->
<!-- ################################################################################################ -->
<div class="wrapper row5">
  <div id="copyright" class="hoc clear"> 
    <!-- ################################################################################################ -->
    <p align="center">Copyright © 2017 - All Rights Reserved - Vinícius Spada Melo e Guilherme Loli</p>
    <!-- ################################################################################################ -->
  </div>
</div>
<!-- ################################################################################################ -->
<!-- ################################################################################################ -->
<!-- ################################################################################################ -->
<a id="backtotop" href="#top"><i class="fa fa-chevron-up"></i></a>
<!-- JAVASCRIPTS -->
<script src="layout/scripts/jquery.min.js"></script>
<script src="layout/scripts/jquery.backtotop.js"></script>
<script src="layout/scripts/jquery.mobilemenu.js"></script>
<!-- IE9 Placeholder Support -->
<script src="layout/scripts/jquery.placeholder.min.js"></script>
<!-- / IE9 Placeholder Support -->		
</body>
</html>
Vinicius

Vinicius

Curtidas 0

Respostas

Vinicius

Vinicius

05/10/2017

Já vi meu erro... estava dando where com o email que não foi cadastrado ainda... desde já obrigado!
GOSTEI 0
POSTAR