Getting Parse error

rajeshp808

I am getting this error :
Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\xampp\htdocs\reg_data.php on line 23
For this below code:

$con=mysqli_connect("localhost","root","xyz","dbdata");
//$temp=$con;
// Check connection
if (mysqli_connect_errno($con))
  {
	echo "Failed to connect to MySQL: " . mysqli_connect_error();
	// Close Connection
	mysqli_close($con);
  }//
$sql="INSERT INTO user_gr (userid , passwor, full_name, mobile, currentcity, company, designation, salary, dob, about)
VALUES
('$_POST["email"]', '$_POST["password"]' , '$_POST["fullname"]',
 '$_POST["mobile"]', '$_POST["city"]', '$_POST["company"]', 
 '$_POST["designation"]', '$_POST["salary"]', '$_POST["dob"]', '$_POST["about"]')";

if (!mysqli_query($con,$sql))
  {
  die('Error: ' . mysqli_error());
  mysqli_close($con);
  }
echo "1 record added";

Please tell me why this error is coming??🙁🙁

Thanks

Weedpacket

It's because you have an unexpected [font=monospace]"[/font] on line 23. See Variable Parsing in Strings.

rajeshp808

I have solved that problem..
but record is not getting inserted into databses.. please check it

// Create connection
//$temp=0;
$con=mysqli_connect("localhost","root","rajesh","rajdata");
//$temp=$con;
// Check connection
if (mysqli_connect_errno($con))
  {
	echo "Failed to connect to MySQL: " . mysqli_connect_error();
	// Close Connection
	mysqli_close($con);
  }//
$i=mysqli_query($con,"INSERT INTO grpersons (email,password,full_name,mobile,currentcity,company,designation,salary,dob,about) VALUES ('$_POST[email]', '$_POST[password]','$_POST[full_name]','$_POST[mobile]','$_POST[currentcity]','$_POST[company]','$_POST[designation]','$_POST[salary]','$_POST[dob]','$_POST[about]')");
if ($i)
   echo "1 record added";
else
 echo $i."error";

rajeshp808

Still getting error. and records are not added to the database
<CODE>// Create connection
//$temp=0;
$con=mysqli_connect("localhost","root","rajesh","rajdata");
//$temp=$con;
// Check connection
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
// Close Connection
mysqli_close($con);
}//
$i=mysqli_query($con,"INSERT INTO grpersons (email,password,full_name,mobile,currentcity,company,designation,salary,dob,about) VALUES ('$POST[email]', '$POST[password]','$POST[full_name]','$POST[mobile]','$POST[currentcity]','$POST[company]','$POST[designation]','$POST[salary]','$POST[dob]','$POST[about]')");
if ($i)
echo "1 record added";
else
echo $i."error";
</CODE>

dalecosp

Weedpacket;11025603 wrote:
It's because you have an unexpected [font=monospace]"[/font] on line 23.

You're such a great parser! And to top that off, you've such a expert handle on a wide variety of knowledge and a great sense of humor! :-)

Perhaps we could have a "Weedpacket Parser" added to PHP 6.0 ? 😃

Weedpacket

rajeshp808 wrote:
Getting new error
I have solved that problem..[/quote]Then it's a subject for a new thread.