Fórum Como alterar no banco de dados com informação da Session? #586503
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
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)