Parse error

[mark103]

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?

[riwan]

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

[mark103]

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?

[riwan]

If the dbhost is the same as the script host, then you can just put it as localhost

[katierosy]

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

}

?>