[Help] Register Page Mysql

01/07/2014 10:10 Beb0mn#1

Greetings is been long time since I post here in the community. I was wondering if someone could help me out here, I am trying to edit a web page downloaded from elitepvpers (I searched for it and got a lot of sources but only one is doing what i really want which is a registration that identifies if the username exists or not and anti inject proof, as far as i know this one those the check for existing usernames, dont know about injection.) I have tried all possible ways including google, and even make up commands for mysql php codes and got nothing, the page loads but it wont send the values to the database.

Spoiler

PHP Code:


			
<?php

require_once('recaptchalib.config.php');

require_once('recaptchalib.php');

require_once('db.config.php');



$user_ip = $_SERVER['IP'];

$username = isset($_POST['Username']) ? trim($_POST['Username']) : '';

$password = isset($_POST['Password']) ? trim($_POST['Password']) : '';

$password2 = isset($_POST['Password']) ? trim($_POST['Password']) : '';

$errors = array();

$success = false;



// Process the POST data.

if(isset($_POST) && !empty($_POST)){

    // Validate user name.

    if(empty($username)){

        $errors[] = 'Please provide a user name.';

    }else if(strlen($username) < 3 || strlen($username) > 16){

        $errors[] = 'User name must be between 3 and 16 characters in length.';

    }else if(ctype_alnum($username) === false){

        $errors[] = 'User name must consist of numbers and letters only.';

    }else{

        // Check if username already exists in the database.

        $sql = "SELECT Username FROM 'accounts' WHERE Username = ?";

        $stmt = mysql_query($GLOBALS['dbConn'],$sql);

        $args = array($username);

        if(!mysql_query($stmt,$args)){

            $errors[] = 'Failed to determine if this username already exists in the database.';

        }elseif($row = mysql_query($stmt)){

            $errors[] = 'User name already exists, please choose a different user name.';

        }

    }

    

    // Validate user password.

    if(empty($password)){

        $errors[] = 'Please provide a password.';

    }else if(strlen($password) < 3 || strlen($password) > 16){

        $errors[] = 'Password must be between 3 and 16 characters in length.';

    }else if($password != $password2){

        $errors[] = 'Passwords do not match.';

    }

    

    // Validate reCAPTCHA.  This is to prevent someone botting account creation.

    $response = recaptcha_check_answer($recaptcha_private_key,$_SERVER['REMOTE_ADDR'],$_POST['recaptcha_challenge_field'],$_POST['recaptcha_response_field']);

    if(!$response->is_valid){

        if($response->error == 'incorrect-captcha-sol'){

            $errors['recaptcha'] = 'Incorrect answer to reCAPTCHA';

        }else{

            $errors['recaptcha'] = $response->error;

        }

    }

    

    // Persist the new account to the database if no previous errors occured.

    if(count($errors) == 0){

        $sql = "INSERT INTO 'accounts'

                (Username,Password,IP)

                VALUES (?,?,GETDATE(),0,0,0,0,0,GETDATE(),'N',0,'',?)";

        $stmt = mysql_connect($GLOBALS['dbConn'],$sql);

        $args = array($username,$password,$user_ip);

        if(mysql_connect($stmt,$args)){

            $success = htmlentities("Account {$username} successfully created!");

        }else{

            // This means the insert statement is probably not valid for your database.  Fix the query or fix your database, your choice ;)

            $errors[] = 'Failed to create a new account, please try again later';

        }

    }

}



?>

If anyone please be so kind. db.config.php contains the database connection details, i know the one that needs to be fixed is this .php file to be launched

Thanks in advance.

P.S- Yes i have tried all the search results I get.

01/07/2014 11:27 Gerculy#2

I'm working on a script right now ( PDO ). If you are not in rush I might share it with you.
(Easy to use and secure)

01/07/2014 16:17 turk55#3

Here is one I wrote for [Only registered and activated users can see links. Click Here To Register...]

Spoiler

Code:

<?php

class DBClass {
	public $db;
	
	function __construct() {
		$host = "localhost";
		$db = "ProjectX_Auth_DB";
		
		try{ 
			$this->db = new PDO("sqlsrv:Server=".$host.";Database=".$db);  
			$this->db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
		}catch(PDOException $e){
			var_dump($e);
		}	
	}
}

Code:

<?php
error_reporting(E_ALL); 
ini_set('display_errors', '1');

session_start();
require "dbclass.php";
class Register extends DBClass {

	private $username;
	private $password;
	private $passwordRepeat;
	private $useCaptcha = true;
	private $captcha;
	private $accountTable = "DB_Accounts";
	private $returnAddress = "http://insomnius-co.com/register/";
	
	// min length
	private $unLengthMin = 4; // minimum username length
	private $pLengthMin = 4;  // minimum password length
	private $unLengthMax = 16; // maximum username length
	private $pLengthMax = 16;  // maximum password length
	
	function __construct($username, $password, $passwordRepeat, $captcha = "") {
		parent::__construct(); 
		$_SESSION['registerform']['messages'] =  array();
		$this->username = $username;
		$this->password = $password;
		$this->passwordRepeat = $passwordRepeat;
		$this->captcha = $captcha;
		$this->checkFieldRequirements();
	}
	function checkFieldRequirements() {
		$_SESSION['registerform']['messages'] = array();
		$pattern = '^[a-zA-Z0-9]+$^';
		$matches = '';
		preg_match($pattern, $this->username, $matches);
		if(strlen($this->username) < $this->unLengthMin) {
			$_SESSION['registerform']['messages'][] = "The length of the username is too short, please choose another.";
		} 
		else if(strlen($this->username) > $this->unLengthMax) {
			$_SESSION['registerform']['messages'][] = "The length of the username is too long, please choose another.";
		}
		else if(count($matches) == 0) {
			$_SESSION['registerform']['messages'][] = "Invalid characters in username";
		}
		else if($this->username_exists()) {
			$_SESSION['registerform']['messages'][] = "The selected username already exists, please choose another."; 
		}  
		unset($matches);
		preg_match($pattern, $this->password, $matches);
		if(strlen($this->password) < $this->pLengthMin) {
			$_SESSION['registerform']['messages'][] = "The length of the password is too short, please choose another."; 
		}
		else if(strlen($this->password) > $this->pLengthMax) {
			$_SESSION['registerform']['messages'][] = "The length of the password is too long, please choose another.";
		}
		else if($this->password != $this->passwordRepeat) {
			$_SESSION['registerform']['messages'][] = "The passwords do not match one another.";
		}
		else if(count($matches) == 0) {
			$_SESSION['registerform']['messages'][] = "Invalid characters in password";
		} 
		if($this->useCaptcha) {
			if(strtolower($_SESSION['captcha']) != strtolower($this->captcha)) {
				$_SESSION['registerform']['messages'][] = "The captcha is incorrect.";
			}
		}
		if(count($_SESSION['registerform']['messages']) == 0) {
			$this->register();
		}
		header("Location: ".$this->returnAddress); 
	}
	
	function username_exists() {
		$query = $this->db->prepare("SELECT COUNT(*) FROM ".$this->accountTable." WHERE AccountName= ?"); 
		$query->bindValue(1, $this->username);
		
		try{
			$query->execute();
			$rows = $query->fetchColumn();
			if($rows == 1){
				return true; 
			}
			return false;
			
		} catch (PDOException $e){
			die($e->getMessage());
			return false;
		}
	}
	function register() {
		$accountBanned 	= 0;
		$ip 			= $_SERVER['REMOTE_ADDR']; 
		$accountServer 	= 0;
		echo $this->username;
		
		$query 	= $this->db->prepare("INSERT INTO ".$this->accountTable." (AccountName, AccountPassword, AccountBanned, AccountRegIP, AccountLastLoginIP, AccountServer) VALUES (?, ?, ?, ?, ?, ?) ");
		$query->bindValue(1, $this->username);
		$query->bindValue(3, $accountBanned);
		$query->bindValue(2, $this->password);
		$query->bindValue(4, $ip);
		$query->bindValue(5, $ip);
		$query->bindValue(6, $accountServer);
	 
		try{
			$query->execute();
			$_SESSION['registerform']['messages'][] = "Account is successfully registered";
			
		} catch(PDOException $e){
			die($e->getMessage());
		}	
	}
}
new Register($_POST['username'], $_POST['password'], $_POST['passwordRepeat'], $_POST["captcha"]);

01/07/2014 16:27 Beb0mn#4

Gerculy, thanks, Looking forward to see what you came up with. I have no rush.

turk55, I will try it as soon as I get home, is it ok if I PM you if I run into issues?

01/07/2014 16:34 turk55#5

Quote:

Originally Posted by Beb0mn

Gerculy, thanks, Looking forward to see what you came up with. I have no rush.

turk55, I will try it as soon as I get home, is it ok if I PM you if I run into issues?

Sure and I just took a look on your script, at the username check you basically say if I can run the query the username exists. This is not how you should do it.

Code:

}elseif($row = mysql_query($stmt)){ 
            $errors[] = 'User name already exists, please choose a different user name.'; 
        }

Try this instead :

Code:

}elseif($row = mysql_query($stmt)){ 
            if(mysql_num_rows($row) > 0) {
				$errors[] = 'User name already exists, please choose a different user name.'; 
			}
        }

Not to mention you are using a question mark ("?") at the query but you are not filling it in any way plus the question mark is only used at prepared statements (the regular mysql library does not support prepared statements, mysqli does).

$sql = "SELECT Username FROM 'accounts' WHERE Username = ?";
TO:
$sql = "SELECT Username FROM 'accounts' WHERE Username = \"".$username."\"";

01/07/2014 16:41 Gerculy#6

Here's my :) ( Little simpler compared to Insomnius one's )

Config ..

Spoiler

Code:

<?php
If($_SERVER['REQUEST_METHOD'] == "POST") { 
		if (isset($_POST['Password1'],$_POST['Password2']) && $_POST['Password1']!=$_POST['Password2']) {
		echo 'Your password confirmation is not equal to your password';
		} else {
		
       	if (!$_POST['Realname'] || 
			!$_POST['Username'] || 
			!$_POST['Password1'] || 
			!$_POST['Password2'] || 
			!$_POST['Email']|| 
			!$_POST['Country'] || 
			!$_POST['City'] ||
			!$_POST['Recoverypassword'] ) {
            echo "<p>Please supply all of the data!</p>";
           exit;
        } else {
	
            try {        
			$dbh  = new Database();


		$stmt = $dbh->prepare('SELECT * FROM accounts WHERE Username=?');
		$stmt->bindParam(1, $_POST['Username'], PDO::PARAM_INT);
		$stmt->execute();
		$row = $stmt->fetch(PDO::FETCH_ASSOC);

						
			$Realname = "$_POST[Realname]";
			$Realname  = stripslashes_deep($Realname);
			$Username = "$_POST[Username]";
			$Username  = stripslashes_deep($Username);
			$Password1 = "$_POST[Password1]";
			$Password1  = stripslashes_deep($Password1);
			$Password2 = "$_POST[Password2]";
			$Password2  = stripslashes_deep($Password2);
			$Email = "$_POST[Email]";
			$EMail  = stripslashes_deep($Email);
			$Country = "$_POST[Country]";
			$Country  = stripslashes_deep($Country);
			$City = "$_POST[City]";
			$City  = stripslashes_deep($City);
			$Recoverypassword = "$_POST[Recoverypassword]";
			$Recoverypassword  = stripslashes_deep($Recoverypassword);
			$Regdate = date("Y-m-d");    

		
		if( ! $row)
		{
			$dbh  = new Database();		
		$query = $dbh->prepare("insert into accounts (Username,Password,Email,Country,City,secretquestion,realname,Regdate)
		values (:Username,:Password,:Email,:Country,:City,:secretquestion,:realname,:Regdate)");
		$data = array(
		':Username' => "$Username",
		':Password' => "$Password1",
		':Email' => "$Email",
		':Country' => "$Country",
		':City' => "$City",
		':secretquestion' => "$Recoverypassword",
		':realname' => "$Realname",
		':Regdate' => "$Regdate"
		);
		$query->execute($data);

		echo "<p>Yout account was created successfully. Check your e-mail.</p>";
			$dbh = null;
			} else { 
			echo"<div class=\"alert alert-danger\">This <u>ACCOUNT ID</u> (<b> $Username </b>) already exists. Please choose other.!</div>";
			}
			}
			catch(PDOException $e) {
				echo $e->getMessage();
			}
			}
			}
			} else { 
			?>
			<div class="row">
			<div class="col-md-6 col-md-offset-3">
				<form role="form" method="POST" name="form" action="/index.php?page=1">
					<div class="form-group">
					<label for="TextInput">Real name:</label>
					<input name="Realname" type="text" class="form-control" placeholder="Enter your full name." required>
				</div>
				<div class="form-group">
					<label for="TextInput">Country :</label>
				<select id="Country" name="Country" class="form-control" required> 
				<option value="" selected="selected">Select Country</option> 
				<option value="United States">United States</option> 
				<option value="United Kingdom">United Kingdom</option> 
				<option value="Afghanistan">Afghanistan</option> 
				<option value="Albania">Albania</option> 
				<option value="Algeria">Algeria</option> 
				<option value="American Samoa">American Samoa</option> 
				<option value="Andorra">Andorra</option> 
				<option value="Angola">Angola</option> 
				<option value="Anguilla">Anguilla</option> 
				<option value="Antarctica">Antarctica</option> 
				<option value="Antigua and Barbuda">Antigua and Barbuda</option> 
				<option value="Argentina">Argentina</option> 
				<option value="Armenia">Armenia</option> 
				<option value="Aruba">Aruba</option> 
				<option value="Australia">Australia</option> 
				<option value="Austria">Austria</option> 
				<option value="Azerbaijan">Azerbaijan</option> 
				<option value="Bahamas">Bahamas</option> 
				<option value="Bahrain">Bahrain</option> 
				<option value="Bangladesh">Bangladesh</option> 
				<option value="Barbados">Barbados</option> 
				<option value="Belarus">Belarus</option> 
				<option value="Belgium">Belgium</option> 
				<option value="Belize">Belize</option> 
				<option value="Benin">Benin</option> 
				<option value="Bermuda">Bermuda</option> 
				<option value="Bhutan">Bhutan</option> 
				<option value="Bolivia">Bolivia</option> 
				<option value="Bosnia and Herzegovina">Bosnia and Herzegovina</option> 
				<option value="Botswana">Botswana</option> 
				<option value="Bouvet Island">Bouvet Island</option> 
				<option value="Brazil">Brazil</option> 
				<option value="British Indian Ocean Territory">British Indian Ocean Territory</option> 
				<option value="Brunei Darussalam">Brunei Darussalam</option> 
				<option value="Bulgaria">Bulgaria</option> 
				<option value="Burkina Faso">Burkina Faso</option> 
				<option value="Burundi">Burundi</option> 
				<option value="Cambodia">Cambodia</option> 
				<option value="Cameroon">Cameroon</option> 
				<option value="Canada">Canada</option> 
				<option value="Cape Verde">Cape Verde</option> 
				<option value="Cayman Islands">Cayman Islands</option> 
				<option value="Central African Republic">Central African Republic</option> 
				<option value="Chad">Chad</option> 
				<option value="Chile">Chile</option> 
				<option value="China">China</option> 
				<option value="Christmas Island">Christmas Island</option> 
				<option value="Cocos (Keeling) Islands">Cocos (Keeling) Islands</option> 
				<option value="Colombia">Colombia</option> 
				<option value="Comoros">Comoros</option> 
				<option value="Congo">Congo</option> 
				<option value="Congo, The Democratic Republic of The">Congo, The Democratic Republic of The</option> 
				<option value="Cook Islands">Cook Islands</option> 
				<option value="Costa Rica">Costa Rica</option> 
				<option value="Cote D'ivoire">Cote D'ivoire</option> 
				<option value="Croatia">Croatia</option> 
				<option value="Cuba">Cuba</option> 
				<option value="Cyprus">Cyprus</option> 
				<option value="Czech Republic">Czech Republic</option> 
				<option value="Denmark">Denmark</option> 
				<option value="Djibouti">Djibouti</option> 
				<option value="Dominica">Dominica</option> 
				<option value="Dominican Republic">Dominican Republic</option> 
				<option value="Ecuador">Ecuador</option> 
				<option value="Egypt">Egypt</option> 
				<option value="El Salvador">El Salvador</option> 
				<option value="Equatorial Guinea">Equatorial Guinea</option> 
				<option value="Eritrea">Eritrea</option> 
				<option value="Estonia">Estonia</option> 
				<option value="Ethiopia">Ethiopia</option> 
				<option value="Falkland Islands (Malvinas)">Falkland Islands (Malvinas)</option> 
				<option value="Faroe Islands">Faroe Islands</option> 
				<option value="Fiji">Fiji</option> 
				<option value="Finland">Finland</option> 
				<option value="France">France</option> 
				<option value="French Guiana">French Guiana</option> 
				<option value="French Polynesia">French Polynesia</option> 
				<option value="French Southern Territories">French Southern Territories</option> 
				<option value="Gabon">Gabon</option> 
				<option value="Gambia">Gambia</option> 
				<option value="Georgia">Georgia</option> 
				<option value="Germany">Germany</option> 
				<option value="Ghana">Ghana</option> 
				<option value="Gibraltar">Gibraltar</option> 
				<option value="Greece">Greece</option> 
				<option value="Greenland">Greenland</option> 
				<option value="Grenada">Grenada</option> 
				<option value="Guadeloupe">Guadeloupe</option> 
				<option value="Guam">Guam</option> 
				<option value="Guatemala">Guatemala</option> 
				<option value="Guinea">Guinea</option> 
				<option value="Guinea-bissau">Guinea-bissau</option> 
				<option value="Guyana">Guyana</option> 
				<option value="Haiti">Haiti</option> 
				<option value="Heard Island and Mcdonald Islands">Heard Island and Mcdonald Islands</option> 
				<option value="Holy See (Vatican City State)">Holy See (Vatican City State)</option> 
				<option value="Honduras">Honduras</option> 
				<option value="Hong Kong">Hong Kong</option> 
				<option value="Hungary">Hungary</option> 
				<option value="Iceland">Iceland</option> 
				<option value="India">India</option> 
				<option value="Indonesia">Indonesia</option> 
				<option value="Iran, Islamic Republic of">Iran, Islamic Republic of</option> 
				<option value="Iraq">Iraq</option> 
				<option value="Ireland">Ireland</option> 
				<option value="Israel">Israel</option> 
				<option value="Italy">Italy</option> 
				<option value="Jamaica">Jamaica</option> 
				<option value="Japan">Japan</option> 
				<option value="Jordan">Jordan</option> 
				<option value="Kazakhstan">Kazakhstan</option> 
				<option value="Kenya">Kenya</option> 
				<option value="Kiribati">Kiribati</option> 
				<option value="Korea, Democratic People's Republic of">Korea, Democratic People's Republic of</option> 
				<option value="Korea, Republic of">Korea, Republic of</option> 
				<option value="Kuwait">Kuwait</option> 
				<option value="Kyrgyzstan">Kyrgyzstan</option> 
				<option value="Lao People's Democratic Republic">Lao People's Democratic Republic</option> 
				<option value="Latvia">Latvia</option> 
				<option value="Lebanon">Lebanon</option> 
				<option value="Lesotho">Lesotho</option> 
				<option value="Liberia">Liberia</option> 
				<option value="Libyan Arab Jamahiriya">Libyan Arab Jamahiriya</option> 
				<option value="Liechtenstein">Liechtenstein</option> 
				<option value="Lithuania">Lithuania</option> 
				<option value="Luxembourg">Luxembourg</option> 
				<option value="Macao">Macao</option> 
				<option value="Macedonia, The Former Yugoslav Republic of">Macedonia, The Former Yugoslav Republic of</option> 
				<option value="Madagascar">Madagascar</option> 
				<option value="Malawi">Malawi</option> 
				<option value="Malaysia">Malaysia</option> 
				<option value="Maldives">Maldives</option> 
				<option value="Mali">Mali</option> 
				<option value="Malta">Malta</option> 
				<option value="Marshall Islands">Marshall Islands</option> 
				<option value="Martinique">Martinique</option> 
				<option value="Mauritania">Mauritania</option> 
				<option value="Mauritius">Mauritius</option> 
				<option value="Mayotte">Mayotte</option> 
				<option value="Mexico">Mexico</option> 
				<option value="Micronesia, Federated States of">Micronesia, Federated States of</option> 
				<option value="Moldova, Republic of">Moldova, Republic of</option> 
				<option value="Monaco">Monaco</option> 
				<option value="Mongolia">Mongolia</option> 
				<option value="Montserrat">Montserrat</option> 
				<option value="Morocco">Morocco</option> 
				<option value="Mozambique">Mozambique</option> 
				<option value="Myanmar">Myanmar</option> 
				<option value="Namibia">Namibia</option> 
				<option value="Nauru">Nauru</option> 
				<option value="Nepal">Nepal</option> 
				<option value="Netherlands">Netherlands</option> 
				<option value="Netherlands Antilles">Netherlands Antilles</option> 
				<option value="New Caledonia">New Caledonia</option> 
				<option value="New Zealand">New Zealand</option> 
				<option value="Nicaragua">Nicaragua</option> 
				<option value="Niger">Niger</option> 
				<option value="Nigeria">Nigeria</option> 
				<option value="Niue">Niue</option> 
				<option value="Norfolk Island">Norfolk Island</option> 
				<option value="Northern Mariana Islands">Northern Mariana Islands</option> 
				<option value="Norway">Norway</option> 
				<option value="Oman">Oman</option> 
				<option value="Pakistan">Pakistan</option> 
				<option value="Palau">Palau</option> 
				<option value="Palestinian Territory, Occupied">Palestinian Territory, Occupied</option> 
				<option value="Panama">Panama</option> 
				<option value="Papua New Guinea">Papua New Guinea</option> 
				<option value="Paraguay">Paraguay</option> 
				<option value="Peru">Peru</option> 
				<option value="Philippines">Philippines</option> 
				<option value="Pitcairn">Pitcairn</option> 
				<option value="Poland">Poland</option> 
				<option value="Portugal">Portugal</option> 
				<option value="Puerto Rico">Puerto Rico</option> 
				<option value="Qatar">Qatar</option> 
				<option value="Reunion">Reunion</option> 
				<option value="Romania">Romania</option> 
				<option value="Russian Federation">Russian Federation</option> 
				<option value="Rwanda">Rwanda</option> 
				<option value="Saint Helena">Saint Helena</option> 
				<option value="Saint Kitts and Nevis">Saint Kitts and Nevis</option> 
				<option value="Saint Lucia">Saint Lucia</option> 
				<option value="Saint Pierre and Miquelon">Saint Pierre and Miquelon</option> 
				<option value="Saint Vincent and The Grenadines">Saint Vincent and The Grenadines</option> 
				<option value="Samoa">Samoa</option> 
				<option value="San Marino">San Marino</option> 
				<option value="Sao Tome and Principe">Sao Tome and Principe</option> 
				<option value="Saudi Arabia">Saudi Arabia</option> 
				<option value="Senegal">Senegal</option> 
				<option value="Serbia and Montenegro">Serbia and Montenegro</option> 
				<option value="Seychelles">Seychelles</option> 
				<option value="Sierra Leone">Sierra Leone</option> 
				<option value="Singapore">Singapore</option> 
				<option value="Slovakia">Slovakia</option> 
				<option value="Slovenia">Slovenia</option> 
				<option value="Solomon Islands">Solomon Islands</option> 
				<option value="Somalia">Somalia</option> 
				<option value="South Africa">South Africa</option> 
				<option value="South Georgia and The South Sandwich Islands">South Georgia and The South Sandwich Islands</option> 
				<option value="Spain">Spain</option> 
				<option value="Sri Lanka">Sri Lanka</option> 
				<option value="Sudan">Sudan</option> 
				<option value="Suriname">Suriname</option> 
				<option value="Svalbard and Jan Mayen">Svalbard and Jan Mayen</option> 
				<option value="Swaziland">Swaziland</option> 
				<option value="Sweden">Sweden</option> 
				<option value="Switzerland">Switzerland</option> 
				<option value="Syrian Arab Republic">Syrian Arab Republic</option> 
				<option value="Taiwan, Province of China">Taiwan, Province of China</option> 
				<option value="Tajikistan">Tajikistan</option> 
				<option value="Tanzania, United Republic of">Tanzania, United Republic of</option> 
				<option value="Thailand">Thailand</option> 
				<option value="Timor-leste">Timor-leste</option> 
				<option value="Togo">Togo</option> 
				<option value="Tokelau">Tokelau</option> 
				<option value="Tonga">Tonga</option> 
				<option value="Trinidad and Tobago">Trinidad and Tobago</option> 
				<option value="Tunisia">Tunisia</option> 
				<option value="Turkey">Turkey</option> 
				<option value="Turkmenistan">Turkmenistan</option> 
				<option value="Turks and Caicos Islands">Turks and Caicos Islands</option> 
				<option value="Tuvalu">Tuvalu</option> 
				<option value="Uganda">Uganda</option> 
				<option value="Ukraine">Ukraine</option> 
				<option value="United Arab Emirates">United Arab Emirates</option> 
				<option value="United Kingdom">United Kingdom</option> 
				<option value="United States">United States</option> 
				<option value="United States Minor Outlying Islands">United States Minor Outlying Islands</option> 
				<option value="Uruguay">Uruguay</option> 
				<option value="Uzbekistan">Uzbekistan</option> 
				<option value="Vanuatu">Vanuatu</option> 
				<option value="Venezuela">Venezuela</option> 
				<option value="Viet Nam">Viet Nam</option> 
				<option value="Virgin Islands, British">Virgin Islands, British</option> 
				<option value="Virgin Islands, U.S.">Virgin Islands, U.S.</option> 
				<option value="Wallis and Futuna">Wallis and Futuna</option> 
				<option value="Western Sahara">Western Sahara</option> 
				<option value="Yemen">Yemen</option> 
				<option value="Zambia">Zambia</option> 
				<option value="Zimbabwe">Zimbabwe</option>
				</select>
				</div>
				<div class="form-group">
					<label for="TextInput">City :</label>
					<input name="City" type="text" class="form-control" placeholder="Enter your city name." required>
				 </div>
				  <div class="form-group">
					<label for="InputEmail1">Email address</label>
					<input name="Email" type="email" class="form-control" id="InputEmail1" placeholder="Enter your email" required>
				  </div>
				  <div class="form-group">
					<label for="TextInput">Account :</label>
					<input name="Username" type="text" class="form-control" placeholder="Enter your Account ID." required>
				 </div>
				  <div class="form-group">
					<label for="InputPassword1">Password</label>
					<input name="Password1" type="password" class="form-control" id="InputPassword1" placeholder="Password" required>
				  </div>
				  <div class="form-group">
					<label for="InputPassword1">Password (Again)</label>
					<input name="Password2" type="password" class="form-control" id="InputPassword1" placeholder="Password" required>
				  </div>
				<div class="form-group">
					<label for="TextInput">Recovery Password (4 Digits)</label>
					<input name="Recoverypassword" type="text" class="form-control" placeholder="Text input" maxlength="4" required>
					<span class="help-block">Used to recovery your password. (Will be sent by email.)</span>
				</div>
				  <div class="checkbox">
					<label>
					  <input type="checkbox" required> Do accept TOS ?
					</label>
				  </div>
				  <button name="submit" id="submit" type="submit" class="btn btn-default">Create Account</button>
				</form>
			</div>
			</div>
		
<?php
}
?>

It looks like this if you use Bootstrap.

Spoiler

Bootstrap CDN

Spoiler

01/07/2014 20:39 Beb0mn#7

Quote:
Originally Posted by turk55
Sure and I just took a look on your script, at the username check you basically say if I can run the query the username exists. This is not how you should do it.
Code:
}elseif($row = mysql_query($stmt)){ 
            $errors[] = 'User name already exists, please choose a different user name.'; 
        }
Try this instead :
Code:
}elseif($row = mysql_query($stmt)){ 
            if(mysql_num_rows($row) > 0) {
				$errors[] = 'User name already exists, please choose a different user name.'; 
			}
        }
Not to mention you are using a question mark ("?") at the query but you are not filling it in any way plus the question mark is only used at prepared statements (the regular mysql library does not support prepared statements, mysqli does).

$sql = "SELECT Username FROM 'accounts' WHERE Username = ?";
TO:
$sql = "SELECT Username FROM 'accounts' WHERE Username = \"".$username."\"";

So all the other commands are ok except for the '?'? That source was from obdc database and i tried to change it to mysql. I dont know if the mysql calls are ok. I will do your sugestion as soon as i can.

Quote:

Originally Posted by Gerculy

Here's my :) ( Little simpler compared to Insomnius one's )

Config ..

Spoiler

Code:

<?php
If($_SERVER['REQUEST_METHOD'] == "POST") { 
		if (isset($_POST['Password1'],$_POST['Password2']) && $_POST['Password1']!=$_POST['Password2']) {
		echo 'Your password confirmation is not equal to your password';
		} else {
		
       	if (!$_POST['Realname'] || 
			!$_POST['Username'] || 
			!$_POST['Password1'] || 
			!$_POST['Password2'] || 
			!$_POST['Email']|| 
			!$_POST['Country'] || 
			!$_POST['City'] ||
			!$_POST['Recoverypassword'] ) {
            echo "<p>Please supply all of the data!</p>";
           exit;
        } else {
	
            try {        
			$dbh  = new Database();


		$stmt = $dbh->prepare('SELECT * FROM accounts WHERE Username=?');
		$stmt->bindParam(1, $_POST['Username'], PDO::PARAM_INT);
		$stmt->execute();
		$row = $stmt->fetch(PDO::FETCH_ASSOC);

						
			$Realname = "$_POST[Realname]";
			$Realname  = stripslashes_deep($Realname);
			$Username = "$_POST[Username]";
			$Username  = stripslashes_deep($Username);
			$Password1 = "$_POST[Password1]";
			$Password1  = stripslashes_deep($Password1);
			$Password2 = "$_POST[Password2]";
			$Password2  = stripslashes_deep($Password2);
			$Email = "$_POST[Email]";
			$EMail  = stripslashes_deep($Email);
			$Country = "$_POST[Country]";
			$Country  = stripslashes_deep($Country);
			$City = "$_POST[City]";
			$City  = stripslashes_deep($City);
			$Recoverypassword = "$_POST[Recoverypassword]";
			$Recoverypassword  = stripslashes_deep($Recoverypassword);
			$Regdate = date("Y-m-d");    

		
		if( ! $row)
		{
			$dbh  = new Database();		
		$query = $dbh->prepare("insert into accounts (Username,Password,Email,Country,City,secretquestion,realname,Regdate)
		values (:Username,:Password,:Email,:Country,:City,:secretquestion,:realname,:Regdate)");
		$data = array(
		':Username' => "$Username",
		':Password' => "$Password1",
		':Email' => "$Email",
		':Country' => "$Country",
		':City' => "$City",
		':secretquestion' => "$Recoverypassword",
		':realname' => "$Realname",
		':Regdate' => "$Regdate"
		);
		$query->execute($data);

		echo "<p>Yout account was created successfully. Check your e-mail.</p>";
			$dbh = null;
			} else { 
			echo"<div class=\"alert alert-danger\">This <u>ACCOUNT ID</u> (<b> $Username </b>) already exists. Please choose other.!</div>";
			}
			}
			catch(PDOException $e) {
				echo $e->getMessage();
			}
			}
			}
			} else { 
			?>
			<div class="row">
			<div class="col-md-6 col-md-offset-3">
				<form role="form" method="POST" name="form" action="/index.php?page=1">
					<div class="form-group">
					<label for="TextInput">Real name:</label>
					<input name="Realname" type="text" class="form-control" placeholder="Enter your full name." required>
				</div>
				<div class="form-group">
					<label for="TextInput">Country :</label>
				<select id="Country" name="Country" class="form-control" required> 
				<option value="" selected="selected">Select Country</option> 
				<option value="United States">United States</option> 
				<option value="United Kingdom">United Kingdom</option> 
				<option value="Afghanistan">Afghanistan</option> 
				<option value="Albania">Albania</option> 
				<option value="Algeria">Algeria</option> 
				<option value="American Samoa">American Samoa</option> 
				<option value="Andorra">Andorra</option> 
				<option value="Angola">Angola</option> 
				<option value="Anguilla">Anguilla</option> 
				<option value="Antarctica">Antarctica</option> 
				<option value="Antigua and Barbuda">Antigua and Barbuda</option> 
				<option value="Argentina">Argentina</option> 
				<option value="Armenia">Armenia</option> 
				<option value="Aruba">Aruba</option> 
				<option value="Australia">Australia</option> 
				<option value="Austria">Austria</option> 
				<option value="Azerbaijan">Azerbaijan</option> 
				<option value="Bahamas">Bahamas</option> 
				<option value="Bahrain">Bahrain</option> 
				<option value="Bangladesh">Bangladesh</option> 
				<option value="Barbados">Barbados</option> 
				<option value="Belarus">Belarus</option> 
				<option value="Belgium">Belgium</option> 
				<option value="Belize">Belize</option> 
				<option value="Benin">Benin</option> 
				<option value="Bermuda">Bermuda</option> 
				<option value="Bhutan">Bhutan</option> 
				<option value="Bolivia">Bolivia</option> 
				<option value="Bosnia and Herzegovina">Bosnia and Herzegovina</option> 
				<option value="Botswana">Botswana</option> 
				<option value="Bouvet Island">Bouvet Island</option> 
				<option value="Brazil">Brazil</option> 
				<option value="British Indian Ocean Territory">British Indian Ocean Territory</option> 
				<option value="Brunei Darussalam">Brunei Darussalam</option> 
				<option value="Bulgaria">Bulgaria</option> 
				<option value="Burkina Faso">Burkina Faso</option> 
				<option value="Burundi">Burundi</option> 
				<option value="Cambodia">Cambodia</option> 
				<option value="Cameroon">Cameroon</option> 
				<option value="Canada">Canada</option> 
				<option value="Cape Verde">Cape Verde</option> 
				<option value="Cayman Islands">Cayman Islands</option> 
				<option value="Central African Republic">Central African Republic</option> 
				<option value="Chad">Chad</option> 
				<option value="Chile">Chile</option> 
				<option value="China">China</option> 
				<option value="Christmas Island">Christmas Island</option> 
				<option value="Cocos (Keeling) Islands">Cocos (Keeling) Islands</option> 
				<option value="Colombia">Colombia</option> 
				<option value="Comoros">Comoros</option> 
				<option value="Congo">Congo</option> 
				<option value="Congo, The Democratic Republic of The">Congo, The Democratic Republic of The</option> 
				<option value="Cook Islands">Cook Islands</option> 
				<option value="Costa Rica">Costa Rica</option> 
				<option value="Cote D'ivoire">Cote D'ivoire</option> 
				<option value="Croatia">Croatia</option> 
				<option value="Cuba">Cuba</option> 
				<option value="Cyprus">Cyprus</option> 
				<option value="Czech Republic">Czech Republic</option> 
				<option value="Denmark">Denmark</option> 
				<option value="Djibouti">Djibouti</option> 
				<option value="Dominica">Dominica</option> 
				<option value="Dominican Republic">Dominican Republic</option> 
				<option value="Ecuador">Ecuador</option> 
				<option value="Egypt">Egypt</option> 
				<option value="El Salvador">El Salvador</option> 
				<option value="Equatorial Guinea">Equatorial Guinea</option> 
				<option value="Eritrea">Eritrea</option> 
				<option value="Estonia">Estonia</option> 
				<option value="Ethiopia">Ethiopia</option> 
				<option value="Falkland Islands (Malvinas)">Falkland Islands (Malvinas)</option> 
				<option value="Faroe Islands">Faroe Islands</option> 
				<option value="Fiji">Fiji</option> 
				<option value="Finland">Finland</option> 
				<option value="France">France</option> 
				<option value="French Guiana">French Guiana</option> 
				<option value="French Polynesia">French Polynesia</option> 
				<option value="French Southern Territories">French Southern Territories</option> 
				<option value="Gabon">Gabon</option> 
				<option value="Gambia">Gambia</option> 
				<option value="Georgia">Georgia</option> 
				<option value="Germany">Germany</option> 
				<option value="Ghana">Ghana</option> 
				<option value="Gibraltar">Gibraltar</option> 
				<option value="Greece">Greece</option> 
				<option value="Greenland">Greenland</option> 
				<option value="Grenada">Grenada</option> 
				<option value="Guadeloupe">Guadeloupe</option> 
				<option value="Guam">Guam</option> 
				<option value="Guatemala">Guatemala</option> 
				<option value="Guinea">Guinea</option> 
				<option value="Guinea-bissau">Guinea-bissau</option> 
				<option value="Guyana">Guyana</option> 
				<option value="Haiti">Haiti</option> 
				<option value="Heard Island and Mcdonald Islands">Heard Island and Mcdonald Islands</option> 
				<option value="Holy See (Vatican City State)">Holy See (Vatican City State)</option> 
				<option value="Honduras">Honduras</option> 
				<option value="Hong Kong">Hong Kong</option> 
				<option value="Hungary">Hungary</option> 
				<option value="Iceland">Iceland</option> 
				<option value="India">India</option> 
				<option value="Indonesia">Indonesia</option> 
				<option value="Iran, Islamic Republic of">Iran, Islamic Republic of</option> 
				<option value="Iraq">Iraq</option> 
				<option value="Ireland">Ireland</option> 
				<option value="Israel">Israel</option> 
				<option value="Italy">Italy</option> 
				<option value="Jamaica">Jamaica</option> 
				<option value="Japan">Japan</option> 
				<option value="Jordan">Jordan</option> 
				<option value="Kazakhstan">Kazakhstan</option> 
				<option value="Kenya">Kenya</option> 
				<option value="Kiribati">Kiribati</option> 
				<option value="Korea, Democratic People's Republic of">Korea, Democratic People's Republic of</option> 
				<option value="Korea, Republic of">Korea, Republic of</option> 
				<option value="Kuwait">Kuwait</option> 
				<option value="Kyrgyzstan">Kyrgyzstan</option> 
				<option value="Lao People's Democratic Republic">Lao People's Democratic Republic</option> 
				<option value="Latvia">Latvia</option> 
				<option value="Lebanon">Lebanon</option> 
				<option value="Lesotho">Lesotho</option> 
				<option value="Liberia">Liberia</option> 
				<option value="Libyan Arab Jamahiriya">Libyan Arab Jamahiriya</option> 
				<option value="Liechtenstein">Liechtenstein</option> 
				<option value="Lithuania">Lithuania</option> 
				<option value="Luxembourg">Luxembourg</option> 
				<option value="Macao">Macao</option> 
				<option value="Macedonia, The Former Yugoslav Republic of">Macedonia, The Former Yugoslav Republic of</option> 
				<option value="Madagascar">Madagascar</option> 
				<option value="Malawi">Malawi</option> 
				<option value="Malaysia">Malaysia</option> 
				<option value="Maldives">Maldives</option> 
				<option value="Mali">Mali</option> 
				<option value="Malta">Malta</option> 
				<option value="Marshall Islands">Marshall Islands</option> 
				<option value="Martinique">Martinique</option> 
				<option value="Mauritania">Mauritania</option> 
				<option value="Mauritius">Mauritius</option> 
				<option value="Mayotte">Mayotte</option> 
				<option value="Mexico">Mexico</option> 
				<option value="Micronesia, Federated States of">Micronesia, Federated States of</option> 
				<option value="Moldova, Republic of">Moldova, Republic of</option> 
				<option value="Monaco">Monaco</option> 
				<option value="Mongolia">Mongolia</option> 
				<option value="Montserrat">Montserrat</option> 
				<option value="Morocco">Morocco</option> 
				<option value="Mozambique">Mozambique</option> 
				<option value="Myanmar">Myanmar</option> 
				<option value="Namibia">Namibia</option> 
				<option value="Nauru">Nauru</option> 
				<option value="Nepal">Nepal</option> 
				<option value="Netherlands">Netherlands</option> 
				<option value="Netherlands Antilles">Netherlands Antilles</option> 
				<option value="New Caledonia">New Caledonia</option> 
				<option value="New Zealand">New Zealand</option> 
				<option value="Nicaragua">Nicaragua</option> 
				<option value="Niger">Niger</option> 
				<option value="Nigeria">Nigeria</option> 
				<option value="Niue">Niue</option> 
				<option value="Norfolk Island">Norfolk Island</option> 
				<option value="Northern Mariana Islands">Northern Mariana Islands</option> 
				<option value="Norway">Norway</option> 
				<option value="Oman">Oman</option> 
				<option value="Pakistan">Pakistan</option> 
				<option value="Palau">Palau</option> 
				<option value="Palestinian Territory, Occupied">Palestinian Territory, Occupied</option> 
				<option value="Panama">Panama</option> 
				<option value="Papua New Guinea">Papua New Guinea</option> 
				<option value="Paraguay">Paraguay</option> 
				<option value="Peru">Peru</option> 
				<option value="Philippines">Philippines</option> 
				<option value="Pitcairn">Pitcairn</option> 
				<option value="Poland">Poland</option> 
				<option value="Portugal">Portugal</option> 
				<option value="Puerto Rico">Puerto Rico</option> 
				<option value="Qatar">Qatar</option> 
				<option value="Reunion">Reunion</option> 
				<option value="Romania">Romania</option> 
				<option value="Russian Federation">Russian Federation</option> 
				<option value="Rwanda">Rwanda</option> 
				<option value="Saint Helena">Saint Helena</option> 
				<option value="Saint Kitts and Nevis">Saint Kitts and Nevis</option> 
				<option value="Saint Lucia">Saint Lucia</option> 
				<option value="Saint Pierre and Miquelon">Saint Pierre and Miquelon</option> 
				<option value="Saint Vincent and The Grenadines">Saint Vincent and The Grenadines</option> 
				<option value="Samoa">Samoa</option> 
				<option value="San Marino">San Marino</option> 
				<option value="Sao Tome and Principe">Sao Tome and Principe</option> 
				<option value="Saudi Arabia">Saudi Arabia</option> 
				<option value="Senegal">Senegal</option> 
				<option value="Serbia and Montenegro">Serbia and Montenegro</option> 
				<option value="Seychelles">Seychelles</option> 
				<option value="Sierra Leone">Sierra Leone</option> 
				<option value="Singapore">Singapore</option> 
				<option value="Slovakia">Slovakia</option> 
				<option value="Slovenia">Slovenia</option> 
				<option value="Solomon Islands">Solomon Islands</option> 
				<option value="Somalia">Somalia</option> 
				<option value="South Africa">South Africa</option> 
				<option value="South Georgia and The South Sandwich Islands">South Georgia and The South Sandwich Islands</option> 
				<option value="Spain">Spain</option> 
				<option value="Sri Lanka">Sri Lanka</option> 
				<option value="Sudan">Sudan</option> 
				<option value="Suriname">Suriname</option> 
				<option value="Svalbard and Jan Mayen">Svalbard and Jan Mayen</option> 
				<option value="Swaziland">Swaziland</option> 
				<option value="Sweden">Sweden</option> 
				<option value="Switzerland">Switzerland</option> 
				<option value="Syrian Arab Republic">Syrian Arab Republic</option> 
				<option value="Taiwan, Province of China">Taiwan, Province of China</option> 
				<option value="Tajikistan">Tajikistan</option> 
				<option value="Tanzania, United Republic of">Tanzania, United Republic of</option> 
				<option value="Thailand">Thailand</option> 
				<option value="Timor-leste">Timor-leste</option> 
				<option value="Togo">Togo</option> 
				<option value="Tokelau">Tokelau</option> 
				<option value="Tonga">Tonga</option> 
				<option value="Trinidad and Tobago">Trinidad and Tobago</option> 
				<option value="Tunisia">Tunisia</option> 
				<option value="Turkey">Turkey</option> 
				<option value="Turkmenistan">Turkmenistan</option> 
				<option value="Turks and Caicos Islands">Turks and Caicos Islands</option> 
				<option value="Tuvalu">Tuvalu</option> 
				<option value="Uganda">Uganda</option> 
				<option value="Ukraine">Ukraine</option> 
				<option value="United Arab Emirates">United Arab Emirates</option> 
				<option value="United Kingdom">United Kingdom</option> 
				<option value="United States">United States</option> 
				<option value="United States Minor Outlying Islands">United States Minor Outlying Islands</option> 
				<option value="Uruguay">Uruguay</option> 
				<option value="Uzbekistan">Uzbekistan</option> 
				<option value="Vanuatu">Vanuatu</option> 
				<option value="Venezuela">Venezuela</option> 
				<option value="Viet Nam">Viet Nam</option> 
				<option value="Virgin Islands, British">Virgin Islands, British</option> 
				<option value="Virgin Islands, U.S.">Virgin Islands, U.S.</option> 
				<option value="Wallis and Futuna">Wallis and Futuna</option> 
				<option value="Western Sahara">Western Sahara</option> 
				<option value="Yemen">Yemen</option> 
				<option value="Zambia">Zambia</option> 
				<option value="Zimbabwe">Zimbabwe</option>
				</select>
				</div>
				<div class="form-group">
					<label for="TextInput">City :</label>
					<input name="City" type="text" class="form-control" placeholder="Enter your city name." required>
				 </div>
				  <div class="form-group">
					<label for="InputEmail1">Email address</label>
					<input name="Email" type="email" class="form-control" id="InputEmail1" placeholder="Enter your email" required>
				  </div>
				  <div class="form-group">
					<label for="TextInput">Account :</label>
					<input name="Username" type="text" class="form-control" placeholder="Enter your Account ID." required>
				 </div>
				  <div class="form-group">
					<label for="InputPassword1">Password</label>
					<input name="Password1" type="password" class="form-control" id="InputPassword1" placeholder="Password" required>
				  </div>
				  <div class="form-group">
					<label for="InputPassword1">Password (Again)</label>
					<input name="Password2" type="password" class="form-control" id="InputPassword1" placeholder="Password" required>
				  </div>
				<div class="form-group">
					<label for="TextInput">Recovery Password (4 Digits)</label>
					<input name="Recoverypassword" type="text" class="form-control" placeholder="Text input" maxlength="4" required>
					<span class="help-block">Used to recovery your password. (Will be sent by email.)</span>
				</div>
				  <div class="checkbox">
					<label>
					  <input type="checkbox" required> Do accept TOS ?
					</label>
				  </div>
				  <button name="submit" id="submit" type="submit" class="btn btn-default">Create Account</button>
				</form>
			</div>
			</div>
		
<?php
}
?>

It looks like this if you use Bootstrap.

Spoiler

Bootstrap CDN

Spoiler

Sorry for the lack of knowledge, Do i add the bootstrap code on top of the php code in the same register page? Like style html code in html?

My thoughts are that i should since the register page is not making a call to a bootstrap.php, i just want to make sure.

Edit = I just realized everything goes in 1 uniqur register.php page. Nevermind the dumb question. I'm still wondering about the one below.

Also sorry for the demands, is it anti injection?

01/07/2014 21:01 Gerculy#8

Quote:

Originally Posted by Beb0mn

Is it anti injection?

I did my best... Shouldn't have problems with it.
( A good hacker hacks anything :handsdown:)

01/07/2014 22:54 Beb0mn#9

Ok this is what i have done so far

For the register.php that contains the form

Spoiler

PHP Code:


			
<?php

define('DB_TYPE', 'mysql');

define('DB_HOST', '');

define('DB_NAME', '');

define('DB_USER', '');

define('DB_PASS', '');



class Database extends PDO {



    public function __construct() {



        $options = array(PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ);

        parent::__construct(DB_TYPE . ':host=' . DB_HOST . ';dbname=' . DB_NAME, DB_USER, DB_PASS, $options);

    }



}



function stripslashes_deep($value)

{

    $value = is_array($value) ?

                array_map('stripslashes_deep', $value) :

                stripslashes($value);



    return $value;

}

?>

            <div class="row">

            <div class="col-md-6 col-md-offset-3">

                <form role="form" method="POST" name="form" action="/registration/registersucessfull.php?page=1">

                  <div class="form-group">

                    <label for="TextInput">Account :</label>

                    <input name="Username" type="text" class="form-control" placeholder="Enter your Account ID." required>

                 </div>

                  <div class="form-group">

                    <label for="InputPassword1">Password</label>

                    <input name="Password" type="password" class="form-control" id="InputPassword1" placeholder="Password" required>

                  </div>

                  <div class="form-group">

                    <label for="InputPassword1">Password (Again)</label>

                    <input name="Password2" type="password" class="form-control" id="InputPassword1" placeholder="Password" required>

                  </div>

                       <div class="form-group">

                    <label for="InputEmail1">Email address</label>

                    <input name="Email" type="email" class="form-control" id="InputEmail1" placeholder="Enter your email" required>

                  </div>

                <div class="form-group">

                    <label for="TextInput">Recovery Password (4 Digits)</label>

                    <input name="Recoverypassword" type="text" class="form-control" placeholder="Text input" maxlength="4" required>

                    <span class="help-block">Used to recovery your password. (Will be sent by email.)</span>

                </div>

                <div class="form-group">

                    <label for="TextInput">Country :</label>

                <select id="Country" name="Country" class="form-control" required> 

                <option value="" selected="selected">Select Country</option> 

                <option value="United States">United States</option> 

                <option value="United Kingdom">United Kingdom</option> 

                <option value="Afghanistan">Afghanistan</option> 

                <option value="Albania">Albania</option> 

                <option value="Algeria">Algeria</option> 

                <option value="American Samoa">American Samoa</option> 

                <option value="Andorra">Andorra</option> 

                <option value="Angola">Angola</option> 

                <option value="Anguilla">Anguilla</option> 

                <option value="Antarctica">Antarctica</option> 

                <option value="Antigua and Barbuda">Antigua and Barbuda</option> 

                <option value="Argentina">Argentina</option> 

                <option value="Armenia">Armenia</option> 

                <option value="Aruba">Aruba</option> 

                <option value="Australia">Australia</option> 

                <option value="Austria">Austria</option> 

                <option value="Azerbaijan">Azerbaijan</option> 

                <option value="Bahamas">Bahamas</option> 

                <option value="Bahrain">Bahrain</option> 

                <option value="Bangladesh">Bangladesh</option> 

                <option value="Barbados">Barbados</option> 

                <option value="Belarus">Belarus</option> 

                <option value="Belgium">Belgium</option> 

                <option value="Belize">Belize</option> 

                <option value="Benin">Benin</option> 

                <option value="Bermuda">Bermuda</option> 

                <option value="Bhutan">Bhutan</option> 

                <option value="Bolivia">Bolivia</option> 

                <option value="Bosnia and Herzegovina">Bosnia and Herzegovina</option> 

                <option value="Botswana">Botswana</option> 

                <option value="Bouvet Island">Bouvet Island</option> 

                <option value="Brazil">Brazil</option> 

                <option value="British Indian Ocean Territory">British Indian Ocean Territory</option> 

                <option value="Brunei Darussalam">Brunei Darussalam</option> 

                <option value="Bulgaria">Bulgaria</option> 

                <option value="Burkina Faso">Burkina Faso</option> 

                <option value="Burundi">Burundi</option> 

                <option value="Cambodia">Cambodia</option> 

                <option value="Cameroon">Cameroon</option> 

                <option value="Canada">Canada</option> 

                <option value="Cape Verde">Cape Verde</option> 

                <option value="Cayman Islands">Cayman Islands</option> 

                <option value="Central African Republic">Central African Republic</option> 

                <option value="Chad">Chad</option> 

                <option value="Chile">Chile</option> 

                <option value="China">China</option> 

                <option value="Christmas Island">Christmas Island</option> 

                <option value="Cocos (Keeling) Islands">Cocos (Keeling) Islands</option> 

                <option value="Colombia">Colombia</option> 

                <option value="Comoros">Comoros</option> 

                <option value="Congo">Congo</option> 

                <option value="Congo, The Democratic Republic of The">Congo, The Democratic Republic of The</option> 

                <option value="Cook Islands">Cook Islands</option> 

                <option value="Costa Rica">Costa Rica</option> 

                <option value="Cote D'ivoire">Cote D'ivoire</option> 

                <option value="Croatia">Croatia</option> 

                <option value="Cuba">Cuba</option> 

                <option value="Cyprus">Cyprus</option> 

                <option value="Czech Republic">Czech Republic</option> 

                <option value="Denmark">Denmark</option> 

                <option value="Djibouti">Djibouti</option> 

                <option value="Dominica">Dominica</option> 

                <option value="Dominican Republic">Dominican Republic</option> 

                <option value="Ecuador">Ecuador</option> 

                <option value="Egypt">Egypt</option> 

                <option value="El Salvador">El Salvador</option> 

                <option value="Equatorial Guinea">Equatorial Guinea</option> 

                <option value="Eritrea">Eritrea</option> 

                <option value="Estonia">Estonia</option> 

                <option value="Ethiopia">Ethiopia</option> 

                <option value="Falkland Islands (Malvinas)">Falkland Islands (Malvinas)</option> 

                <option value="Faroe Islands">Faroe Islands</option> 

                <option value="Fiji">Fiji</option> 

                <option value="Finland">Finland</option> 

                <option value="France">France</option> 

                <option value="French Guiana">French Guiana</option> 

                <option value="French Polynesia">French Polynesia</option> 

                <option value="French Southern Territories">French Southern Territories</option> 

                <option value="Gabon">Gabon</option> 

                <option value="Gambia">Gambia</option> 

                <option value="Georgia">Georgia</option> 

                <option value="Germany">Germany</option> 

                <option value="Ghana">Ghana</option> 

                <option value="Gibraltar">Gibraltar</option> 

                <option value="Greece">Greece</option> 

                <option value="Greenland">Greenland</option> 

                <option value="Grenada">Grenada</option> 

                <option value="Guadeloupe">Guadeloupe</option> 

                <option value="Guam">Guam</option> 

                <option value="Guatemala">Guatemala</option> 

                <option value="Guinea">Guinea</option> 

                <option value="Guinea-bissau">Guinea-bissau</option> 

                <option value="Guyana">Guyana</option> 

                <option value="Haiti">Haiti</option> 

                <option value="Heard Island and Mcdonald Islands">Heard Island and Mcdonald Islands</option> 

                <option value="Holy See (Vatican City State)">Holy See (Vatican City State)</option> 

                <option value="Honduras">Honduras</option> 

                <option value="Hong Kong">Hong Kong</option> 

                <option value="Hungary">Hungary</option> 

                <option value="Iceland">Iceland</option> 

                <option value="India">India</option> 

                <option value="Indonesia">Indonesia</option> 

                <option value="Iran, Islamic Republic of">Iran, Islamic Republic of</option> 

                <option value="Iraq">Iraq</option> 

                <option value="Ireland">Ireland</option> 

                <option value="Israel">Israel</option> 

                <option value="Italy">Italy</option> 

                <option value="Jamaica">Jamaica</option> 

                <option value="Japan">Japan</option> 

                <option value="Jordan">Jordan</option> 

                <option value="Kazakhstan">Kazakhstan</option> 

                <option value="Kenya">Kenya</option> 

                <option value="Kiribati">Kiribati</option> 

                <option value="Korea, Democratic People's Republic of">Korea, Democratic People's Republic of</option> 

                <option value="Korea, Republic of">Korea, Republic of</option> 

                <option value="Kuwait">Kuwait</option> 

                <option value="Kyrgyzstan">Kyrgyzstan</option> 

                <option value="Lao People's Democratic Republic">Lao People's Democratic Republic</option> 

                <option value="Latvia">Latvia</option> 

                <option value="Lebanon">Lebanon</option> 

                <option value="Lesotho">Lesotho</option> 

                <option value="Liberia">Liberia</option> 

                <option value="Libyan Arab Jamahiriya">Libyan Arab Jamahiriya</option> 

                <option value="Liechtenstein">Liechtenstein</option> 

                <option value="Lithuania">Lithuania</option> 

                <option value="Luxembourg">Luxembourg</option> 

                <option value="Macao">Macao</option> 

                <option value="Macedonia, The Former Yugoslav Republic of">Macedonia, The Former Yugoslav Republic of</option> 

                <option value="Madagascar">Madagascar</option> 

                <option value="Malawi">Malawi</option> 

                <option value="Malaysia">Malaysia</option> 

                <option value="Maldives">Maldives</option> 

                <option value="Mali">Mali</option> 

                <option value="Malta">Malta</option> 

                <option value="Marshall Islands">Marshall Islands</option> 

                <option value="Martinique">Martinique</option> 

                <option value="Mauritania">Mauritania</option> 

                <option value="Mauritius">Mauritius</option> 

                <option value="Mayotte">Mayotte</option> 

                <option value="Mexico">Mexico</option> 

                <option value="Micronesia, Federated States of">Micronesia, Federated States of</option> 

                <option value="Moldova, Republic of">Moldova, Republic of</option> 

                <option value="Monaco">Monaco</option> 

                <option value="Mongolia">Mongolia</option> 

                <option value="Montserrat">Montserrat</option> 

                <option value="Morocco">Morocco</option> 

                <option value="Mozambique">Mozambique</option> 

                <option value="Myanmar">Myanmar</option> 

                <option value="Namibia">Namibia</option> 

                <option value="Nauru">Nauru</option> 

                <option value="Nepal">Nepal</option> 

                <option value="Netherlands">Netherlands</option> 

                <option value="Netherlands Antilles">Netherlands Antilles</option> 

                <option value="New Caledonia">New Caledonia</option> 

                <option value="New Zealand">New Zealand</option> 

                <option value="Nicaragua">Nicaragua</option> 

                <option value="Niger">Niger</option> 

                <option value="Nigeria">Nigeria</option> 

                <option value="Niue">Niue</option> 

                <option value="Norfolk Island">Norfolk Island</option> 

                <option value="Northern Mariana Islands">Northern Mariana Islands</option> 

                <option value="Norway">Norway</option> 

                <option value="Oman">Oman</option> 

                <option value="Pakistan">Pakistan</option> 

                <option value="Palau">Palau</option> 

                <option value="Palestinian Territory, Occupied">Palestinian Territory, Occupied</option> 

                <option value="Panama">Panama</option> 

                <option value="Papua New Guinea">Papua New Guinea</option> 

                <option value="Paraguay">Paraguay</option> 

                <option value="Peru">Peru</option> 

                <option value="Philippines">Philippines</option> 

                <option value="Pitcairn">Pitcairn</option> 

                <option value="Poland">Poland</option> 

                <option value="Portugal">Portugal</option> 

                <option value="Puerto Rico">Puerto Rico</option> 

                <option value="Qatar">Qatar</option> 

                <option value="Reunion">Reunion</option> 

                <option value="Romania">Romania</option> 

                <option value="Russian Federation">Russian Federation</option> 

                <option value="Rwanda">Rwanda</option> 

                <option value="Saint Helena">Saint Helena</option> 

                <option value="Saint Kitts and Nevis">Saint Kitts and Nevis</option> 

                <option value="Saint Lucia">Saint Lucia</option> 

                <option value="Saint Pierre and Miquelon">Saint Pierre and Miquelon</option> 

                <option value="Saint Vincent and The Grenadines">Saint Vincent and The Grenadines</option> 

                <option value="Samoa">Samoa</option> 

                <option value="San Marino">San Marino</option> 

                <option value="Sao Tome and Principe">Sao Tome and Principe</option> 

                <option value="Saudi Arabia">Saudi Arabia</option> 

                <option value="Senegal">Senegal</option> 

                <option value="Serbia and Montenegro">Serbia and Montenegro</option> 

                <option value="Seychelles">Seychelles</option> 

                <option value="Sierra Leone">Sierra Leone</option> 

                <option value="Singapore">Singapore</option> 

                <option value="Slovakia">Slovakia</option> 

                <option value="Slovenia">Slovenia</option> 

                <option value="Solomon Islands">Solomon Islands</option> 

                <option value="Somalia">Somalia</option> 

                <option value="South Africa">South Africa</option> 

                <option value="South Georgia and The South Sandwich Islands">South Georgia and The South Sandwich Islands</option> 

                <option value="Spain">Spain</option> 

                <option value="Sri Lanka">Sri Lanka</option> 

                <option value="Sudan">Sudan</option> 

                <option value="Suriname">Suriname</option> 

                <option value="Svalbard and Jan Mayen">Svalbard and Jan Mayen</option> 

                <option value="Swaziland">Swaziland</option> 

                <option value="Sweden">Sweden</option> 

                <option value="Switzerland">Switzerland</option> 

                <option value="Syrian Arab Republic">Syrian Arab Republic</option> 

                <option value="Taiwan, Province of China">Taiwan, Province of China</option> 

                <option value="Tajikistan">Tajikistan</option> 

                <option value="Tanzania, United Republic of">Tanzania, United Republic of</option> 

                <option value="Thailand">Thailand</option> 

                <option value="Timor-leste">Timor-leste</option> 

                <option value="Togo">Togo</option> 

                <option value="Tokelau">Tokelau</option> 

                <option value="Tonga">Tonga</option> 

                <option value="Trinidad and Tobago">Trinidad and Tobago</option> 

                <option value="Tunisia">Tunisia</option> 

                <option value="Turkey">Turkey</option> 

                <option value="Turkmenistan">Turkmenistan</option> 

                <option value="Turks and Caicos Islands">Turks and Caicos Islands</option> 

                <option value="Tuvalu">Tuvalu</option> 

                <option value="Uganda">Uganda</option> 

                <option value="Ukraine">Ukraine</option> 

                <option value="United Arab Emirates">United Arab Emirates</option> 

                <option value="United Kingdom">United Kingdom</option> 

                <option value="United States">United States</option> 

                <option value="United States Minor Outlying Islands">United States Minor Outlying Islands</option> 

                <option value="Uruguay">Uruguay</option> 

                <option value="Uzbekistan">Uzbekistan</option> 

                <option value="Vanuatu">Vanuatu</option> 

                <option value="Venezuela">Venezuela</option> 

                <option value="Viet Nam">Viet Nam</option> 

                <option value="Virgin Islands, British">Virgin Islands, British</option> 

                <option value="Virgin Islands, U.S.">Virgin Islands, U.S.</option> 

                <option value="Wallis and Futuna">Wallis and Futuna</option> 

                <option value="Western Sahara">Western Sahara</option> 

                <option value="Yemen">Yemen</option> 

                <option value="Zambia">Zambia</option> 

                <option value="Zimbabwe">Zimbabwe</option>

                </select>

                </div>

                <div class="form-group">

                    <label for="TextInput">City :</label>

                    <input name="City" type="text" class="form-control" placeholder="Enter your city name." required>

                 </div>



                                    <button name="submit" id="submit" type="submit" class="btn btn-default">Create Account</button>

                </form>

            </div>

            </div>

<?php    



?>        

<!-- Latest compiled and minified CSS -->

<link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.0.3/css/bootstrap.min.css">



<!-- Optional theme -->

<link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.0.3/css/bootstrap-theme.min.css">



<!-- Latest compiled and minified JavaScript -->

<script src="//netdna.bootstrapcdn.com/bootstrap/3.0.3/js/bootstrap.min.js"></script>

I can fill out the information and then after the submit button is pressed he calls this page - registersucessfull.php

Spoiler

PHP Code:


			
<?php

define('DB_TYPE', 'mysql');

define('DB_HOST', '');

define('DB_NAME', '');

define('DB_USER', '');

define('DB_PASS', '');



class Database extends PDO {



    public function __construct() {



        $options = array(PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ);

        parent::__construct(DB_TYPE . ':host=' . DB_HOST . ';dbname=' . DB_NAME, DB_USER, DB_PASS, $options);

    }



}



function stripslashes_deep($value)

{

    $value = is_array($value) ?

                array_map('stripslashes_deep', $value) :

                stripslashes($value);



    return $value;

}

?>

<?php

If($_SERVER['REQUEST_METHOD'] == "POST") { 

        if (isset($_POST['Password1'],$_POST['Password2']) && $_POST['Password1']!=$_POST['Password2']) {

        echo 'Your password confirmation is not equal to your password';

        } else {

        

           if (!$_POST['Realname'] || 

            !$_POST['Username'] || 

            !$_POST['Password'] || 

            !$_POST['Password2'] || 

            !$_POST['Email']|| 

            !$_POST['Country'] || 

            !$_POST['City'] ) {

            echo "<p>Please supply all of the data!</p>";

           exit;

        } else {

    

            try {        

            $dbh  = new Database();





        $stmt = $dbh->prepare('SELECT * FROM accounts WHERE Username=?');

        $stmt->bindParam(1, $_POST['Username'], PDO::PARAM_INT);

        $stmt->execute();

        $row = $stmt->fetch(PDO::FETCH_ASSOC);



                        

            $Username = "$_POST[Username]";

            $Username  = stripslashes_deep($Username);

            $Password1 = "$_POST[Password]";

            $Password1  = stripslashes_deep($Password1);

            $Password2 = "$_POST[Password2]";

            $Password2  = stripslashes_deep($Password2);

            $Email = "$_POST[Email]";

            $EMail  = stripslashes_deep($Email);

            $Country = "$_POST[Country]";

            $Country  = stripslashes_deep($Country);

            $City = "$_POST[City]";

            $City  = stripslashes_deep($City);

            $Recoverypassword = "$_POST[SecurityCode]";

            $Recoverypassword  = stripslashes_deep($Recoverypassword);

            $Regdate = date("Y-m-d");    



        

        if( ! $row)

        {

            $dbh  = new Database();        

        $query = $dbh->prepare("insert into accounts (Username,Password,Email,Country,City,Question)

        values (:Username,:Password,:Email,:Country,:City,:Question)");

        $data = array(

        ':Username' => "$Username",

        ':Password' => "$Password",

        ':Email' => "$Email",

        ':Country' => "$Country",

        ':City' => "$City",

        ':Question' => "$Recoverypassword"

        );

        $query->execute($data);



        echo "<p>Yout account was created successfully. Check your e-mail.</p>";

            $dbh = null;

            } else { 

            echo"<div class=\"alert alert-danger\">This <u>ACCOUNT ID</u> (<b> $Username </b>) already exists. Please choose other.!</div>";

            }

            }

            catch(PDOException $e) {

                echo $e->getMessage();

            }

            }

            }

            } else { 

?>

it says error in line 98.

If i combine both pages into one it just gives me error Please supply all data!, even if the form has been filled completely.

01/08/2014 06:36 Gerculy#10

Remove else { from the end of the page .
That should fix it.

--
You also can remove the connection to database from register.php ( It's useless )

and ?page=1 ( Line 29 )

01/08/2014 08:44 Beb0mn#11

Thanks guys for the support

Thread can be close. Thank you again.