Skip to content

Instantly share code, notes, and snippets.

View jankensword's full-sized avatar

jankensword

View GitHub Profile
@jankensword
jankensword / logout.php
Created October 21, 2015 11:28
Halaman Keluar
<?php
// logout.php
session_start();
unset($_SESSION['NAMA_USER']);
unset($_SESSION['PASSWORD_USER']);
session_destroy();
?>
<!DOCTYPE html>
<html lang="en-US">
@jankensword
jankensword / index.php
Created October 21, 2015 11:24
Halaman Utama
<!DOCTYPE html>
<html lang="en-US">
<head>
<meta charset="utf-8">
<title>INDEX</title>
<style type="text/css">
div
{
text-align: center;
font-size: 180%;
@jankensword
jankensword / proses_login.php
Created October 21, 2015 11:19
File Otentikasi Login
<!-- proses_login.php -->
<?php
@session_start();
//Membuat Koneksi Database dan Menampung Query
include"oraconn.php";
$username = $_POST['NAMA_USER'];
$password = $_POST['PASSWORD_USER'];
$query = "SELECT * FROM TB_USER WHERE NAMA_USER = :nu_pl AND PASSWORD_USER = :pw_pl";
$hasil = oci_parse($c, $query);
@jankensword
jankensword / latihan_login.php
Created October 20, 2015 16:26
Halaman Login (Login Page)
<?php
@session_start();
unset($_SESSION['NAMA_USER']);
if(isset($_SESSION['NAMA_USER']))
{
header("location:index.php");
}
?>
<!DOCTYPE html>
<html lang="en-US">
@jankensword
jankensword / oraconn.php
Created October 20, 2015 16:17
File untuk memeriksa koneksi dengan database beserta user dan password untuk mengakses tabel
<?php
$username = "simple";
$password = "transaction";
$dbname = "localhost/XE";
$c = oci_connect($username, $password, $dbname);
if(!$c){
echo "Gagal tersambung dengan Database";
}
?>
@jankensword
jankensword / create-tb_user.sql
Last active October 20, 2015 16:15
SQL Syntax untuk membuat Tabel TB_USER
CREATE TABLE TB_USER(ID_USER NOT NULL VARCHAR2(5), NAMA_USER VARCHAR2(25),
COMPANY_USER VARCHAR2(15), CHANNEL_USER VARCHAR2(15), LEVEL_USER VARCHAR2(15),
PASSWORD_USER VARCHAR2(15), CONSTRAINT pk_user PRIMARY KEY(ID_USER));