 |
|
if(isset($_POST['sLogin'])){
$email = $_POST['email'];
$pwd = MD5($_POST['pwd']);
$sql ="select * from members where email = '$email' AND password ='$pwd'";
$result =mysqli_query($conn,$sql);
$data =mysqli_fetch_array($result);
if($email==$data['email']&&$pwd==$data['password']){
$_SESSION['mID']=$data['memberid'];
$_SESSION['uSer']=$data['username'];
echo"<script>
window.location='account.php';
</script>";
}else
{
echo"<script>
alert('email หรือ password ไม่ถูกต้อง');
window.location='index.php';
</script>";
}
}
?>
<div class="col-sm-1">
<h2 class="or">OR</h2>
</div>
<div class="col-sm-4">
<div class="signup-form"><!--sign up form-->
<h2>New User Signup!</h2>
<form name="form2"action="" method="post">
<input type="text" name="txtName" placeholder="Name" required="" />
<input type="email" name="txtEmail" placeholder="Email Address" required="" />
<input type="password" name="txtPwd" placeholder="Password" required="" />
<button type="submit" name="SignUp" class="btn btn-default">Signup</button>
</form>
</div>
<!--/sign up form-->
</div>
</div>
</div>
<!--ตรวจสอบว่ากดปุ่มสมัครหรือกดปุ่มล็อกอินแล้วค่อยทำงาน-->
<?php
if(isset($_POST['SignUp'])){
$spass =MD5($_POST['txtPwd']);
$sname=$_POST['txtName'];
$smail=$_POST['txtEmail'];
$datenow = date('Y-m-d H:i:s');
$sql2 ="insert into members values('','','$spass','$smail','','2','$sname','','','',CURRENT_TIMESTAMP)";
$result2 =mysqli_query($conn,$sql2);
$sql3 ="select * from members where email = '$smail' AND password ='$spass'";
$result3 =mysqli_query($conn,$sql3);
$data3 =mysqli_fetch_array($result3);
if($smail==$data3['email']&&$spass==$data3['password']){
$_SESSION['mID']=$data3['memberid'];
$_SESSION['uSer']=$data3['username'];
echo"<script>
alert('ยินดีต้อนรับเข้าสู่เว็บไซต์');
window.location='index.php';
</script>";
}
}
?>
if(isset($_POST['sLogin'])){
$email = $_POST['email'];
$pwd = MD5($_POST['pwd']);
$sql ="select * from members where email = '$email' AND password ='$pwd'";
$result =mysqli_query($conn,$sql);
$data =mysqli_fetch_array($result);
if($email==$data['email']&&$pwd==$data['password']){
$_SESSION['mID']=$data['memberid'];
$_SESSION['uSer']=$data['username'];
echo"<script>
window.location='account.php';
</script>";
}else
{
echo"<script>
alert('email หรือ password ไม่ถูกต้อง');
window.location='index.php';
</script>";
}
}
?>
<div class="col-sm-1">
<h2 class="or">OR</h2>
</div>
<div class="col-sm-4">
<div class="signup-form"><!--sign up form-->
<h2>New User Signup!</h2>
<form name="form2"action="" method="post">
<input type="text" name="txtName" placeholder="Name" required="" />
<input type="email" name="txtEmail" placeholder="Email Address" required="" />
<input type="password" name="txtPwd" placeholder="Password" required="" />
<button type="submit" name="SignUp" class="btn btn-default">Signup</button>
</form>
</div>
<!--/sign up form-->
</div>
</div>
</div>
<!--ตรวจสอบว่ากดปุ่มสมัครหรือกดปุ่มล็อกอินแล้วค่อยทำงาน-->
<?php
if(isset($_POST['SignUp'])){
$spass =MD5($_POST['txtPwd']);
$sname=$_POST['txtName'];
$smail=$_POST['txtEmail'];
$datenow = date('Y-m-d H:i:s');
$sql2 ="insert into members values('','','$spass','$smail','','2','$sname','','','',CURRENT_TIMESTAMP)";
$result2 =mysqli_query($conn,$sql2);
$sql3 ="select * from members where email = '$smail' AND password ='$spass'";
$result3 =mysqli_query($conn,$sql3);
$data3 =mysqli_fetch_array($result3);
if($smail==$data3['email']&&$spass==$data3['password']){
$_SESSION['mID']=$data3['memberid'];
$_SESSION['uSer']=$data3['username'];
echo"<script>
alert('ยินดีต้อนรับเข้าสู่เว็บไซต์');
window.location='index.php';
</script>";
}
}
?>
โค้ดผมไปเอาใน github มาเพื่อจะศึกษาต่อ ใช้ xampp เป็น Server
Tag : PHP, XAMPP
|
|
|
 |
 |
 |
 |
| Date :
2020-02-17 21:43:53 |
By :
jupjaija |
View :
659 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
