Register Form

<?php
if(isset($_GET['email']) && isset($_GET['key'])) {
	include "database/connection.php";
	$email2 = $_GET['email'];
	$key2 = $_GET['key'];
$kntl = mysql_query("SELECT * FROM users WHERE email='$email2' and kode='$key2'");
if(mysql_num_rows($kntl) > 0) {
	$mmk = mysql_query("UPDATE users SET aktif='y' WHERE email='$email2' and kode='$key2'");
		$confirm = '<div class="text-center">
		<div class="alert bg-success alert-styled-left">
		<button type="button" class="close" data-dismiss="alert"><span>&times;</span>
		<span class="sr-only">Close</span></button>
		<span class="text-semibold">Selamat! Akun anda sudah diaktivasi!</span>
		</div></div>';
	} else {
		$error5 = '<div class="text-center">
		<div class="alert bg-danger alert-styled-left">
		<button type="button" class="close" data-dismiss="alert"><span>&times;</span>
		<span class="sr-only">Close</span></button>
		<span class="text-semibold">Gagal mengkonfirmasi email! Silahkan menghubungi Admin!</span>
		</div></div>';
	}
}
if(isset($_GET['succes'])) {
	$succes = '<div class="text-center">
		<div class="alert bg-success alert-styled-left">
		<button type="button" class="close" data-dismiss="alert"><span>&times;</span>
		<span class="sr-only">Close</span></button>
		<span class="text-semibold">Silahkan cek e-mail (Inbox/Spam)<br> yang didaftarkan untuk aktivasi<br> pendaftaran!</span>
		</div></div>';
}
//Kode ini digunakan menampilkan error
if(!empty($_GET['error'])) {
	if ($_GET['error'] == 1) {
		$error1 = '<div class="text-center">
		<div class="alert bg-danger alert-styled-left">
		<button type="button" class="close" data-dismiss="alert"><span>&times;</span>
		<span class="sr-only">Close</span></button>
		<span class="text-semibold">Username atau Email sudah terdaftar!</span>
		</div></div>';
	} else if ($_GET['error'] == 2) {
		$error2 = '<div class="text-center">
		<div class="alert bg-danger alert-styled-left">
		<button type="button" class="close" data-dismiss="alert"><span>&times;</span>
		<span class="sr-only">Close</span></button>
		<span class="text-semibold">Username kosong!</span>
		</div></div>';
	} else if ($_GET['error'] == 3) {
		$error3 = '<div class="text-center">
		<div class="alert bg-danger alert-styled-left">
		<button type="button" class="close" data-dismiss="alert"><span>&times;</span>
		<span class="sr-only">Close</span></button>
		<span class="text-semibold">Password kosong!</span>
		</div></div>';
	} else if ($_GET['error'] == 4) {
		$error4 = '<div class="text-center">
		<div class="alert bg-danger alert-styled-left">
		<button type="button" class="close" data-dismiss="alert"><span>&times;</span>
		<span class="sr-only">Close</span></button>
		<span class="text-semibold">Harus diisi dengan benar</span>
		</div></div>';
	}
}
$tanggal = gmdate("d-m-y H:i:s", time()+60*60*7);
require_once('database/connection.php');
$username2 = $_POST['username'];
if (isset($_POST['submit'])) {
	$username = $_POST['username'];
	$email = $_POST['email'];
	$password = $_POST['password'];
	$twitter = $_POST['twitter'];

$kntl2 = mysql_query("SELECT * FROM users WHERE email='$email' or username='$username'");
if(mysql_num_rows($kntl2) > 0) {
	header('location:register.php?error=1');
} else {
	$activation = md5(uniqid(rand(), true));
	$result = mysql_query("INSERT into users(username, email, password, kode, twitter, created) values('$username','$email','$password','$activation','$twitter','$tanggal')");
	$messages = "Halo $username, \nTerima kasih telah mendaftar akun anda di SocMed Market \n\nBerikut ini adalah detail akun yang anda daftarkan \nUsername : $username \nPassword : $password \nUntuk aktivasi akun anda, silahkan klik link konfirmasi berikut : $link/register.php?email=".$email."&key=".$activation;
	mail($email, 'Aktivasi Akun SocMed Market',$pesan,'From: admin@socmedmarket.com');
	header('location:register.php?succes=aktivasinya');
}

}
?>