Como alterar no banco de dados com informação da Session?
05/10/2017
0
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
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
Curtir tópico
+ 0
Responder
Posts
05/10/2017
Vinicius
Já vi meu erro... estava dando where com o email que não foi cadastrado ainda... desde já obrigado!
Responder
Clique aqui para fazer login e interagir na Comunidade :)