Jump to content

Parse Error While Trying To Verify Unique Email.


BrettHartel

Recommended Posts

Thank you to everyone who is taking the time to read my post and help me.

 

Brief - I want the user to enter their eMail into the form and submit it to signup.php; the PHP file will do the following:

  1. Generate a random User_ID that is 16 characters long.
     
  2. Check the database to make sure the Unque_ID does not exist. If it does exists the script will generate another random User_ID and attempt again . If it does NOT exist the PHP script will continue.
     
  3. Check the database to make sure the eMail does not exists. If it does exists the fuction will not create a new account and displays "eMail already exists." If it does NOT exists then the script will continue.
     
  4. The PHP script will add the informtion to the table named "eMail" as a new entry.

I keep getting this error:

Parse error: syntax error, unexpected T_FUNCTION in /home/diamon79/public_html/signup.php on line 12

 

Line 12 is

function generateRandomString($User_ID = 16) {

 

 

The form to submit content:

<form action="signup.php" method="post">
eMail: <input type="text" name="eMail">
<input type="submit">
</form>

 

The PHP script the form is posted to:

<?php
$con = mysql_connect("localhost","*********","*******");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("diamon79_mysql", $con);
$eMail == '$_POST[eMail]'
function generateRandomString($User_ID = 16) {
return substr(str_shuffle("0123456789"), 0, $User_ID);
}
$searchquery = "SELECT * FROM eMail WHERE `Column_A` = '$User_ID'";
$searchresult = mysql_query($searchquery) or die(mysql_error());
if (mysql_num_rows($searchresult) == 0) {
eMailCheck();
}
// no rows found
else {
generateRandomString($User_ID = 16);
}
function eMailCheck()
$searcheMailquery = "SELECT * FROM eMail WHERE `Column_B` = '$eMail'";
$searcheMailresult = mysql_query($searcheMailquery) or die(mysql_error());

if (mysql_num_rows($searcheMailresult) == 0) {
PostInformation();
}
// no rows found
else {
echo "eMail already exists";
}

function PostInformation()
$sql="INSERT INTO eMail (User_ID, eMail)
VALUES
('$User_ID','$_POST[eMail]')";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";

mysql_close($con);
?>

 

I downloaded Notepad++ to be able to debug the script, but I cannot figure out how to use it properly so I am posting here. Thank you.

 

Brett Hartel

WOW! Thanks for the help! Now I get this error:

Error: Query was empty

 

Here is the updated script with requinix's help:

<?php
$con = mysql_connect("localhost","****","****");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("diamon79_mysql", $con);[/u]

[u]function generateRandomString($Generate_ID = 16) {
return substr(str_shuffle("01234567890123456789"), 0, $Generate_ID);
}[/u]
[u]$searchquery = "SELECT * FROM eMail WHERE `User_ID` = '$Generate_ID'";[/u]
[u]$searchresult = mysql_query($searchquery) or die(mysql_error());[/u]
[u]if (mysql_num_rows($searchresult) == 0) {
$User_Id = $Generate_ID;
eMailCheck();
}
// no rows found
else {
generateRandomString();
}[/u]
[u]function eMailCheck() {
$eMail = "$_POST[eMail]";
return $eMail;
}
$searcheMailquery = "SELECT * FROM eMail WHERE `eMail` = '$eMail'";[/u]
[u]$searcheMailresult = mysql_query($searcheMailquery) or die(mysql_error());

if (mysql_num_rows($searcheMailresult) == 0) {
PostInformation();
}
// no rows found
else {
echo "eMail already exists";
}

function PostInformation() {
$sql="INSERT INTO eMail (User_D, eMail)
VALUES
('$User_ID','$_POST[eMail]')";
}
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";

mysql_close($con);
?>

I hope you changed your database password in addition to editing it out of your post. Google indexes these pages usually within a couple minutes. If you haven't changed it yet, go do it right now.

I hope you changed your database password in addition to editing it out of your post. Google indexes these pages usually within a couple minutes. If you haven't changed it yet, go do it right now.

 

Thank you :) I have changed my password.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.