Hello guys,
i'm trying to create a small portal where by every users thats comes in to d site must register b4 they could view tutorials in the website.. i created everything and every thing seems to work fine.. when u click on Register.php it Register and display confirmation.. but **** it woun't dump into DB and it woun't send me Activation Code to my box.. i'm confused pls can someone help me out ?? here is the Register.php code

The Database is working perfectly but i didn't get infos in it no info.

<?php 

include 'dbconn.php'; 

if(isset($_POST['submit'])) 
{ 

$first = addslashes(trim($_POST['firstname'])); 
$surname = addslashes(trim($_POST['surname'])); 
$username = addslashes(trim($_POST['username'])); 
$email = addslashes(trim($_POST['email'])); 
$pass = addslashes(trim($_POST['password'])); 
$conf = addslashes(trim($_POST['confirm'])); 

$ip = $_SERVER['REMOTE_ADDR']; 
$date = date("d, m y"); 

if ( $_POST['password'] == $_POST['confirm'] ) 
{}else{ 

echo '<script>alert("Your passwords were not the same, please enter the same password in each field.");</script>'; 
echo '<script>history.back(1);</script>'; 
exit; 

} 

$password = md5($pass); 

if ((((( empty($first) ) || ( empty($surname) ) || ( empty($username) ) || ( empty($email) ) || ( empty($password) ))))) 
{ 

echo '<script>alert("One or more fields was left empty, please try again.");</script>'; 
echo '<script>history.back(1);</script>'; 
exit; 

} 

if((!strstr($email , "@")) || (!strstr($email , "."))) 
{ 

echo '<script>alert("You entered an invalid email address. Please try again.");</script>'; 
echo '<script>history.back(1);</script>'; 
exit; 

} 

$q = mysql_query("SELECT * FROM Users WHERE Username = '$username'") or die(mysql_error()); 
if(mysql_num_rows($q) > 0) 
{ 

echo '<script>alert("The username you entered is already in use, please try again.");</script>'; 
echo '<script>history.back(1);</script>'; 
exit; 

} 

$name = $first . ' ' . $surname; 
$actkey = mt_rand(1, 500).'f78dj899dd'; 
$act = sha1($actkey); 

$query = mysql_query("INSERT INTO Users (Username, Password, Name, Email, Date, IP, Actkey) VALUES ('$username','$password','$name','$email','$date',    '$ip','$act')") or die(mysql_error()); 
$send = mail($email , "Registration Confirmation" , "Thank you for registering with UcheAlone.\n\nYour username and password is below, along with details on how to activate your account.\n\nUser: ".$username."\nPass: ".$pass."\n\nClick the link below to activate your account:\nhttp://EDITTHISURL.COM/activate.php?id=".$act."\n\nPlease do not reply, this is an automated mailer.\n\nThanks", "FROM: no-reply@uchealone.com"); 

if(($query)&&($send)) 
{ 

echo ' <html> 
<head> 
<title>Success</title> 
<link href="style.css" rel="stylesheet" type="text/css"> 
</head> 

<body> 

<div id="success"> 
<p>Thank you for registering, you will recieve an email soon with your login details and your activation link so that you can activate your account.</p> 
<p><a href="login.php">Click here</a> to login once you have activated.</p> 
</div> 

</body> 
</html> 
'; 

} else { 

echo ' 
<html> 
<head> 
<title>Error</title> 
<link href="style.css" rel="stylesheet" type="text/css"> 
</head> 

<body> 

<div id="error"> 
<p>We are sorry, there appears to be a problem with our script at the moment.</p> 
<p>Your data was not lost. Username: '.$username.' | Password: '.$pass.' | Email: '.$email.' | Full name: '.$name.'</p> 
<p>Please try again later.</p> 
</div> 

</body> 
</html> 
'; 

} 

} else { 

?> 
<html> 
<head> 
<title>Register</title> 
<link href="style.css" rel="stylesheet" type="text/css"> 
</head> 

<body> 

<div id="wrapper"> 

<div id="head">the registration page</div> 
<br> 
<div id="main"> 
<p>Welcome to the registration, fill out the form below and hit Submit. All fields are required,so fill them all out! </p> 
<form action="<?= $_SERVER['PHP_SELF'] ?>" method="post"> 
<table width="100%" border="0" cellpadding="0" cellspacing="0"> 
<tr> 
<td width="50%">First name </td> 
<td width="50%"><input name="firstname" type="text" id="firstname"></td> 
</tr> 
<tr> 
<td>Surname</td> 
<td><input name="surname" type="text" id="surname"></td> 
</tr> 
<tr> 
<td>Email Address </td> 
<td><input name="email" type="text" id="email"></td> 
</tr> 
<tr> 
<td>Username</td> 
<td><input name="username" type="text" id="username"></td> 
</tr> 
<tr> 
<td>Password</td> 
<td><input name="password" type="password" id="password"></td> 
</tr> 
<tr> 
<td>Confirm Password </td> 
<td><input name="confirm" type="password" id="confirm"></td> 
</tr> 
<tr> 
<td>Register</td> 
<td><input name="submit" type="submit" class="textBox" value="Submit"></td> 
</tr> 
</table> 
</form> 
Upon confirmation of your details, you will be sent an email containing your username, password and details on how to activate your account so as to be able to use this website. </div> 

</div> 

</body> 
</html> 

<? } mysql_close($l); ?> 

Edited 3 Years Ago by Dani: Formatting fixed

$query = mysql_query("INSERT INTO Users (Username, Password, Name, Email, Date, IP, Actkey) VALUES ('$username','$password','$name','$email','$date', '$ip','$act')") or die(mysql_error());
$send = mail($email , "Registration Confirmation" , "Thank you for registering with UcheAlone.\n\nYour username and password is below, along with details on how to activate your account.\n\nUser: ".$username."\nPass: ".$pass."\n\nClick the link below to activate your account:\nhttp://EDITTHISURL.COM/activate.php?id=".$act."\n\nPlease do not reply, this is an automated mailer.\n\nThanks", "FROM: no-reply@uchealone.com");

Please check each step using 'echo' whether the variables contain data you post using the form. It would be easier to spot any error by breakdown the script rather than putting everything in one line. Try below:

mysql_query("INSERT INTO Users (Username, Password, Name, Email, Date, IP, Actkey) VALUES ('$username','$password','$name','$email','$date',    '$ip','$act')") or die(mysql_error()); 

$subject = "Registration Confirmation";
$message = "Thank you for registering with UcheAlone.\n\n";
$message .= "Your username and password is below, along ";
$message .= "with details on how to activate your account.\n\nUser: ";
$message .= $username."\nPass: ".$pass."\n\n";
$message .= "Click the link below to activate your ..";
mail($email, $subject, $message);
This article has been dead for over six months. Start a new discussion instead.