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

Edited by BrettHartel
Link to comment
Share on other sites

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);
?>

Edited by BrettHartel
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.