Code: Select all
$mysql_register_0 = mysql_query("SELECT email FROM `public_accounts` WHERE email = '$email'", $db);
echo mysql_num_rows(mysql_query($mysql_register_0, $db));Moderator: General Moderators
Code: Select all
$mysql_register_0 = mysql_query("SELECT email FROM `public_accounts` WHERE email = '$email'", $db);
echo mysql_num_rows(mysql_query($mysql_register_0, $db));Code: Select all
"SELECT email FROM `public_accounts` WHERE email = '".$email."'"
Code: Select all
if ($_POST['formis'] == 'registration_start')
{
$db = mysql_connect($mysql_host, $mysql_name, $mysql_pass);
if (!$db) {echo 'Could not connect to the database: '.mysql_error();}
$db_selected = mysql_select_db("public_accounts", $db);
$username = mysql_real_escape_string($_POST['username']);
$password = mysql_real_escape_string($_POST['password']);
$email = $_POST['email'];
$date_time = date("Y:m:d:H:i:s");
$activation_key = rand(101, 998);
$_SESSION['username'] = $_POST['username'];
$_SESSION['activation_key'] = $activation_key;
$mysql_register_0 = mysql_query("SELECT email FROM `public_accounts` WHERE email = '".$email."'", $db);
if (mysql_num_rows($mysql_register_0) != "0") {header("location:____.php?error=email_registered");}
else
{
$mysql_register = mysql_query("INSERT INTO public_accounts (username, password, email, activation_key, date_0) VALUES ('$username', '$password', '$email', '$activation_key', NOW())");
if (!$mysql_register) {$_SESSION['error'] = mysql_error(); header("location:____.php?error=email_registered");}
else
{
header("location:____.php?activate");
$emailfrom = 'no_reply__at__jabcreations.com';
$body = "Click the link below to complete your registration at JAB Creations.\nhttp://www.____.php?activate=".$activation_key;
$subject = 'JAB Creations - Registration Activation Code = '.$activation_key;
$success = mail($_POST['email'], $subject, $body, "From: <$emailfrom>");
}
}
}