Hi..I need help...I am using the following
<?php
$username="";
$password="";
$firstname="";
$lastname="";
$ydob="";
$mdob="";
$bdob="";
$email="";
$gender="";
$priority="";
$usid="";
$users= $_POST['txt_xml_users'];
$xml_Doc = new DOMDocument();
$xml_Doc->loadXML($users);
if(!$xml_Doc->schemaValidate('users.xsd'))
echo "Your xml is NOT valid";
else
{
include("dbconnect.php");
header('Content-Type: text/xml');
//$xml_users=simplexml_load_string($users );
$xml_users=simplexml_import_dom($xml_Doc);
foreach ($xml_users->user as $user)
{
$username=$user->username;
$password=$user->password;
$firstname=$user->firstname;
$lastname=$user->lastname;
$ydob=$user->ydob;
$mdob=$user->mdob;
$bdob=$user->bdob;
$email=$user->email;
$gender=$user->gender;
$priority=$user->priority;
$usid=$user->usid;
if($username!="" && $username!=null)
{
$sql_select="SELECT * FROM users WHERE
username='$username'";
$Rs = mysql_query($sql_select);
if (mysql_num_rows($Rs)<1)
if($password!="" && $password!=null)
{
$sql_select="SELECT * FROM users WHERE
password='$password'";
$Rs = mysql_query($sql_select);
if (mysql_num_rows($Rs)<1)
if($firstname!="" && $firstname!=null)
{
$sql_select="SELECT * FROM users WHERE
firstname='$firstname'";
$Rs = mysql_query($sql_select);
if (mysql_num_rows($Rs)<1)
if($lastname!="" && $lastname!=null)
{
$sql_select="SELECT * FROM users WHERE
lastname='$lastname'";
$Rs = mysql_query($sql_select);
if (mysql_num_rows($Rs)<1)
if($ydob!="" && $ydob!=null)
{
$sql_select="SELECT * FROM users WHERE ydob='$ydob'";
$Rs = mysql_query($sql_select);
if (mysql_num_rows($Rs)<1)
if($mdob!="" && $mdob!=null)
{
$sql_select="SELECT * FROM users WHERE mdob='$mdob'";
$Rs = mysql_query($sql_select);
if (mysql_num_rows($Rs)<1)
if($bdob!="" && $bdob!=null)
{
$sql_select="SELECT * FROM users WHERE bdob='$bdob'";
$Rs = mysql_query($sql_select);
if (mysql_num_rows($Rs)<1)
if($email!="" && $email!=null)
{
$sql_select="SELECT * FROM users WHERE email='$email'";
$Rs = mysql_query($sql_select);
if (mysql_num_rows($Rs)<1)
if($gender!="" && $gender!=null)
{
$sql_select="SELECT * FROM users WHERE gender='$gender'";
$Rs = mysql_query($sql_select);
if (mysql_num_rows($Rs)<1)
if($priority!="" && $priority!=null)
{
$sql_select="SELECT * FROM users WHERE
priority='$priority'";
$Rs = mysql_query($sql_select);
if (mysql_num_rows($Rs)<1)
if($usid!="" && $usid!=null)
{
$sql_select="SELECT * FROM users WHERE usid='$usid'";
$Rs = mysql_query($sql_select);
if (mysql_num_rows($Rs)<1)//insert only if the data has not
been inserted before
{
//we want to insert data
$sql_insert="INSERT INTO
modules(username,password,firstname,lastname,ydob,mdob,bdob,email,
gender,priority,usid)VALUES('$username','$password','$firstname','
$lastname','$ydob','$mdob','$bdob','$email','$gender','$priority',
'$usid')";
if (!mysql_query($sql_insert,$con))
{
die('Error: ' . mysql_error());
}
}//end if
}//end if
}//end if
}//end if
}//end if
}//end if
}//end if
}//end if
}//end if
}//end if
}//end if
}//end foreach
?>
<?
mysql_close($con);
}//end else
?>
Am getting error
Parse error: syntax error, unexpected $end in D:\xampp\htdocs\xampp\csite\process_reg.php on line 157