Jump to content


Photo

mysql error


  • Please log in to reply
2 replies to this topic

#1 stugreenham

stugreenham
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 27 September 2005 - 06:44 PM

can anyone help me, just registered with 1and1 for the webspace and mysql database and am having some problems, i uploaded phpmyadmin, and got a table on the database but when i try to interact with it for example, add a user, i keep getting this error:

Parse error: parse error, unexpected '{' in /homepages/24/d136628883/htdocs/register.php on line 98

heres the code for the page...


<?php

include 'db.inc';

// Define post fields into simple variables
$email = $_POST['email'];
$fname = $_POST['f_name'];
$sname = $_POST['s_name'];
$street = $_POST['street'];
$city = $_POST['city'];
$county = $_POST['county'];
$pcode = $_POST['p_code'];
$ref_email = $_POST['referral'];
$ipod_code = $_POST['ipod_code'];



$email = stripslashes($email);
$f_name = stripslashes($f_name);
$s_name = stripslashes($s_name);
$street = stripslashes($street);
$city = stripslashes($city);
$county = stripslashes($county);
$p_code = stripslashes($p_code);
$ref_email = stripslashes($ref_email);
$ipod_code = stripslashes($ipod_code);


if((!email) || (!$f_name) || (!$s_name) || (!$street) || (!$city) || (!$county) || (!p_code)){
echo 'You did not submit the following required information: <br />';
if(!$email){
echo "Email is a required field. Please enter it below.<br />";
}
if(!$f_name){
echo "First Name is a required field. Please enter it below.<br />";
}
if(!$s_name){
echo "Surname is a required field. Please enter it below.<br />";
}
if(!$street){
echo "Street is a required field. Please enter it below.<br />";
}
if(!$city){
echo "City is a required field. Please enter it below.<br />";
}
if(!$county){
echo "County is a required field. Please enter it below.<br />";
}
if(!$p_code){
echo "Post Code is a required field. Please enter it below.<br />";
}
echo "Please <a href=javascript:history.back()>Click Here</a> to return to the form";
exit();
}


$sql_email_check = mysql_query("SELECT email FROM members
WHERE email = '$email'");

$email_check = mysql_num_rows($sql_email_check);

if(($email_check > 0){
echo "Please fix the following errors: <br />";
if($email_check > 0){
echo "<strong>Your email address has already been used by another member
in our database. Please submit a different Email address!<br />";
unset($email);
}
echo "Please <a href=javascript:history.back()>Click Here</a> to return to the form";
exit();
}


function makeRandomPassword() {
$salt = "abchefghjkmnpqrstuvwxyz0123456789";
srand((double)microtime()*1000000);
$i = 0;
while ($i <= 7) {
$num = rand() % 33;
$tmp = substr($salt, $num, 1);
$pass = $pass . $tmp;
$i++;
}
return $pass;
}

$random_password = makeRandomPassword();

$db_password = md5($random_password);

// Enter info into the Database.
$sql = mysql_query("INSERT INTO members (email, password, f_name, s_name, street, city, county, p_code, referral, ipod_code, signup_date)
VALUES('$email', '$db_password', '$f_name', '$s_name', '$street', '$city', $county, $p_code, $referral, $ipod_code, now())")
or die (mysql_error());

if(!$sql){
echo 'There has been an error creating your account. Please contact the webmaster.';
}
}

?>


<br /><br />

</center>
</td >

<tr>
<td colspan="3"><br /></td>
</tr>

</div>



..also can anyone help me with the exact script i should have in my db.inc file, thanks

stu

#2 neylitalo

neylitalo
  • Staff Alumni
  • Advanced Member
  • 1,854 posts
  • LocationMichigan, USA

Posted 27 September 2005 - 07:10 PM

please point out line 98... and in the future, enclose your code in the BBCode PHP or CODE tags. Preferably [ PHP ], without the spaces. Look at the buttons above your post area.

also can anyone help me with the exact script i should have in my db.inc file, thanks


I'm thinking you would want something like this...

[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--][span style=\"color:#0000BB\"]<?

$host [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"mysqlservername\"[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]$username [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"username\"[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]$password [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"password\"[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]$db [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"databasename\"[/span][span style=\"color:#007700\"];

@[/span][span style=\"color:#0000BB\"]mysql_connect[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$host[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$username[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$password[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]());
@[/span][span style=\"color:#0000BB\"]mysql_select_db[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$db[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]());

[/span][span style=\"color:#0000BB\"]?>[/span]
[/span][!--PHP-Foot--][/div][!--PHP-EFoot--]

And you shoud rename db.inc to db.inc.php or something ending with .php. If you leave it as .inc, I could just navigate to http://www.yourdomain.com/db.inc and it would show me the username and password for your database server.
http://nealylitalo.net - My personal website, and home of The Netizen's Journal.

#3 stugreenham

stugreenham
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 27 September 2005 - 08:28 PM

this is from line 98 in dreamweaver...

[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--]

if(($email_check > 0){
    echo \"Please fix the following errors: <br />\";
    if($email_check > 0){
        echo \"<strong>Your email address has already been used by another member
        in our database. Please submit a different Email address!<br />\";
        unset($email);
    }
    echo \"Please <a href=javascript:history.back()>Click Here</a> to return to the form\";
    //include \'join_form.html\'; // Show the form again!
    exit();  // exit the script so that we do not create this account!
}

[/span][!--PHP-Foot--][/div][!--PHP-EFoot--]






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users