Form Login dan Daftar menggunakan PHP dan MySQL dengan validasi

Form Login dan Daftar menggunakan PHP dan MySQL dengan validasi

Form Login dan Daftar menggunakan PHP dan MySQL dengan validasi

Form Login dan Daftar menggunakan PHP dan MySQL dengan validasi, Masuk, Daftar, dan Keluar sekarang umum untuk aplikasi web apa pun. Karena tanpa login kita tidak bisa melacak data siapa yang menggunakan aplikasi kita.

Dalam contoh ini kita akan membahas cara membuat form login dan signup menggunakan database PHP dan MySQL.

Untuk semua jenis login aplikasi web, pendaftaran adalah hal terpenting untuk alasan keamanan. Jika kami tidak memiliki fitur login di aplikasi web kami, maka siapa pun dapat mengakses data dan layanan kami.

Di sini, di contoh formulir login dan pendaftaran ini kami menggunakan 5 file ini adalah:

Langkah langkah membuat form login dan daftar dengan php mysql

File SQL: Untuk membuat tabel

database.php: Untuk menghubungkan database

register.php: Untuk mendapatkan nilai dari pengguna

register_a.php: File PHP yang memproses permintaan pendaftaran

login.php: untuk mendapatkan nilai dari pengguna

loginProcess.php: Untuk proses login untuk mengecek user yang valid atau tidak

home.php: untuk halaman selamat datang setelah login

logout.php: Untuk logout dari aplikasi

Langkah 1: Buat tabel di atas

Langkah 2: buat semua file lain yang disebutkan di atas.

Langkah 3: Buat folder unggahan untuk menyimpan file gambar.

Kemudian buka browser Anda dan masukkan url localhost / login /

File Sql

CREATE TABLE `register` (

`ID` int(10) NOT NULL,

`First_Name` varchar(100) NOT NULL,

`Last_Name` varchar(100) NOT NULL,

`Email` varchar(100) NOT NULL,

`Password` int(100) NOT NULL,

`File` varchar(100) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 

Baca Juga  Cara menampilkan Data Dari MySQL Menggunakan PHP

database.php

<?php

$url='localhost';

$username='root';

$password='';

$conn=mysqli_connect($url,$username,$password,"fregister");

if(!$conn){

die('Could not Connect My Sql:' .mysql_error());

}

?>

 

register.php

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8">

<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:400,700">

<title>Welcome to Finance Portal</title>

<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">

<link rel="stylesheet" href="assests/css/style.css">

<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>

<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js"></script>

<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>

</head>

<body>

<div class="signup-form">

<form action="register_a.php" method="post" enctype="multipart/form-data">

<h2>Register</h2>

<p class="hint-text">Create your account</p>

<div class="form-group">

<div class="row">

<div class="col"><input type="text" class="form-control" name="first_name" placeholder="First Name" required="required"></div>

<div class="col"><input type="text" class="form-control" name="last_name" placeholder="Last Name" required="required"></div>

</div>

</div>

<div class="form-group">

<input type="email" class="form-control" name="email" placeholder="Email" required="required">

</div>

<div class="form-group">

<input type="password" class="form-control" name="pass" placeholder="Password" required="required">

</div>

<div class="form-group">

<input type="password" class="form-control" name="cpass" placeholder="Confirm Password" required="required">

</div>

<div class="form-group">

<input type="file" name="file" required>

<!-- <input type="submit" name="upload" value="Upload" class="btn"> -->

</div>

<div class="form-group">

<label class="form-check-label"><input type="checkbox" required="required"> I accept the <a href="#">Terms of Use</a> & <a href="#">Privacy Policy</a></label>

</div>

<div class="form-group">

<button type="submit" name="save" class="btn btn-success btn-lg btn-block">Register Now</button>

</div>

<div class="text-center">Already have an account? <a href="login.php">Sign in</a></div>

</form>




</div>

</body>

</html>

 

register_a.php

<?php

extract($_POST);

include("database.php");

$sql=mysqli_query($conn,"SELECT * FROM register where Email='$email'");

if(mysqli_num_rows($sql)>0)

{

echo "Email Id Already Exists";

exit;

}

else(isset($_POST['save']))

{

$file = rand(1000,100000)."-".$_FILES['file']['name'];

$file_loc = $_FILES['file']['tmp_name'];

$folder="upload/";

$new_file_name = strtolower($file);

$final_file=str_replace(' ','-',$new_file_name);

if(move_uploaded_file($file_loc,$folder.$final_file))

{

$query="INSERT INTO register(First_Name, Last_Name, Email, Password, File ) VALUES ('$first_name', '$last_name', '$email', 'md5($pass)', '$final_file')";

$sql=mysqli_query($conn,$query)or die("Could Not Perform the Query");

header ("Location: login.php?status=success");

}

else

{

echo "Error.Please try again";

}

}

?>

 

login.php

<?php

session_start();

?>

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8">

<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:400,700">

<title>Welcome to Finance Portal</title>

<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">

<link rel="stylesheet" href="assests/css/style.css">

<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>

<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js"></script>

<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>

</head>

<body>

<div class="signup-form">

<form action="loginProcess.php" method="post" enctype="multipart/form-data">

<h2>Login</h2>

<p class="hint-text">Enter Login Details</p>

<div class="form-group">

<input type="email" class="form-control" name="email" placeholder="Email" required="required">

</div>

<div class="form-group">

<input type="password" class="form-control" name="pass" placeholder="Password" required="required">

</div>

<div class="form-group">

<button type="submit" name="save" class="btn btn-success btn-lg btn-block">Login</button>

</div>

<div class="text-center">Don't have an account? <a href="register.php">Register Here</a></div>

</form>

</div>

</body>

</html>

 

loginProcess.php

<?php

session_start();

if(isset($_POST['save']))

{

extract($_POST);

include 'database.php';

$sql=mysqli_query($conn,"SELECT * FROM register where Email='$email' and Password='md5($pass)'");

$row = mysqli_fetch_array($sql);

if(is_array($row))

{

$_SESSION["ID"] = $row['ID'];

$_SESSION["Email"]=$row['Email'];

$_SESSION["First_Name"]=$row['First_Name'];

$_SESSION["Last_Name"]=$row['Last_Name'];

header("Location: home.php");

}

else

{

echo "Invalid Email ID/Password";

}

}

?>

 

home.php

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8">

<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:400,700">

<title>Welcome to Finance Portal</title>

<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">

<link rel="stylesheet" href="assests/css/style.css">

<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>

<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js"></script>

<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>

</head>

<body>

<div class="signup-form">

<form action="home.php" method="post" enctype="multipart/form-data">

<h2>Welcome</h2>

<br>

<?php

session_start();

include 'database.php';

$ID= $_SESSION["ID"];

$sql=mysqli_query($conn,"SELECT * FROM register where ID='$ID' ");

$row = mysqli_fetch_array($sql);

?>




<img src="upload/<?php echo $row['File'] ?>" height="150" width="150" style="border-radius:50%;display:block;margin-left:auto;margin-right:auto;" />

<p class="hint-text"><br><b>Welcome </b><?php echo $_SESSION["First_Name"] ?> <?php echo $_SESSION["Last_Name"] ?></p>

<div class="text-center">Want to Leave the Page? <br><a href="logout.php">Logout</a></div>

</form>




</div>

</body>

</html>

 

Baca Juga  Belajar Microsoft Excel: Penerapan Rumus If Pada Excel

logout.php

<?php

session_start();

unset($_SESSION["id"]);

unset($_SESSION["name"]);

header("Location:login.php");

?>

 

 

Tinggalkan Komentar

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *

Need Help? Chat with us