Found this bit of script could be what i need

Discussion in 'PHP' started by dougvcd, May 23, 2007.

  1. #1
    ok have found this script
    from what i can understand from reading it you fill out form then it emails you to activate then inserts the data into database
    can any one help me out with this as this seems to be what i need to verify email addy

    <?php
    include ('inc/header.php');
    
    if(isset($_POST['submit'])){
    	$postfname = $_POST['firstname'];
    	$postlname = $_POST['lastname'];
    	$postuser = $_POST['username'];
    	$postpass = md5($_POST['password']);
    	$postpass2 = md5($_POST['confirmpassword']);
    	$postemail = $_POST['email'];
    	$postemail2 = $_POST['confirmemail'];
    	$postphone = $_POST['phone'];
    	$postloca = $_POST['location'];
    	$postweb = $_POST['website'];
    
    if(($postpass != $postpass2) || ($postemail != $postemail2)){
    	header('location: register.php?error=Fields do not match');
    } else {
    	$check = mysql_query("SELECT * FROM users WHERE lower(username) = lower('$postuser')")or die(mysql_error('Sorry couldnt find you in the database.'));
    
    	$rowcount = mysql_num_rows($check);
    	if ($rowcount >= 1) {
    			header("location: register.php?error=Username already taken");
    		}
    
    	$query = "INSERT INTO users (username, password, firstname, lastname, email, phone, location, website) VALUES
    				('$postuser', '$postpass', '$postfname', '$postlname', '$postemail', '$postphone', '$postloca', '$postweb')";
    	$result = @mysql_query($query);
    
    	$to = $postemail;
    	$subject = "Caravan Holiday Exchange Activation";
    	$message = "Thank you, $postuser.<br><br>
    				Please active by click the link below:<br><br>
    				<a href='http://www.***********/register.php?active=1&user=$postuser'>
    				http://www.*********/register.php?active=1&user=$postuser</a><br><br>
    				Thank you,<br>
    				C*************";
    	include('inc/mail.inc');
    }
    PHP:

     
    dougvcd, May 23, 2007 IP
  2. -bank-

    -bank- Well-Known Member

    Messages:
    674
    Likes Received:
    37
    Best Answers:
    0
    Trophy Points:
    120
    #2
    Well, its got a lot to be worked on.. Will talk to you on msn later, although is sort of there.
     
    -bank-, May 23, 2007 IP