Skip to content

Instantly share code, notes, and snippets.

@ammarfaizi2

ammarfaizi2/register.php

Created October 29, 2018 05:50
Show Gist options
  • Save ammarfaizi2/583868b928cc514b42a04c031ff7e377 to your computer and use it in GitHub Desktop.
Save ammarfaizi2/583868b928cc514b42a04c031ff7e377 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
register.php
<?php
require_once("config2.php");
if(isset($_POST['Register'])){
// filter data yang diinputkan
$cnama = filter_input(INPUT_POST, 'cnama', FILTER_SANITIZE_STRING);
$cuser = filter_input(INPUT_POST, 'cuser', FILTER_SANITIZE_STRING);
// enkripsi password
$cpass = md5($_POST["cpass"]);
$cemail = filter_input(INPUT_POST, 'cemail', FILTER_VALIDATE_EMAIL);
$ctlp = filter_input(INPUT_POST, 'ctlp', FILTER_SANITIZE_STRING);
$calamat = filter_input(INPUT_POST, 'calamat', FILTER_SANITIZE_STRING);
$cbank = filter_input(INPUT_POST, 'cbank', FILTER_SANITIZE_STRING);
$cnamarek = filter_input(INPUT_POST, 'cnamarek', FILTER_SANITIZE_STRING);
$cnorek = filter_input(INPUT_POST, 'cnorek', FILTER_SANITIZE_STRING);
$cdate = date('Y-m-d H:i:s');
//memeriksa username dan email
//
// We need to use PDO instead of mysqli because the DB connector is using PDO.
//
// $sql_u = "SELECT * FROM customer WHERE cuser='$cuser'";
// $sql_e = "SELECT * FROM customer WHERE cemail='$cemail'";
// $res_u = mysqli_query($db, $sql_u);
// $res_e = mysqli_query($db, $sql_e);
$stmt = $db->prepare("SELECT `cemail` FROM `customer` WHERE `cemail` LIKE :cemail LIMIT 1;");
$stmt->execute([":cemail" => $cemail]);
if ($stmt->fetch(PDO::FETCH_NUM)) {
?><!DOCTYPE html>
<html>
<head><title></title><script type="text/javascript">alert(
"Email <?php print $cemail; ?> has already been registered in database, please use another email!"
);window.location = "?";
</script></head><body></body></html><?php
exit;
}
$stmt = $db->prepare("SELECT `cuser` FROM `customer` WHERE `cuser` LIKE :cuser LIMIT 1;");
$stmt->execute([":cuser" => $cuser]);
if ($stmt->fetch(PDO::FETCH_NUM)) {
?><!DOCTYPE html>
<html>
<head><title></title><script type="text/javascript">alert(
"Username <?php print $cuser; ?> has already been registered in database, please use another username!"
);window.location = "?";
</script></head><body></body></html><?php
exit;
}
//
// if (mysqli_num_rows($res_u) > 0) {
// $name_error = "Sorry... username already taken";
// }else if(mysqli_num_rows($res_e) > 0){
// $email_error = "Sorry... email already taken";
// }else{
$sql = "INSERT INTO customer (cnama, cuser, cemail, cpass, ctlp, calamat, cbank, cnamarek, cnorek, cstatus, cterbaca, cdeposit, cdepositsbo, cdepositibc, cdeposithorey, cdeposittangkas, cdate)
VALUES (:cnama, :cuser, :cemail, :cpass, :ctlp, :calamat, :cbank, :cnamarek, :cnorek, :cstatus, :cterbaca, :cdeposit, :cdepositsbo, :cdepositibc, :cdeposithorey, :cdeposittangkas, :cdate)";
$stmt = $db->prepare($sql);
// bind parameter ke query
$params = array(
":cnama" => $cnama,
":cuser" => $cuser,
":cpass" => $cpass,
":cemail" => $cemail,
":ctlp" => $ctlp,
":calamat" => $calamat,
":cbank" => $cbank,
":cnamarek" => $cnamarek,
":cdeposit" => 0,
":cdepositsbo" => 0,
":cdepositibc" => 0,
":cdeposithorey" => 0,
":cdeposittangkas" => 0,
":cstatus" => 1,
":cterbaca" => 1,
":cdate" => $cdate,
":cnorek" => $cnorek
);
// eksekusi query untuk menyimpan ke database
$saved = $stmt->execute($params);
// jika query simpan berhasil, maka user sudah terdaftar
// maka alihkan ke halaman index
if($saved) header("Location: index.php");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<!-- Required meta tags-->
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="Colorlib Templates">
<meta name="author" content="Colorlib">
<meta name="keywords" content="Colorlib Templates">
<!-- Title Page-->
<title>SDSB Register</title>
<!-- Icons font CSS-->
<link href="vendor/mdi-font/css/material-design-iconic-font.min.css" rel="stylesheet" media="all">
<link href="vendor/font-awesome-4.7/css/font-awesome.min.css" rel="stylesheet" media="all">
<!-- Font special for pages-->
<link href="https://fonts.googleapis.com/css?family=Poppins:100,100i,200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">
<!-- Vendor CSS-->
<link href="vendor/select2/select2.min.css" rel="stylesheet" media="all">
<link href="vendor/datepicker/daterangepicker.css" rel="stylesheet" media="all">
<!-- Main CSS-->
<link href="css/main.css" rel="stylesheet" media="all">
</head>
<body>
<div class="page-wrapper bg-gra-01 p-t-180 p-b-100 font-poppins">
<div class="wrapper wrapper--w780">
<div class="card card-3">
<div class="card-heading"></div>
<div class="card-body">
<h2 class="title">SDSB Registration</h2>
<form method="POST">
<div class="input-group">
<label for="cnama">Nama Lengkap</label>
<input class="input--style-3" type="text" name="cnama" placeholder="Nama" />
</div>
<div class="input-group">
<div <?php if (isset($name_error)): ?> class="form_error" <?php endif ?> >
<label for="cuser">Username</label>
<input class="input--style-3" type="text" name="cuser" placeholder="Username" />
<?php if (isset($name_error)): ?>
<span><?php echo $name_error; ?></span>
<?php endif ?>
</div>
<div class="input-group">
<div <?php if (isset($email_error)): ?> class="form_error" <?php endif ?> >
<label for="cemail">Email</label>
<input class="input--style-3" type="email" name="cemail" placeholder="Alamat Email" />
<?php if (isset($email_error)): ?>
<span><?php echo $email_error; ?></span>
<?php endif ?>
</div>
<div class="input-group">
<label for="cpass">Password</label>
<input class="input--style-3" type="password" name="cpass" placeholder="Password" />
</div>
<div class="input-group">
<label for="ctlp">Telepon</label>
<input class="input--style-3" type="tel" name="ctlp" placeholder="Nomor Telepon" />
</div>
<div class="input-group">
<label for="calamat">Alamat</label>
<input class="input--style-3" type="text" name="calamat" placeholder="Alamat" />
</div>
<div class="input-group">
<label for="cbank">Bank</label>
<input class="input--style-3" type="text" name="cbank" placeholder="Bank" />
</div>
<div class="input-group">
<label for="cnamrek">Nama Rekening</label>
<input class="input--style-3" type="text" name="cnamarek" placeholder="Nama Rekening" />
</div>
<div class="input-group">
<label for="cnorek">No Rekening</label>
<input class="input--style-3" type="number" name="cnorek" placeholder="No Rekening" />
</div>
<br>
<br>
<input type="submit" class="btn btn--pill btn--green" name="Register" value="Daftar" />
</form>
</div>
</div>
</div>
</div>
<!-- Jquery JS-->
<script src="vendor/jquery/jquery.min.js"></script>
<!-- Vendor JS-->
<script src="vendor/select2/select2.min.js"></script>
<script src="vendor/datepicker/moment.min.js"></script>
<script src="vendor/datepicker/daterangepicker.js"></script>
<!-- Main JS-->
<script src="js/global.js"></script>
</body><!-- This templates was made by Colorlib (https://colorlib.com) -->
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment