Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(isset($_POST['username']) && isset($_POST['password']) && isset($_POST['name']) && isset($_POST['last_name']) && isset($_POST['company'])){
- if($username === '') {
- $errMsg = "Du skal udfylde brugernavn";
- }
- elseif($password === ''){
- $errMsg = "Du skal udfylde password";
- }
- elseif($name === ''){
- $errMsg = "Du skal udfylde navn";
- }
- elseif($last_name === ''){
- $errMsg = "Du skal udfylde efternavn";
- }
- elseif($company === ''){
- $errMsg = "Du skal udfylde firma";
- }
- $sql = ("SELECT * FROM members WHERE username ='$username'");
- $result = mysql_query($sql) or die('error');
- $row = mysql_fetch_assoc($result);
- if(mysql_num_rows($result)) {
- $errMsg = 'Brugernavn findes, vælg et andet.';
- } else {
- $sql = ("INSERT INTO members (username, password, name, last_name, company, salt)VALUES('$username', '$password', '$name', '$last_name', '$company', '$salt')")or die(mysql_error());
- if(mysql_query($sql))
- echo "Du er oprettet som profil.";
- }
- }//End whole if
- $sql = "INSERT INTO members (username, password, name, last_name, company, salt)VALUES('" . mysql_real_escape_string($username) . "', '" . mysql_real_escape_string($password) . "', '" . mysql_real_escape_string($name) . "', '" . mysql_real_escape_string($last_name) . "', '" . mysql_real_escape_string($company) . "', '$salt')";
- $sql = "SELECT COUNT(*) num FROM members WHERE username = '" . mysql_real_escape_string($username) . "'";
- $result = mysql_query($sql) or die('error');
- $row = mysql_fetch_assoc($result);
- if($row['num']) {
- $errMsg = 'Username exists';
- }
- $sql = "SELECT * FROM members WHERE username = '" . mysql_real_escape_string($username) . "'";
- $result = mysql_query($sql) or die('error');
- $row = mysql_fetch_assoc($result);
- if(mysql_num_rows($result)) {
- $errMsg = 'Username exists';
- }
- //If anything is empty write an error.
- if(empty($_POST['username'])){
- $errMsg = "Du skal udfylde brugernavn.";
- }
- elseif(empty($_POST['password'])){
- $errMsg = "Du skal udfylde password.";
- }
- elseif(empty($_POST['name'])){
- $errMsg = "Du skal udfylde navn.";
- }
- elseif(empty($_POST['last_name'])){
- $errMsg = "Du skal udfylde efternavn.";
- }
- elseif(empty($_POST['company'])){
- $errMsg = "Du skal udfylde firma.";
- } else {
- $sql = (" SELECT * FROM users WHERE username ='.$username.'")
- $res = mysql_query($sql) ;
- while ($row = mysql_fetch_array($res) ){
- $errMsg = "Your error message";
- exit();
- }
- $sql = ("INSERT INTO members (username, password, name, last_name, company, salt)VALUES('$username', '$password', '$name', '$last_name', '$company', '$salt')")or die(mysql_error());
- if(mysql_query($sql))
- echo "Du er oprettet som profil.";
- }//End if empty else
- $sSelect = "SELECT FROM members WHERE username = ".$sUserName." LIMIT 1";
- $rResult = mysql_query($sSelect);
- if (mysql_num_rows($rResult) > 0) {
- echo 'error, it exists!';
- }
Add Comment
Please, Sign In to add comment