<?php
$serverName = "YourServername"; //serverName\instanceName
// Since UID and PWD are not specified in the $connectionInfo array,
// The connection will be attempted using Windows Authentication.
$connectionInfo = array( "Database"=>"Account", "UID"=>"Username", "PWD"=>"Password"); //<<<--- Add your username and password to database
$conn = sqlsrv_connect( $serverName, $connectionInfo);
//This will verify i'm getting a connection with sqlsrv to mssql server uncomment to use <<<---- can use this to verify a connection to database.
//if( $conn ) {
// echo "Connection established.<br />";
//}else{
// echo "Connection could not be established.<br />";
// die( print_r( sqlsrv_errors(), true));
//}
$name = $_POST['name'];
$pass = $_POST['password'];
$pass2 = $_POST['password2'];
$email = $_POST['email'];
$str_len1 = strlen($name);
$str_len2 = strlen($pass);
$str_len3 = strlen($email);
if ($str_len1 <= 0){
echo "<center><font color=red size=2> Please enter your Username! </font></center>";
exit();}
if ($str_len2 <= 0){
echo "<center><font color=red size=2> Please enter a Password! </font></center>";
exit();}
if ($str_len1 < 4){
echo "<center><font color=red size=2> Username is too small must be greater than 4 characters. </font></center>";
exit();}
if ($str_len2 < 4){
echo "<center><font color=red size=2> Password is too small must be greate than 4 characters </font></center>";
exit();}
if ($pass != $pass2){
echo "<center><font color=red size=2> Passwords do not match! </font></center>";
exit();}
if ($str_len3 < 4){
echo "<center><font color=red size=2> Check your email address! </font></center>";
exit();}
if ($str_len1 > 12){
echo "<center><font color=red size=2> User is too Large </font></center>";
exit();}
if ($str_len2 > 12){
echo "<center><font color=red size=2> Password Too Large </font></center>";
exit();}
if (!preg_match("#^[a-z0-9]+$#i", $name)){
echo "<center><font color=red size=2> They account name already exist! </font></center>";
exit();}
if (!preg_match("#^[a-z0-9]+$#i", $pass)){
echo "<center><font color=red size=2> Password does not Match! </font></center>";
exit();}
$query = "SELECT login FROM dbo.Accounts
WHERE login = '$name'";
$query1 = "SELECT email FROM dbo.Accounts
WHERE email = '$email'";
$result = sqlsrv_query($conn, $query);
$result_ret = sqlsrv_has_rows($result);
$result1 = sqlsrv_query($conn, $query1);
$result_ret1 = sqlsrv_has_rows($result1);
if ($result_ret === FALSE and $result_ret1 === FALSE){
$procedure = "{call DN_REGISTER( ?, ?, ?)}";
$params = array(
array($name, SQLSRV_PARAM_IN),
array($pass, SQLSRV_PARAM_IN),
array($email, SQLSRV_PARAM_IN)
);
$res = sqlsrv_query( $conn, $procedure, $params);
if( !$res ) {
die( print_r( sqlsrv_errors(), true));
}echo "<center><font color=green size=2> Your Account has Been Created</font></center>";
}else
if ($result_ret1 === True){
echo "The Email:<font color='red'><strong><b>$email</b></strong></font> has already been used!";
}else
if ($result_ret === True){
echo "The Username:<font color='red'><strong><b>$name</b></strong></font> has already been taken select another name!";
}else
if($row[0] == "2")
echo "<center><font color=red size=2>Account error</font></center>";
else if ($row[0] == "3")
echo "<center><font color=red size=2> Bad email</font></center>";
?>