Check if user exists?

zero_ZX · July 1, 2010

Hey all, here's my code:

<?php include('header.php'); ?>
<?php
session_start();
// dBase file
include "inc/config.php";

if (!$_SESSION["valid_user"])
{
// Ikke logget ind
Header("Location: index.php");
}


$staff = $_SESSION['valid_user'];

$result = mysql_query("SELECT * FROM admin WHERE brugernavn=('$staff')  LIMIT 1");
$row = mysql_fetch_array($result);

if ($row["kunder"] != "1")
{
echo '

<div class="response-msg error ui-corner-all">
						<span>Meddelelse</span>
						Adgang til denne side blev nægtet af serveren.
                            <br />
                            Du har muligvis ikke fået tildelt en personale konto. Kontakt din administrator vedrørende dette problem.
					</div>



												<div class="clear"></div>

				<div class="clear"></div>

			<div class="clear"></div>

			<div class="clear"></div>';

			include('sidebar.php');
echo'		</div>
		<div class="clear"></div>
	</div>
</div>';
include('footer.php'); 
echo '</div>
</body>
</html> ';

exit();						


}





if ($_GET["op"] == "add")
{
$brugernavn = mysql_real_escape_string($_POST['brugernavn']); 
$password = md5($_POST['password']); 
$virksomhed = mysql_real_escape_string($_POST['virksomhed']); 
$telefon = mysql_real_escape_string($_POST['telefon']); 
$kontakt = mysql_real_escape_string($_POST['kontakt']);
$email = mysql_real_escape_string($_POST['email']);
$adresse = mysql_real_escape_string($_POST['adresse']);



$result = mysql_query("SELECT brugernavn FROM kunder WHERE brugernavn=('$brugernavn')");
$row = mysql_fetch_array($result);

if ($result == "$brugernavn")
{
echo '

<div class="response-msg error ui-corner-all">
						<span>Meddelelse</span>
						Brugeren eksistere allerede
                            <br />
                            Du har muligvis ikke fået tildelt en personale konto. Kontakt din administrator vedrørende dette problem.
					</div>



												<div class="clear"></div>

				<div class="clear"></div>

			<div class="clear"></div>

			<div class="clear"></div>';

			include('sidebar.php');
echo'		</div>
		<div class="clear"></div>
	</div>
</div>';
include('footer.php'); 
echo '</div>
</body>
</html> ';

exit();						


}





mysql_query("INSERT INTO kunder (brugernavn, password, virksomhed, telefon, kontakt, email, adresse)
VALUES ('$brugernavn', '$password', '$virksomhed', '$telefon', '$kontakt', '$email', '$adresse')");


echo '<div class=one-column>';
echo '<div class=column>';
echo '<div class="portlet ui-widget ui-widget-content ui-helper-clearfix ui-corner-all">';
echo '<div class="portlet-header ui-widget-header">Nyhed tilføjet!<span class="ui-icon ui-icon-circle-arrow-s"></span></div>';
echo '<div class=portlet-content>';
echo '<p>';
echo "$virksomhed ($telefon) er blevet oprettet";
echo "</div>";
echo "</div>";
echo "</div>";
echo '<a href="user-add.php">Tilbage</a>';

echo '<div id="sub-nav"><div class="page-title"></div>';
include('top_buttons.php'); 
echo '</div>';

echo '<div class="clearfix"></div>';
echo '</div>';
echo '<div class="clear"></div></div></div>';
include('footer.php'); 
echo '</div></body>';

exit;
}
?>


	<div id="sub-nav"><div class="page-title">
	</div>
<?php include('top_buttons.php'); ?>

<script type="text/javascript" src="js/validate.js"></script>

<script type="text/javascript">
$().ready(function() {
// validate the comment form when it is submitted
$("#commentForm").validate();

// validate signup form on keyup and submit
$("#signupForm").validate({
	rules: {
		brugernavn: "required",
		password: "required",
		telefon: "required",
		adresse: "required",
		kontakt: {
			required: true,
			minlength: 2
		},
		virksomhed: {
			required: true,
			minlength: 2
		},

		email: {
			required: true,
			email: true
		},
	messages: {
		brugernavn: "Du skal angive et brugernavn",
		password: "Du skal angive et password",
		telefon : "Du skal angive et telefonnummer",
		kontakt: {
			required: "Du skal angive en kontakt",
			minlength: "Dine indtastninger skal være mindst 2 karaktere lange"
		},
		virksomhed: {
			required: "Du skal angive en virksomhed",
			minlength: "Dine indtastninger skal være mindst 2 karaktere lange"
		},
		email: "Du skal angive en gyldig email",
	}
	}


});
});



</script>


</div>
	<div id="page-layout"><div id="page-content">
		<div id="page-content-wrapper">

        
        <div class="inner-page-title">
				<h2>Tilføj kunde</h2>
				<span>Her kan du tilføje kunder i systemet.</span>
			</div>
			<div class="portlet ui-widget ui-widget-content ui-helper-clearfix ui-corner-all form-container">
				<div class="portlet-header ui-widget-header">Indfyld venligst alle felter<span class="ui-icon ui-icon-circle-arrow-s"></span></div>
				<div class="portlet-content">
					<form id="signupForm" action="?op=add" method="post" enctype="multipart/form-data" class="forms" name="form" >
						<ul>
							<li>
								<label  class="desc">
									Brugernavn
								</label>
								<div>
									<input type="text" tabindex="1" maxlength="255" value="" class="field text small" name="brugernavn" />
								</div>
							</li>
							<li>
								<label  class="desc">
									Password
								</label>
								<div>
									<input type="password" tabindex="1" maxlength="255" value="" class="field text small" name="password" />
								</div>
							</li>
								<li>						
								<label  class="desc">
									Virksomhed
								</label>
								<div>
									<input type="text" tabindex="1" maxlength="255" value="" class="field text small" name="virksomhed" />
								</div>
							</li>
                                
                                <li>

								<label  class="desc">
									Telefon
								</label>
								<div>
									<input type="text" tabindex="1" maxlength="255" value="" class="field text small" name="telefon" />
								</div>
							</li>
                                
                                
                                <li>

								<label  class="desc">
									Kontakt
								</label>
								<div>
									<input type="text" tabindex="1" maxlength="255" value="" class="field text small" name="kontakt" />
								</div>
							</li>
                         
                         
                         
                         
                                <li>

								<label  class="desc">
									Email
								</label>
								<div>
									<input type="text" tabindex="1" maxlength="255" value="" class="field text small" name="email" />
								</div>
							</li>          
                                
                                
                                                                <li>

								<label  class="desc">
									Adresse
								</label>
								<div>
									<input type="text" tabindex="1" maxlength="255" value="" class="field text small" name="adresse" />
								</div>
							</li> 
                                
							<li>

									</span>
								</div>
							</li>
							<li class="buttons">
								<button class="ui-state-default float-left ui-corner-all ui-button" type="submit">Tilføj kunde</button>
							</li>
						</ul>
					</form>
				</div>
			</div>
        
        
        
			<div class="clearfix"></div>
			<?php include('sidebar.php'); ?>
		</div>
		<div class="clear"></div>
	</div>
</div>
<?php include('footer.php'); ?></div>
</body>
</html>

Sorry that some is danish.. Any way, this site will allow the system administrator to add a new client, but I don't really know how to check if the "username" is already taken.. any suggestions on how to do this?

Stooney · July 1, 2010

It's pretty straightforward:

$user_exists=mysql_query("SELECT username FROM table WHERE username='$username'");
if(mysql_num_rows($user_exists)>0){
    //Username exists, throw error
} else{
    //Username is not taken, create user
}

Pikachu2000 · July 1, 2010

In most cases, a SELECT COUNT() query is more efficient.

Stooney · July 1, 2010

In most cases, a SELECT COUNT() query is more efficient.

Good point.

Sign In

Check if user exists?

Recommended Posts

zero_ZX

Link to comment

Share on other sites

Stooney

Link to comment

Share on other sites

Pikachu2000

Link to comment

Share on other sites

Stooney

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information