here is actiovation .php
<?php include_once('config/db_connect.php');
include_once('config/init.php');
include_once ('functions/functions.php');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>ASK</title>
<script type="text/javascript">
WebFontConfig = {
google: { families: [ 'PT+Sans:400,700:latin' ] }
};
(function() {
var wf = document.createElement('script');
wf.src = ('https:' == document.location.protocol ? 'https' : 'http') +
'://ajax.googleapis.com/ajax/libs/webfont/1/webfont.js';
wf.type = 'text/javascript';
wf.async = 'true';
var s = document.getElementsByTagName('script')[0];
s.parentNode.insertBefore(wf, s);
})(); </script>
<link href='http://fonts.googleapis.com/css?family=PT+Sans:400,700' rel='stylesheet' type='text/css'>
<!-- MAIN STYLE -->
<link rel="stylesheet" href="assets/css/style.css">
<!-- BOOTSTRAP STYLE http://twitter.github.com/bootstrap/ -->
<link rel="stylesheet" href="assets/css/bootstrap.css" media="screen">
<!-- BOOTSTRAP MODAL EXTEND https://github.com/jschr/bootstrap-modal/ -->
<link rel="stylesheet" href="assets/css/bootstrap-modal.css" media="screen" />
<!-- JQUERY -->
<script type="text/javascript" src="assets/js/jquery-1.9.1.min.js"></script>
<!-- REGISTER JS -->
<script type="text/javascript" src="assets/js/register.js"></script>
<!-- BOOTSTRAP JS, ADDONS & CUSTOM -->
<script type="text/javascript" src="assets/js/script.js"></script>
<script type="text/javascript" src="assets/js/bootstrap.min.js"></script>
</head>
<body>
<?php include_once('template/topNav.php'); ?>
<!-- BEGIN MAIN CONTAINER -->
<div id="mainContainer" class="container">
<?php include_once('template/mainHeader.php'); ?>
<div class="row" id="activateBody">
<!-- <img src="assets/img/signup-right.png" /> -->
Dit is de activerings pagina....
<?php
if (isset($_GET['emailcode']))
{
$emailcode = strip_tags(trim($_GET['emailcode']));
//Check if only numbers and letters
if (!preg_match("/^[a-zA-Z0-9]+$/", $emailcode)){
echo $emailcode;
$errors[] = 'De door jou opgegeven email code klopt niet';
}
else {
$sql = "SELECT * FROM users WHERE emailcode='$emailcode' LIMIT 1";
$query = mysqli_query($db_connect, $sql);
//Tellen hoeveel rijen er gevonden zijn 0 of 1
$code_check = mysqli_num_rows($query);
if ($code_check == 1) {
echo 'exists';
}
}
}
?>
</div>
</div>
<?php include_once('template/footer.php'); ?>
<!-- END MAIN CONTAINER -->
</body>
</html>
ans here is functions
<?phpfunction activateUser($emailcode) {
$sql = "SELECT * FROM users WHERE emailcode='$emailcode' LIMIT 1";
$query = mysqli_query($db_connect, $sql);
//Tellen hoeveel rijen er gevonden zijn 0 of 1
$code_check = mysqli_num_rows($query);
if ($code_check == 1) {
echo 'exists';
}
}
?>
but please refer back to origial post because now i have put the code in activation to test.. but i want this in functions..