Created
December 19, 2021 13:51
-
-
Save erowsika/80f0c16b9683280c2a36bd90db056619 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
// file connection.php | |
$con = mysqli_connect("localhost", "username", "password", "dbname"); | |
// file login.php | |
require_once(__DIR__ . '/connection.php'); | |
session_start(); | |
// mysqli_real_escape_string prevent sql injection (security) | |
$user = mysqli_real_escape_string($con, $_POST['username']); | |
$pass = mysqli_real_escape_string($con, $_POST['password']); | |
//convert password to md5 | |
$pass = md5($pass); | |
// check if the user id and password combination exist in database | |
$sql = mysqli_query($con, "SELECT * FROM users WHERE username = '$user' AND password = '$pass'") or die(mysqli_error($con)); | |
//if match is equal to 1 there is a match | |
if (mysqli_num_rows($sql) === 1) { | |
$user = mysqli_fetch_array($sql); | |
//set session | |
$_SESSION['authorized'] = true; | |
$_SESSION['id_user'] = $user['id_user']; // id user for relathionship only data | |
$_SESSION['username'] = $user['username']; // username stored in session global variable | |
// go to arsip this user only | |
$_SESSION['success'] = 'Login Successful'; | |
header('Location: ./arsip.php'); | |
exit; | |
} else { | |
// login failed save error to a session | |
$_SESSION['error'] = 'Sorry, wrong username or password'; | |
exit($_SESSION['error']); // print error message | |
} | |
// file arsip.php | |
require_once(__DIR__ . '/connection.php'); | |
session_start(); | |
// check if user is successfully login | |
if (!isset($_SESSION['id_user'])) die('Unauthorize Access !'); | |
$query_arsip = mysqli_query($con, "SELECT * FROM arsip WHERE id_user = $_SESSION[id_user];"); | |
while ($arsip = mysqli_fetch_array($query_arsip)) | |
{ ?> | |
<p> | |
Nama Berkas : <?php echo $arsip['nama_berkas']; ?><br/> | |
Tanggal Berkas : <?php echo $arsip['tgl_berkas']; ?> | |
</p> | |
<?php | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment