<?php
require_once("oturum.php");
require_once("class.user.php");
$auth_user = new USER();
$user_id = $_SESSION['user_session'];
$stmt = $auth_user->runQuery("SELECT * FROM users WHERE user_id=:user_id");
$stmt->execute(array(":user_id"=>$user_id));
$userRow=$stmt->fetch(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" media="screen">
<link href="bootstrap/css/bootstrap-theme.min.css" rel="stylesheet" media="screen">
<script type="text/javascript" src="jquery-1.11.3-jquery.min.js"></script>
<link rel="stylesheet" href="style.css" type="text/css" />
<title>Hoşgeldin - <?php print($userRow['kullanici_mail']); ?></title>
</head>
<body>
<nav class="navbar navbar-default navbar-fixed-top">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#"><?php print($userRow['kullanici_mail']); ?></a>
</div>
<div id="navbar" class="navbar-collapse collapse">
<ul class="nav navbar-nav">
<li class="active"><a href="#">Link</a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
<span class="glyphicon glyphicon-user"></span> Merhaba <?php echo $userRow['kullanici_mail']; ?> <span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="#"><span class="glyphicon glyphicon-user"></span> Xxx
</a></li>
<li><a href="cikis.php?logout=true"><span class="glyphicon glyphicon-log-out"></span> Çıkış yapın</a></li>
</ul>
</li>
</ul>
</div><!--/.nav-collapse -->
</div>
</nav>
<div class="clearfix"></div>
<div class="container-fluid" style="margin-top:80px;">
<div class="container">
<label class="h5">Hoşgeldin : <?php print($userRow['kullanici_adi']); ?></label>
<hr />
<h4>
<a href="anasayfa.php"><span class="glyphicon glyphicon-home"></span> Anasayfa</a>
<a href="#"><span class="glyphicon glyphicon-user"></span> Xxx</a></h4>
<hr />
<meta charset="utf-8">
<pre>
<div class="form">
<p>Öğrenci numaranız</p>
<input class="form-control" type="text" name="??" value="<?php echo $??['??']; ?>">
<p>Öğrenci Şifreniz</p>
<input class="form-control" type="text" name="??" value="<?php echo $??['??']; ?>">
</div>
<button type="submit" name="save" class="btn btn-success">Bilgilerimi Kaydet</button>
</pre>
<pre>
içerik
</pre>
<p class="blockquote-reverse" style="margin-top:200px;">Mikoc<br />
<a href="#">xxx</a>
</p>
</div>
</div>
<script src="bootstrap/js/bootstrap.min.js"></script>
</body>
</html>class.user.php
<?php
require_once('dbconfig.php');
class USER
{
private $conn;
public function __construct()
{
$database = new Database();
$db = $database->dbConnection();
$this->conn = $db;
}
public function runQuery($sql)
{
$stmt = $this->conn->prepare($sql);
return $stmt;
}
public function register($uname,$umail,$upass)
{
try
{
$new_password = password_hash($upass, PASSWORD_DEFAULT);
$stmt = $this->conn->prepare("INSERT INTO users(kullanici_adi,kullanici_mail,kullanici_sifre)
VALUES(:uname, :umail, :upass)");
$stmt->bindparam(":uname", $uname);
$stmt->bindparam(":umail", $umail);
$stmt->bindparam(":upass", $new_password);
$stmt->execute();
return $stmt;
}
catch(PDOException $e)
{
echo $e->getMessage();
}
}
public function doLogin($uname,$umail,$upass)
{
try
{
$stmt = $this->conn->prepare("SELECT user_id, kullanici_adi, kullanici_mail, kullanici_sifre FROM users WHERE kullanici_adi=:uname OR kullanici_mail=:umail ");
$stmt->execute(array(':uname'=>$uname, ':umail'=>$umail));
$userRow=$stmt->fetch(PDO::FETCH_ASSOC);
if($stmt->rowCount() == 1)
{
if(password_verify($upass, $userRow['kullanici_sifre']))
{
$_SESSION['user_session'] = $userRow['user_id'];
return true;
}
else
{
return false;
}
}
}
catch(PDOException $e)
{
echo $e->getMessage();
}
}
public function is_loggedin()
{
if(isset($_SESSION['user_session']))
{
return true;
}
}
public function redirect($url)
{
header("Location: $url");
}
public function doLogout()
{
session_destroy();
unset($_SESSION['user_session']);
return true;
}
}
?>(lazım olucaksa)kayit-ol.php
<?php
session_start();
require_once('class.user.php');
$user = new USER();
if($user->is_loggedin()!="")
{
$user->redirect('anasayfa.php');
}
if(isset($_POST['btn-signup']))
{
$uname = strip_tags($_POST['txt_uname']);
$umail = strip_tags($_POST['txt_umail']);
$upass = strip_tags($_POST['txt_upass']);
if($uname=="") {
$error[] = "Kullanıcı adınızı girin";
}
else if($umail=="") {
$error[] = "Mail adresinizi girin";
}
else if(!filter_var($umail, FILTER_VALIDATE_EMAIL)) {
$error[] = 'Geçerli bir mail adresi girin';
}
else if($upass=="") {
$error[] = "Şifrenizi girin";
}
else if(strlen($upass) < 6){
$error[] = "Şifreniz en az 6 karakterden oluşmalıdır";
}
else
{
try
{
$stmt = $user->runQuery("SELECT kullanici_adi, kullanici_mail FROM users WHERE kullanici_adi=:uname OR kullanici_mail=:umail");
$stmt->execute(array(':uname'=>$uname, ':umail'=>$umail));
$row=$stmt->fetch(PDO::FETCH_ASSOC);
if($row['kullanici_adi']==$uname) {
$error[] = "Kullanıcı adı zaten alınmış";
}
else if($row['kullanici_mail']==$umail) {
$error[] = "Bu epostaya kayıtlı bir hesap zaten vardır, şifrenizi unuttuysanz iletişim sayfamızdan bilginizle birlikte bildirimde bulununuz";
}
else
{
if($user->register($uname,$umail,$upass)){
$user->redirect('kayit-ol.php?joined');
}
}
}
catch(PDOException $e)
{
echo $e->getMessage();
}
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Hoşgeldin misafir :-)</title>
<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" media="screen">
<link href="bootstrap/css/bootstrap-theme.min.css" rel="stylesheet" media="screen">
<link rel="stylesheet" href="style.css" type="text/css" />
</head>
<body>
<div class="container"><br>
<div class="container">
<form method="post" class="form-signin">
<h2 class="form-signin-heading">Kayıt olun</h2><hr/>
<?php
if(isset($error))
{
foreach($error as $error)
{
?>
<div class="alert alert-danger">
<i class="glyphicon glyphicon-warning-sign"></i> <?php echo $error; ?>
</div>
<?php
}
}
else if(isset($_GET['joined']))
{
?>
<div class="alert alert-info">
<i class="glyphicon glyphicon-log-in"></i> Başarıyla kayıt oldunuz <a href='index.php'>Giriş</a> yapabilirsiniz
</div>
<?php
}
?>
<div class="form-group">
<input type="text" class="form-control" name="txt_uname" placeholder="Kullanıcı adınız" value="<?php if(isset($error)){echo $uname;}?>" />
</div>
<div class="form-group">
<input type="text" class="form-control" name="txt_umail" placeholder="Mail adresiniz" value="<?php if(isset($error)){echo $umail;}?>" />
</div>
<div class="form-group">
<input type="password" class="form-control" name="txt_upass" placeholder="Şifreniz" />
</div>
<div class="clearfix"></div><hr />
<div class="form-group">
<button type="submit" class="btn btn-primary" name="btn-signup">
<i class="glyphicon glyphicon-open-file"></i> KAYIT OL
</button>
</div>
<br />
<label>Hesabınız varsa<a href="index.php"> giriş yapın</a></label>
</form>
</div>
</div>
</div>
</body>
</html>anasayfa.php deki bu
ogrencı no ve sıfreyı veritabannda
buraya yazmak ve guncellemek cn anasayfa php deki kodlar nasl yazmalııyız, baya ugastım üstesinden gelemedim yardımcı olabılen olursa cok sevınırım arkadaslar