mark103 Posted June 1, 2010 Share Posted June 1, 2010 Hi guys, I have a problem with the script. There is an error while I tried to produce the script. Parse error: syntax error, unexpected T_DNUMBER in /home/mysite/public_html/mysite.com/script.php on line 15 Here it is the code: <?php //Start session session_start(); //Include database connection details require_once('config.php'); //Array to store validation errors $errmsg_arr = array(); //Validation error flag $errflag = false; //Connect to mysql server $link = mysql_connect(111.11.11.11.11:5002, myusername, mypassword); if(!$link) { die('Failed to connect to server: ' . mysql_error()); } //Select database $db = mysql_select_db(DB_DATABASE); if(!$db) { die("Unable to select database"); } //Function to sanitize values received from the form. Prevents SQL injection function clean($str) { $str = @trim($str); if(get_magic_quotes_gpc()) { $str = stripslashes($str); } return mysql_real_escape_string($str); } //Sanitize the POST values $fname = clean($_POST['fname']); $lname = clean($_POST['lname']); $login = clean($_POST['login']); $password = clean($_POST['password']); $cpassword = clean($_POST['cpassword']); //Input Validations if($fname == '') { $errmsg_arr[] = 'First name missing'; $errflag = true; } if($lname == '') { $errmsg_arr[] = 'Last name missing'; $errflag = true; } if($login == '') { $errmsg_arr[] = 'Login ID missing'; $errflag = true; } if($password == '') { $errmsg_arr[] = 'Password missing'; $errflag = true; } if($cpassword == '') { $errmsg_arr[] = 'Confirm password missing'; $errflag = true; } if( strcmp($password, $cpassword) != 0 ) { $errmsg_arr[] = 'Passwords do not match'; $errflag = true; } //Check for duplicate login ID if($login != '') { $qry = "SELECT * FROM members WHERE login='$login'"; $result = mysql_query($qry); if($result) { if(mysql_num_rows($result) > 0) { $errmsg_arr[] = 'Login ID already in use'; $errflag = true; } @mysql_free_result($result); } else { die("Query failed"); } } //If there are input validations, redirect back to the registration form if($errflag) { $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: register-form.php"); exit(); } //Create INSERT query $qry = "INSERT INTO members(firstname, lastname, login, passwd) VALUES('$fname','$lname','$login','".md5($_POST['password'])."')"; $result = @mysql_query($qry); //Check whether the query was successful or not if($result) { header("location: register-success.php"); exit(); }else { die("Query failed"); } ?> Suely I have enter the correct local host ip, username and password? Quote Link to comment Share on other sites More sharing options...
riwan Posted June 1, 2010 Share Posted June 1, 2010 you should check again the host ip $link = mysql_connect(111.11.11.11.11:5002, myusername, mypassword); there should be only 3 dots in it and you should enclosed in quotes Quote Link to comment Share on other sites More sharing options...
mark103 Posted June 1, 2010 Author Share Posted June 1, 2010 Oh sorry, I realised why it doesn't work. I have input the wrong details. Here it is: $link = mysql_connect('DB_HOST', 'DB_USER', 'DB_PASSWORD'); How can I find out what is my database host? Quote Link to comment Share on other sites More sharing options...
riwan Posted June 2, 2010 Share Posted June 2, 2010 If the dbhost is the same as the script host, then you can just put it as localhost Quote Link to comment Share on other sites More sharing options...
katierosy Posted June 2, 2010 Share Posted June 2, 2010 I see no error in it, I have tested the below script, It has no error as such. <?php //Start session session_start(); //Include database connection details //require_once('config.php'); //Array to store validation errors $errmsg_arr = array(); //Validation error flag $errflag = false; //Connect to mysql server $link = mysql_connect('localhost','root',''); if(!$link){ die('Failed to connect to server: ' . mysql_error()); } //Select database $db = mysql_select_db('test3'); if(!$db){ die("Unable to select database"); } //Function to sanitize values received from the form. Prevents SQL injection function clean($str){ $str = @trim($str); if(get_magic_quotes_gpc()){ $str = stripslashes($str); } return mysql_real_escape_string($str); } //Sanitize the POST values $fname = clean($_POST['fname']); $lname = clean($_POST['lname']); $login = clean($_POST['login']); $login=1; $password = clean($_POST['password']); $cpassword = clean($_POST['cpassword']); //Input Validations if($fname == '') { $errmsg_arr[] = 'First name missing'; $errflag = true; } if($lname == '') { $errmsg_arr[] = 'Last name missing'; $errflag = true; } if($login == ''){ $errmsg_arr[] = 'Login ID missing'; $errflag = true; } if($password == ''){ $errmsg_arr[] = 'Password missing'; $errflag = true; } if($cpassword == ''){ $errmsg_arr[] = 'Confirm password missing'; $errflag = true; } if(strcmp($password, $cpassword) != 0){ $errmsg_arr[] = 'Passwords do not match'; $errflag = true; } //Check for duplicate login ID if($login != ''){ //$qry = "SELECT * FROM members WHERE login='$login'"; $qry = "SELECT * FROM members"; $result = mysql_query($qry); $array = mysql_fetch_assoc($result); print_r($array); if($result){ if(mysql_num_rows($result) > 0) { $errmsg_arr[] = 'Login ID already in use'; $errflag = true; } @mysql_free_result($result); } else { die("Query failed"); } } //If there are input validations, redirect back to the registration form if($errflag){ $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); //header("location:register-form.php"); exit(); } //Create INSERT query $qry = "INSERT INTO members(firstname, lastname, login, passwd) VALUES('$fname','$lname','$login','".md5($_POST['password'])."')"; $result = @mysql_query($qry); //Check whether the query was successful or not if($result) { //header("location: register-success.php"); exit(); } else { die("Query failed"); } ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.