Merhaba PHP ile bir script yazıyorum şifre güncelleme işlemi yapıyorum mysql veritabanına şifre kaydoluyor ancak giriş yapmaya çalıştığımda şifre yanlış hatasıyla karşılaşıyorum nerede hata yaptığımı bulamadım yardımcı olursanız sevinirim teşekkürler.
adminfonksiyon.php ;
adminislem.php ;
settings.php (şifre güncelleme paneli) ;
login.php ;
adminfonksiyon.php ;
Kod:
<?php
function checkInput($var)
{
return stripcslashes(trim(htmlspecialchars($var)));
}
function kayitlimi($id)
{
global $baglan;
$sorgu=$baglan->prepare("SELECT id FROM admin WHERE id=?");
$sorgu->execute(array($id));
if ($sorgu->rowCount())
{
return true;
}
else
{
return false;
}
}
function OturumAcikmi()
{
return (isset($_SESSION['admin'])) ? true : false;
}
?>
adminislem.php ;
Kod:
<?php
include "../config/db.php";
include "adminfonksiyon.php";
if($_POST)
{
$email=checkInput($_POST['email']);
$parola=checkInput($_POST['parola']);
$adsoyad=checkInput($_POST['adsoyad']);
if (kayitlimi(1))
{
$sorgu=$baglan->prepare("UPDATE admin SET email=? , parola=? , adsoyad=? WHERE id=?");
$sorgu->execute(array($email,md5(sha1($parola)),$adsoyad,1));
$hata=$sorgu->errorInfo();
if(empty($hata[2]))
{
$uyari="Güncelleme başarıyla tamamlandı";
}
else
{
$uyari= "Güncelleme işlemi sırasında hata:".$hata[2];
}
}
else
{
$sorgu=$baglan->prepare("INSERT INTO admin(email,parola,adsoyad) VALUES (?,?,?)");
$sorgu->execute(array($email,md5(sha1($parola)),$adsoyad));
$hata=$sorgu->errorInfo();
if(empty($hata[2]))
{
$uyari="Kayıt işlemi başarıyla tamamlandı";
}
else
{
$uyari= "Kayıt işlemi sırasında hata:".$hata[2];
}
}
echo $uyari;
}
?>
settings.php (şifre güncelleme paneli) ;
Kod:
<?php
include "../config/db.php";
include "adminfonksiyon.php";
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Admin Paneli</title>
<**** charset="utf-8">
<**** name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.css'>
<link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/noUiSlider/10.1.0/nouislider.css'><link rel="stylesheet" href="./css/style.css">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<script src="../assets/ckeditor/ckeditor.js"></script>
<link rel="stylesheet" href="../assets/css/stil.css">
</head>
<?php
if (kayitlimi(1))
{
$sorgu = $baglan->prepare("SELECT * FROM admin");
$sorgu->execute(array());
$icerik = $sorgu->fetch(PDO::FETCH_OBJ);
?>
<!-- partial:index.partial.html -->
<div class="container">
<!-- SIDE AREA -->
<div class="sideArea">
<div class="avatar">
<div class="avatarName">Hoşgeldin,<br><?=$icerik->adsoyad;?></div>
</div>
<ul class="sideMenu">
<li><a href="javascript:****(0)" class="has-submenu"><span class="fa fa-table"></span>PRODUCT</a>
<ul class="submenu">
<li><a href="index.php?c=product&a=list01"><span class="fa fa-list"></span>Product List</a></li>
<li><a href="index.php?c=product&a=list02"><span class="fa fa-tags"></span>Category List</a></li>
</ul>
</li>
<li><a href="menu_list.php"><span class="fa fa-sitemap"></span>MENU</a></li>
<li><a href="settings.php"><span class="fa fa-user-o"></span>Admin Bilgileri</a></li>
<li><a href="contact_list.php"><span class="fa fa-envelope-o"></span>CONTACT</a></li>
</ul>
</div>
<!-- SIDE AREA -->
<div class="mainArea">
<!-- BEGIN NAV -->
<nav class="navTop row">
<div class="menuIcon fl"><span class="fa fa-bars"></span></div>
<div class="account fr">
<div class="name has-submenu"><?=$icerik->adsoyad;?><span class="fa fa-angle-down"></span></div>
<ul class="accountLinks submenu">
<li><a href="localhost">View website</a></li>
<li><a href="cikis.php">Log out<span class="fa fa-sign-out fr"></span></a></li>
</ul>
</div>
</nav>
<!-- END NAV -->
<!-- CONTAINER -->
<div class="mainContent">
<div class="formHeader row">
<form id="admin-form">
<h4>Admin Bilgileri</h4>
<hr>
<div class="form-group">
<label>Ad Soyad</label>
<input type="text" class="form-control" name="adsoyad" value="<?=$icerik->adsoyad;?>">
</div>
<div class="form-group">
<label>E posta </label>
<input type="email" class="form-control" name="email" value="<?=$icerik->email;?>">
</div>
<div class="form-group">
<label>Şifre</label>
<input type="password" class="form-control" name="parola" value="<?=$icerik->parola;?>">
</div>
<div class="form-group text-right ">
<button type="button" <button class="button button2 btnkaydet">Bilgileri Kaydet</button>
</div>
<div class="form-group text-center row d-none uyari">
<div class="col-md-3"></div>
<div class="alert alert-info col-md-6 text-center"></div>
<div class="col-md-3"></div>
</div>
</a>
<?php } else { ?>
<div class="container">
<!-- SIDE AREA -->
<div class="sideArea">
<div class="avatar">
<div class="avatarName">Hoşgeldin,<br><?=$icerik->author;?></div>
</div>
<ul class="sideMenu">
<li><a href="javascript:****(0)" class="has-submenu"><span class="fa fa-table"></span>PRODUCT</a>
<ul class="submenu">
<li><a href="index.php?c=product&a=list01"><span class="fa fa-list"></span>Product List</a></li>
<li><a href="index.php?c=product&a=list02"><span class="fa fa-tags"></span>Category List</a></li>
</ul>
</li>
<li><a href="menu_list.php"><span class="fa fa-sitemap"></span>MENU</a></li>
<li><a href="settings.php"><span class="fa fa-user-o"></span>Admin Bilgileri</a></li>
<li><a href="contact_list.php"><span class="fa fa-envelope-o"></span>CONTACT</a></li>
</ul>
</div>
<!-- SIDE AREA -->
<div class="mainArea">
<!-- BEGIN NAV -->
<nav class="navTop row">
<div class="menuIcon fl"><span class="fa fa-bars"></span></div>
<div class="account fr">
<div class="name has-submenu"><?=$icerik->author;?><span class="fa fa-angle-down"></span></div>
<ul class="accountLinks submenu">
<li><a href="localhost">View website</a></li>
<li><a href="cikis.php">Log out<span class="fa fa-sign-out fr"></span></a></li>
</ul>
</div>
</nav>
<!-- END NAV -->
<!-- CONTAINER -->
<div class="mainContent">
<div class="formHeader row">
<form id="admin-form">
<h4>Şifre Değiştir</h4>
<hr>
<div class="form-group">
<label>Admin Bilgileri</label>
</div>
<div class="form-group">
<label>Ad Soyad</label>
<input type="text" class="form-control" name="adsoyad" value="<?=$icerik->adsoyad;?>">
</div>
<div class="form-group">
<label>E posta </label>
<input type="text" class="form-control" name="email" value="<?=$icerik->email;?>">
</div>
<div class="form-group">
<label>Şifre</label>
<input type="text" class="form-control" name="parola" value="<?=$icerik->parola;?>">
</div>
<div class="form-group text-right ">
<button type="button" <button class="button button2 btnkaydet">Bilgileri Kaydet</button>
</div>
<div class="form-group text-center row d-none uyari">
<div class="col-md-3"></div>
<div class="alert alert-info col-md-6 text-center"></div>
<div class="col-md-3"></div>
</div>
*********
input[type=text] {
width: 100%;
padding: 12px 20px;
margin: 8px 0;
box-sizing: border-box;
border: 3px solid #008CBA;
-webkit-transition: 0.5s;
transition: 0.5s;
outline: none;
}
input[type=text]:focus {
border: 3px solid #2A3F54;
}
.button {
background-color: #4CAF50; /* Green */
border: none;
color: white;
padding: 16px 32px;
text-align: center;
text-decoration: none;
display: inline-block;
font-size: 16px;
margin: 4px 2px;
transition-duration: 0.4s;
cursor: pointer;
}
.button2 {
background-color: white;
color: black;
border: 2px solid #008CBA;
width: 50%;
}
.button2:hover {
background-color: #008CBA;
color: white;
}
</style>
<?php } ?>
</form>
</body>
</html>
<script src='https://cdnjs.cloudflare.com/ajax/libs/noUiSlider/10.1.0/nouislider.js'></script><script src="./js/script.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script>
<script src="./js/jsadmin.js"></script>
login.php ;
Kod:
<?php
include "../config/db.php";
include "adminfonksiyon.php";
session_start();
OturumAcikmi() ? header("********: index.php") : "";
if ($_POST)
{
$email=checkInput($_POST['email']);
$parola=checkInput($_POST['parola']);
$sorgu=$baglan->prepare("SELECT * FROM admin WHERE email=?");
$sorgu->execute(array($email));
if ($sorgu->rowCount())
{
$result=$sorgu->fetch(PDO::FETCH_ASSOC);
if (password_verify($parola,$result["parola"]))
{
$_SESSION["admin"]=$result["email"];
$uyari="Giriş işlemi başarılı.";
}
else
{
$uyari="Giriş işlemi başarısız!";
}
}
else
{
$uyari="Giriş işlemi başarısız!";
}
}
?>
<!doctype html>
<html lang="tr">
<head>
<**** charset="utf-8">
<**** name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link href="https://fonts.googleapis.com/css?family=Raleway:300,400,600" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="assets/css/stil.css">
<link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<title>Admin Login</title>
</head>
<body class="login">
<div class="container">
<div class="row">
<div class="col-md-12 text-center m-5">
<h2 >Admin Paneli - Giriş</h2>
</div>
</div>
</div>
<main class="login-form">
<div class="container">
<div class="row justify-content-center">
<div class="col-md-8">
<div class="card">
<div class="card-header">Giriş Yap</div>
<div class="card-body">
<form method="POST" action="">
<div class="form-group row">
<label for="email_address" class="col-md-4 col-form-label text-md-right">E-Mail Adresi</label>
<div class="col-md-6">
<input type="email" id="email_address" class="form-control" name="email" required autofocus>
</div>
</div>
<div class="form-group row">
<label for="password" class="col-md-4 col-form-label text-md-right">Parola</label>
<div class="col-md-6">
<input type="password" id="password" class="form-control" name="parola" required>
</div>
</div>
<div class="col-md-6 offset-md-4">
<button type="submit" class="btn btn-primary">
Giriş Yap
</button>
</div>
<div class="form-group row">
<div class="col-md-6 offset-md-4 mt-2">
<?php if(isset($uyari)) : ?>
<div class="alert alert-info text-center">
<?=$uyari;?>
<?php if (strpos($uyari,"başarılı")):?>
<script>
setTimeout(function(){ window.********.href="index.php"; }, 3000);
</script>
<?php endif; ?>
</div>
<?php endif; ?>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</main>
</body>
</html>